--------------------------Re.php---------------------- ----------
りー<html> <head> <meta http-equiv="Content-Type" c/html; charset=utf-8" /> <script type="text/javascript" src="jquery-1.4.4.min.js"></script> <?php $c //连接并选择数据库服务器 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" <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>
<html> <head> <meta http-equiv="Content-Type" c/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>
-----------------login.html--------------------------- -- -
<? $c //连接并选择数据库服务器 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.php----- -- ------------------
りぃ------------------------------------- ------ --userinfo.php-----------------------------
<html> <head> <meta http-equiv="Content-Type" c/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>
上記は、PHP のサンプル登録とログインを内容も含めて紹介しました。PHP チュートリアルに興味のある友人の参考になれば幸いです。