Comparing a PHP array to MySQL database using IN, but only the first result is displayed

Question

I have the following MySQL table

|   module  | module_id |
|    301    |      1    |
|    302    |      2    |
|    303    |      3    |
|    304    |      4    |
|    305    |      5    |
|    306    |      6    |

The names of the modules are passed to PHP in the form of a JSON array. I'd like to select and display all of the module IDs which are included in the array. So for example, if the modules 301, 303 and 306 are passed to the script, I want to return the values 1, 3 and 6.

I've put together the following script which almost works, but unfortunately it's only returning the first value - so if 301, 303 and 306 are in the array, the script is returning '1', rather than 1, 3 and 6.

I'm sure there's probably something pretty basic that I'm missing but can't figure out what it is. Can someone help?

Thanks!

$conn = (DATABASE CONNECTION INFO);
$modules = $_REQUEST['modules'];
$insertmodules = json_decode(stripslashes($modules), true);
$inmods = implode(',', $insertmodules);
$getmodsquery = "SELECT module_id FROM modules WHERE module IN ('$inmods')";
$getmods = $conn->query($getmodsquery);

while($row = $getmods->fetch_assoc()) {
 foreach ($row as $value){
  print_r($value);
  }
 }

Do you have an idea what does $getmodsquery content looks like? — Your Common Sense
– Your Common Sense, Commented Mar 5, 2013 at 10:29

Vahid CH · Accepted Answer · 2013-03-05 10:29:41Z

2

remove quote from query and try this line:

$getmodsquery = "SELECT module_id FROM modules WHERE module IN ($inmods)";

answered Mar 5, 2013 at 10:29

Vahid CH

1,52715 silver badges27 bronze badges

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

1 Comment

Chris Over a year ago

That's it! I knew it'd be something embarrassingly simple! Thank you! I'll accept the answer in 10 minutes when it lets me!

Collectives™ on Stack Overflow

Comparing a PHP array to MySQL database using IN, but only the first result is displayed

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related