tutorial.pdo.bindParam.php

<?php

$host = 'localhost';
$dbname = 'tutorial_pdo';
$user = 'root';
$pass = '';

try {
    //$dbh , database handler aka db handler
    $dbh = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass);

    $stmt = $dbh->prepare("SELECT * FROM users WHERE id = ?");
    $stmt->bindParam(1, $id, PDO::PARAM_INT);
    $stmt->setFetchMode(PDO::FETCH_ASSOC);

    $id = 2;
    $stmt->execute();
    $row = $stmt->fetch();

    echo '<pre>';
    print_r($row);
    echo '</pre>';

    $id = 1;
    $stmt->execute();
    $row = $stmt->fetch();

    echo '<pre>';
    print_r($row);
    echo '</pre>';

    //close db handler
    $dbh = null;
} catch (PDOException $e) {
    echo "ouch!... ada ralat.";
    file_put_contents('error_log.txt', $e->getMessage() . PHP_EOL, FILE_APPEND);
}