PDO Select query using array of OR

Question

I have an array of objects:

$arr = array('10', '12');

and i am running this query using PDO:

$stmt = $pdo->prepare("SELECT * from table WHERE user_sequence = :user_sequence");

i want to be able to have the query say WHERE user_sequence = :item1 OR user_sequence = :item2

item1, item2 etc being the objects from the array

how can i do this using PDO?

usually in MySQL, i would do:

$sql="SELECT * from table WHERE ";
foreach($array as $a) {
    $sql.="col = '".$a."' OR ";
}

but im not sure how to copy this theory in a PDO query

You would do the query as you have written it WHERE (user_sequence = :item1 OR user_sequence = :item2) and bind your variable accordingly. — Jay Blanchard
– Jay Blanchard, Commented Nov 11, 2015 at 22:32

Mike · Accepted Answer · 2015-11-11 23:53:44Z

1

You could do it like this:

$values = [ 'first value', 'second value', 'third value' ];

$conds = array_map(function() {
    return "user_sequence = ?";
}, $values);

$sql = "SELECT * from table WHERE " . implode(" OR ", $conds);

$stmt = $pdo->prepare($sql);
$stmt->execute($values);

edited Nov 11, 2015 at 23:53

answered Nov 11, 2015 at 22:21

Mike

24.5k14 gold badges84 silver badges93 bronze badges

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

3 Comments

charlie Over a year ago

just tried this, im getting an error (Fatal error: Call to undefined method PDO::execute())

Mike Over a year ago

@charlie Sorry, I had a small mistake.

Mike Over a year ago

@charlie You should consider accepting more of the answers to your questions. It shows future visitors to the site which ones worked for you and also gives reputation points to both you and the person whose answer you accept.

Collectives™ on Stack Overflow

PDO Select query using array of OR

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest