Menu
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.
253
Fetches a row from a result set associated with a PDOStatement object. The mode parameter determines how PDO returns the row.
What is PDO? PDO - PHP Data Object. A set of PHP extensions that provide a core PDO class and database specific drivers. Provides a vendor-neutral lightweight data-access abstraction layer. Focus on data access abstraction rather than database abstraction.
Introduction to the PHP fetch() method The fetch() method allows you to fetch a row from a result set associated with a PDOStatement object. Internally, the fetch() method fetches a single row from a result set and moves the internal pointer to the next row in the result set.
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.
186
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
