PHP PDO: Do the fetch styles FETCH_CLASS and FETCH_INTO fetch into private object properties?

Question

Pretty short question, here is an example:

$prepared = $this->pdo->prepare("SELECT * FROM Users WHERE ID = :ID");
$statement = $prepared->execute(array(":ID" => $User_ID))
$result = $statement->fetchAll(PDO::FETCH_CLASS, "User");
//OR
$User = new User();
$result = $statement->fetch(PDO::FETCH_INTO, $User);

(written from top of the head, could contain syntax errors)

Do those two directly fetch into the private properties of said objects? I read it also circumvents the __construct function, so will it circumvent private status too?

cwallenpoole · Accepted Answer · 2011-09-02 11:50:07Z

7

Very short answer: Yes it will.

class Foo
{
    private $id;
    public function echoID()
    {
        echo $this->id;
    }
}
$result = $statement->fetchAll(PDO::FETCH_CLASS, "Foo");
$result[0]->echoID(); // your ID

Aside:

This will cause syntax errors $statement->fetchAll(PDO::FETCH_INTO, $User);. You can't use FETCH_INTO with the fetchAll method.

answered Sep 2, 2011 at 11:50

cwallenpoole

82.4k26 gold badges132 silver badges174 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

sinni800 Over a year ago

Ah, okay... Since fetchAll wants to create more than one object this will never work. I get it!

Wesley van Opdorp Over a year ago

It will have no problem creating the classes, it is FETCH_INTO that won't work since you can only send a single object as a parameter.

sinni800 Over a year ago

@Wesleay that's what I was refering to. I only give it a single instance so it doesn't work.

Tek Over a year ago

PDO::FETCH_INTO will give you exception cannot access protected property. However, PDO::FETCH_CLASS works fine.

Madara's Ghost Over a year ago

-1 That is incorrect. FETCH_INTO cannot fetch into private properties. Please test your answers.

|

Олег Всильдеревьев · Accepted Answer · 2014-07-29 18:34:51Z

2

But event with PDO::FETCH_CLASS there is a problem for private properties for subclasses. E.g.

class Animal
{
    private $color;
    public function getColor()
    {
        return $this->color;
    }
}
class Cat extends Animal
{
}

$statement->setFetchMode(PDO::FETCH_CLASS, "Cat" );
$someCat = $statement->fetch();

echo $someCat->getColor();  //empty
print_r( $someCat );
/*
now have strange output like:
[color:Animal:private] => 
[color] => grey
*/

But if you set the property to protected - it works fine

answered Jul 29, 2014 at 18:34

Олег Всильдеревьев

94310 silver badges11 bronze badges

1 Comment

crodas Over a year ago

Private properties belong to the class only and cannot be inherited by subclasses.

cardonator · Accepted Answer · 2015-12-11 00:00:37Z

0

The reason you can't access private properties on a super class is because those properties are out of scope. Subclasses don't take on the private attributes of their parent classes, including variables and functions.

edit: Thanks for clarifying your question but it does make my answer look a bit ridiculous here. :p

edited Dec 11, 2015 at 0:00

answered Aug 1, 2014 at 17:27

cardonator

4063 silver badges9 bronze badges

Comments

Israel Hernández · Accepted Answer · 2016-02-22 21:36:38Z

0

You could try:

class Foo {
    private $id;
    public function __set($prop, $val) {
        $this->$prop = $val;
    }
    public function __get($prop) {
        return $this->$prop;
    }
}

$result = $statement->fetchAll(PDO::FETCH_CLASS, "Foo");
$result[0]->id();

answered Feb 22, 2016 at 21:36

Israel Hernández

466 bronze badges

Collectives™ on Stack Overflow

PHP PDO: Do the fetch styles FETCH_CLASS and FETCH_INTO fetch into private object properties?

4 Answers 4

6 Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

6 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related