Difference between Fetch_assoc, Fetch_array, Fetch_row - MySQL

What is the difference between Fetch_assoc, Fetch_array and Fetch_row in MySQL. When is it effective to use each of them ?

11 Aug 2021 at 08:30 AM

Stor

Hi,

There are differences between using Fetch_assoc, Fetch_array and Fetch_row. Each of them is effective in different situations, so it depends on your needs. In specific solutions, some of them may be faster or slower.

Fetch_row - returns a numeric array of strings that corresponds to the fetched row, or false if there are no rows.
Fetch_assoc - returns an associative array of strings that corresponds to the fetched row, or false if there are no rows.
Fetch_array - is a combination of Fetch_row and Fetch_assoc. It returns both numeric array and associative array of strings that corresponds to the fetched row.

For example can be used SQL query SELECT user_id, user_name, user_account FROM users;

Mysqli_fetch_row returns an output:

[0] => 1,
[1] => "Brandon",
[2] => "Pro"

Mysqli_fetch_assoc returns an output:

[user_id] => 1,
[user_name] => "Brandon",
[user_account] => "Pro"

Mysqli_fetch_array returns an output:

[0] => 1,
[1] => "Brandon",
[2] => "Pro",
[user_id] => 1,
[user_name] => "Brandon",
[user_account] => "Pro"

15 Aug 2021 at 11:43 AM

Tim

Difference between Fetch_assoc, Fetch_array, Fetch_row - MySQL

Fatal error: Call to undefined function mysql_query() - PHP

Error: Illegal parameter data types INT and row for operation '='

Is faster one big SQL query or multiple small SQL queries ?

Copy and update rows in the same table with autoincrement - SQL

Insert or update current date in DATETIME format - SQL

MySQL error: Unknown table engine 'InnoDB' - how to fix ?

Fix SQL error Index for table 'user_db' is corrupted, try to repair it