logon_process.php

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

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

	include("sidcheck.php"); // 导入身份证号码检查机制

	// 查询数据库中是否有此用户 BEGIN
	$SQLStr = "SELECT * FROM memberprize WHERE m_sid = '$m_sid'";
	$res = db_query($SQLStr);
	// 查询数据库中是否有此用户 END
	
	if (db_num_rows($res)>0) // 若有此用户
	{
		$message = "您已经登记过了..";
	}
	else // 若无此用户
	{
		// 将用户信息写进数据库中 BEGIN
		$SQLStr = "INSERT INTO memberprize (m_id, m_name, m_sid, m_email, m_phone, m_addr, p_id) ";
		$SQLStr .= "VALUES('', '$m_name', '$m_sid', '$m_email', '$m_phone', '$m_addr', '0')";
		db_query($SQLStr);
		echo $SQLStr;
		$message = "谢谢您的登记, 请期待抽奖日的结果";
		// 将用户信息写进数据库中 END
	}
?>

<script>
alert("<?=$message?>");
location.href="prizelist.php";
</script>