How can I optimize my PHP code to efficiently handle database queries using PDO?

To optimize your PHP code for handling database queries using PDO, you can utilize prepared statements to prevent SQL injection attacks and improve query performance. Prepared statements allow you to execute the same SQL query with different parameters without re-parsing the query each time, resulting in faster execution times. 

// Connect to the database
$pdo = new PDO('mysql:host=localhost;dbname=mydatabase', 'username', 'password');

// Prepare a SQL query using a prepared statement
$stmt = $pdo->prepare('SELECT * FROM users WHERE id = :id');

// Bind parameters to the prepared statement
$stmt->bindParam(':id', $userId, PDO::PARAM_INT);

// Execute the prepared statement
$stmt->execute();

// Fetch the results
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);

// Loop through the results
foreach ($results as $row) {
    // Process each row
}

Keywords

PHP PDO database queries optimization efficiency

Related Questions