Question

Which method rolls back the present transaction?

(a) commit()

(b) undo()

(c) mysqli_rollback()

(d) rollback()

The question was posed to me in a job interview.

My question comes from Working with Databases-2 topic in section Objects and Databases in PHP of PHP

Answer 1

The correct option is (c) mysqli_rollback()

The explanation: The function mysqli_rollback() is used to roll back from the current transaction for the specified database connection. Its syntax is: mysqli_rollback(connection);

Rollback() was used in previous version of PHP.