SQLite mit PHP
-
$q = "SELECT COUNT(*) FROM fruits WHERE name='apple'";
echo $db->query($q)->fetchColumn(); -
$q = "SELECT COUNT(*) FROM fruits WHERE name=?";
echo $db->prepare($q)->execute(array("apple"))->fetchColumn(); - http://www.tu-chemnitz.de/docs/php/ref.sqlite.html
-
$stmt = $dbh->prepare("INSERT INTO REGISTRY (name, value) VALUES (:name, :value)");
$stmt->bindParam(':name', $name);
$stmt->bindParam(':value', $value);
// insert one row
$name = 'one';
$value = 1;
$stmt->execute(); -
$stmt = $dbh->prepare("INSERT INTO REGISTRY (name, value) VALUES (?, ?)");
$stmt->bindParam(1, $name);
$stmt->bindParam(2, $value);
»
