我無法弄清楚我的 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')";?>
1 回答
寶慕林4294392
TA貢獻2021條經驗 獲得超8個贊
您可以嘗試以這種方式使用您的查詢
$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();
- 1 回答
- 0 關注
- 163 瀏覽
添加回答
舉報
0/150
提交
取消