![]() |
|
首页 │ Apache │ Linux│ Java│ MySQL│ 注册│帮助 | |||
[PHP]
Mysql 表
CREATE TABLE `user` (
`ID` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`username` VARCHAR( 20 ) NOT NULL ,
`password` VARCHAR( 20 ) NOT NULL ,
`fullname` VARCHAR( 20 ) NOT NULL ,
`email` VARCHAR( 20 ) NOT NULL ,
`wenti` VARCHAR( 20 ) NOT NULL ,
`huida` VARCHAR( 20 ) NOT NULL ,
PRIMARY KEY ( `ID` )
);
插入程序:
var $reg_user;
var $reg_pass;
var $reg_fullname;
var $reg_email;
var $reg_wenti;
var $reg_huida;
function RegisterUser($username,$password,$fullname,$email,$wenti,$huida)
{
$this->reg_user=$username;
$this->reg_pass=$password;
$this->reg_fullname=$fullname;
$this->reg_email=$email;
$this->reg_wenti=$wenti;
$this->reg_huida=$huida;
if(!$this->Connects()) //数据库不能连接返回错误信息
{
return($this->Connects());
exit;
}
else
{
$sql="SELECT * FROM user WHERE username='$this->reg_user'";
$query=mysql_query($sql);
if(!$query)
{
return("数据查找出错请检查SQL语句");
exit;
}
else
{
$arry=mysql_fetch_array($query);
$count=count($array['username']);
if($count!=0)
{
return("您的用户名已经存在");
exit;
}
else
{
$sql="INSERT INTO user (ID,username,password,fullname,email,wenti,huida) VALUES ('','$this->username','$this->password','$this->fullname','$this->email','$this->wenti','$this->huida')";
$query=mysql_query($sql);
if($query)
{
return("ok");
exit;
}
else
{
return("数据添加出错请检查SQL语句".mysql_error());
}
}
}
}[/PHP]
每次插入数据库中只有一个root的记录,不是我插入的数据
为何?

