Nesting mysqli array and query functions

Question

$array = mysqli_fetch_array(mysqli_query($link,$result));

Is this a correct PHP/mysqli statement or do I have to run the query first and then the array fetching in two separate statements?

Martin Prikryl · Accepted Answer · 2016-10-12 05:56:16Z

1

The code should do, what you want. Assuming the $result, despite the strange name, is really an SQL query string.

But make sure you have configured mysqli to throw exceptions on error. Otherwise in case of error you will have no means to get the error message.

(Credits go to @Your Common Sense)

answered Oct 11, 2016 at 18:59

Martin Prikryl

205k64 gold badges559 silver badges1.1k bronze badges

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

6 Comments

@YourCommonSense Why do you think so?

Because result will be discarded and thus released all associated resources in destructor

OK, I see, because there's no reference to the results anymore, right?

Yes, exactly. So technically this code is all right.

You cannot as it's accepted. But you can edit it and then I can delete mine )

|