Skip to content

Instantly share code, notes, and snippets.

@cam-gists
Created June 10, 2012 00:11
Show Gist options
  • Save cam-gists/2903181 to your computer and use it in GitHub Desktop.
Save cam-gists/2903181 to your computer and use it in GitHub Desktop.
PHP: PDO
<?php
require 'config.php';
try {
# MySQL with PDO_MYSQL
$DBH = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass);
$DBH->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING );
}
catch(PDOException $e) {
echo $e->getMessage();
}
$data = array(
'' => $var,
'' => $var2,
'' => $var3
);
$sql ="INSERT INTO table (`var`, `var2`, `var3`)
VALUES (:var1, :var2, :var3)";
$STH = $DBH->prepare($sql);
$STH->execute($data);
$row = fetch(PDO::FETCH_ASSOC);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment