mysqli fetch_all() not a valid function?

Question

Thanks to the answers I have figured out that I am unable to use fetch_all() because i am using PHP 5.2.17 - fetch_assoc with while loop worked.

The function I am using fetch_all is coming back with this error:

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

$mysqli = new mysqli($host, $username, $password, $database);
$query = "LONG QUERY that works, tested in phpmyadmin"
$result = $mysqli->query($query);
$result->fetch_all(); or  $mysqli->fetch_all() tried both
mysqli_fetch_all() was already tried.
$mysqli->close();

I am able to connect to the DB and I have pulled single rows. When I place the query in PHPMYADMIN I get 5 rows back.

Does this function even work? Is there a way I can place my data into an assoc array on my own?

score 56 · Accepted Answer · answered Jul 14 '11 at 14:16

56

This function is available since PHP 5.3.0. Possibly your version is older. Use fetch_assoc() instead.

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

answered Jul 14 '11 at 14:16

Karolis

9,396
29
38

score 35 · Answer 2 · edited Oct 21 '14 at 23:31

35

mysqli::fetch_all() needs mysqlnd driver to be installed before you can use it.

edited Oct 21 '14 at 23:31

Unihedron

10,902
13
62
72

answered Oct 21 '14 at 23:07

Amir Hassan Azimi

9,180
5
32
43

2

Yes, and if you have a roundcube running (on Debian) it will stop working since mysqlnd removes php-mdb2-driver-mysql and roundcube-mysql driver. So install mysqlnd with caution – trojan Nov 02 '15 at 08:11

javatar · Answer 3 · 2020-02-13T06:37:34.817

22

Issue seems to be 'mysqli' and 'mysqlnd' are not working together. I had the same issue in cpanel

Steps:

1) Go to CPanel dashboard

2) Go to 'Select PHP Version', you should see a bunch of checkboxes

3) Set PHP version (5.4 or above)

4) Uncheck the 'mysqli' extension and check both 'mysqlind' and 'nd_mysqli'

Apparently 'nd_mysqli' is 'mysqli' but configured to work with 'mysqlind' and to make it work you have to uncheck 'mysqli' due to settings conflicts.

Following answer I found here helped me.

edited Feb 13 '20 at 06:37

answered Jun 19 '19 at 23:29

javatar

1,332
1
17
24

1

this is the correct answer. it's not about the PHP version, but about the extension. must be nd_mysqli and mysqlind. my hosting pre-select mysqli and nd_mysqli, that's why mysqli_fetch_all does not work. – Yohannes Kristiawan Jun 19 '20 at 09:27
Correct answer! Thanks a lot, I do not know why this happened but it helped me ^^ – Ahmet Halilović Sep 01 '20 at 20:12
Correct! Thanks a lot!! – Nabukodonosor Nov 26 '20 at 16:43
Don't just change this setting on a whim, it can have serious implications. Doing so took down my site until I reverted the changes. – Alan P. Dec 18 '20 at 22:14
corect thanks alot it worked for me as well – manoj Oct 10 '21 at 14:28

score 21 · Answer 4 · edited Mar 26 '14 at 04:03

21

The typical way to construct an associative array is in a while loop:

$results_array = array();
$result = $mysqli->query($query);
while ($row = $result->fetch_assoc()) {
  $results_array[] = $row;
}

edited Mar 26 '14 at 04:03

p0rsche

503
7
20

answered Jul 14 '11 at 14:17

Michael Berkowski

267,341
46
444
390

This code helped me solve my problem. Thank you! – MichalRyszardWojcik Jan 17 '22 at 17:24

score 9 · Answer 5 · edited Nov 06 '11 at 12:22

9

Please be careful about using fetch_all():

http://www.php.net/manual/en/mysqli-result.fetch-all.php#88031

Read the note about mysqldn requirement.

edited Nov 06 '11 at 12:22

Bill the Lizard

