What are the differences between mysql_fetch_array and mysqli_fetch_array in PHP, and how should they be used effectively?

The main difference between mysql_fetch_array and mysqli_fetch_array in PHP is that mysql_fetch_array is part of the deprecated MySQL extension, while mysqli_fetch_array is part of the newer MySQLi extension, which includes improved security features and support for prepared statements. It is recommended to use mysqli_fetch_array for better performance and security. 

// Using mysqli_fetch_array to fetch rows from a MySQL database

// Connect to the database using MySQLi
$mysqli = new mysqli('localhost', 'username', 'password', 'database_name');

// Query the database
$result = $mysqli->query("SELECT * FROM table_name");

// Fetch rows using mysqli_fetch_array
while ($row = mysqli_fetch_array($result)) {
    // Process each row here
}

// Close the database connection
$mysqli->close();

Keywords

mysql_fetch_array mysqli_fetch_array PHP MySQLi data retrieval

Related Questions