Breaking News: Grepper is joining You.com. Read the official announcement!

PDO::FETCH_OBJ

Terrible Turtle answered on July 7, 2020 Popularity 9/10 Helpfulness 2/10

answer PDO::FETCH_OBJ

related pdo fetch

PDO::FETCH_OBJ

Comment

It should be mentioned that this method can set even non-public properties. It may sound strange but it can actually be very useful when creating an object based on mysql result.
Consider a User class:

<?php
class User {
   // Private properties
   private $id, $name;

   private function __construct () {}

   public static function load_by_id ($id) {
      $stmt = $pdo->prepare('SELECT id, name FROM users WHERE id=?');
      $stmt->execute([$id]);
      return $stmt->fetchObject(__CLASS__);
   }
   /* same method can be written with the "name" column/property */
}

$user = User::load_by_id(1);
var_dump($user);
?>

fetchObject() doesn't care about properties being public or not. It just passes the result to the object. Output is like:

object(User)#3 (2) {
  ["id":"User":private]=>
  string(1) "1"
  ["name":"User":private]=>
  string(10) "John Smith"
}

Popularity 9/10 Helpfulness 2/10 Language php

Source: www.php.net

Tags: php

Link to this answer
Share Copy Link

Contributed on Mar 05 2021

Terrible Turtle

0 Answers Avg Quality 2/10

Closely Related Answers

pdo fetch

Comment

<?php
$sth = $dbh->prepare("SELECT name, colour FROM fruit");
$sth->execute();

/* Exercise PDOStatement::fetch styles */
print("PDO::FETCH_ASSOC: ");
print("Return next row as an array indexed by column name\n");
$result = $sth->fetch(PDO::FETCH_ASSOC);
print_r($result);
print("\n");

print("PDO::FETCH_BOTH: ");
print("Return next row as an array indexed by both column name and number\n");
$result = $sth->fetch(PDO::FETCH_BOTH);
print_r($result);
print("\n");

print("PDO::FETCH_LAZY: ");
print("Return next row as an anonymous object with column names as properties\n");
$result = $sth->fetch(PDO::FETCH_LAZY);
print_r($result);
print("\n");

print("PDO::FETCH_OBJ: ");
print("Return next row as an anonymous object with column names as properties\n");
$result = $sth->fetch(PDO::FETCH_OBJ);
print $result->name;
print("\n");
?>

Popularity 10/10 Helpfulness 9/10 Language php

Source: www.php.net

Tags: fetch fetc

Link to this answer
Share Copy Link

Contributed on Jul 07 2020

Inexpensive Ibis

0 Answers Avg Quality 2/10

PDO::FETCH_OBJ

Contents

More Related Answers

PDO::FETCH_OBJ

Closely Related Answers

pdo fetch

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.