ステートメントクラス

<?php
$dbh = new PDO('sqlite:test.db','', '');
 
/* ステートメントクラスの生成 */
$query = "INSERT INTO account_tbl(number,name,email)".
                            "VALUES(:number,:name,:email) ";
$stmt = $dbh->prepare($query); 
 
$stmt->bindParam(':number',$number, PDO_PARAM_INT);
$stmt->bindParam(':name',  $name, PDO_PARAM_STR, 64);
$stmt->bindParam(':email', $email, PDO_PARAM_STR, 128);
 
$number = 30248;
$name = '高橋'; 
$email = 'yujiro@rakuto.net'; 
/* クエリを実行する */
$stmt->execute(); 
?>

<?php
    /* データの取得 */
    $stmt = $dbh->prepare('SELECT * FROM account_tbl'); 
    $stmt->execute();
    $cols = array();
    /* 結果リソースから値を返す */
    while ($cols = $stmt->fetch(PDO_FETCH_ASSOC)) { 
        echo "----------------------n";
        echo "id    = {$cols['id']}n";
        echo "name  = {$cols['name']}n";
        echo "email = {$cols['email']}n";
        echo "----------------------n";
    } 
    $stmt = null;
?>

<?php
$stmt = $dbh->prepare('SELECT name FROM account_tbl id = 1'); 
/* 最初のカラム情報を取得 */
echo $stmt->fetchSingle();
?>

<?php
/* データの取得 */
$stmt = $dbh->prepare('SELECT * FROM account_tbl'); 
$stmt->execute();
$all = $stmt->fetchAll();
 
print_r($all);
?>

<?php
$dbh = new PDO('sqlite:test.db','', '');
 
/* ステートメントクラスの生成 */
$query = "INSERT INTO account_tbl(number,name,email)".
                            "VALUES(:number,:name,:email) ";
$stmt = $dbh->prepare($query); 
 
/* バインド変数を設定 */
$stmt->bindParam(':number',$number, PDO_PARAM_INT);
$stmt->bindParam(':name',  $name, PDO_PARAM_STR, 64);
$stmt->bindParam(':email', $email, PDO_PARAM_STR, 128);
 
$number = 30248;
$name = '高橋'; 
$email = 'yujiro@rakuto.net'; 
/* クエリを実行する */
$stmt->execute(); 
?>

<?php
$dbh = new PDO('sqlite:test.db','', '');
 
$stmt = $dbh->prepare('SELECT id, name, email FROM account_tbl'); 
$stmt->execute(); 
/* バインドカラム処理 */
$stmt->bindColumn('id', $id); 
$stmt->bindColumn('name', $name); 
$stmt->bindColumn('email', $email); 
 
while ($stmt->fetch(PDO_FETCH_BOUND)) { 
    echo "----------------------n";
    echo "id    = {$id}n";
    echo "name  = {$name}n";
    echo "email = {$email}n";
    echo "----------------------n";
} 
?>

<?php
$dbh = new PDO('sqlite:test.db','', '');
 
$stmt = $dbh->prepare('DELETE FROM account_tbl'); 
$stmt->execute(); 
 
/* 影響を受けた行数の取得 */
echo $stmt->rowCount();
?>

<?php
/* PDO データベースハンドルの生成 */
$dbh = new PDO('sqlite:test.db','', '');
 
/* エラーモードの設定（デフォルト） */
$dbh->setAttribute(PDO_ATTR_ERRMODE, PDO_ERRMODE_SILENT);
 
/* テーブルの作成 */
$query = <<<QUERY
CREATE TABLE account_tbl (
    id INTEGER,
    name VARCHAR(64) NOT NULL,
    email VARCHAR(128) UNIQUE,
    PRIMARY KEY (id)
);
QUERY;
$dbh->query($query); 
/* エラー判定 */
if (PDO_ERR_NONE != $dbh->errorCode()){
    $error = $dbh->errorInfo();
    print_r($error);
}
 
/* プリペアドステートメントの生成 */
$query = "INSERT INTO account_tbl (name,email) ".
                            "VALUES (:name,:email) ";
$stmt = $dbh->prepare($query); 
$stmt->bindParam(':name',  $name, PDO_PARAM_STR, 64);
$stmt->bindParam(':email', $email, PDO_PARAM_STR, 128);
 
$values = array(
    array('name'=>'高橋', 'email'=>'yujiro@rakuto.net'),
    array('name'=>'藤井', 'email'=>'fuzy@rakuto.net')
);
 
foreach ($values as $value){
    $name = $value['name'];
    $email = $value['email'];
    $stmt->execute();
}
 
/* エラー判定 */
if (PDO_ERR_NONE != $stmt->errorCode()){
    $error = $stmt->errorInfo();
    print_r($error);
}
 
$stmt = null;
?>

<?php
$dbh = new PDO('sqlite:test.db','', '');
 
$stmt = $dbh->prepare('SELECT id, name, email FROM account_tbl'); 
 
/* アトリビュート設定 */
$stmt->setAttribute(PDO_ATTR_CURSOR, PDO_CURSOR_FWDONLY);
?>

<?php
$dbh = new PDO('sqlite:test.db','', '');
 
$stmt = $dbh->prepare('SELECT id, name, email FROM account_tbl'); 
 
/* アトリビュート設定 */
$result = $stmt->getAttribute(PDO_ATTR_CONNECTION_STATUS);
print_r($result);
?>

<?php
echo $stmt->columnCount();
?>

<?php
echo $stmt->getColumnMeta(1);
?>