/** * Checks, if a specified user exists in MySQL. * * @param MysqlUserModel $user * * @return bool */ public function checkUserExists(MysqlUserModel $user) { $q = sprintf('SELECT User, Host FROM mysql.user WHERE User = "******" AND Host = "%s"', $user->getUsername(), $user->getHost()); $result = $this->_mysqli->query($q); if ($result->num_rows > 0) { return true; } return false; }