php mysqli fetch all

Solutions on MaxInterview for php mysqli fetch all by the best coders in the world

Search
showing results for - "php mysqli fetch all"
Shana
30 Mar 2020
1$mysqli = new mysqli("host", "user", "password", "database", 'port', 'socket');
2
3$result = $mysqli->query("SELECT Name, Type, Color FROM Fruit");
4
5/**
6 * This optional parameter is a constant indicating what type of array should
7 * be produced from the current row data. The possible values for this parameter
8 * are the constants MYSQLI_ASSOC, MYSQLI_NUM, or MYSQLI_BOTH.
9 */
10$rows = $result->fetch_all(MYSQLI_ASSOC);
11
12foreach ($rows as $row) {
13  printf("%s - %s - %s\n", $row["Name"], $row["Type"], $row["Color"]);
14}
source
similar questions
php mysqli fetch single rowhow to fetch data from url in php properlygeneral errorstring fetchall 28 29 phpphp fetchfetch body show in php codephp fetch mysql result as variablephp print fetchhow to fetch data from database in phphow to reverse fetch assoc in phpfetch row in phpphp fetchallmysql fetch array phpphp fetch return falsemysqli fetch row assochow to fetch mysql data with speacial characters in phpphp code for fetching data from database
queries leading to this page
php fetch data from mysqlimysqli connect fetch allmysqli fetch all 28 29php mysqli fetch allmysqli fetch all in phppgp manual mysqli fetch allfetch all mysqlimysqli fetchfetchall in mysqlimysqli fetch resultmysqli query fetch result in phpmysqli fetch allmysqli fetch all phpmysqli fetch allmysqli fetch all as objecthow to fetch data from mysqli in phpfetch data from mysqli in phpmysqli query fetch resultphp manual mysqli fetch allmysqli fetch all dataphp mysqli fetch data from databasefetch data mysqli phpmysqli fetch dataphp mysqli fetch all