"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
$stmt->setFetchMode(PDO::FETCH_ASSOC)
2014-11-12
通過這門課程 一來復(fù)習鞏固pdo使用的基礎(chǔ)知識 而來提醒自己以后要書寫嚴謹?shù)拇a 例如在sql exec或者query的時候try-catch錯誤信息,并使用errorInfo獲取提示信息
2014-11-12
$pdo->errorCode() $pdo->errorInfo()
2014-11-12
uri:file://dsn.txt mysql:dbname=imoov;host=loacalhost php.ini->pdo.dsn.imooc="mysql:host=localhost;dbname=imoov"
2014-11-12