PHP PDO數(shù)據(jù)庫操作預處理與注意事項

?php
header('content-type:text/html; charset=utf-8');
//實例化pdo對象
$pdo = new PDO('mysql:host=127.0.0.1;port=3306;dbname=test;', 'root', '888888');
//通過query函數(shù)執(zhí)行sql命令
$pdo->query('set names utf8');
//插入數(shù)據(jù)
$sql  = "insert into persons (name,age) values (?, ?);";
$preObj = $pdo->prepare($sql);
$res  = $preObj->execute(array('小明', 22));
var_dump($res);
//刪除數(shù)據(jù)
$sql = "delete from persons where id = ?";
$preObj = $pdo->prepare($sql);
$res  = $preObj->execute(array(3));
var_dump($res);
//修改數(shù)據(jù)
$sql = "update persons set name = ? where id = ?;";
$preObj = $pdo->prepare($sql);
$res  = $preObj->execute(array('lucy', 5));
var_dump($res);
//查詢數(shù)據(jù)
$sql = "select * from persons where age > ? order by id desc;";
$preObj = $pdo->prepare($sql);
$preObj->execute(array(20));
$arr = $preObj->fetchAll(PDO::FETCH_ASSOC);
/*
 * FETCH_BOTH   是默認的，可省，返回關(guān)聯(lián)和索引。
 * FETCH_ASSOC   參數(shù)決定返回的只有關(guān)聯(lián)數(shù)組。
 * PDO::FETCH_NUM 返回索引數(shù)組
 * PDO::FETCH_OBJ 返回由對象組成的二維數(shù)組
 */
print_r($arr);

?php
$dsn = 'mysql:dbname=test;host=127.0.0.1';
$user = 'root';
$password = '';
try {
  $dbh = new PDO($dsn, $user, $password);
} catch (PDOException $e) {
  echo 'Connection failed: ' . $e->getMessage();
}
/* Execute a prepared statement by passing an array of values */
$sth = $dbh->prepare('INSERT INTO room (create_time,create_uid,exp_time,is_private) VALUES (?,?,?,?)');
$rs = $sth->execute(["2018-05-14 14:10:04",0,1526278504,1]);
var_dump($sth->errorInfo());exit;