tutorial.pdo.3.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);

    //named place holder
    $stmt = $dbh->prepare("INSERT INTO users ( username, full_name, email ) values ( ?, ?, ? )");
    $stmt->bindParam(1, $username);
    $stmt->bindParam(2, $full_name);
    $stmt->bindParam(3, $email);

    //insert 1st row
    $username = 'razali';
    $full_name = 'Razali Khairuddin';
    $email = '[email protected]';
    $stmt->execute();

    //insert 2nd row
    $username = 'suhaimi';
    $full_name = 'Suhaimi Kamal';
    $email = '[email protected]';
    $stmt->execute();

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