PHP+MySQL注册登陆代码
这是一款用户注册的功能,可以实现简单的用户由创建数据库到注册成功,有需要的朋友可以参考一下,代码如下:
- $DB_HOST = "localhost";
- $DB_LOGIN = "root";
- $DB_PASSWORD = "admin";
- $DB_NAME = "flag";
-
- $conn= mysql_connect($DB_HOST, $DB_LOGIN, $DB_PASSWORD);
- mysql_select_db($DB_NAME);
- ?>
-
-
- ************************222222
-
- functiondb_query($sqlstr) {returnmysql_query($sqlstr);}
- functiondb_num_rows($res) {returnmysql_num_rows($res);}
- functiondb_fetch_array($res) {returnmysql_fetch_array($res);}
- functiondb_fetch_object($res) {returnmysql_fetch_object($res);}
- functiondb_data_seek($res,$num){return mysql_data_seek($res,$num);}
- functiondb_insert_id($res) {returnmysql_insert_id($res);}
- ?>
-
-
-
-
- **************************333333333333
-
- include("registry_up.htm")
- ?>
- <script>
- functioncheck()
- {
- if(document.regstep1.username.value== "")
- {
- alert("未输入账号");
- returnfalse;
- }
- if(document.regstep1.userpass.value== "")
- {
- alert("请勿使用空白密码");
- returnfalse;
- }
- if(document.regstep1.userpass.value!= document.regstep1.userpass2.value)
- {
- alert("两次输入的密码不相同");
- returnfalse;
- }
-
- document.regstep1.submit();
-
- }
- </script>
-
- <script>
-
- function Checkname(){
- var Name = document.regstep1.username.value;
- window.open("uniquecheck.php?name="+Name,"Check","width=300,height=10,status=0,scrollbars=0,resizable=1,menubar=0,toolbar=0,location=0");
- }
-
- </script>
-
- method="post" action="registry_do.php">
- /*?>">
-
-
-
-
- border="0"bordercolor="#000000" align="center"cellspacing="0">
-
-
- border="0"height="220" align="center" bgcolor="#EEEEEE" cellspacing="0"cellpadding="0">
-
"2" | bgcolor="#FFFFFF">
- "center">"images/1.GIF"width="298" height="41">
-
-
-
-
-
"center"
>账 号
-
"18" | >
- "center">
- "text"name="username" size="15">
- "网页特效:Checkname()" type=button value="检查账号"name="button">
-
-
-
-
-
"#FFFFFF" | >
- "center">密 码
-
"6" | bgcolor="#FFFFFF">
"center"
>
- "password" name="userpass" size="20">
-
-
-
-
-
- "center">密 码 确 认
-
"2" | >
- "center">
- "password" name="userpass2" size="20">
-
-
-
-
"#FFFFFF" | >
- "center">密 码 提 示
-
"2" | bgcolor="#FFFFFF">
- "center">
- "pass_rem">
- "0">您宠物的名字
- "1">您最想去的国家
- "2">您最喜欢的运动
- "3">您最讨厌的食物
- "4">您在家最常做什么
- "5">您最爱看的电影
-
-
-
-
-
-
- "center">答 案
-
"2" | >
- "center">
- "text"name="pass_ans" size="20">
-
-
-
-
"2" | bgcolor="#FFFFFF">
- "center">
- "reset" name="reset" value="清除重填">
- "button" name="Submit" value="提交"onClick="check();">
-
-
-
-
-
-
-
-
-
- include("registry_down.htm")
- ?>
-
- ******************************44444444444
-
- include("db_conn.php");
- include("db_func.php");
-
-
- $SQLStrUser= "INSERT INTO member (m_username, m_userpass, m_pass_rem, m_pass_ans)";
- $SQLStrUser.= " VALUES('$username', '$userpass', '$pass_rem', '$pass_ans') ";
- db_query($SQLStrUser);
-
-
-
- ?>
-
- ****************************55555555555555555
-
- include("db_conn.php");
- include("db_func.php");
-
-
- $SQLStr= "SELECT * FROM nogood WHERE n_name LIKE '%$username%'";
- $res= db_query($SQLStr);
-
-
- if(db_num_rows($res)>0)
- {
- echo"<script>";
- echo"alert("请勿使用不雅名称" . $username . "为账号");";
- echo"location.href = "registry1.php";";
- echo"</script>";
- }
- ?>
-
- ******************************6^^^^^^^^
- include("db_conn.php");
- include("db_func.php");
-
-
- $sqlstr= "SELECT * FROM member WHERE m_username='$name'";
- $res= db_query($sqlstr);
-
-
- if(db_num_rows($res)>0)
- echo "
此账号名称" .$name. "已被注册使用
";
- else
- echo "
此账号名称" .$name. "尚未有人注册使用
";
- ?>