//使用PDO對象連接數據庫
try{
$pdo = new PDO("mysql:dbname=origin;host=localhost","root","");
} catch (PDOException $e){
die("數據庫連接失?。?.$e -> getMessage());
}
//使用占位符準備SQL語句
$sql = "select ? , ? , ? from user where age = ? ";
//進行預處理
$stmt = $pdo -> prepare($sql);
//綁定參數
$stmt ->bindparam(1,$id);
$stmt ->bindparam(2,$name);
$stmt ->bindparam(3,$age);
$stmt ->bindparam(4,$num);
//給參數賦值
$id ='id';
$name = 'name';
$age ='age';
$num = 100;
//執行
$stmt -> execute();
//處理結果集
while ($result = $stmt->fetch()){
var_dump($result);
}
/*程序運行結果:
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 )
結果竟然全部是字段名，而不是字段值，不知道是為什么？
*/
2 回答
幕布斯7119047
TA貢獻1794條經驗 獲得超8個贊
我把sql寫出來, 你就明白了.
select "id", "name", "age" from user where age = "100" - 2 回答
- 0 關注
- 624 瀏覽
添加回答
舉報
0/150
提交
取消