Fetch multiple mysql rows at once in PHP

Question

How can I fetch multiple rows at once from a MySQL table in PHP?

Suppose my query returns 5 rows in all and I specify a block size of 2, the function must return an object/array with 2+2+1 rows successively.

P.S. I know that I can iterate over all the results manually and do the same implementation myself, but I am looking for some built-in function that does this cleanly and in an optimized way.

Answer 1

Look into using the PDO object if you're not already using it. That way, you'll be able to make use of the fetchAll function.

<?php
$sth = $dbh->prepare("SELECT name, colour FROM fruit");
$sth->execute();

/* Fetch all of the remaining rows in the result set */
print("Fetch all of the remaining rows in the result set:\n");
$result = $sth->fetchAll();
print_r($result);
?>

Fetch all of the remaining rows in the result set:

Array
(
    [0] => Array
        (
            [NAME] => pear
            [0] => pear
            [COLOUR] => green
            [1] => green
        )

    [1] => Array
        (
            [NAME] => watermelon
            [0] => watermelon
            [COLOUR] => pink
            [1] => pink
        )

)

Answer 2

The function you're looking for does not exist. Write it yourself.