简单的php用户注册程序[全套]-PHP源码

?>

注册php处理页面

//注册处理页面
//www.yd631.com
//技术D.JOY
function checkmail($nmail){ /// 验证电子邮件地址
if(ereg("^([a-zA-Z0-9_-])+@([a-zA-Z0-9_-])+(.[a-zA-Z0-9_-])+",$nmail))
return true;
else
return false;
}

include("config.php"); //参数页面提取过来

if(empty($_POST["yd631_name"])){
echo ("");
exit;
}
if(empty($_POST["yd631_pws"])){
echo ("");
exit;
}
if(empty($_POST["yd631_sex"])){
echo ("");
exit;
}
if(empty($_POST["yd631_age"])){
echo ("");
exit;
}
if(!is_numeric($_POST["yd631_age"])){
echo ("");
exit;
}
if(empty($_POST["yd631_call"])){
echo ("");
exit;
}
if(!is_numeric($_POST["yd631_call"])){
echo ("");
exit;
}
if(empty($_POST["yd631_email"])){
echo ("");
exit;
}
if($_POST["yd631_email"]!=""){

if(!checkmail($_POST["yd631_email"])) {
echo ("");
exit;
}
}

if(empty($_POST["yd631_address"])){
echo ("");
exit;
}

$yd631_name=$_POST["yd631_name"];
$yd631_pws=$_POST["yd631_pws"];
$yd631_sex=$_POST["yd631_sex"];
$yd631_age=$_POST["yd631_age"];
$yd631_call=$_POST["yd631_call"];
$yd631_email=$_POST["yd631_email"];
$yd631_address=$_POST["yd631_address"];
$yd631_time=date("Y-m-d");
$yd631_pass="no";

$db=mysql_connect($servername,$sqlservername,$sqlserverpws);
mysql_select_db($sqlname,$db) ;
$sql="select * from $sqltable where yd631_name='$yd631_name'";
$result=mysql_fetch_row(mysql_query($sql));

if($result){
echo ("");

}
else{
$sql="insert into $sqltable(yd631_name,yd631_pws,yd631_sex,yd631_age,yd631_call,yd631_email,yd631_address,yd631_time,yd631_pass) values('$yd631_name','$yd631_pws','$yd631_sex','$yd631_age','$yd631_call','$yd631_email','$yd631_address','$yd631_time','$yd631_pass') ";
mysql_query($sql);

echo ("");
}
?>

mysql数据库

--
-- 表的结构 `yd631_users`
--

CREATE TABLE `yd631_users` (
`yd631_id` int(10) NOT NULL auto_increment,
`yd631_name` varchar(10) default NULL,
`yd631_pws` varchar(10) default NULL,
`yd631_sex` varchar(4) default NULL,
`yd631_age` varchar(4) default NULL,
`yd631_call` varchar(15) default NULL,
`yd631_email` varchar(20) default NULL,
`yd631_address` text,
`yd631_pass` varchar(4) default NULL,
`yd631_time` date default NULL,
PRIMARY KEY (`yd631_id`)
) ;