php向mysql写入_php向mysql写入数据

提示注册成功了，可查询表就没没数据~<?php $con=mysql_connect("localhost","root","gl");mysql_select_db("happysea");$name=$_POST['name'];$password=$_POST['password'];$sex=$_P...

提示注册成功了，可查询表就没没数据~

$con=mysql_connect("localhost","root","gl");

mysql_select_db("happysea");

$name=$_POST['name'];

$password=$_POST['password'];

$sex=$_POST['sex'];

$e_mail=$_POST['e_mail'];

$question=$_POST['question'];

$answer=$_POST['answer'];

$sql="insert into userinfo(name,password,sex,e_mail,question,answer)

values('$name','$password','$sex','$e_mail','$question','$answer')";

if(!$sql)

{

echo('注册失败!');

}

else

{

echo('注册成功!');

}

?>

这是数据库。。

mysql> describe userinfo;

+----------+-------------+------+-----+---------+----------------+

| Field | Type | Null | Key | Default | Extra |

+----------+-------------+------+-----+---------+----------------+

| id | int(11) | NO | PRI | NULL | auto_increment |

| name | text | YES | | NULL | |

| password | varchar(20) | YES | | NULL | |

| sex | char(4) | YES | | NULL | |

| e_mail | varchar(30) | YES | | NULL | |

| question | text | YES | | NULL | |

| answer | text | YES | | NULL | |

+----------+-------------+------+-----+---------+----------------+

展开