When I'm returning one row from a table, to gather the results I usually use e.g.:
$info = $result->fetch_assoc();
What is the difference between that and:
$info = $result->fetch_array();
Is there a reason to use one over the other when returning only one row, or is it just personal preference?
分享 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.
分享
