Return the current row in the result set, then print the value of each field:
<?php // Assume database username: root, password: 123456, database: CODERCTO $con=mysqli_connect("localhost","root","123456","CODERCTO"); 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>"; } // Release the result collection mysqli_free_result($result);}mysqli_close($con);?>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.
mysqli_fetch_object( result,classname,params ) ;
| parameter | describe |
|---|---|
| result | Required. Specifies the result set identifier returned by mysqli_query(), mysqli_store_result(), or mysqli_use_result(). |
| classname | Optional. Specifies the name of the class to be instantiated, sets properties and returns. |
| params | Optional. Specifies an array of parameters to be passed to the constructor of the classname object. |
| Return value: | Returns an object with the string properties of the retrieved row. Returns NULL if there are no more rows in the result set. |
|---|---|
| PHP version: | 5+ |
| Update log: | New in PHP 5.0.0 is the ability to return as distinct objects. |