| title | PDOStatement::setFetchMode | Microsoft Docs |
|---|---|
| ms.custom | |
| ms.date | 01/19/2017 |
| ms.prod | sql |
| ms.prod_service | connectivity |
| ms.reviewer | |
| ms.technology | connectivity |
| ms.topic | conceptual |
| ms.assetid | f132b2af-0433-4fbe-b03f-69a7d631093a |
| author | David-Engel |
| ms.author | v-daenge |
[!INCLUDEDriver_PHP_Download]
Specifies the fetch mode for the PDOStatement handle.
bool PDOStatement::setFetchMode( $mode );
$mode: Any parameter(s) that are valid to pass to PDOStatement::fetch.
true on success, false otherwise.
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", "", "");
$stmt1 = $conn->query( "select * from Person.ContactType where ContactTypeID < 5 " );
while ( $row = $stmt1->fetch()) {
print($row['Name'] . "\n");
}
print( "\n---------- PDO::FETCH_ASSOC -------------\n" );
$stmt = $conn->query( "select * from Person.ContactType where ContactTypeID < 5 " );
$stmt->setFetchMode(PDO::FETCH_ASSOC);
$result = $stmt->fetch();
print_r( $result );
print( "\n---------- PDO::FETCH_NUM -------------\n" );
$stmt = $conn->query( "select * from Person.ContactType where ContactTypeID < 5 " );
$stmt->setFetchMode(PDO::FETCH_NUM);
$result = $stmt->fetch();
print_r ($result );
print( "\n---------- PDO::FETCH_BOTH -------------\n" );
$stmt = $conn->query( "select * from Person.ContactType where ContactTypeID < 5 " );
$stmt->setFetchMode(PDO::FETCH_BOTH);
$result = $stmt->fetch();
print_r( $result );
print( "\n---------- PDO::FETCH_LAZY -------------\n" );
$stmt = $conn->query( "select * from Person.ContactType where ContactTypeID < 5 " );
$stmt->setFetchMode(PDO::FETCH_LAZY);
$result = $stmt->fetch();
print_r( $result );
print( "\n---------- PDO::FETCH_OBJ -------------\n" );
$stmt = $conn->query( "select * from Person.ContactType where ContactTypeID < 5 " );
$stmt->setFetchMode(PDO::FETCH_OBJ);
$result = $stmt->fetch();
print $result->Name;
print( "\n \n" );
?>