_GET in PHP for variable with multiple values

Question

I am sending a variable with multiple values like this:

JQUERY:

 $(".indexMain").load('indexMain.php?color=' + colors.join("+"), function()

--> indexMain.php?colors=blue+red+brown

I want to _GET those values and then use them in a while loop to put them into a SQL query like this one:

$items = $con -> prepare("SELECT * FROM item_descr WHERE color_base1 = :colorbase1");
$items -> bindValue(":colorbase1", $color);

Thanks!

EDIT: here is my current code but it is not working, it just shows the items corresponding to the 1st color.

foreach (explode(' ', $_GET['color']) as $color) 
    {
        $items = $con -> prepare("SELECT * FROM item_descr WHERE color_base1 = :colorbase1");
        $items -> bindValue(":colorbase1", $color);

    }

You can't bind more than one value to one "variable" in PDO. — Tyler Crompton
– Tyler Crompton, Commented Aug 17, 2012 at 3:05
@Tyler, he said that he wanted to use them in a while loop, so I am guessing that he intends to use them one at a time. I could be wrong though :-P. — Evan Teran
– Evan Teran, Commented Aug 17, 2012 at 3:05

Tyler Crompton · Accepted Answer · 2012-08-17 03:17:32Z

3

indexMain.php?color=blue+red+brown

should be

indexMain.php?colors%5B%5D=blue&colors%5B%5D=red&colors%5B%5D=brown

which is equivalent to

indexMain.php?colors[]=blue&colors[]=red&colors[]=brown

This creates an array accessible with $_GET['colors']. After that use this PHP:

foreach ($_GET['colors'] as $color) {
    $query = $con->prepare("SELECT * FROM item_descr WHERE color_base1 = :colorbase1");
    if ($query->execute(":colorbase1", $color)) {
        // use results from query
    } else {
        // handle failed query
    }
}

If you don't want to change the query string, you can do this alternatively:

foreach (explode(' ', $_GET['colors']) as $color) {
    $query = $con->prepare("SELECT * FROM item_descr WHERE color_base1 = :colorbase1");
    if ($query->execute(":colorbase1", $color)) {
        // use results from query
    } else {
        // handle failed query
    }
}

Note that the only change is in the first line and we are splitting the string by spaces (because "+" gets converted to a space character).

Also note that both examples assume that $_GET['colors'] is defined. You can use isset() to check if it is defined.

edited Aug 17, 2012 at 3:17

answered Aug 17, 2012 at 3:11

Tyler Crompton

12.8k15 gold badges69 silver badges99 bronze badges

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

2 Comments

samyb8 Over a year ago

Hi, thanks this looks good but doesn't work in my code... I am editing my original post with the current code... Thanks!

Tyler Crompton Over a year ago

Well, you're not using the code that I provided. You're binding a variable but not doing anything with it. You have to execute the query like I did.

Evan Teran · Accepted Answer · 2012-08-17 03:04:10Z

0

I think this should work:

$colors = explode(' ', $_GET['color']);
foreach($colors as $color) {
    // your code here...
}

answered Aug 17, 2012 at 3:04

Evan Teran

90.9k33 gold badges188 silver badges246 bronze badges

1 Comment

samyb8 Over a year ago

Thanks, I updated my code on the top following your idea but it doesn't work yet... would you mind taking a look? It's edited

kushalbhaktajoshi · Accepted Answer · 2012-08-17 03:06:18Z

0

Try this

$colors = explode("+", $_GET['color']);
foreach($colors as $color){
$items = $con -> prepare("SELECT * FROM item_descr WHERE color_base1 = :colorbase1");
$items -> bindValue(":colorbase1", $color);
}

How about this

$colors = explode(" ", $_GET['color']);
foreach($colors as $color){
$items = $con -> prepare("SELECT * FROM item_descr WHERE color_base1 = :colorbase1");
$items -> bindValue(":colorbase1", $color);
}

answered Aug 17, 2012 at 3:06

kushalbhaktajoshi

4,6883 gold badges24 silver badges38 bronze badges

4 Comments

Evan Teran Over a year ago

wouldn't + in a query parameter be converted to spaces?

Geoffrey Over a year ago

This will not work, $_GET['color'] will contain spaces, not the '+' sign that the GET parameter would have been encoded with.

kushalbhaktajoshi Over a year ago

@EvanTeran please check the latter one . .

kushalbhaktajoshi Over a year ago

@Geoffrey please check the latter one . .

Collectives™ on Stack Overflow

_GET in PHP for variable with multiple values

3 Answers 3

2 Comments

1 Comment

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related