------------------------Re.php---------------------------------
<meta http-equiv="Content-Type" c 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+"";
city.append(option);
});
},'json');
}
</script>
<title>Register</title>
<h1>用户注册</h1>
<meta http-equiv="Content-Type" c charset='utf-8"'>
<title>Register</title>
<?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>
$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.html----------------------------
<meta http-equiv="Content-Type" c charset='utf-8"'> <title>Login</title> <h1>用户登录</h1>
------------------------login.php-------------------------------------
<meta http-equiv="Content-Type" c charset='utf-8"'>
<title>Login</title>
<?php $c //连接并选择数据库服务器
mysql_query("set names utf8");
mysql_select_db("cookie",$connection);
?>
<?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 "登录成功！";
<strong>include</strong> "userinfo.php";
}
else
{
echo "用户名或密码错误，请确认！";
}
$db->close();
?>
-----------------------------userinfo.php----------------------------------
<meta http-equiv="Content-Type" c charset='utf-8"'>
<title>Login</title>
<?php $c //连接并选择数据库服务器
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
<strong>left join gender as g on u.genderid = g.genderid <strong>left join</strong> province as p on u.provinceid = p.provinceid
<strong>left join</strong> city as c on u.cityid = c.cityid <strong>left join</strong> department as d on u.departmentid = d.departmentid
<strong>left join</strong> positions as po on u.positionid = po.positionid";
$result=mysql_query($query,$connection);
?>
| 用户ID | 工号 | 真实姓名 | 性别 | 省份 | 城市 | 部门 | 职位 | 备注 | 操作 |
|---|---|---|---|---|---|---|---|---|---|
| echo $row[userid]." "; ?> |
echo $row[userno]." "; ?> |
echo $row[username]." "; ?> |
echo $row[gender]." "; ?> |
echo $row[province]." "; ?> |
echo $row[city]." "; ?> |
echo $row[department]." "; ?> |
echo $row[positions]." "; ?> |
echo $row[remark]." "; ?> |
编辑 | } ?>
