php 用戶注冊頁面代碼 這款用戶注冊程序是一款包括有數據庫,注冊頁面,注冊js 驗證是一款完整理的php+mysql實用的用戶注冊代碼。
- */
- $conn=mysql_connect('localhost','root','root')or die('數據庫連接錯誤');
- mysql_select_db('demo',$conn);
- mysql_query("set names 'gbk'");
- //檢測會員名稱是否存在
- if($_post[username]){
- $sql="select * from users where username='$_post[username]'";
- $res=mysql_query($sql)or die("查詢失??!");
- $us=$_get[name];
- echo $us."222222";
- $ps= md5($_post[password]);
- $sex=$_post['sex'];
- $age=$_post['age'];
- $qq=$_post['qq'];
- $phone=$_post['phone'];
- $email=$_post['email'];
- $address=$_post['address'];
- if(is_array(mysql_fetch_row($res))){
- echo "該會員名已經存在!";
- }else{
- $sql="insert into users (username,password,sex,age,qq,phone,email,address) values ('$us','$ps',$sex,$age,$qq,'$phone','$email','$address')";
- echo $sql;
- mysql_query($sql)or die("注冊失敗");
- echo "<script>alert('注冊成功');location.href='login.php'</script>";
- }
- }
- ?>
- <script language="" type="text/javascript">
- function docheck(){
- var username = document.regform.username.value;
- var pwd =document.regform.password.value;
- var repwd=document.regform.repassword.value;
- if(username==""){
- alert("請輸入用戶名!");
- return false;
- }
- if(pwd==""){
- alert("請輸入密碼!");
- return false;
- }
- if(repwd != pwd){
- alert("兩次填寫的密碼不相同!");
- return false;
- }
- }
- </script>
- <script language="javascript">
- function createxmlhttprequest(){
- var xmlhttp;
- if(window.activexobject){
- xmlhttp = new activexobject("microsoft.xmlhttp");
- }else{
- xmlhttp = new xmlhttprequest();
- }
- //return xmlhttp;
- }
- function checkname(){
- var name = document.getelementbyid('username'); //獲取用戶名文本框
- var span = document.getelementbyid('name_info'); //獲取用于顯示結果的span標記
- if(name.value.length <= 4){
- span.style.color = '#ff0000'; //設置span標記內的字體顏色為紅色
- span.innerhtml = '用戶名長度不能少于4個字符!'; //span標記內容
- return false;
- }
- var xmlhttp = createxmlhttprequest();//創建異步請求對象
- var time = new date().gettime();
- var url = 'regval.php?name=' + name.value + '&tmp=' + time;//構造出請求地址
- xmlhttp.open("get",url,true); //建立一個異步請求
- //這里我們使用get方式請求
- xmlhttp.onreadystatechange = function(){ //監視請求狀態
- span.style.color = '#ff9900';
- span.innerhtml = '查詢中,請稍候!';
- if(xmlhttp.readystate == 4 && xmlhttp.status == 200){
- alert(xmlhttp.responsetext+"........");
- if(xmlhttp.responsetext.indexof('no') != -1){ //如果服務器返回的信息中有no
- span.style.color = '#cb2121'; //設置span標記顏色為紅色
- span.innerhtml = '用戶名[' + name.value + ']已經被別的用戶使用!';
- //document.regform.username.value="";
- }else{//如果返回信息中沒有no
- span.style.color = '#00a800';//設置顏色為綠色
- span.innerhtml = '恭喜您,該用戶名未被注冊!';
- }
- return true;
- delete xmlhttp; //刪除請求對象
- }
- }
- xmlhttp.send(null); //發送請求
- }
- </script>
- <form action="regval.php" method="post" onsubmit="return docheck()" name="regform">
- 會員名稱:
- <input type="text" name="username" value="" id="username" onblur="checkname()"/>
- <span id="name_info"></span>
- <br>
- 密 碼:
- <input type="password" name="password" value=""/><br>
- 確認密碼:
- <input type="password" name="repassword" value=""/><br>
- 性別:
- 男:<input name="sex" type="radio" value="0" checked="checked"/>
- 女:<input name="sex" type="radio" value="1"/><br>
- 年齡:<input type="text" name="age" value=""/><br>
- qq:<input type="text" name="qq" value=""/><br>
- 電話:<input type="text" name="phone" value=""/><br>
- email:<input type="text" name="email" value=""/><br>
- 地址:<input type="text" name="address" value=""/><br>
- <input type="submit" name="sub" value="注冊"/>
- <input type="reset" name="re" value="取消"/>
- </form>
- <?
- /*
- drop table if exists `users`;
- create table `users` (
- `id` int(10) not null auto_increment,
- `username` varchar(50) not null,
- `password` varchar(50) not null,
- `sex` int(1) not null default '0',
- `age` int(10) not null,
- `qq` int(15) default null,
- `phone` varchar(50) default null,
- `email` varchar(50) default null,
- `address` varchar(100) default null,
- primary key (`id`)
- ) engine=innodb auto_increment=4 default charset=gbk;
- -- ----------------------------
- -- records of users
- -- ----------------------------
- insert into `users` values ('1', 'admin', '21232f297a57a5a743894a0e4a801fc3', '0', '22', '379559090', '666666', '666666@163.com', '武漢');
- insert into `users` values ('2', 'root', '63a9f0ea7bb98050796b649e85481845', '0', '20', '1244249796', '8888888', '8888888@163.com', '中國');
- insert into `users` values ('3', 'www.111cn.net', '96e79218965eb72c92a549dd5a330112', '0', '20', '1244249796', '8888888', '8888888@163.com', '中國');
新聞熱點
疑難解答