PHP / MySQL - 如何从表中选择id并在数组中选择echo

Question

How to make the array of id that we call from a table?

What I want is like this :

$array = array(1, 2, 3, 4, 5); // **1 - 5 select from a table**.

Thank you

Code :

$query = mysqli_query($conn, "SELECT * FROM tableA");
while($row = mysqli_fetch_assoc($query )){          
    $a = implode(',',(array)$row['id_add_user']);
    echo $a;
}

What I get from echo $a is 12345 not 1,2,3,4,5

Answer 1

Add all the elements to an array, then implode() it into one string with your desired deliminator (here, its ", ") once all results are fetched.

$result = [];
$query = mysqli_query($conn, "SELECT * FROM tableA");
while($row = mysqli_fetch_assoc($query)){          
    $result[] = $row['id_add_user']);
}

echo implode(", ", $result);