PHP PDO, Краткая инструкция.

    define ( SQLCHARSET, "cp1251" );   //define ( SQLCHARSET, "uft8" );  
    $dbhost = "localhost";  
    $dbname = "dbname";  
    $dbuser = "username";  
    $dbpass = "pawwsord";  
    $db = new PDO ( 'mysql:host=' . $dbhost . ';dbname=' . $dbname, $dbuser, $dbpass );  
    $db->query ( 'SET character_set_connection = ' . SQLCHARSET . ';' );  
    $db->query ( 'SET character_set_client = ' . SQLCHARSET . ';' );  
    $db->query ( 'SET character_set_results = ' . SQLCHARSET . ';' );

    $row = $db->query("select row from tablename WHERE 1;")->fetch();  
    $row=$row[row];

$row = $db->query("select row from tablename WHERE 1;")->fetch();

$row = $db->query("select row from tablename WHERE 1;")->fetchAll();

$player_stat = $db->query("SELECT COUNT(*) FROM players WHERE name = '".$val['name']."';")->fetchColumn()

    $sql = "SHOW COLUMNS FROM tablename;";  
    $dbresult = $db->prepare ( $sql );  
    $dbresult->execute ();  
    $dbfield = $dbresult->fetchAll ();  
    $count = $dbresult->rowCount();  
    for ($i=0; $i<$count; $i++) {  
        $keys[$i]="~".$dbfield[$i]['Field'];  
    }

    $sql = "SELECT * from tablename where 1;";  
    $result = $db->prepare ( $sql );  
    $result->execute ();  
    $tdata = $result->fetchAll ();  
    foreach ($tdata as $row){  
    //любые действия например  
    echo "<b>".$row['name']."</b>\n";  
    }

$ercode = $db->exec("delete from tablename where id='".$id."';")->errorCode();
print_r($ercode);

    /* например что то удаляем */  
    $db->exec("delete from tablename where id='".$id."';");  
    /* и смотрим */  
    $ercode=$db->errorCode();  
    $ercode=$ercode[0];  
    $ref=$_SERVER['HTTP_REFERER']  
    if($ercode>0){  
        echo "<script language=\"javascript\">alert('Системная ошибка.'); location.href='$ref';</script>";  
    }else{  
        echo "<script language=\"javascript\">location.href='$ref';</script>";  
    }

$q = $db->prepare("INSERT INTO table (".(implode(",",array_keys($t))).") VALUES ('".(implode("','",$t))."');")->execute();

$db->prepare("UPDATE table SET column='data' WHERE id = '1';")->execute();

    $lastid = $db->lastInsertId();

<?php
if ( !extension_loaded('pdo')  ){
....
}elseif ( !extension_loaded('pdo_mysql') ) {
....
}
?>