PHP中的SQL查询未返回预期结果

Question

I'm trying to query users Level but I'm not able to return an int. I have no idea why because when I echo the result it gives is i.e "1"

function lvl_chcek($username)
{
    $db = new mysqli('localhost', 'root', 'root', 'idoctor_db');

    $lvl = $db->query('
    SELECT Level
    FROM users
    WHERE Login = "'.$username.'"
    ');

    echo $lvl->fetch_object()->Level;

    return $lvl->fetch_object()->Level;

}

I also tried this but I get NULL

function lvl_chcek($username)
{
    $db = new mysqli('localhost', 'root', 'root', 'idoctor_db');

    $query = $db->query('
    SELECT Level
    FROM users
    WHERE Login = "'.$username.'"
    ');
    $result = mysql_query($query);
    $array = mysql_fetch_assoc($result);
    $lvl = $array['Level'];

    echo $lvl;

    return $lvl;
}

Answer 1

as per mysqli <kbd>doc</kbd> you need to query after that you need to fetch the result.

try this:

function lvl_chcek($username)
{
    $db = new mysqli('localhost', 'root', 'root', 'idoctor_db');

   $query = $db->query('
    SELECT Level
     FROM users
     WHERE Login = "'.$username.'"
     LIMIT 1');

    $obj = $query->fetch_object();
    return $obj->Level;

}

it should return user level.