Mysqli fetch_assoc vs fetch_array

by

It’s all about performance

fetch_array() returns one array with both numeric keys, and associative strings (column names), so here you can either use $row['column_name'] or $row[0]

Where as fetch_assoc() will return string indexed key array and no numeric array so you won’t have an option here of using numeric keys like $row[0].

So the latter one is better in performance compared to fetch_array() and obviously using named indexes is far better compared to numeric indexes.

More Related Contents:

  1. PHP create new array by value
  2. PHP Mysqli query update not working with variable
  3. Turning a SQL row into an array
  4. How to insert database rows if there are no answers
  5. two person chat room
  6. Pagination data
  7. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  8. Example of how to use bind_result vs get_result
  9. mysqli::query(): Couldn’t fetch mysqli
  10. get array of rows with mysqli result
  11. How to start and end transaction in mysqli?
  12. How to install MySQLi on MacOS
  13. How do I iterate over the results in a MySQLi result set?
  14. PHP MySQLI Prevent SQL Injection [duplicate]
  15. The mysqli extension is missing. Please check your PHP configuration
  16. How to test if a MySQL query was successful in modifying database table data?
  17. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in [duplicate]
  18. PHP Commands Out of Sync error
  19. MYSQLi error: User already has more than ‘max_user_connections’ active connections [duplicate]
  20. $stmt->execute() : How to know if db insert was successful?
  21. store_result() and get_result() in mysql returns false
  22. Checking if mysqli_query returned any values?
  23. Warning: mysqli_query() expects parameter 1 to be mysqli, string given in
  24. Mysqli Prepare Statement – Returning False, but Why? [duplicate]
  25. Fatal error: Call to undefined method mysqli_result::fetch_all()
  26. How to run the bind_param() statement in PHP?
  27. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  28. Set character set using MySQLi
  29. Cannot figure out how to run a mysqli_multi_query and use the results from the last query
  30. How to get a list of databases?

Leave a Comment