How to store all of the data from MySQL into a variable in PHP?

Question

When I run the following query in phpmyadmin:

SELECT firstName, lastName, credits FROM volunteers ORDER BY credits, firstName ASC

I get 9 rows as the result. But when I run the following code in php, the $storing_data variable stores the array value of only one row.

$query_for_credits_table=mysqli_query($conn, "SELECT firstName, lastName, credits FROM volunteers ORDER BY credits, firstName ASC;");
$storing_data=mysqli_fetch_assoc($query_for_credits_table);

What will I have to do to store the complete information in the variable??

you get a table back, and you want to store it in a variable, do you mean an array or json? — nbk
– nbk, Commented Apr 19, 2020 at 11:03

nbk · Accepted Answer · 2020-04-19 11:14:11Z

1

You have to loop through the results and build then the array

$query_for_credits_table=mysqli_query($conn, "SELECT firstName, lastName, credits FROM volunteers ORDER BY credits, firstName ASC;");

if( $query_for_credits_table){
    while ($row = mysqli_fetch_assoc($query_for_credits_table)) {
        $user = array(
            'firstName' => $row['firstName'],
            'lastName' => $row['lastName'],
            'credits ' => $row['credits ']
        );
    }
    $storing_data[] = $user;
}

answered Apr 19, 2020 at 11:14

nbk

49.6k8 gold badges32 silver badges53 bronze badges

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

1 Comment

kmoser Over a year ago

Or just use mysqli_fetch_all().

Collectives™ on Stack Overflow

How to store all of the data from MySQL into a variable in PHP?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related