//链接数据库
$conn=mysql_connect("localhost","root","123456")or die("数据库连接失败");
mysql_select_db("php",$conn);
mysql_query("set names 'GBK'");
function htmlocode($content)
{
$content=str_replace("\n","
",str_replace(" "," ",$content));
return $content;
}
?>
//链接数据库
$link=mysql_connect("localhost","root","root") or die("数据库连接失败".mysql_error());
mysql_select_db("php",$link);
if ($_POST["submit"] == "提交"){
$username=$_POST["username"];
$password=$_POST["password"];
$email=$_POST["email"];
$insert_sql="insert into userinfo values(null,'".trim($username)."','".trim($password)."','".trim($email)."')";
$result=mysql_query("$insert_sql",$link);
mysql_query("set names gb2312");
if ($result){
echo "";
echo "";
}else {
echo "注册失败";
header("location:zhuce.php");
}
}
?>
注册界面function $(id){
return document.getElementById(id);
}
//用户名检测
function checkName(){
var username=$("username").value;
if(username == ""){
$("uname").className="fontShow";
$("uname").innerHTML="用户名不能为空";
$("username").focus();
}else if(username.length < 3){
$("uname").className="fontShow";
$("uname").innerHTML="用户名必须大于等于3位";
$("username").focus();
}else{
$("uname").className="fontShow";
$("uname").innerHTML="恭喜您,用户名有效";
}
}
//密码的检测
function checkPw(){ //密码
var password=$("password").value;
if(password == ""){
$("pw").className="fontShow";
$("pw").innerHTML="密码不能为空";
$("password").focus();
}else if(password.length < 6){
$("pw").className="fontShow";
$("pw").innerHTML="密码必须大于等于6位";
$("password").focus();
}else{
$("pw").className="fontShow";
$("pw").innerHTML="";
}
}
function checkRpw(){
var password=$("password").value;
var rpw=$("rpw").value;
if(rpw == ""){
$("rpassword").className="fontShow";
$("rpassword").innerHTML="确认密码不能为空";
$("rpw").focus();
}else if(password != rpw){
$("rpassword").className="fontShow";
$("rpassword").innerHTML="确认密码和密码不一致";
$("rpw").focus();
}else{
$("rpassword").className="fontShow";
$("rpassword").innerHTML="恭喜您,密码有效";
}
}
function checkEmail(){
var em=/^[0-9a-zA-Z](\w)+@(\w)+(\.)(com|cn|net|edu|com(\.)cn)/;
var email=$("email").value;
if(email == ""){
$("ckemail").className="fontShow";
$("ckemail").innerHTML="邮箱不能为空";
$("email").focus();
}else if(!email.match(em)){
$("ckemail").className="fontShow";
$("ckemail").innerHTML="邮箱格式不正确";
$("email").focus();
}else{
$("ckemail").className="fontShow";
$("ckemail").innerHTML="恭喜您,邮箱有效";
}
}
function check(){
var username=$("username").value;
var password=$("password").value;
var email=$("email").value;
if(username == "" || password == "" || email == ""){
$("sorry").className="fontShow";
$("sorry").innerHTML="提示:*为必填项,若不填写,不能进行提交!";
return false;
}else{
return true;
}
}
用户名*
密码*
确认密码*
Email*