PHP Multiple Dropdown Box Form Submit To MySQL with OR

Question

This question is similar to PHP Multiple Dropdown Box Form Submit To MySQL, but with a twist.

Let's assume we have an HTML multi-select, which gets submitted to a PHP backend.

How do you elegantly create a mysql request with an OR condition on the values of a multi-select?

For instance I have a multi-select with a list of sports. How do do:

SELECT * FROM sports WHERE sport.name=:sport1 OR sport.name=:sport2 OR sport.name=:sport3...

Galen · Accepted Answer · 2009-11-26 20:42:25Z

2

This is untested, just an idea...

$_POST['sports'] = array('basketball', 'baseball', 'football', 'soccer');

$sql = sprintf("SELECT * FROM sports WHERE sport.name IN (%s)", implode( ',', array_fill(1,count($_POST['sports']), '?') ) );
// SELECT * FROM sports WHERE sport.name IN (?,?,?,?) 
$st = $dbh->prepare($sql);

// bind all values
foreach( $_POST['sports'] as $i => $sport) {

    $st->bindValue( ++$i, $sport );

}

$st->execute();

answered Nov 26, 2009 at 20:42

Galen

30.2k9 gold badges75 silver badges90 bronze badges

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

1 Comment

JB Hurteaux Over a year ago

Dude, if you typed that without even try it to run it, you are amazing ;-) Works perfectly.

mtvee · Accepted Answer · 2009-11-26 19:57:51Z

2

SELECT * FROM sports WHERE sports.name IN ('football','hockey','soccer','trolling');

answered Nov 26, 2009 at 19:57

mtvee

1,58513 silver badges14 bronze badges

1 Comment

JB Hurteaux Over a year ago

This is a good point since I cheched mySQL operators and could not find "IN". But the question, whether using IN or ORs, is more about the PHP part to generate this from the array my input will produce. And to generate it in a elegant way, because I'm sure I can write an ugly loop with checks on first item, last item and empty array.

mhutter · Accepted Answer · 2010-07-29 14:16:04Z

1

$_POST['sports'] = array('basketball', 'baseball', 'football', 'soccer');

$sql = sprintf("SELECT * FROM sports WHERE sport.name IN (%s)", implode(',', $_POST['sports']));

Should result in

SELECT * FROM sports WHERE sport.name IN (basketball,baseball,football,soccer)

answered Jul 29, 2010 at 14:16

mhutter

2,92523 silver badges33 bronze badges

Collectives™ on Stack Overflow

PHP Multiple Dropdown Box Form Submit To MySQL with OR

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related