php - 为什么我的绑定参数查询不起作用？

Question

我想在我的文件中一次执行 3 个查询，我的代码如下所示：

$stmtinsertcustomers = $conn->prepare("INSERT INTO customers (id, name, phone)
VALUES ('', ?, ?)");
echo $conn->error;
$stmtinsertcustomers->bind_param("ss", $name, $phone);
$stmtinsertcustomers->execute();
$last_id = mysqli_insert_id($conn);
$stmtinsertcustomers->close();


$stmtinsertorder = $conn->prepare("INSERT INTO orders (customerid, orderid, orderdate) VALUES (?,?,?)");
echo $conn->error;
$stmtinsertorder->bind_param("sss", $last_id, $orderid, $date);
$stmtinsertorder->execute();
$stmtinsertorder->close();

$stmtinsertorderitems = $conn->prepare("INSERT INTO orderitems (orderid, productid) VALUES (?,?)");
echo $conn->error;
$stmtinsertorderitems->bind_param("ss", $orderid, $productid);
$stmtinsertorderitems->execute();
$stmtinsertorderitems->close();

但不幸的是它不起作用，有什么问题？感谢您的帮助！

标签： phpmysqli