php实例-注册&登录

最新推荐文章于 2023-08-08 15:46:30 发布

Cookie's

最新推荐文章于 2023-08-08 15:46:30 发布

阅读量1.7k

点赞数 1

分类专栏： PHP 文章标签：实例 php

本文链接：https://blog.csdn.net/Cookie_1030/article/details/48548905

版权

PHP 专栏收录该内容

46 篇文章 1 订阅

订阅专栏

------------------------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" οnchange="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> 
<?
} 
?>

Cookie's

关注

1
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
php实例-注册&登录

------------------------Re.php--------------------------------- <?php $connection=mysql_connect("localhost","root","cookie"); //连接并选择数据库服务器 mysql_query("set names utf8"); mysql_select_
复制链接

扫一扫