登錄頁面點擊登錄后查詢不出數據，無法成功登陸，但是在數據庫中進行查詢操作是可以成功的，是什么原因呢？

問題描述

<?php

session_start();

error_reporting(E_ERROR);

$zh=$_POST['zh'];

$password=$_POST['password'];

$user=$_POST['user'];

if(!isset($user)){

echo "<script> alert('請選擇用戶類型');</script>";

echo "<script> history.go(-1);</script>";

}

$conn=mysqli_connect("localhost","8admin","8admin")or die('連接數據庫失敗');

$db=mysqli_select_db($conn,"8_com");

$sql1="SELECT*FROM admin WHERE admin_id ='$zh' AND password='$password' ";

$sql2="select * from teacher where teach_id ='$zh' and password='$password' ";

$sql3="select * from student where stuno ='$zh' and password='$password' ";

mysqli_query($conn,"set names utf8");

switch($user){

case 1:$result=mysqli_query($conn,$sql)or die('查詢不到');

$row = mysqli_fetch_array($conn,$result);

$count=$row[0];

if($count!=""){

$url="index_admin.php";

$_SESSION['admin_name']=$row['name'];

$_SESSION['admin_id']=$row['admin_id'];

echo "<script type='text/javascript'>"."location.href='".$url."'"."</script>";

}

else {

echo "<script> alert('賬戶或密碼錯誤');</script>";

echo "<script> history.go(-1);</script>";

}

break;

case 2:$result=mysqli_query($sql2,$conn);

$result=mysqli_query($sql2,$conn)or die('查詢不到');

$row = mysqli_fetch_array($result);

$count=$row[0];

if($count!=""){

$url="index_teacher.php";

$_SESSION['teacher_name']=$row['name'];

$_SESSION['teacher_id']=$row['teach_id'];

echo "<script type='text/javascript'>"."location.href='".$url."'"."</script>";

}

else {

echo "<script> alert('賬戶或密碼錯誤');</script>";

echo "<script> history.go(-1);</script>";

}

break;

case 3:$result=mysqli_query($sql3,$conn);

$result=mysqli_query($sql3,$conn)or die('查詢不到');

$row = mysqli_fetch_array($result);

$count=$row[0];

if($count!=""){

$url="index_stu.php";

$_SESSION['stu_name']=$row['name'];

$_SESSION['stu_id']=$row['stuno'];

echo "<script type='text/javascript'>"."location.href='".$url."'"."</script>";

}

else {

echo "<script> alert('賬戶或密碼錯誤');</script>";

echo "<script> history.go(-1);</script>";

}

break;

default :break;

}

mysqli_close($conn);

?>

問題解答

后端斷點打印是否能夠拿到數據