Retrive an array stored in database using PDO

[hamedghaderi]

I have an array:

 productid = [1,2] 

. Now I want to fetch data from product table by using this part of code:

$sql = 'SELECT name FROM product WHERE id=:id';
$s = $pdo->prepare($sql);
foreach($productid as $id)
{
  $s->bindValue(':id', $id);
  $s->execute();
}

when I returned the names as follow:

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

I just got the product name of second id and didn't get both names. What's the problem?