mysql_fetch_object
]Podporované v PHP 4, PHP 5 Syntax
object mysql_fetch_object ( resource $result [, string $class_name [, array $params ] ] )
Popis
Príkaz jazyka PHP
Returns an object with properties that correspond to the fetched row and moves the internal data pointer ahead.
Parametre
result - The result resource that is being evaluated. This result comes from a call to mysql_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.
Vrátená hodnota
Returns an object with string properties that correspond to the fetched row, or FALSE if there are no more rows.
Príklad 1
<?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);
?>
Príklad 2
<?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);
?>
Pozri aj
mysql_fetch_array, mysql_fetch_assoc, mysql_fetch_row, mysql_data_seek, mysql_query
]