What are the recommended ways to structure PHP code for connecting to and querying a MySQL database?

When connecting to and querying a MySQL database in PHP, it is recommended to use PDO (PHP Data Objects) for improved security and flexibility. PDO allows for parameterized queries to prevent SQL injection attacks and supports multiple database drivers, including MySQL. Structuring the code with PDO also makes it easier to switch to a different database system in the future. 

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $stmt = $conn->prepare("SELECT * FROM table WHERE column = :value");
    $stmt->bindParam(':value', $value);
    $stmt->execute();

    while ($row = $stmt->fetch()) {
        // Process results
    }
} catch(PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
}
?>

Keywords

PHP MySQL database connection query structured code

Related Questions