Skip to content

Instantly share code, notes, and snippets.

@hanafiah
Created March 7, 2014 07:31
Show Gist options
  • Save hanafiah/9406997 to your computer and use it in GitHub Desktop.
Save hanafiah/9406997 to your computer and use it in GitHub Desktop.
<?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("DELETE FROM users WHERE id = :id ");
$stmt->bindParam(':id', $id, PDO::PARAM_INT);
//Find this ID and update full name
$id = 3;
$stmt->execute();
echo "Deleted {$stmt->rowCount()} rows." ;
//close db handler
$dbh = null;
} catch (PDOException $e) {
echo "ouch!... ada ralat.";
file_put_contents('error_log.txt', $e->getMessage() . PHP_EOL, FILE_APPEND);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment