$str="insert into user (username,password,unit,tel,email,realname,province,city)values($username,$password,$unit,$tel,$email,$realname,$province,$city)";PHP里不用"'"的吧~~~不知道行不行?
我改称]这样的了,他提示的是:Query was empty 以下是我修改后的: <? $amyconn=mysql_connect("localhost","root","") or die("数据库出问题了"); mysql_select_db("mybbs",$amyconn) or die("数据库有问题"); $strsql="insert into user(username) values('$username')"; $result=mysql_query($strSql,$amyconn) or die(mysql_error()); ?>
哥们儿,我没注意呀,可是我把大小写搞对了,却还是不成呀,他提示: You have an error in your SQL syntax near 'user(username) values('11')' at line 1 看提示应该是$strsql=".........";中有什么错误,帮我检查呀!
$myconn=mysql_connect("localhost","root",""); mysql_select_db("mybbs",$myconn); $str="insert into user (username,password,unit,tel,email,realname,province,city) values('$username','$password','$unit','$tel','$email','$realname','$province','$city')"; $result=mysql_query($str);
1、一是cpplus(百合)说的:是NULL还是NOT NULL?
2、少了一个分号:‘;’。
EG: insert into table_name (filed1,filed1) values('$filed1','$filed2');
2.分号也不少呀!
以下是我修改后的:
<?
$amyconn=mysql_connect("localhost","root","") or die("数据库出问题了");
mysql_select_db("mybbs",$amyconn) or die("数据库有问题");
$strsql="insert into user(username) values('$username')";
$result=mysql_query($strSql,$amyconn) or die(mysql_error());
?>
You have an error in your SQL syntax near 'user(username) values('11')' at line 1
看提示应该是$strsql=".........";中有什么错误,帮我检查呀!
mysql_select_db("mybbs",$myconn);
$str="insert into user (username,password,unit,tel,email,realname,province,city) values('$username','$password','$unit','$tel','$email','$realname','$province','$city')";
$result=mysql_query($str);
values 前后都要空格
最后一行,改为这样看一看:
$result=mysql_query($str,$myconn);