What is the difference between mysql_fetch_array and mysql_fetch_object?

Posted by Editorial Staff | Updated on January 4, 2020

Want to know the difference between mysql_fetch_array and mysql_fetch_object, then this answer is for you.

MySQL mysql_fetch_array() Function

The mysql_fetch_array() function returns a row from a recordset as an associative array and/or a numeric array. This function gets a row from the mysql_query() function and returns an array on success, or FALSE on failure or when there are no more rows.

Example: MySQL mysql_fetch_array() example.

mysql_connect("localhost", "mysql_user", "mysql_password") or

die("Could not connect: " . mysql_error());

mysql_select_db("mydb");

$result = mysql_query("SELECT id, name FROM mytable");

while ($row = mysql_fetch_array($result, MYSQL_NUM)) {

printf("ID: %s Name: %s", $row[0], $row[1]);

}

mysql_free_result($result);

MySQL mysql_fetch_object() Function

Example: mysql_fetch_object() example

mysql_connect("hostname", "user", "password");

mysql_select_db("mydb");

$result = mysql_query("select * from mytable");

while ($row = mysql_fetch_object($result)) {

echo $row->user_id;

echo $row->fullname;

}

mysql_free_result($result);

If you like this question & answer and want to contribute, then write your question & answer and email to freewebmentor[@]gmail.com. Your question and answer will appear on FreeWebMentor.com and help other developers.

What is the difference between mysql_fetch_array and mysql_fetch_object?

Related Questions & Answers

Solved Programs