MySQL Query based on Dropdown

[Hikaru12]

Let's say I have the following HTML dropdown.

<form action="filter.php" method="post" name="filter_dropdown"><select name="categories_filter"><option value="select" selected="selected">Select Search Field</option><option value="news">News</option><option value="recipes">Recipes</option><option value="funny">Funny</option></select>

 

I'd like to run a MYSQL query based on what the user selected from the dropdown, e.g. if News is selected I want a list of all bookmarks that are categorized as news to be displayed in a table. How would I do this?

[Paralectic]

Catch the value in the HTTP post and put in a variable, use that variable in the query.

[vorticalbox]

if($_POST['categories_filter'] == "news")

{

//news stuff

} else if($_POST['categories_filter'] == "recipes")

{

//recipes stuff

}else if($_POST['categories_filter'] == "funny")

{

//funny stuff

}else

{

//error with form.

}

[Guest]

Just something like "select from bookmarks where category = ?".

 

Of course, the actual query depends on your database structure. I wouldn't advise actually using this query as you should be using a join table at the minimum for something like this - gotta have that normalization.

 

And you should obviously be using PDO and prepared statements.

[Neil]

Just something like "select from bookmarks where category = ?".

 

Of course, the actual query depends on your database structure. I wouldn't advise actually using this query as you should be using a join table at the minimum for something like this - gotta have that normalization.

 

And you should obviously be using PDO and prepared statements.

 

Just gonna quote this because it needs to be repeated over and over and over.