php - 如何根据某些条件重定向主页: PHP?

Question

我想根据用户类型将我的页面重定向到不同的页面。下面是我的代码，它不起作用。需要修复它的帮助。

$check = mysql_query("SELECT * FROM user WHERE username = '".$_POST['username']."'");
$row = mysql_fetch_array($check);
                    switch($row["userType"])
                    {
                        case "Coordinator":
                        header("Location: staff_dashboard.php"); 
                        die();
                        break;
                        case "Lecturer":
                        header("Location: staff_dashboard.php"); 
                        die();
                        break;
                        case "Student":
                        header("Location: student_dashboard.php"); 
                        die();
                        break;
                    }

Answer 1

这可能对您有帮助:-

$con=mysqli_connect("localhost","my_user","my_password","my_db");
$sql="SELECT * FROM user WHERE username = '".$_POST['username']."'";
$result=mysqli_query($con,$sql);

$row=mysqli_fetch_assoc($result);

switch($row["userType"])
                {
                    case "Coordinator":
                    header("Location: staff_dashboard.php"); 
                    die();
                    break;
                    case "Lecturer":
                    header("Location: staff_dashboard.php"); 
                    die();
                    break;
                    case "Student":
                    header("Location: student_dashboard.php"); 
                    die();
                    break;
                }