mysqli - mysqli_connect not working on MAMP

Question

The code below worked on my old iMac with MAMP. However, it does not work on my new iMac. How do I fix this? Do I need to do something to the php.ini file?

<?php
$dbConnection = mysqli_connect("localhost", "xxxx", "xxxx", "gallery");
$query = "SELECT * FROM images";
$stmt = mysqli_prepare($dbConnection,$query);
mysqli_stmt_execute($stmt);
mysqli_stmt_bind_result($stmt, $id, $categories,$img_name);
   while (mysqli_stmt_fetch($stmt)) {
     echo $id."<br />";

 }

?>

Answer 1

You should enable php_mysqli extension in PHP.ini. It's disabled by default.

look for the following line: extension=php_mysqli