//使用PDO對(duì)象連接數(shù)據(jù)庫(kù)
try{
$pdo = new PDO("mysql:dbname=origin;host=localhost","root","");
} catch (PDOException $e){
die("數(shù)據(jù)庫(kù)連接失?。?.$e -> getMessage());
}
//使用占位符準(zhǔn)備SQL語(yǔ)句
$sql = "select ? , ? , ? from user where age = ? ";
//進(jìn)行預(yù)處理
$stmt = $pdo -> prepare($sql);
//綁定參數(shù)
$stmt ->bindparam(1,$id);
$stmt ->bindparam(2,$name);
$stmt ->bindparam(3,$age);
$stmt ->bindparam(4,$num);
//給參數(shù)賦值
$id ='id';
$name = 'name';
$age ='age';
$num = 100;
//執(zhí)行
$stmt -> execute();
//處理結(jié)果集
while ($result = $stmt->fetch()){
var_dump($result);
}
/*程序運(yùn)行結(jié)果:
Array ( [id] => id [name] => name [age] => age )
Array ( [id] => id [name] => name [age] => age )
Array ( [id] => id [name] => name [age] => age )
Array ( [id] => id [name] => name [age] => age )
Array ( [id] => id [name] => name [age] => age )
Array ( [id] => id [name] => name [age] => age )
Array ( [id] => id [name] => name [age] => age )
Array ( [id] => id [name] => name [age] => age )
結(jié)果竟然全部是字段名，而不是字段值，不知道是為什么？
*/
PDO預(yù)處理對(duì)象參數(shù)綁定后,執(zhí)行查詢的結(jié)果竟然不是數(shù)據(jù)表的字段值，而成了字段名，請(qǐng)教一下，這是為什么？
明月笑刀無(wú)情
2019-03-12 05:35:25
