查询md5加密的密码不能正常返回结果

Question

doLogin.php:<?phpheader('content-type:text/html;charset=utf-8');$mysqli=new mysqli('localhost','root','123456','test');if($mysqli->errno){ die('Connect Error'.$mysqli->error);}$mysqli->set_charset('UTF8');$username=$_POST['username'];$password=md5($_POST['password']);$sql="SELECT * FROM user WHERE username='{$username}' AND password='{$password}'";$mysqli_result=$mysqli->query($sql);if($mysqli_result && $mysqli_result->num_rows>0){ echo '登陆成功';}else{ echo '登陆失败';}上述代码如果$password不用md5加密，就能正常查询，但是查询加密后的信息就显示结果为空

Answer 1

明白了 密码设置位数低于md5加密的结果位数