Which of the following are true? a. MySQL supports Object oriented way of accessing the database b. MySQL supports Prepared statement c. MySQLi supports Object oriented way of accessing the database d. MySQLi supports Prepared statement code example

Example 1: mysqli_connect using prepare statement

$stmt = $mysqli->prepare("DELETE FROM myTable WHERE id = ?");
$stmt->bind_param("i", $_SESSION['id']);
$stmt->execute();
$stmt->close();
Copy

Example 2: mysqli_connect using prepare statement

$stmt = $mysqli->prepare("UPDATE myTable SET name = ? WHERE id = ?");
$stmt->bind_param("si", $_POST['name'], $_SESSION['id']);
$stmt->execute();
$stmt->close();
Copy

Tags:

Sql Example