register.php

网上书店网站系统

<?php
session_start();
//if($login==""||$password1==""||$password2==""||$question==""||$answer==""||$truename==""||$gender==""||$education==""||$marital==""||$occupation==""||$province=="")
//{
//	print "Please input what we told you!";
//	exit();
//}
if(strcmp($password1,$password2))
{
	print "Your two password is different!";
	exit();
}
if($email!="")
{
	if(""==strchr($email,'@'))
	{
		print "Your email address is  not right.<br>";
		print "If you do not want to fill it ,You can leave it blank!";
		exit();
	}
}
//if($year<=0||$month<=0||$day<=0||$month>12||$day>31)
//{
//	print "It seems that your birhtday is not right!";
//	exit();
//}

$handler=@mysql_pconnect("localhost","root","307910");

if($handler==false)
{
	print "Connect to Mysql failed!";
	exit();
}
	$query=@mysql_select_db("bookseller",$handler);#$query="use bookseller";
	$res=@mysql_query($query,$handler);
	if(res==false)
	{
		print "Switch to \"bookseller\"database failed";
		exit();
	}
$query="select * from register where login='$login';";
$res=@mysql_query($query,$handler);
$num=mysql_num_rows($res);
if($num==0)
{
	$date=sprintf("%s-%s-%s",$year,$month,$day);
//	$query="insert into register values(\"$login\",\"$password1\",\"$question\",\"$answer\",\"$truename\",\"$gender\",$year,$month,$day,\"$education\",\"$martial\",\"$occupation\",\"$province\",\"$email\");";
	$query="insert into register values(\"$login\",\"$password1\",\"$question\",\"$answer\",\"$truename\",\"$gender\",\"$education\",\"$marital\",\"$occupation\",\"$province\",\"$email\")";
	$res=@mysql_query($query,$handler);
	if($res==false)
	{
		print "Input into database failed!";
		exit();
	}
	print "You are register now!<br>";
	print "Please use your loginname and password to login!";
	exit();	
	}
else
{
	print "You loginname has been used.Please change it and login again!";
	exit();
}
		

?>