用户登陆时,login.php中判断取policy值可以如下这样写:
-
<?php
-
$db_conn = mysql_connect ( "host", "db_user", "db_pass" );
-
mysql_select_db ( "db_name", $db_conn );
-
-
$sql = "select policy from users where `username`='$username' and
-
`password`='". md5 ($password ). "' limit 1";
-
$result = mysql_query($sql);
-
if (mysql_num_rows ($result ) > 0 ) {
-
list($policy) = mysql_fetch_row($result );
-
} else {
-
// 登陆错误
-
header('location:index.php');
-
exit();
-
}
-
?>