PHP 예제-등록 및 로그인

------------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=&#39;"+array.cityid+"&#39;>"+array.city+""; 
				city.append(option); 
			}); 
		},&#39;json&#39;); 
	}

	</script>
	<title>Register</title>


	
	<h1 id="用户注册">用户注册</h1>
	

输入工号： 输入密码： 确认密码： 真实姓名： 性 别：男 女 籍贯：---请选择省份--- $query="select * from province"; $result=mysql_query($query,$connection); while($row=mysql_fetch_array($result)) { ?> echo $row[province] ?> } ?> ---请选择城市--- 所在部门： ---请选择部门--- $query="select * from department"; $result=mysql_query($query,$connection); while($row=mysql_fetch_array($result)) { ?> echo $row[department]?> } ?> 职位： ---请选择职位--- $query="select * from positions"; $result=mysql_query($query,$connection); while($row=mysql_fetch_array($result)) { ?> echo $row[positions]?> } ?> 备注：

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

	<meta http-equiv="Content-Type" c charset='utf-8"'>
	<title>Register</title>

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

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

		$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 id="用户登录">用户登录</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[&#39;username&#39;];
			$password = $_POST[&#39;password&#39;];
			
			if(!$password || !$username)
			{
				echo "用户名或密码不能为空，请重新输入！";
				exit;
			}
			@ $db = new mysqli(&#39;localhost&#39;,&#39;root&#39;,&#39;cookie&#39;,&#39;cookie&#39;);
			
			if(mysqli_connect_errno())
			{
				echo "数据库链接失败，请重试！";
				exit;
			}
			$query = "select * from userinfo where username = &#39;$username&#39; && passwd = &#39;$password&#39;";
			$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); 
?>

while($row=mysql_fetch_array($result)) { ?> } ?>

위 내용은 PHP 예제-등록 및 로그인에 대한 내용을 소개하고 있으며, PHP 튜토리얼에 관심이 있는 친구들에게 도움이 되기를 바랍니다.

用户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]." "; ?>	编辑