398,270
210
566
880

answered Jul 14 '11 at 14:13

Fabrizio D'Ammassa

4,729
25
32

Couldn't find anything about the mysqldn requirement on that page. Could you elaborate, why fetch_all() is "evil"? Thanks – Sandro Mar 21 '21 at 20:17

score 8 · Answer 6 · answered Jul 14 '11 at 14:16

8

As an addition to Fabrizios answer, please consider building up your array with a loop:

$array = array();
while($row = $result->fetch_assoc())
    $array[] = $row;

answered Jul 14 '11 at 14:16

Sascha Galley

15,711
5
37
51

score 3 · Answer 7 · edited May 22 '20 at 17:58

3

If you don't want to iterate using Karolis' answer, use

     while($row = mysqli_fetch_array($result,MYSQLI_ASSOC))
    {
       $rows[] = $row;
    }

to achieve the same result as

$rows = mysqli_fetch_all($result, MYSQLI_ASSOC);

You may change constant to MYSQLI_NUM or MYSQLI_BOTH. This optional parameter are constants indicating what type of array should be produced from the current row data.

Notice that mysqli_fetch_array($result,MYSQLI_ASSOC ) behaves identically to the mysqli_fetch_assoc() function, while mysqli_fetch_array($result,MYSQLI_NUM) will behave identically to the mysqli_fetch_row() function. The final option MYSQLI_BOTH will create a single array with the attributes of both. http://php.net/manual/en/mysqli-result.fetch-array.php

edited May 22 '20 at 17:58

Dharman

30,962
25
85
135

answered Mar 24 '18 at 10:10

Wilson

1,259
11
17

This answer is essentially wrong. `mysqli_fetch_array($result, MYSQLI_ASSOC);` **does not** achieve the same result as `$rows = mysqli_fetch_all($result, MYSQLI_ASSOC);` – Your Common Sense Jul 23 '19 at 11:54
It's funny I didn't notice that. Grateful @YourCommonSense – Wilson Jul 24 '19 at 13:14

score 2 · Answer 8 · answered Mar 25 '17 at 02:30

2

I had 5.6 but didn't work for me anyway. By enabling the mysqlnd driver it worked for me. Just write apt-get install php5-mysqlnd then restart php and you're good to go!

answered Mar 25 '17 at 02:30

Coco

826
1
12
20

sirmagid · Answer 9 · 2016-02-06T19:39:33.520

PHP Fatal error: Call to undefined function mysqli_fetch_all()

$rows = mysqli_fetch_all($result, MYSQLI_ASSOC);//not work

change to:php 5.3 or

$query = "SELECT * FROM `user_counter` ORDER BY id DESC LIMIT 20";
$result =  mysqli_query($connection, $query) or die
("Error in Selecting " . mysqli_error($connection));
$rows = array();
while ($row = $result->fetch_assoc()) {
    $rows[] = $row;
}
echo json_encode($rows);

score 0 · Answer 10 · edited Apr 15 '16 at 17:07

0

Just to add an additional note about the mysqlnd driver: It also has to have the mysqli API extension installed. Without the extension, fetch_all() still won't be available. I found this while troubleshooting why my code worked on one server but not another, both PHP > 5.3. Use phpinfo() to verify the installed extensions.

edited Apr 15 '16 at 17:07

Richard Erickson

2,568
8
26
39

answered Apr 15 '16 at 15:52

Chris Langtiw

176
4

score 0 · Answer 11 · answered Mar 02 '17 at 04:29

function runQuery($query) {
        $result = mysqli_query($this->conn,$query);
                $resultset  = array(); //you need to define array
                         while($row=$result->fetch_assoc()) {
                              $resultset[] = $row; //then insert result into the array
            }       
            if(!empty($resultset))
            {

            return $resultset;}
            else{return 'empty';};
    }

mysqli fetch_all() not a valid function?

11 Answers11

Linked

Related