php实例-注册&登录

来源：互联网发布：淘宝中老年毛呢外套编辑：程序博客网时间：2024/05/17 22:39

------------------------Re.php---------------------------------

<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><script type="text/javascript" src="jquery-1.4.4.min.js"></script><?php $connection=mysql_connect("localhost","root","cookie"); //连接并选择数据库服务器 mysql_query("set names utf8");mysql_select_db("cookie",$connection); ?><script>function sel(obj){  $.get("select.php",{province:obj.options[obj.selectedIndex].value},function(json){ var city = $("#city"); //$("option",city).remove(); //清空原有的选项 $.each(json,function(index,array){ //alert(array.cityid);var option = "<option value='"+array.cityid+"'>"+array.city+"</option>"; city.append(option); }); },'json'); }</script><title>Register</title></head><body><h1>用户注册</h1><form method="POST" action="register.php">输入工号：<input type="text" name="userno" maxlength="10" size="10"></br></br>输入密码：<input type="password" name="password1" maxlength="20" size="20"></br></br>确认密码：<input type="password" name="password2" maxlength="20" size="20"></br></br>真实姓名：<input type="text" name="username" maxlength="30" size="30"></br></br>性    别：<input type="radio" checked="checked" name="gender" value="1">男  <input type="radio" name="gender" value="2">女</br></br>    籍贯：<select name="province" id="province" onchange="sel(this)">  <option value ="0">---请选择省份---</option><?$query="select * from province"; $result=mysql_query($query,$connection); while($row=mysql_fetch_array($result)) { ?>  <option value ="<? echo $row[provinceid]; ?>"><? echo $row[province] ?></option>  <?} ?> </select>  <select name="city" id="city">  <option value ="0">---请选择城市---</option>  </select> </br></br>所在部门：<select name="department">  <option value ="0">---请选择部门---</option><?$query="select * from department"; $result=mysql_query($query,$connection); while($row=mysql_fetch_array($result)) { ?>  <option value ="<? echo $row[departmentid]?>"><? echo $row[department]?></option><?} ?>  </select></br></br>职位：<select name="position">  <option value ="0">---请选择职位---</option><?$query="select * from positions"; $result=mysql_query($query,$connection); while($row=mysql_fetch_array($result)) { ?>  <option value ="<? echo $row[positionid]?>"><? echo $row[positions]?></option><?} ?>  </select></br></br>备注：<input type="text" name="remark" maxlength="30" size="30"></br></br><input type="submit" value="提交"></form></body></html>

-------------------------------------register.php------------------------------------

<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>Register</title></head><body><?php$userno = $_POST['userno'];$password1 = $_POST['password1'];$password2 = $_POST['password2'];$username = $_POST['username'];$gender = $_POST['gender'];$province = $_POST['province'];$city = $_POST['city'];$department = $_POST['department'];$position = $_POST['position'];$remark = $_POST['remark'];if(!$password1 || !$username){echo "用户名或密码不能为空，请重新输入！";exit;}if($password1 != $password2){echo "两次密码不一致，请重新输入！";exit;}@ $db = new mysqli('localhost','root','cookie','cookie');if(mysqli_connect_errno()){echo "数据库链接失败，请重试！";exit;}$query = "insert into userinfo values(null,$userno,'$password1','$username',$gender,$province,$city,$department, $position,'remark')";$result = $db->query($query);if($result){echo "注册成功！<br />";}else{echo "注册失败！";}$db->close();?><a href="login.html">点击登录</a></body></html>

--------------------------select.php-----------------------------------

<?$connection=mysql_connect("localhost","root","cookie"); //连接并选择数据库服务器 mysql_query("set names utf8");mysql_select_db("cookie",$connection); $proid = $_GET["province"]; if(isset($proid)){ $q=mysql_query("select * from city where provinceid = $proid"); while($row=mysql_fetch_array($q)){ $select[] = array("cityid"=>$row[cityid],"city"=>$row[city]); } //var_dump($select); echo json_encode($select); }?>

-----------------login.html----------------------------

<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>Login</title></head><body><h1>用户登录</h1><form method="POST" action="login.php">用 户 名：<input type="text" name="username" maxlength="30" size="30"></br></br>用户密码：<input type="password" name="password" maxlength="30" size="30"></br></br><input type="submit" value="登录"></form></body></html>

------------------------login.php-------------------------------------

<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>Login</title><?php $connection=mysql_connect("localhost","root","cookie"); //连接并选择数据库服务器 mysql_query("set names utf8");mysql_select_db("cookie",$connection); ?></head><body><?php$username = $_POST['username'];$password = $_POST['password'];if(!$password || !$username){echo "用户名或密码不能为空，请重新输入！";exit;}@ $db = new mysqli('localhost','root','cookie','cookie');if(mysqli_connect_errno()){echo "数据库链接失败，请重试！";exit;}$query = "select * from userinfo where username = '$username' && passwd = '$password'";$result = $db->query($query);$num_results = $result->num_rows;if($num_results >0){//echo "登录成功！";                                include "userinfo.php";}else{echo "用户名或密码错误，请确认！";}$db->close();?></body></html>

-----------------------------userinfo.php----------------------------------

 <head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>Login</title></head><?php $connection=mysql_connect("localhost","root","cookie"); //连接并选择数据库服务器 mysql_select_db("cookie",$connection); $query="select u.userid,u.userno,u.username,g.`gender`,p.`province`,c.`city`,d.`department`,po.`positions`,u.remark from userinfo as u left join gender as g on u.genderid = g.genderid left join province as p on u.provinceid = p.provinceid left join city as c on u.cityid = c.cityid left join department as d on u.departmentid = d.departmentid left join positions as po on u.positionid = po.positionid"; $result=mysql_query($query,$connection); ?><table border="1" width="100%"><tr><th>用户ID</th><th>工号</th><th>真实姓名</th><th>性别</th><th>省份</th><th>城市</th><th>部门</th><th>职位</th><th>备注</th><th>操作</th></tr><?while($row=mysql_fetch_array($result)) { ?><tr><td> <? echo $row[userid]."<br>"; ?></td> <td> <? echo $row[userno]."<br>";  ?></td> <td> <? echo $row[username]."<br>"; ?></td> <td> <? echo $row[gender]."<br>"; ?></td> <td> <? echo $row[province]."<br>"; ?></td> <td> <? echo $row[city]."<br>"; ?></td> <td> <? echo $row[department]."<br>"; ?></td> <td> <? echo $row[positions]."<br>"; ?></td> <td> <? echo $row[remark]."<br>"; ?></td> <td>编辑</td> <?} ?>

1 0