PHP将所有行作为数组获取

Question

im trying to grab all the row values from a database column like this:

$products = mysqli_fetch_assoc(mysqli_query($con,"SELECT product_id FROM am_product"));
print_r($products);

expecting to get something like if i do this:

$products = array(1,2,3,4,5) 

in the first place so i can use it in other functions. But instead i only get this: Array ( [product_id] => 1 ).

How can i get all the values and not only the first one?

Thank you.

Answer 1

In your post: $products should be renamed to $product to better understand your code and to understand your problem. fetch_assoc() only returns ONE element and increases a 'pointer'. Upon reaching the end of a list the function will return false. Thats why you mostly use while(fetch_assoc()) for this purpose.

Maybe this will help:

$entries = array();
while($entry = $result->fetch_assoc()) {
    foreach($entry as $key => $value) $entries[$i][$key] = $value;
    $i++;
}