Save SQL data to PHP array

Question

I want to pull the data from a SQL table to an array in my PHP script. I need that because after that I want to compare two tables.

$sql = "select date, sum(clicks) from Table group by date";

$query = $Db->query($sql);

$result = array(); // Script does not work even if I remove this line

$result = $query->fetchAll();

print_r($result);

I am getting the error :

PHP Fatal error: Call to undefined method mysqli_result::fetchAll()

Possible duplicate of mysqli fetch_all() not a valid function? — Muhammad Muazzam
– Muhammad Muazzam, Commented Dec 8, 2015 at 13:53

Lavi Avigdor · Accepted Answer · 2015-12-08 14:02:18Z

1

As @Mark said, use

$result = $query->fetch_all();

For PHP version prior to PHP 5.3.0, use:

while ($row = $result->fetch_assoc()) {
    // do what you need.
}

edited Dec 8, 2015 at 14:02

answered Dec 8, 2015 at 13:49

Lavi Avigdor

4,1923 gold badges28 silver badges28 bronze badges

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

2 Comments

Datacrawler Over a year ago

PHP Fatal error: Call to undefined method mysqli_result::fetch_all()

Lavi Avigdor Over a year ago

I've edited the response. Please also post your PHP version.

Collectives™ on Stack Overflow

Save SQL data to PHP array

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related