Easy Tutorial
❮ Func Xml Parser Get Option Func String Substr ❯

PHP mysqli_fetch_object() Function

PHP MySQLi Reference Manual

Returns the current row from the result set and outputs the value of each field:

<?php 
// Assume database username: root, password: 123456, database: tutorialpro 
$con = mysqli_connect("localhost", "root", "123456", "tutorialpro"); 
if (mysqli_connect_errno($con)) 
{ 
    echo "Failed to connect to MySQL: " . mysqli_connect_error(); 
} 

$sql = "SELECT name, url FROM websites ORDER BY alexa";

if ($result = mysqli_query($con, $sql))
{
    while ($obj = mysqli_fetch_object($result))
    {
        printf("%s : %s", $obj->name, $obj->url);
        echo "<br>";
    }

    // Free result set
    mysqli_free_result($result);
}

mysqli_close($con);
?>

Definition and Usage

The mysqli_fetch_object() function fetches the current row from the result set and returns it as an object.

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


Syntax

Parameter Description
result Required. Specifies a result set identifier returned by mysqli_query(), mysqli_store_result(), or mysqli_use_result().
classname Optional. Specifies the class name to instantiate, set properties, and return.
params Optional. Specifies an array of parameters to pass to the constructor of the classname object.

Technical Details

Return Value: Returns an object with string properties that corresponds to the fetched row. Returns NULL if there are no more rows in the result set.
PHP Version: 5+
--- ---
Changelog: Added the ability to return as an object in PHP 5.0.0.
--- ---
❮ Func Xml Parser Get Option Func String Substr ❯