php - 如何通过从表单获取变量来插入 pdo？

Question

如何通过 PDO 从表单中插入内容，它给出以下错误:

Fatal error: Call to a member function bindParam() on string  

这是我的代码:

$name = $_POST['name'];
$name = $_POST['subname'];
$phone= $_POST['phone'];

$sql = "INSERT INTO customers(name,subname,phone)VALUES(:name,:subname,:phone)";
$sql->bindParam(':name', $name);
$sql->bindParam(':subname', $subname);
$sql->bindParam(':phone', $phone);
$sql->bindParam(':telefono', $telefono);
$sql->execute();

Answer 1

您必须使用 PDO 语句，并首先准备查询:

$name = $_POST['name'];
$name = $_POST['subname'];
$phone= $_POST['phone'];

$sql = "INSERT INTO customers(name,subname,phone)VALUES(:name,:subname,:phone)";
$sth = $dbh->prepare($sql);
$sth->bindParam(':name', $name);
$sth->bindParam(':subname', $subname);
$sth->bindParam(':phone', $phone);
$sth->bindParam(':telefono', $telefono);
$sth->execute();