How can late binding be implemented in PHP when dealing with SQL queries and arrays?

Late binding in PHP when dealing with SQL queries and arrays can be implemented by using prepared statements with placeholders for variables in the SQL query. This ensures that the variables are bound to the query at execution time, preventing SQL injection attacks and allowing for dynamic data to be passed into the query. 

// Example of implementing late binding with SQL query and array in PHP
$conn = new PDO("mysql:host=localhost;dbname=myDB", $username, $password);

// Prepare the SQL query with placeholders
$stmt = $conn->prepare("SELECT * FROM users WHERE id = :id AND status = :status");

// Bind variables to the placeholders
$id = 1;
$status = 'active';
$stmt->bindParam(':id', $id, PDO::PARAM_INT);
$stmt->bindParam(':status', $status, PDO::PARAM_STR);

// Execute the query
$stmt->execute();

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

// Use the results as needed
foreach($results as $result) {
    echo $result['username'] . "<br>";
}

Keywords

late binding PHP SQL queries arrays implementation

Related Questions