PHP: Hypertext Preprocessor (original) (raw)

mysql_fetch_object

(PHP 4, PHP 5)

mysql_fetch_object — Fetch a result row as an object

Description

Parameters

result

The result resource that is being evaluated. This result comes from a call tomysql_query().

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](reserved.constants.php#constant.false) if there are no more rows.

Examples

Example #1 mysql_fetch_object() example

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

Example #2 mysql_fetch_object() example

<?php class foo { public $name; }mysql_connect("hostname", "user", "password"); mysql_select_db("mydb");$result = mysql_query("select name from mytable limit 1"); <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>o</mi><mi>b</mi><mi>j</mi><mo>=</mo><mi>m</mi><mi>y</mi><mi>s</mi><mi>q</mi><msub><mi>l</mi><mi>f</mi></msub><mi>e</mi><mi>t</mi><mi>c</mi><msub><mi>h</mi><mi>o</mi></msub><mi>b</mi><mi>j</mi><mi>e</mi><mi>c</mi><mi>t</mi><mo stretchy="false">(</mo></mrow><annotation encoding="application/x-tex">obj = mysql_fetch_object(</annotation></semantics></math>obj=mysqlfetchobject(result, 'foo'); var_dump($obj); ?>

Notes

Note: Performance

Speed-wise, the function is identical tomysql_fetch_array(), and almost as quick asmysql_fetch_row() (the difference is insignificant).

Note:

mysql_fetch_object() is similar tomysql_fetch_array(), with one difference - an object is returned, instead of an array. Indirectly, that means that you can only access the data by the field names, and not by their offsets (numbers are illegal property names).

Note: Field names returned by this function are case-sensitive.

Note: This function sets NULL fields to the PHP [null](reserved.constants.php#constant.null) value.

Found A Problem?

There are no user contributed notes for this page.