mysql_fetch_object

mysql_fetch_object

Fetch a result row as an object

Waarschuwing: > mysqli_fetch_object``PDOStatement::fetch``mode``PDO::FETCH_OBJ

object **mysql_fetch_object** resource $result string $class_name array $params

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

class_name The name of the class to instantiate, set the properties of and return. If not specified, a object is returned. stdClass

params An optional of parameters to pass to the constructor for objects. array``class_name

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

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

Voorbeeld: example

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

Opmerking: > ### Performance

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

mysql_fetch_array``mysql_fetch_row

Opmerking: > is similar to , 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). mysql_fetch_object``mysql_fetch_array

mysql_fetch_array``mysql_fetch_assoc``mysql_fetch_row``mysql_data_seek``mysql_query