PHP redirect header

Question

I am working on a web portal for a school project and I need to create a signature. I have a table called student in my database where I have supervisor_id_dos and supervisor_id_sup2.

Now I want to use session to check who is logged in and direct them to a particular page to sign but the if statement doesn't run, it skips and loads the page under the else statement.

I don't know what am doing right

 <?php   



include "connect.php";  



session_start();    <br/>



$sql = "SELECT * from student WHERE level ='user' and (supervisor_id_dos='$_SESSION[username]'OR      supervisor_id_sup2='$_SESSION[username]')";
$result = mysqli_query($con, $sql);


$row = mysql_num_rows($result);  
if($row){ 
    if($_SESSION["username"] = $row["supervisor_id_dos"])
    { 

    header("Location: dos_sign.php"); 
    } 

else{ 
    header("Location: wrong_sign.php");
}    


}  






?>

code

you're mixing MySQL APIs for one thing and thanks for the lovely screenshot of "code". — Funk Forty Niner, Apr 05 '16 at 18:05
First thing, you are using `mysql` and `mysqli` at the same time. And your if condition is wrong, it needs to be `==`. — Manikiran, Apr 05 '16 at 18:09
[Learning PHP](http://code.tutsplus.com/tutorials/the-best-way-to-learn-php--net-22287) — Martin, Apr 05 '16 at 18:13
I've made the corrections but now it skips the if statement to the else statement — Barile Zinah, Apr 05 '16 at 18:32

score 2 · Answer 1 · answered Apr 05 '16 at 18:09

2

You have to use == instead of = inside IF statements to compare values, here is more information about PHP Comparison Operators

Try to put exit() after use of header() redirect, it will prevent the rest of php code to get executed

Then, I think you also have an error in your MySQL query where you don't have a space before OR

answered Apr 05 '16 at 18:09

Seva Kalashnikov

4,262
2
21
36

1

you missed something very important. – Funk Forty Niner Apr 05 '16 at 18:16
I've done that but it returns with --- Warning: mysql_num_rows() expects parameter 1 to be resource, object given in /Applications/XAMPP/xamppfiles/htdocs/fyp/sign_check.php on line 8 and line 8 is the $row = mysql_num_rows($result); – Barile Zinah Apr 05 '16 at 18:19
There, you see what I mean? ^ ^ ^ and it won't stop there neither. – Funk Forty Niner Apr 05 '16 at 18:20
I'll just leave this link here.. http://www.dummies.com/how-to/computers-software/programming/php.html – Seva Kalashnikov Apr 05 '16 at 18:28
I appreciate your concern, I'll take a careful study of the link you sent. But I've to to fix this script soon because my project is due soon. – Barile Zinah Apr 05 '16 at 18:31

PHP redirect header

1 Answers1