X
X
xenonhammer2020-02-13 13:34:38
PHP
xenonhammer, 2020-02-13 13:34:38

Why do the rows received after SELECT behave like this?

I do

$query1_string = "SELECT `manufacturer_id` FROM `oc_manufacturer`";
$query1 = mysqli_query($connect_bd, $query1_string);

I check how many lines I touched:
echo mysqli_num_rows($query1);
I get the result: 862

Ok, then I put it in an array:
$arrayQuery = mysqli_fetch_assoc($query1);
var_dump($arrayQuery); // выдает только первую строчку в колонке MySQL

Why only one value??? Please answer who knows.

What happens when I use loops:
foreach($arrayQuery as $Query){ // Форич показывает, так же одну строку ассоциативного массива - ключ, значение.
echo $Query;
} 
while($arrayQuery = mysqli_fetch_assoc($query1)){ // А вот вайл показывает все 862 значения....
echo $arrayQuery;
}

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
AUser0, 2020-02-13
@xenonhammer

Read the documentation. Re-read the documentation. Understand what is written in the documentation. Or here:

$arrayQuery = mysqli_fetch_all($query1, MYSQLI_ASSOC);
var_dump($arrayQuery);

F
FanatPHP, 2020-02-13
@FanatPHP

php.net/mysqli_fetch_assoc

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question