我試圖在將注冊表單的所有內(nèi)容放入數(shù)據(jù)庫之前測試對 MySQL 數(shù)據(jù)庫的寫入，但這是錯誤的。有人可以檢查一下我的 PHP 代碼，看看我哪里出錯了。<html> <body> <form action="testingPHP.php" method="post"> Name: <input type="text" name="Name"><br> Age: <input type="text" name="Age"><br> Gender: <select name="Gender"> <option value=" "> </option> <option value="Boy">Boy</option> <option value="Girl">Girl</option> </select><br> <input type ="submit"> </form> </body></html> PHP：$Name = $_.POST['Name'];$Age = $_.POST['Age'];$Gender = $_.POST['Gender'];$servername = "localhost";$username = "testing";$password = "testing1";$db = "tesingdb";$conn new mysql($sername, $username, $password, $db);$sql = "insert into testingtable (name,age,gender)values('$Name','$Age','$Gender')"$conn->close();
1 回答
素胚勾勒不出你
TA貢獻1827條經(jīng)驗 獲得超9個贊
以下是變化。
已刪除
testingPHP.php自<form action="testingPHP.php" ...>$_.POST到$_POST$conn = new mysqli(....)代替$conn new mysql(....)添加
$conn->query($sql);拼寫錯誤
$servername
其余代碼
<form action="" method="post">
Name: <input type="text" name="Name"><br>
Age: <input type="text" name="Age"><br>
Gender: <select name="Gender">
<option value=" "> </option>
<option value="Boy">Boy</option>
<option value="Girl">Girl</option>
</select><br>
<input type ="submit">
</form>
<?php
$Name = $_POST['Name'];
$Age = $_POST['Age'];
$Gender = $_POST['Gender'];
$servername = "localhost";
$username = "testing";
$password = "testing1";
$db = "tesingdb";
$conn = new mysqli($servername, $username, $password, $db);
$sql = "insert into testingtable (name,age,gender) values('$Name','$Age','$Gender')";
$conn->query($sql);
$conn->close();
?>
- 1 回答
- 0 關(guān)注
- 159 瀏覽
添加回答
舉報
0/150
提交
取消