捷哥之天龙八部
1 <?php 2 header("content-type:text/html;charset=utf-8"); 3 //$ip = "192.168.1.1"; 4 //echo ip2long($ip); 5 //echo long2ip(-1062731519); 6 7 //1.接收数据 8 $username = $_POST['username']; 9 $password = $_POST['password']; 10 $repass = $_POST['repass']; 11 $age = $_POST['age']; 12 13 //获取当前脚本的请求时间(注册时间) 14 $rtime = $_SERVER['REQUEST_TIME']; 15 16 //获取客户端的IP地址(注册IP) 17 $rip = $_SERVER['REMOTE_ADDR']; 18 $rip = ip2long($rip); 19 20 //判断密码两次输入是否一致 21 if($password!=$repass){ 22 exit("对不起,亲,您手又抖了吧,两次密码输入不一致,请重新输入!"); 23 } 24 $password = md5($password); 25 26 //数据插入的天龙八部 27 //1.数据库连接 28 $link = mysql_connect("localhost","root","lixiaoshuai"); 29 30 //2.判断错误 31 if(mysql_errno()){ 32 exit("数据库连接失败:".mysql_error()); 33 } 34 35 //3.设置字符集 36 mysql_set_charset("utf8"); 37 38 //4.选择数据库 39 mysql_select_db("psd1311"); 40 41 //5.准备sql语句 42 $sql = "insert into shop_user(username,password,age,rtime,rip) values('$username','$password',{$age},{$rtime},{$rip})"; 43 44 //6.发送sql语句 45 $result = mysql_query($sql); 46 47 //7.处理结果 48 if($result && mysql_affected_rows()){ 49 echo "恭喜您,注册成功!注册的个数:".mysql_affected_rows().";您的ID号:".mysql_insert_id(); 50 }else{ 51 echo "对不起,您没有注册成功!失败原因:".mysql_error(); 52 } 53 54 //8.关闭连接 55 mysql_close($link); 56 57 58 59 60 61 62 63 64