Export (0) Print
Expand All

PDOStatement::fetchObject

SQL Server 2008 R2

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 Microsoft Drivers for PHP for SQL Server.

<?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;
?>

Reference

Other Resources

PDO

Community Additions

ADD
Show:
© 2014 Microsoft