Fetching one row only with MySQLi

Question

How can I only fetch one INDEXED row with MySQLi? I'm currently doing this:

$row = $result->fetch(MYSQLI_ASSOC);
$row = $row[0];

Is there another way?

I'm aware of mysqli_fetch_row but it doesn't return an associative array.

score 56 · Accepted Answer · edited Apr 12 '18 at 13:34

56

Use $row = $result->fetch_assoc(); - it's the same as fetch_row() but returns an associative array.

edited Apr 12 '18 at 13:34

Tim

answered Jan 17 '12 at 11:10

You Qi

Also, see http://php.net/manual/en/mysqli-result.fetch-assoc.php fetch_assoc manual page. – webLacky3rdClass May 03 '17 at 19:20

1 Answers1