Oracle 5.0, Reference Manual

Page: 2515 / 3232

MySQL Improved Extension (
Mysqli
)
2495
result
Procedural style only: A result set identifier returned
by
mysqli_query
,
mysqli_store_result
or
mysqli_use_result
.
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 corresponds to the fetched row or
NULL
if there are no
more rows in resultset.
Note
Field names returned by this function are case-sensitive.
Note
This function sets NULL fields to the PHP
NULL
value.
Changelog
Version Description
5.0.0 Added the ability to return as a different object.
Examples
Example 20.197. Object oriented style
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
$query = "SELECT Name, CountryCode FROM City ORDER by ID DESC LIMIT 50,5";
if ($result = $mysqli->query($query)) {
/* fetch object array */
while ($obj = $result->fetch_object()) {
printf ("%s (%s)\n", $obj->Name, $obj->CountryCode);
}
/* free result set */
$result->close();
}
/* close connection */
$mysqli->close();
?>
Example 20.198. Procedural style