PHP 简单的 INSERT 数据库

Question

我无法弄清楚我的 PHP 有什么问题，但 INSERT 似乎总是失败。当我提交表单时，什么也没有发生，也没有任何错误消息发送到我的数据库<form action="" method="POST">  <div class="form-group mt-4">    <label for="exampleInputEmail1">Title</label>    <input type="text" class="form-control" name="title" aria-describedby="emailHelp" required>  </div>  <div class="form-group">    <label for="exampleInputPassword1">Products to buy</label>    <textarea class="form-control" name="products" rows="3" required></textarea>  </div>  <div class="form-group">    <label for="exampleInputPassword1">Comments</label>    <input type="text" class="form-control" name="comments" aria-describedby="emailHelp" required>  </div>  <button type="submit" class="btn btn-info">Submit</button></form><?php $title = null;if (isset($_POST['title'])) {    $title = htmlspecialchars($_POST['title']);}$products = null;if (isset($_POST['products'])) {  $products = htmlspecialchars($_POST['products']);}$comments = null;if (isset($_POST['comments'])) {  $comments = htmlspecialchars($_POST['comments']);}$pdo = new PDO('mysql:host=localhost;dbname=liste_course;charset=utf8', 'root', '', [  PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,  PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC]);$sql = "INSERT INTO content(id, title_content, products_content, comments_content) VALUES('','$title','$products','$comments')";?>

Answer 1

您可以尝试以这种方式使用您的查询

$pdo = new PDO('mysql:host=localhost;dbname=liste_course;charset=utf8', 'root', '', [

  PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,

  PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC

]);

//$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$query = $pdo->prepare("INSERT INTO content(id, title_content, products_content, comments_content) VALUES('','$title','$products','$comments')");

$query->execute();

绑定参数也更安全

$query = $pdo->prepare("INSERT INTO content(id, title_content, products_content, comments_content) VALUES(:id,:title,:products,:comments)");

$query->bindParam(":id", $id);

$query->bindParam(":title", $title);

$query->bindParam(":products", $products);

$query->bindParam(":comments", $comments);

$query->execute();