multiple parameters into sql select 'in' statement

Question

So I have a dynamic built query using the 'IN' clause, but really need to select for two parameters, and cannot seem to figure out how to do this.

$selectSql= "SELECT groupid FROM groups WHERE name IN(";

foreach ($groupsArray as $group => $row){

  $selectSql .= "'".$row['name']."'".",";

}  
$selectSql = rtrim($selectSql, ',');
$selectSql .= ")";

Really, the query needs to look something like:

$selectSql= "SELECT groupid FROM groups WHERE name and type IN(;

How would I go about doing this?

Sincere thanks for any help! it is greatly appreciated.

What you are doing has nothing to do with prepared statement. Please remove the tag. — Jens
– Jens, Commented Feb 3, 2015 at 9:36

Rakesh Sharma · Accepted Answer · 2015-02-03 09:40:03Z

3

Try implode()

foreach ($groupsArray as $group => $row ){
  $name[]= "'".$row['name']."'";
  $type[] = "'".$row['type']."'";
}  
$selectSql= "SELECT groupid FROM groups WHERE name IN(".implode(',',$name).") and type IN(".implode(',',$type).")";

answered Feb 3, 2015 at 9:40

Rakesh Sharma

13.7k5 gold badges41 silver badges44 bronze badges

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

Comments

Cristiano C. · Accepted Answer · 2015-02-03 10:14:02Z

2

I also support implode() but done in a slightly different way:

$name = array();
$type = array();
foreach ($groupsArray as $group => $row ) {
  $name[] = $row['name'];
  $type[] = $row['type'];
}

$selectSql= "SELECT groupid FROM groups WHERE name IN ('". implode("' ,'", $name) ."') and type IN ('". implode("', '", $type). "')";

In this way you do not have to change the array to insert the ' to each item because it is done by implode.

I did not understand well what he's like your array, but you may even direct access $groupsArray items without creating $name and $type.

answered Feb 3, 2015 at 10:14

Cristiano C.

363 bronze badges

Collectives™ on Stack Overflow

multiple parameters into sql select 'in' statement

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