mail_process.php

php模块设计。。。里面的模块很有学习价值

<?
	include("db_conn.php");
	include("db_func.php");

	// 取出表中是否有此用户 BEGIN
	$SQLStr = "SELECT * FROM buyer WHERE b_mail = '$usermail'";
	$res = db_query($SQLStr);
	// 取出表中是否有此用户 END
	
	if(db_num_rows($res)>0) // 若有此用户
	{	
		$row = db_fetch_array($res);

		//判断此用户的密码是否输入正确 BEGIN
		if ($row['b_pass'] == $mailpass) // 若正确
		{
			// 将 usermail 注册为 session
			session_start();
			session_register("usermail");
			echo "<script>";
			echo "alert(\"欢迎您再次回来购物\");";
			echo "location.href=\"shop_process.php?p_id=" . $p_id . "&usermai=" . $usermail . "\";";
			echo "</script>";
		}
		else // 若不正确
		{
			echo "<script>";
			echo "alert(\"密码错误\");";
			// 将用户导回登录页面
			echo "location.href=\"mail_login.php?p_id=" . $p_id . "\";";
			echo "</script>";
		}
		//判断此用户的密码是否输入正确 END
	}
	else
	{
		// 将新的用户信息写进 buyer 表中 BEGIN
		$SQLStr = "INSERT INTO buyer (b_id, b_mail, b_pass, b_cool) VALUES('', '$usermail', '$mailpass','0')";
		db_query($SQLStr);
		// 将新的用户信息写进 buyer 表中 END

		session_start();
		session_register("usermail");

		echo "<script>";
		echo "alert(\"已将您的信息收录进数据库\");";
		// 将用户导回原产品页面
		echo "location.href=\"shop_process.php?p_id=" . $p_id;
		echo "</script>";
	}
?>