mysql stmt num rows_php – MySQLi stmt num_rows返回0

试试这个,首先调用store_result,然后获取结果.

public function get_login($username, $password)

{

$query = "SELECT `id` FROM `users` WHERE `username` = ? AND `password` = ? LIMIT 1;";

if($stmt = $this->prepare($query))

{

$stmt->bind_param('ss', $username, $password);

if($stmt->execute())

{

$stmt->bind_result($id);

$stmt->store_result();

$stmt->fetch();

if($stmt->num_rows > 0)

{

return $id;

}

return false;

}

return false;

}

return false;

}