我写了这段代码
<?php
mysql_connect ("localhost","root","root");
mysql_select_db ("new");
$newusername=$_POST ['newusername'];
$newpassword=$_POST ['newpassword'];
$submit=$_POST ['submit'];
if($submit) {
$newaccount= "INSERT INTO users (name,password) VALUES ("$newusername","$newpassword")";
$result=mysql_query($newaccount);
if ($result) {
print "account has been created"."<meta http-equiv="refresh" content="5;login.php">";
}
else {
echo " The account is already exist";
}
}
?>但是它在第8行显示错误,即“insert into”行
发布于 2014-07-22 15:42:15
双引号有一个问题。您可以添加连接:
$newaccount = "INSERT INTO users (name,password) VALUES ('" . $newusername . "','" . $newpassword . "')";备注:不要使用mysql_*函数(mysql扩展已弃用),请使用mysqli_*。
发布于 2014-07-22 15:42:52
您使用了错误的引号:
$newaccount= "INSERT INTO users (name,password) VALUES ('$newusername','$newpassword')";发布于 2014-07-22 17:24:40
整理引号并使用mysql_real_escape_string清理输入(并防止简单的SQL注入攻击):-
<?php
mysql_connect("localhost","root","root");
mysql_select_db ("new");
$newusername = mysql_real_escape_string($_POST['newusername']);
$newpassword = mysql_real_escape_string($_POST['newpassword']);
$submit = $_POST['submit'];
if($submit)
{
$newaccount = "INSERT INTO users (name, password) VALUES ('$newusername', '$newpassword')";
$result = mysql_query($newaccount);
if ($result)
{
print "account has been created"."<meta http-equiv='refresh' content='5;login.php'>";
}
else
{
echo " The account is already exist";
}
}
?>https://stackoverflow.com/questions/24881469
复制相似问题