存储数组的PDO执行变量 - PDO execute variable which stores array

PDO execute variable which stores array

本文关键字：执行变量 PDO 数组存储 | 更新日期: 2023-09-27

$data变量存储一个包含用户名和密码的数组，需要将其插入到某个表中。

$data = array('username' => $username, 'password' => $password);
foreach($data as $key => $value){
   $values = $values . "'" . $value . "'" . ",";
}
$sql = "INSERT INTO table(username, password) VALUES (?, ?)";
$query = $con->prepare($sql);
$query->execute($values);

如何更改此代码，使其将$values变量的值打印到执行函数中？例如"新用户"，"我的秘密通行证"

你可以这样做：

$data = array('username' => $username, 'password' => $password);
$sql = "INSERT INTO table(username, password) VALUES (:username, :password)";
$query = $con->prepare($sql);
foreach($data as $key => $value){
   $query->bindValue($key, $value);
   #echo 'key = '.$key.' | value = '.$value;
}
$query->execute();

上面将每个值绑定到其占位符，如果要打印它们，可以。

试试这个！通过传递插入值数组来执行预准备语句。

$sql = "INSERT INTO table(username, password) VALUES (?, ?)";
$query = $con->prepare($sql);  
$query->execute(array($username, $password));

您可以像

$sql = "INSERT INTO table(username, password) VALUES (:user, :pass)";
$query = $con->prepare($sql);
$query->bindParam(':user', $data['username'] );
$query->bindParam(':pass', $data['password']);
$query->execute();