FOREACH在每次迭代时都没有准备PDO语句

Question

I am trying to run a FOREACH with PDO but so far my code seems to iterate only once for the FOREACH and returns only the 1st value.

Here is what I have:

$colors = $_GET['color'];
$colors = explode(' ', $colors);
foreach ($colors as $color) 
    {
    $items = $con -> prepare("SELECT * FROM item_descr WHERE color_base1 = :colorbase1");
    $items -> bindValue(":colorbase1", $color);
    }
$items ->execute();
while($info = $items->fetch(PDO::FETCH_ASSOC)) 
{
echo $info['color_base1'];
}

Note that $colors contains more than 1 different color obtained from checkboxes and a jquery.

Thanks!

Answer 1

Your code is nested wrong: you want to prepare the query once, and execute it multiple times, but you're doing the opposite.

Rather than:

foreach ( ... )
{
    prepare( ... );
    bind( ... );
}
execute();

You need:

prepare( ... );
foreach ( ... )
{
    bind( ... );
    $results[] = execute();
}

Alternatively, you could use an SQL IN clause to build one query rather than having the overhead of going back and forth to the database multiple times.