Home/ Manual/ mysql / functions/ mysql_fetch_object

mysql_fetch_object

PHP function Edit on GitHub ✎

(PHP 4, PHP 5)

Fetch a result row as an object

Note mysqli_fetch_objectPDOStatement::fetch with mode as PDO::FETCH_OBJ

Description

mysql_fetch_object(resource $result, [string $class_name], [array $params]): object

Returns an object with properties that correspond to the fetched row and moves the internal data pointer ahead.

Parameters

class_name: The name of the class to instantiate, set the properties of and return. If not specified, a stdClass object is returned.
params: An optional array of parameters to pass to the constructor for class_name objects.

Return Values

Returns an object with string properties that correspond to the fetched row, or false if there are no more rows.

Examples

mysql_fetch_object() example

php

<?php
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);
?>

mysql_fetch_object() example

php

<?php
class foo {
    public $name;
}

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

$result = mysql_query("select name from mytable limit 1");
$obj = mysql_fetch_object($result, 'foo');
var_dump($obj);
?>

Notes

Note

Speed-wise, the function is identical to mysql_fetch_array(), and almost as quick as mysql_fetch_row() (the difference is insignificant).