How to get from the database (mysqli) all records in the form of associative arrays?

Question

PHP

There is a database:
id, foo, bar
1,1,1
2,2,2
I want to get an array:
[0]=>['id'=>1,'foo'=>1,'bar'=>1]
[ 1]=>['id'=>2,'foo'=>2,'bar'=>2]
mysqli_fetch_all returns non-associative arrays. I can't find a suitable method.

Answer 1

mysqli_fetch_all($res, MYSQLI_ASSOC);
php.net/manual/ru/mysqli-result.fetch-all.php

Answer 2

php.net/manual/ru/function.mysql-fetch-assoc.php