mysqli_fetch_array returning only one result

Question

I'm trying to make a very, very simple query of a small mysql database, using the following code (with appropriate values in $host, etc.):

$result = mysqli_query($connection, "select university from universities_alpha");
$row = mysqli_fetch_array($result);

echo print_r($result);
echo '<br><br>';
echo print_r($row);

As you can see, I printed out the results in a human-readable way, yielding:

mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => Array ( [0] => 19 ) [num_rows] => 9 [type] => 0 ) 1

Array ( [0] => Arizona State Univ. [university] => Arizona State Univ. ) 1

There are a few example universities in that column, so I'm not sure what I'm doing wrong.

read the manual for the mysqli functions. you put the fetch_array in a while loop, because it returns the rows one by one until it returns null and the loop terminates. — Felk
– Felk, Commented Oct 16, 2014 at 23:34

RiggsFolly · Accepted Answer · 2019-07-03 12:38:14Z

7

mysqli_fetch_array works by pointers each time it's called

Imagine the following

$result = mysqli_query($connection, "select university from universities_alpha");
$row = mysqli_fetch_array($result); // this is the first row
$row = mysqli_fetch_array($result); // now it's the second row
$row = mysqli_fetch_array($result); // third row

To actually display the data the way you want it to, I suggest you do the following

$rows = array();
$result = mysqli_query($connection, "select university from universities_alpha");
while($row = mysqli_fetch_array($result)) {
    $rows[] = $row;
}

print_r($rows);

edited Jul 3, 2019 at 12:38

RiggsFolly

94.7k22 gold badges108 silver badges152 bronze badges

answered Oct 16, 2014 at 23:35

Ali

3,4364 gold badges19 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dharman · Accepted Answer · 2021-04-16 10:56:24Z

2

If you want to fetch all rows from the result set then you must use mysqli_fetch_all() instead of mysqli_fetch_array().

Replace your code with this:

$result = mysqli_query($connection, "select university from universities_alpha");
$rows = mysqli_fetch_all($result, MYSQLI_BOTH);

answered Apr 16, 2021 at 10:56

Dharman♦

34k27 gold badges106 silver badges157 bronze badges

Collectives™ on Stack Overflow

mysqli_fetch_array returning only one result

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related