mysql 库检查_MySQL数据库检查

尝试这个：

$username = isset($_POST['user'])?$_POST['user']:''; // check if isset to avoid notice

$password = isset($_POST['pass'])?$_POST['pass']:'';

$verify = 0;

if (!empty($username)) {

$db = mysqli_connect('localhost', 'root', '', 'db');

if($query = mysqli_query($db, "SELECT `pass` FROM `accounts` WHERE `user` = '$username'")) {

while($row = mysqli_fetch_assoc($query)){

$setpassword = $row['pass'];

break; // exit the loop once you found the password

}

mysqli_free_result($query);

}

if (isset($setpassword)) {

$verify = 1;

if ($password == $setpassword) {

$verify = 2;

}

}