第七色在线视频,2021少妇久久久久久久久久,亚洲欧洲精品成人久久av18,亚洲国产精品特色大片观看完整版,孙宇晨将参加特朗普的晚宴

為了賬號(hào)安全,請(qǐng)及時(shí)綁定郵箱和手機(jī)立即綁定
已解決430363個(gè)問(wèn)題,去搜搜看,總會(huì)有你想問(wèn)的

PHP 簡(jiǎn)單的 INSERT 數(shù)據(jù)庫(kù)

PHP 簡(jiǎn)單的 INSERT 數(shù)據(jù)庫(kù)

PHP
人到中年有點(diǎn)甜 2022-11-04 17:20:00
我無(wú)法弄清楚我的 PHP 有什么問(wèn)題,但 INSERT 似乎總是失敗。當(dāng)我提交表單時(shí),什么也沒(méi)有發(fā)生,也沒(méi)有任何錯(cuò)誤消息發(fā)送到我的數(shù)據(jù)庫(kù)<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貢獻(xiàn)2021條經(jīng)驗(yàn) 獲得超8個(gè)贊

您可以嘗試以這種方式使用您的查詢


$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();

綁定參數(shù)也更安全


$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();


查看完整回答
反對(duì) 回復(fù) 2022-11-04
  • 1 回答
  • 0 關(guān)注
  • 146 瀏覽

添加回答

舉報(bào)

0/150
提交
取消
微信客服

購(gòu)課補(bǔ)貼
聯(lián)系客服咨詢優(yōu)惠詳情

幫助反饋 APP下載

慕課網(wǎng)APP
您的移動(dòng)學(xué)習(xí)伙伴

公眾號(hào)

掃描二維碼
關(guān)注慕課網(wǎng)微信公眾號(hào)