Example #1
1
<?php

$dbh = getDBH();
$sth = $dbh->prepare("INSERT INTO user (name) VALUES (:name)");
$sth->execute(array(":name" => ""));
$id = $dbh->lastInsertId();
echo json_encode(array("id" => $id));
Example #2
1
function runSQL($sql, $exec = array())
{
    $dbh = getDBH();
    $sth = $dbh->prepare($sql);
    $sth->execute($exec);
    return $sth;
}