PHP - 在插入sql之前更改变量的值 - 没有Ajax

Question

I have the variable

$sql1 .= "Brukertype";

Which gets information set from an already-filled textbox. It can either have the value Administrator or the value Iskjører.

What is the best way to change these values before inserting them into SQL? The Administrator value should get changed to the value 1 and Iskjører gets changed to the value 2.

I can't use a select function (dropdown list) on the question because it needs to be enabled/disabled on my command.

Answer 1

Since you have stated:

It can eighter have the value "Administrator" or the value "Iskjører"...

we only check whether the value is 'Administrator' or not.

Try this:

$val = 'Administrator'; // user input variable
$sql_val = ($val == 'Administrator') ? 1 : 2;

If value is 'Administrator' set $sql_val to 1, else set $sql_val to 2