我已经解决了代码中的错误,但现在它返回的数组为空。任何问题的想法都可以帮助解决代码是
<?php
session_start();
include_once 'dbconnect.php';
if(!isset($_SESSION['user']))
{
header("Location: index.php");
}
$res=mysql_query("SELECT user_level FROM users where user=".$_SESSION['user']);
while($rows=mysql_fetch_array($res)){
echo $rows['user_level'];
// close while loop
}
die();
?>
这样做同样的事情:
session_start();
include_once 'dbconnect.php';
if(!isset($_SESSION['user'])){
header("Location: index.php");
}
$user = $_SESSION['user'];
echo $sql = "SELECT user_level FROM users where user='".$user."'";
$res=mysql_query($sql);
$count = mysql_num_rows($res);
if($count > 0){
while($rows = mysql_fetch_array($res)){
echo $rows['user_level'];
// close while loop
}
die();
}else{
echo 'No rows.';
}