PHP To Pass Selected Value To Query

Question

I am populating a Select with data from my database (A SQL Query). The options, for example are:

All Employees
Jack
Joe
Larry
Bob

Now the text All Employees is obviously not an actual employee name, so how would I alter my query based off the value of the Select add a where clause to my sql query?

Obviously $selectedOption = $_POST['testingselect']; would store the selected value in the variable $selectedOption and I could write my Where clause to read (hypothetical)

$SQL = "Select * from goneaz where firstname = $selectedOption"

However, if $selectedOption = All Employees nothing would be returned. How can I add dynamically add in my SQL Statement that (pseudocode) if $selectedOption = All Employees Then SQL = "Select * FROM goneaz. If $selectedOption <> All Employees THEN SQL = "Select * FROM goneaz where firstname = $selectedOption

RiggsFolly · Accepted Answer · 2017-05-13 02:41:46Z

2

All you need to do is concatenate the WHERE clause if the $selectedOption <> All Employees.

$SQL = 'SELECT * FROM goneaz';
if( $selectedOption != 'All Employees' ) {
    $SQL .= " WHERE firstname = '$selectedOption'";
}

//Execute the query

edited May 13, 2017 at 2:41

RiggsFolly

94.7k22 gold badges108 silver badges152 bronze badges

answered May 13, 2017 at 2:41

Raphael Cunha

1,1146 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

RiggsFolly Over a year ago

Minor mod, just so it works properly. Hope you dont mind

Raphael Cunha Over a year ago

@RiggsFolly Thanks for the edit. I completely forgot the quotes '' lol

BellHopByDayAmetuerCoderByNigh Over a year ago

Simple string concatenation. I was overcomplicating it!

Raphael Cunha Over a year ago

@BellHopByDayAmetuerCoderByNigh It happens. Sometimes all you need is a 5 minute break and everything comes back to you.

Collectives™ on Stack Overflow

PHP To Pass Selected Value To Query

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related