PDO PHP Fetch Class

Question

I am learning pdo in php , so as to make database access easier and more efficient .One explanation i have read for fetch _class is that The properties of your object are set BEFORE the constructor is called.What does this mean? Any direction is greatly appreciated.

Answer 1

This means that when using PDO to return a result into a custom object, you are required to set out the member variables which correspond to the query result keys.

such as:

class User {     //Predefine Here     public $id;     public $username;     public $password;     public $email;     public $hash;      public function profileLink()     {          return sprintf('<a href="/profile/%s">%s</a>',$this->id,$this->username);     } }  $result = $sth->fetchAll(PDO::FETCH_CLASS, "User"); foreach($result as $user) {     echo $user->profileLink(); } 

This way PDO can set the variables to the object outside of its internal scope.

if you user class was like so:

class User { } 

then PDO Would not be able to set the values from outside the scope, as there are no properties defined.