Get all rows as an array of objects without a loop using MySQLi

Question

This is how I get one record with MySQLi:

$result = $db->query("...");
$image = $result->fetch_object();

Now I need to get the comments and pass it to the view. I'm using the following snippet right now, but it doesn't seem right:

$result = $db->query("...");

while ($row = $result->fetch_object())
    $comments[] = $row;

I'm wondering if there's a way to remove the loop? Is there something like:

$image = $result->fetch_object(((s)))

So then my code would look like:

$result = $db->query("...");
$comments = $result->fetch_objects();

You can make your loop shorter if you use a bodyless for loop. for (; $obj = $result->fetch_object(); $arr_objects[] = $obj); — Dharman
– Dharman ♦, Commented Aug 18, 2022 at 20:38

mickmackusa · Accepted Answer · 2022-08-26 23:28:01Z

4

The mysqli_result class provides a fetch_all method to collect the full result set. However, that method will only return associative or numeric arrays (or a hybrid), not objects.

edited Aug 26, 2022 at 23:28

mickmackusa♦

49.2k13 gold badges98 silver badges165 bronze badges

answered Jan 31, 2012 at 1:38

pilcrow

59.2k14 gold badges101 silver badges147 bronze badges

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

Comments

TylerH · Accepted Answer · 2022-08-26 14:57:45Z

1

It's not possible to get an array of objects using mysqli_fetch_all(). The available options are: indexed array, associative array, or both.

Consider using the PHP Data Objects (PDO) interface, which has many more fetch modes and is thus superior to MySQLi in that regard.

edited Aug 26, 2022 at 14:57

TylerH

21.3k84 gold badges84 silver badges121 bronze badges

answered Aug 18, 2022 at 20:27

Dharman♦

33.9k27 gold badges106 silver badges157 bronze badges

1 Comment

Barmar Over a year ago

Very diplomatic. It's superior to mysqli in all regards, IMHO. Unless similarity to the old mysql extension is something you value.

Kyle Noland · Accepted Answer · 2012-01-31 00:29:25Z

-1

Without seeing your SQL, it's tough to say. There may be a better query you could use. Post your SQL and I'll take another look.

In terms of your SQL query, if your query returns multiple rows, then you have already fetched them with one db call.

I don't see a way to collect into an array all of the comments, but you can clean up your code with a custom function.

function get_all_rows_as_array(&$result)
{
    foreach($result as mysql_fetch_assoc($result))
    {
        $array[] = $row;
    }

    return $array;
}

$result = $db->query("...");
$comments = get_all_rows_as_array($result);

answered Jan 31, 2012 at 0:29

Kyle Noland

4,7986 gold badges32 silver badges34 bronze badges

Collectives™ on Stack Overflow

Get all rows as an array of objects without a loop using MySQLi

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related