只获得第一个入门php mysql

Question

I have an mysqli table having values as such:-

 id | price
  65| 7000
  67| 7001

And a php code to echo both out using an array variable:-

  require('setup.php'); // got connection
  $array = array(0 => 65, 1 => 67);
  $d = implode("," , $array);
  $sql = "SELECT price FROM trade WHERE id IN('$d')";
  $query = mysqli_query($conn, $sql);
  if($query){
     while ($row = mysqli_fetch_array($query)) {
     echo $row['price'].'<br>';
    }
  }
 else {
   echo mysqli_error($conn);
   }

The output should come as

7000
7001

but it's only 7000.

Answer 1

You need to do IN(65,67) while you are doing IN('65,67')

So remove ' around $d

Code needs to be:-

$sql = "SELECT price FROM trade WHERE id IN($d)";

Note:- use fetch_assoc() for lighter array iteration (as it only gives associative array resultset)

while ($row = mysqli_fetch_assoc($query)) {

Working snippet :- http://rextester.com/FEFBWZ40805