Multiple php query string and multiple select options

Question

This is the problem I have. I have a side menu like:

Options A:

A

B

C

Options 1:

1

2

3

Options A and Options 1 are coloumns in a sql table, so If I clicked on A:

whatever.php?OptionA=A

However I want it to be able to multi select, so if I clicked on A, then clicked on B, it would filter the table so that it shows A and B only.

Also, I should be able to select in Options 1 also, so if I clicked on A then 1 it would be:

whatever.php?OptionA=A&Option1=1

The main issue is how can I do it so it can show A and B together?

Gary Green · Accepted Answer · 2011-03-27 00:14:02Z

2

Why not use array?

<input type="checkbox" name="option1[]" value="1">
<input type="checkbox" name="option1[]" value="2">
<input type="checkbox" name="option1[]" value="3">

<input type="checkbox" name="option_a[]" value="A">
<input type="checkbox" name="option_a[]" value="B">
<input type="checkbox" name="option_a[]" value="C">

Then...

$box = $_POST['option1'];


foreach ($box as $key => $value)
{
  echo "$key => $value";
}

..etc.

answered Mar 27, 2011 at 0:14

Gary Green

22.4k6 gold badges52 silver badges76 bronze badges

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

Comments

Jean-Philippe Leclerc · Accepted Answer · 2011-03-27 00:20:08Z

0

You will need some jQuery to achieve this task.

First of, you'll need to bind an event to your <select> tags. See the click event with jQuery: Click event

Secondly, you will need to execute a PHP script with the post function of jQuery when the click event occurs. Learn about it here: Post function

Third, now you can execute your PHP script with your post variables received previously.

Your MySql query should look like this (note that you will need to generate your query dynamically):

SELECT * FROM myTable WHERE (OptionsA = 'A' OR OptionsA = 'B') AND (Options1 = '1' OR Options1 = '2')

edited Mar 27, 2011 at 0:20

answered Mar 27, 2011 at 0:04

Jean-Philippe Leclerc

6,8055 gold badges45 silver badges66 bronze badges

Collectives™ on Stack Overflow

Multiple php query string and multiple select options

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related