如果usertype是求职者，那么如果usertype是雇主，则重定向到第1页，然后重定向到第2页

Question

Hello i just want to check if the user (who is logging in) has usertype Employer then he should redirect to my-profile.php and if usertype is Jobseeker then he should redirect to latest-jobs.php. Here is my code please help me if you can.

I am trying to add some script in my code but it has some mistake and not working. Now it's redirecting to latest-jobs.php to both (Employer and Jobseeker). Check down my second script.

Thanks

<?php
session_start();
include("lib/conn.php");

?>
<?php
$email=$_POST['user'];
$password=$_POST['password'];

if ($email && $password){

$query = "SELECT * FROM register WHERE email = '$email' AND password= '$password' and status = '1'";
$result = mysql_query( $query ) or die ("didn't query");
$num = mysql_num_rows( $result );


if ($num == 1){

$_SESSION['ocer']=$email;

header("Location: my-profile.php");

}

else {

header("Location: index.php?l=1");

}

}

?>

My second script

<?php
session_start();
include("lib/conn.php");

?>
<?php
$email=$_POST['user'];
$password=$_POST['password'];


if ($email && $password){

$query = "SELECT * FROM register WHERE email = '$email' AND password= '$password' and status = '1'";
$result = mysql_query( $query ) or die ("didn't query");
$num = mysql_num_rows( $result );


if ($num == 1){

$_SESSION['ocer']=$email;

if ($usertype == "Employer") {

header("Location: my-profile.php");

}

else {

header ("Location: latest-jobs.php");

}

}

else {

header("Location: index.php?l=1");

}

}

?>

Answer 1

I got the solution now.

<?php
session_start();
include("lib/conn.php");

    $email=$_POST['user'];
    $password=$_POST['password'];

    if ($email && $password)
    {       
        $query = "SELECT * FROM register WHERE email = '".$email."' AND password= '".$password."' and status = '1'";        
        $result = mysql_query($query) or die ("didn't query". mysql_error());
        $num = mysql_num_rows($result);

        if($num ==1){
            $data = mysql_fetch_array($result);
            if($data['usertype'] == 'Employer')
            {
                $_SESSION['ocer'] = $email;
                header("Location: my-profile.php"); 
            }
            else if($data['usertype'] == 'Jobseeker')
            {   
            $_SESSION['ocer'] = $email;
                header("Location: latest-jobs.php");                
            }
        } 
        else{
            header("Location: index.php?l=1");
        }
    }

?>