What are some best practices for querying a database in PHP to minimize repetitive code?

When querying a database in PHP, one way to minimize repetitive code is to create a function that handles the database connection and query execution. By encapsulating this functionality in a function, you can easily reuse it throughout your codebase without duplicating the same database connection and query logic. 

// Function to query the database
function queryDatabase($query) {
    $servername = "localhost";
    $username = "username";
    $password = "password";
    $dbname = "database";

    // Create connection
    $conn = new mysqli($servername, $username, $password, $dbname);

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

    // Execute query
    $result = $conn->query($query);

    // Close connection
    $conn->close();

    return $result;
}

// Example usage
$query = "SELECT * FROM users";
$result = queryDatabase($query);

// Process results
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo "Name: " . $row["name"]. "<br>";
    }
} else {
    echo "0 results";
}

Keywords

SQL injection prepared statements PDO database abstraction layer query optimization

Related Questions