| title | PDOStatement::fetchObject |
|---|---|
| description | API reference for the PDOStatement::fetchObject function in the Microsoft PDO_SQLSRV Driver for PHP for SQL Server. |
| author | dlevy-msft-sql |
| ms.author | dlevy |
| ms.reviewer | davidengel, sumitsar, jathakkar |
| ms.date | 08/10/2020 |
| ms.service | sql |
| ms.subservice | connectivity |
| ms.topic | reference |
[!INCLUDEDriver_PHP_Download]
Retrieves the next row as an object.
mixed PDOStatement::fetchObject([ $class_name[,$ctor_args ]] )
$class_name: An optional string specifying the name of the class to create. The default is stdClass.
$ctor_args: An optional array with arguments to a custom class constructor.
On success, returns an object with an instance of the class. Properties map to columns. Returns false on failure.
Support for PDO was added in version 2.0 of the [!INCLUDEssDriverPHP].
<?php
$server = "(local)";
$database = "AdventureWorks";
$conn = new PDO( "sqlsrv:server=$server ; Database = $database", "", "");
$stmt = $conn->query( "select * from Person.ContactType where ContactTypeID < 5 " );
$result = $stmt->fetchObject();
print $result->Name;
?>