PDO PHP Fetch Class

by

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 your 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.

More Related Contents:

  1. Insert form in MySQL with PDO [duplicate]
  2. Undefined index $_POST
  3. How to check if a row exists in MySQL? (i.e. check if username or email exists in MySQL)
  4. Are PDO prepared statements sufficient to prevent SQL injection?
  5. Reference — frequently asked questions about PDO
  6. Getting raw SQL query string from PDO prepared statements
  7. How do I set ORDER BY params using prepared PDO statement?
  8. “Invalid parameter number: parameter was not defined” Inserting data
  9. Having issue with matching rows in the database using PDO
  10. How can I properly use a PDO object for a parameterized SELECT query
  11. How do I return integer and numeric columns from MySQL as integers and numerics in PHP?
  12. pdo – Call to a member function prepare() on a non-object [duplicate]
  13. How to replace MySQL functions with PDO?
  14. Connect to SQL Server through PDO using SQL Server Driver
  15. PDO error: ” SQLSTATE[HY000]: General error ” When updating database
  16. Real escape string and PDO [duplicate]
  17. How to check if a row exist in the database using PDO?
  18. PHP PDO vs normal mysql_connect
  19. Can I create a database using PDO in PHP?
  20. PHP PDO::bindParam() data types.. how does it work?
  21. PDO::PARAM for type decimal?
  22. PHP PDO and MySQLi [duplicate]
  23. PDO fetch one column from table into 1-dimensional array
  24. Using value of a column as index in results using PDO
  25. Retrieve (or simulate) full query from PDO prepared statement
  26. Getting a PHP PDO connection from a mysql_connect()?
  27. PDO returning incorrect, but duplicate, data. Key’s not in database.
  28. Having issue with matching rows in the database
  29. PHP: mysql v mysqli v pdo [closed]
  30. PDO and MySQL ‘between’

Leave a Comment