我有麻烦插入表单数据到我的数据库。它成功地连接到数据库,但是数据没有插入到我的MySQL数据库中。希望你能帮忙!提前感谢!
这是表单代码:
<form id="score" method="post" action="process.php">
<fieldset>
<div class="box1">
<legend>Your details</legend>
<ol>
<li>
<label for=name>Name</label>
<input id=name name=name type=text placeholder="First and last name" required autofocus>
</li>
<li>
<label for=email>Email</label>
<input id=email name=email type=email placeholder="example@domain.com" required>
</li>
<li>
<label for=phone>Phone (country code if overseas)</label>
<input id=phone name=phone type=tel placeholder="Eg. +447500000000" required>
</li>
</ol>
</div>
</fieldset>
<fieldset style="border: none;">
<button type=submit>Continue</button>
</fieldset>
</form>
这是php代码(filename process.php):
<?php
if( $_POST )
{
$con = mysql_connect("localhost","database_user","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("database_name", $con);
$insert_query = "insert into feedback(
name,
phone,
email
) values (
".$_POST['name'].",
".$_POST['phone'].",
".$_POST['email'].")";
($insert_query);
echo "<h2>Thank you for your feedback!</h2>";
mysql_close($con);
}
?>
您错过了mysql_query
功能:
这样使用:
$retval = mysql_query( $insert_query, $con );
if(! $retval )
{
die('Could not enter data: ' . mysql_error());
}
参考链接试试:
<?php
if( $_POST )
{
$con = mysql_connect("localhost","database_user","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("database_name", $con);
$insert_query = "insert into feedback(
name,
phone,
email
) values (
'".$_POST['name']."',
'".$_POST['phone']."',
'".$_POST['email']."')";
mysql_query($insert_query);
echo "<h2>Thank you for your feedback!</h2>";
mysql_close($con);
}
?>
mysql_query()缺失
也用"关闭查询变量。因为它们是字符串,所以你需要使用它们,否则会失败。
欢呼
缺少mysql_query()
。替换
($insert_query);
mysql_query($insert_query);