Difficulty using an array as part of PDO "IN" query

Question

I'm trying to query a MySQL databse using an array.

$array=array('Group1','Group2','Group3');
$inQuery=implode(",",$array);
//$inQuery='Group1'; //This returns the expected result, but is obviously not an array

$data=array($inQuery);
try {
  $STH = $this->DBH->prepare('SELECT GroupName FROM myTable WHERE GroupName IN(?)');            
  $STH->execute($data);
  /* Output results*/
}
catch(PDOException $e) { /*Panic!*/ }

I am not getting any error messages, just 0 results. Any help would be appreciated!

The SQL IN clause doesn't support using a single variable for a list of values -- you'd need ? for each array value. — OMG Ponies
– OMG Ponies, Commented Jun 27, 2011 at 20:28

hornetbzz · Accepted Answer · 2011-06-27 20:55:31Z

1

You could try this way - not tested - :

// To fetch your array data
$array=array('Group1','Group2','Group3');
try {
  $STH = $this->DBH->prepare("SELECT GroupName FROM myTable WHERE GroupName IN (?)");            
  $STH->execute($array);
  while($lines=$STH->fetch($this->DBH->FETCH_OBJ))
{
        echo $lines->GroupName.'<br />';
}

}
catch(PDOException $e) { 
/*Panic!*/ 
echo 'ERR: ' .$e->getMessage().'<br/>';
}

answered Jun 27, 2011 at 20:55

hornetbzz

9,4056 gold badges41 silver badges58 bronze badges

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

Comments

Matt · Accepted Answer · 2011-08-02 18:11:57Z

0

Just in case anyone else ever comes across this....

It appeared to be an issue with escaping the imploded array.

$array=array('Group1','Group2','Group3');
$inQuery=implode(",",$array);
$inQuery="'".$inQuery."'"; //Solved the issue.

$data=array();
try {
  $STH = $this->DBH->prepare('SELECT GroupName FROM myTable WHERE GroupName IN($inQuery)');            
  $STH->execute($data);
  /* Output results*/
}
catch(PDOException $e) { /*Panic!*/ }

answered Aug 2, 2011 at 18:11

Matt

7,25216 gold badges55 silver badges67 bronze badges

Collectives™ on Stack Overflow

Difficulty using an array as part of PDO "IN" query

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related