Databases
StackOverflow2013
Postsdbo
PODynamic SQL SELECT Statement with PHP based on user options
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODynamic SQL SELECT Statement with PHP based on user options
    text
    copied!<p>First of all I want to mention that I've been trying and searching like crazy to find a solution to this but no luck so far. My issue is the following:</p> <p>I have a MySQL database with dozens of rows and I created a jQuery grid to display the data; this page is working already. As per requirements I'm putting together a page where people can select a couple options from checkboxes and filter the results. This is how it will work:</p> <p>Page 1 will have 3 groups of checkboxes (Name, Location, Language) and each set has different options ([Name: David, Nick, etc], [Location: New York, Washington, Mumbai, London, Miami], [Language: English, Spanish]. Once the user selects his options it will submit a form with something like this </p> <p>grid.php?location=Washington&amp;location=Mumbai&amp;language=English&amp;name=David</p> <p>Creating the string is easy but the receiver that will take this parameters and place then in an array to then create the SQL statement is where I'm struggling.</p> <p>I've tried with something like this:</p> <pre><code>$location= $_GET['location']; $language= $_GET['language']; $name= $_GET['name']; if($location!=""){ $where[] = 'location='; $where_args[] = $location; } //same code for the other 2 options $where_clause = implode(' OR ', $where_args); $sql_json = "SELECT * FROM myTable WHERE $where_clause ORDER BY id DESC"; </code></pre> <p>None of the options are mandatory so the query needs to accept the possibility that the value may or may not be set so it may end up being something like grid.php?language=English. </p> <p>I know that the code above doesn't quite work but I will appreciate if someone can please point me in the right direction.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload