login_process.php

来自「php模块设计。。。里面的模块很有学习价值」· PHP 代码 · 共 59 行

<?
	include("db_conn.php");
	include("db_func.php");
	
	$SQLStr = "SELECT * FROM buyer WHERE b_mail = '$usermail'";
	$res = db_query($SQLStr);
	
	if(db_num_rows($res)>0) // 若用户已登录过
	{	
		$row = db_fetch_array($res);
		$b_id = $row['b_id'];
		if ($row['b_pass'] == $mailpass) // 若用户密码正确
		{
			session_start();
 
			// 将 b_id 注册为 session
			session_register("b_id");

			// 将用户引导至网络相册管理界面 BEGIN
			echo "<script>";
			echo "alert(\"欢迎您再次回来\");";
			echo "location.href=\"photolist.php\";";
			echo "</script>";
			// 将用户引导至网络相册管理界面 END
		}
		else // 若用户密码错误
		{
			// 将用户导回登录页面 BEGIN
			echo "<script>";
			echo "alert(\"密码错误\");";
			echo "location.href=\"index.php\";";
			echo "</script>";
			// 将用户导回登录页面 END
		}
	}
	else // 若用户尚未登录过
	{
		// 将该用户 E-mail 及密码写入数据库 BEGIN
		$SQLStr = "INSERT INTO buyer (b_id, b_mail, b_pass, b_cool) VALUES('', '$usermail', '$mailpass','0')";
		db_query($SQLStr);
		// 将该用户 E-mail 及密码写入数据库 END

		// 取出该用户之编号 b_id BEGIN
		$SQLStr = "SELECT b_id FROM buyer WHERE b_mail = '$usermail'";
		$res = db_query($SQLStr);
		$row = db_fetch_array($res);
		$b_id = $row[0];
		// 取出该用户之编号 b_id END

		session_start();
		session_register("b_id");

		echo "<script>";
		echo "alert(\"已将您的信息收录进数据库\");";
		echo "location.href=\"photolist.php\";";
		echo "</script>";
	}
?>