login.php

php会员管理地模块设计。需要地同志可以直接拿来应用于自己地网站建设

<!---Login php srcipt begins here--->
<?
mysql_connect("localhost", "root", "")
	or die ("Unable to connect to server.");
mysql_select_db("secretDB")
	or die ("Unable to select database.");
$sql = "SELECT id
	FROM users
	WHERE username='$username' and password='$password'";
$result = mysql_query($sql)
	or die ("Unable to get results.");
$num = mysql_numrows($result)
	or die ("You're not authorized to be here.  If you feel you have recieved this
message in error, please contact the <a
href=\"mailto:[e-mail]\">webmaster</a>");
if ($num == 1) {
echo "<p>You can be here<br>";
echo "Your username is $username</p>";
}
?>