What are PDO statements and how are they used in PHP?

PDO statements in PHP are used for interacting with databases in a secure and efficient way. They help prevent SQL injection attacks by using parameterized queries. To use PDO statements, you first establish a database connection using the PDO class, then prepare a SQL query using the prepare method, bind any parameters using bindValue or bindParam, execute the query, and finally fetch the results if needed. 

// Establish a database connection
$pdo = new PDO('mysql:host=localhost;dbname=mydatabase', 'username', 'password');

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

// Bind parameters
$stmt->bindValue(':id', 1, PDO::PARAM_INT);

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

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

// Loop through results
foreach ($results as $row) {
    echo $row['username'] . '<br>';
}

Keywords

PDO statements PHP database query

Related Questions