已采納回答 / EasyChen
很多 web 應用程序通過使用到數(shù)據(jù)庫服務的持久連接獲得好處。持久連接在腳本結束后不會被關閉,且被緩存,當另一個使用相同憑證的腳本連接請求時被重用。持久連接緩存可以避免每次腳本需要與數(shù)據(jù)庫回話時建立一個新連接的開銷,從而讓 web 應用程序更快。
2014-11-14
setAttribute(PDO::ATTR_ERRMODE,PDO::ERRROMODE_WARNING|EXCEPTION|SLIENCE)
2014-11-14
call test()
delimiter //
create procedure test
begin
select * from user;
select * from usergroups
end
//
delimiter ;
delimiter //
create procedure test
begin
select * from user;
select * from usergroups
end
//
delimiter ;
2014-11-14
debugDumpParams()我還以為可以打印添加參數(shù)后的sql語句呢
2014-11-14
PDOSTATEMENT對象果然強大 getColumnMeta()獲取列元數(shù)據(jù)信息 getCloumnCount()獲取列數(shù)
2014-11-14
"select username,password from user where userid=1"
$stmt->bindColumn(1,$username);
$stmt->bindColumn(2,$password);
while($stmt->fetch(PDO::FETCH_BOUND)){
echo $username,$password;
}
$stmt->bindColumn(1,$username);
$stmt->bindColumn(2,$password);
while($stmt->fetch(PDO::FETCH_BOUND)){
echo $username,$password;
}
2014-11-14
$stmt->bindParam(':username',$username,PDO::PARAM_STR);
$username = 'rambo;
$stmt->execute();
$username = 'king;
$stmt->execute();
$username = 'rambo;
$stmt->execute();
$username = 'king;
$stmt->execute();
2014-11-14
rowCount execute(array(':username'=>$username,':password'=>$password))
2014-11-14