How can the use of mysql_query and mysql_fetch_assoc functions in PHP be optimized for better performance and security?

When using mysql_query and mysql_fetch_assoc functions in PHP, it is recommended to switch to mysqli or PDO for better performance and security. These functions are deprecated and no longer recommended due to security vulnerabilities and lack of support in newer PHP versions. By using mysqli or PDO, you can take advantage of prepared statements to prevent SQL injection attacks and improve overall performance. 

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

// Check connection
if ($mysqli->connect_error) {
    die("Connection failed: " . $mysqli->connect_error);
}

// Perform a query using prepared statement
$stmt = $mysqli->prepare("SELECT * FROM table WHERE id = ?");
$stmt->bind_param("i", $id);
$id = 1;
$stmt->execute();
$result = $stmt->get_result();

// Fetch results as associative array
while ($row = $result->fetch_assoc()) {
    // Process data
}

// Close statement and connection
$stmt->close();
$mysqli->close();

Keywords

mysql_query mysql_fetch_assoc optimization performance security

Related Questions