在同一页面通过html表单插入数据到数据库 [英] Insert data to database via html form in the same page
本文介绍了在同一页面通过html表单插入数据到数据库的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
<!doctype html>
<html>
<head>
<title>Lab03</title>
</head>
<form id="signin" action="lab_03.php" method="post">
Name: <input type="text" name="name">
<br />
First Name: <input type="text" name="fn">
<br />
SID: <input type="text" name="sid">
<br />
Email Address: <input type="text" name="email">
<input type="submit" value="Submit">
</form>
<?php
include ("connection.php");
mysqli_query($con,"INSERT INTO lab_03 (name, fname, sid, email) VALUES ($POST_[name], $POST_[fn], $POST_[sid], $POST_[email]");
?>
<body>
</body>
</html>
我想通过html表格插入数据到数据库,但我不想让另一个文件插入数据我上面的代码给我以下错误
I want to insert data to database via html form. But i don't want to make another file to insert data. I the above code gives me the following error.
推荐答案
将您的查询部分更改为这个:
Change your query part to this one:
mysqli_query($con,"INSERT INTO lab_03 (name, fname, sid, email) VALUES ('".$_POST['name']."', '".$_POST['fn']."',". $_POST['sid'].", '".$_POST['email']."'");
这篇关于在同一页面通过html表单插入数据到数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文