Mastering PHP 7

Deleting

Again, we can use the prepare(), bind_param(), and execute() methods to handle record deleting, as shown here:

<?phptry {    // Report on all types of errors    mysqli_report(MYSQLI_REPORT_ALL);    // Open a new connection to the MySQL server    $mysqli = new mysqli('127.0.0.1', 'root', 'mL08e!Tq', 'sakila');    // Prepare some teat address data    $paymentId = 500;    // Prepare an SQL statement for execution    $statement = $mysqli->prepare('DELETE FROM payment WHERE payment_id = ?');    // Bind variables to a prepared statement as parameters    $statement->bind_param('i', $paymentId);    // Execute a prepared Query    $statement->execute();    // Close a prepared statement    $statement->close();    // Close database connection    $mysqli->close();} catch (mysqli_sql_exception ...