PHP mysql_fetch_object() Function
 Complete PHP MySQL Reference
Definition and Usage
The mysql_fetch_object() function returns a row from a recordset as an
object.
This function gets a row from the mysql_query() function and returns an
object on success, or FALSE on failure or
when there are no more
rows.
Syntax
| Parameter |
Description |
| data |
Required. Specifies which data pointer to use. The data
pointer is the result from the mysql_query() function |
Tips and Notes
Note: Each subsequent call to mysql_fetch_object() returns the next
row in the recordset.
Example
<?php
$con = mysql_connect("localhost", "peter", "abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$db_selected = mysql_select_db("test_db",$con);
$sql = "SELECT * from Person";
$result = mysql_query($sql,$con);
while ($row = mysql_fetch_object($result))
{
echo $row->FirstName . "<br />";
}
mysql_close($con);
?>
|
The output of the code above could be:
Complete PHP MySQL Reference
 |
|
Get Your Diploma!
W3Schools' Online Certification Program is the perfect solution for busy
professionals who need to balance work, family, and career building.
The HTML Certificate is for developers who want to document their knowledge of HTML, XHTML, and CSS.
The JavaScript Certificate is for developers who want to document their knowledge of JavaScript and the HTML DOM.
The XML Certificate is for developers who want to document their knowledge of XML, XML DOM and XSLT.
The ASP Certificate is for developers who want to document their knowledge of ASP, SQL, and ADO.
The PHP Certificate is for developers who want to document their knowledge of PHP and SQL (MySQL).
|
|
