<?php
/* SQLiteハンドルの取得 */
$dbh = new PDO('sqlite:test3.db','', '');
 
/* テーブルの作成 */
$query = <<<QUERY
CREATE TABLE REGISTRY  (
    name VARCHAR(64),
    value INTEGER
);
QUERY;
$dbh->exec($query);
 
 
/* -------------------------------- */
/* http://jp2.php.net/pdo  サンプル */
$stmt = $dbh->prepare("INSERT INTO REGISTRY (name, value) VALUES (?, ?)");
 
$stmt->bindParam(1, $name);
$stmt->bindParam(2, $value);
 
// 行を挿入します
$name = 'one';
$value = 1;
$stmt->execute();
 
// パラメータを変更し、別の行を挿入します
$name = 'two';
$value = 2;
$stmt->execute();
/* -------------------------------- */
 
 
/* データの取得 */
$stmt = $dbh->prepare('SELECT * FROM REGISTRY'); 
$stmt->execute(); 
while ($cols = $stmt->fetch(PDO::FETCH_ASSOC)) { 
    echo "----------------------<br />";
    echo "name  = {$cols['name']}<br />";
    echo "value = {$cols['value']}<br />";
    echo "----------------------<br />";
} 
/* カーソルを閉じる */
$stmt->closeCursor();
?>