我正在尝试制作一个php,mysql登录脚本。当我输入错误的用户名或密码或登录ID时,它不会显示我的错误消息。为什么?
$con = mysqli_connect($DB_HOST, $DB_USER, $DB_PASS, $DB_NAME);
if ( mysqli_connect_errno() ) {
die ('Failed to connect to MySQL: ' . mysqli_connect_error());
}
$c_id = $_POST['c_id'];
$p_nickname = $_POST['p_nickname'];
$p_password = $_POST['p_password'];
if(!empty($c_id)&&!empty($p_nickname)&&!empty($p_password)){
$query = "SELECT c_id, p_nickname, p_password FROM people_inside_company INNER JOIN company ON pic_c_id = c_id INNER JOIN people ON pic_code_number = p_code_number WHERE c_id = '$c_id' AND p_nickname = '$p_nickname' AND p_password = '$p_password'";
#t
if($result = mysqli_query($con, $query)or die(mysqli_error($con))){
if($row = mysqli_fetch_assoc($result)){
$in_cid = $row['c_id'];
$in_pnickname = $row['p_nickname'];
$in_ppassword = $row['p_password'];
$count = mysqli_num_rows($result);
if($count == 1){
echo "you're in";
# i get this when i type the right c_id, p_nickname and p_passowrd
#more code
}
else{
echo "wrong username, password or id";
# i don't get this when im typing the wrong c_id, p_nickname or p_password, why?
}
}
}
}
使用此代码:
$con = mysqli_connect($DB_HOST, $DB_USER, $DB_PASS, $DB_NAME);
if ( mysqli_connect_errno() ) {
die ('Failed to connect to MySQL: ' . mysqli_connect_error());
}
$c_id = $_POST['c_id'];
$p_nickname = $_POST['p_nickname'];
$p_password = $_POST['p_password'];
if(!empty($c_id)&&!empty($p_nickname)&&!empty($p_password)){
$query = "SELECT c_id, p_nickname, p_password FROM people_inside_company INNER JOIN company ON pic_c_id = c_id INNER JOIN people ON pic_code_number = p_code_number WHERE c_id = '$c_id' AND p_nickname = '$p_nickname' AND p_password = '$p_password'";
#t
if($result = mysqli_query($con, $query)or die(mysqli_error($con))){
if(mysqli_num_rows($result)){
$row=mysqli_fetch_assoc($result);
$in_cid = $row['c_id'];
$in_pnickname = $row['p_nickname'];
$in_ppassword = $row['p_password'];
$count = mysqli_num_rows($result);
if($count == 1){
echo "you're in";
# i get this when i type the right c_id, p_nickname and p_passowrd
#more code
}
}
else
{
echo "wrong username, password or id";
# i don't get this when im typing the wrong c_id, p_nickname or p_password, why?
}
}
}
您的“ else”区块无法到达(逻辑上)
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句