PHP PdoStatement::setFetchMode Examples

Programming Language: PHP

Class/Type: PdoStatement

Method/Function: setFetchMode

Examples at hotexamples.com: 1

The PDOStatement setFetchMode() method sets the fetch mode for a database query. The method takes two parameters - the fetch mode and an optional argument that provides additional details depending on the fetch mode selected.

Example 1: Setting the fetch mode to FETCH_ASSOC

$stmt = $dbh->prepare("SELECT name, age FROM user");
$stmt->setFetchMode(PDO::FETCH_ASSOC);
$results = $stmt->fetchAll();

This code sets the fetch mode to FETCH_ASSOC, which means that each row retrieved will be returned as an associative array, where the column names are the keys.

Example 2: Setting the fetch mode to FETCH_CLASS

class User {
  public $name;
  public $age;
}

$stmt = $dbh->prepare("SELECT name, age FROM user");
$stmt->setFetchMode(PDO::FETCH_CLASS, 'User');
$results = $stmt->fetchAll();

This code sets the fetch mode to FETCH_CLASS, which means that each row retrieved will be returned as an instance of the specified class (in this case, the User class). This method is part of the PDO package library in PHP.

PHP PdoStatement::setFetchMode - 1 examples found. These are the top rated real world PHP examples of PdoStatement::setFetchMode extracted from open source projects. You can rate examples to help us improve the quality of examples.

Frequently Used Methods

Show Hide

execute(1)

fetch(1)

fetchAll(1)

setCountStatement(1)

setFetchMode(1)

setPagination(1)

setPrimaryStatement(1)

setResult(1)

Example #1

Show file

File: PDOClient.php Project: hgraca/vacancy-repository

 /**
  * @param PDOStatement $stmt
  *
  * @return array
  */
 private function fetchData(PdoStatement $stmt)
 {
     $stmt->setFetchMode(PDO::FETCH_ASSOC);
     $resultAsArray = $stmt->fetchAll();
     return $resultAsArray;
 }