20,398
社区成员




CREATE TABLE `user` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(32) DEFAULT NULL,
`uid` varchar(32) CHARACTER SET latin1 DEFAULT NULL,
`uname` varchar(64) CHARACTER SET latin1 DEFAULT NULL,
`password` varchar(64) CHARACTER SET latin1 DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
conn.php
<?php
$conn=mysql_connect('localhost','root','');
mysql_select_db('test');
mysql_query("SET NAMES utf8");
reg.php
<?php
include 'conn.php';
?>
<html>
<header>
<script type="text/javascript" src="http://code.jquery.com/jquery-1.4.1.min.js"></script>
</header>
<body>
<script type="text/javascript">
var p1,p2,uid,name,uname;
$(document).ready(function(){
$('#reg').click(function(){
p1=$.trim($('#p1').val());
p2=$.trim($('#p2').val());
uid=$.trim($('#uid').val());
name=$.trim($('#name').val());
uname=$.trim($('#uname').val());
if(uid.length<4||uid.length<4){
alert('必须输入后4位身份证号');
$('#uid').focus();
return false;
}
if(p1!=p2){
alert('两次密码不一样');
$('#p2').focus();
return false;
}
$.post("check.php",{password:p1,name:name,uid:uid,uname:uname},function(result){
if(result==-1){
alert('姓名或身份证后四位不正确');
$('#name').focus();
return false;
}else if(result==-2){
alert( '账号已经注册');
$('#name').focus();
return false;
}else if(result==1){
alert('恭喜你注册成功!');
$('#tips').html('姓名:'+name+'用户名:'+uname+'密码'+p1);
}
});
});
});
</script>
<table align="center">
<tr><td>姓名:</td><td><input type="text" name="name" id='name' maxlength='12'></td></tr>
<tr><td>身份证后四位:</td><td><input type="text" name="uid" id='uid' maxlength='4'></td></tr>
<tr><td>用户名:</td><td><input type="text" name="uid" id='uname' maxlength='12'></td></tr>
<tr><td>密码:</td><td><input type="password" name="password1" id="p1" maxlength='12'></td></tr>
<tr><td>重复密码:</td><td><input type="password" name="password2" id='p2' maxlength='12'></td></tr>
<tr align="center"><td colspan="2"><button id="reg">注册</button> </td></tr>
<tr id='tips'></tr>
</table>
</body>
</html>
check.php
<?php
include 'conn.php';
$puid=$_POST['uid'];
$name=$_POST['name'];
$password=$_POST['password'];
$uname=$_POST['uname'];
$sql="select * from user where name='$name' and uid like '%$puid'";
if($result=mysql_query($sql)){
while ($row = mysql_fetch_array($result)) {
$uid=$row['id'];
$uname2=$row['uname'];
$password2=$row['password'];
}
if(strlen($name2)>0||strlen($password2)>0){
echo -2;exit;
}
if(is_numeric($uid)){
$sql2="update user set uname=$uname,password=$password where id=$uid ";
if(mysql_query($sql2)){
echo 1;
}
}else{
echo -1;exit;
}
}else{
echo -1;exit;
}
?>
<?php
include 'conn.php';
$puid=$_POST['uid'];
$name=$_POST['name'];
$password=$_POST['password'];
$uname=$_POST['uname'];
$sql="select * from user where name='$name' and uid like '%$puid'";
if($result=mysql_query($sql)){
while ($row = mysql_fetch_array($result)) {
$uid=$row['id'];
$uname2=$row['uname'];
$password2=$row['password'];
}
if(strlen($name2)>0||strlen($password2)>0){
echo -2;exit;
}
if(is_numeric($uid)){
$sql2="update user set uname=$uname,password=$password where id=$uid ";
if(mysql_query($sql2)){
echo 1;
}
}else{
echo -1;exit;
}
}else{
echo -1;exit;
}
?>
<?php
$conn=mysql_connect('localhost','root','');
mysql_select_db('test');
mysql_query("SET NAMES utf8");
reg.php
<?php
include 'conn.php';
?>
<html>
<header>
<script type="text/javascript" src="http://code.jquery.com/jquery-1.4.1.min.js"></script>
</header>
<body>
<script type="text/javascript">
$(document).ready(function(){
$('#reg').click(function(){
p1=$.trim($('#p1').val());
p2=$.trim($('#p2').val());
uid=$.trim($('#uid').val());
name=$.trim($('#name').val());
uname=$.trim($('#uname').val());
if(uid.length<4||uid.length<4){
alert('必须输入后4位身份证号');
$('#uid').focus();
return false;
}
if(p1!=p2){
alert('两次密码不一样');
$('#p2').focus();
return false;
}
$.post("check.php",{password:p1,name:name,uid:uid,uname:uname},function(result){
if(result==-1){
alert('姓名或身份证后四位不正确');
$('#name').focus();
return false;
}else if(result==-2){
alert( '账号已经注册');
$('#name').focus();
return false;
}else if(result==1){
alert('恭喜你注册成功!');
$('#tips').html('姓名:'+name+'用户名:'+uname+'密码'+p1);
}
});
});
});
</script>
<table align="center">
<tr><td>姓名:</td><td><input type="text" name="name" id='name' maxlength='12'></td></tr>
<tr><td>身份证后四位:</td><td><input type="text" name="uid" id='uid' maxlength='4'></td></tr>
<tr><td>用户名:</td><td><input type="text" name="uid" id='uname' maxlength='12'></td></tr>
<tr><td>密码:</td><td><input type="password" name="password1" id="p1" maxlength='12'></td></tr>
<tr><td>重复密码:</td><td><input type="password" name="password2" id='p2' maxlength='12'></td></tr>
<tr align="center"><td colspan="2"><button id="reg">注册</button> </td></tr>
<tr id='tips'></tr>
</table>
</body>
</html>
CREATE TABLE `user` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(32) DEFAULT NULL,
`uid` varchar(32) CHARACTER SET latin1 DEFAULT NULL,
`uname` varchar(64) CHARACTER SET latin1 DEFAULT NULL,
`password` varchar(64) CHARACTER SET latin1 DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;