User Redirection accordingly an enum input

[Pos3id0nas]

Hello,i am new in sport and i'm wonder if could helping me to resolve an issue.

I want to redirect after the successful login of user to different page accordingly the enum input.

here is my code and my db.

 

[Barand]

Where does $row get its values?

[gizmola]

My First comment:  Don't use enums.  

I would recommend changing the definition of the field to a CHAR[1], and store either a 'P' or an 'S'.

Your code should not interpolate values into your SQL even if you are escaping them.  Use Prepared Statements.

 

Your redirection code should be changed:

if ($specialty == "pro") {
    header("Location: pro.php");
} elseif ($specialty == "stu") {
	header("Location: stu.php");
} else {
  die('Unknown Specialty.')
}

Note format of the Location header.

[Barand]

Erm! @gizmola Note that in the English speaking parts of the world we have "speciality" and not "specialty" 😀

[gizmola]

31 minutes ago, Barand said:

Erm! @gizmola Note that in the English speaking parts of the world we have "speciality" and not "specialty" 😀

Hey I didn't name the field  😅

But my american upbringing says that "specialty" is good.  I do like the english pronunciation of spe-cee-al-it-tee of your version though.