What is Doctrine hydration?

I’ve read about hydration in doctrine’s documentation but I still can’t understand what it is.

Could someone please explain?

Here is Solutions:

We have many solutions to this problem, But we recommend you to use the first solution because it is tested & true solution that will 100% work for you.

Solution 1

Hydration is a method used to return query results. For example:

  1. HYDRATE_ARRAY – This will return you an array of records that are represented by another array:

    $q = Doctrine_Query::create()
       ->from('Post p')
    $resultSet = $q->execute(); // $resultSet is an array
    foreach ($resultSet as $post) {
        // $post is an array
        echo $post['title'];
  2. HYDRATE_RECORD – This will return you an collection (Doctrine_Collection) of objects:

    $q = Doctrine_Query::create()
       ->from('Post p')
       ->setHydrationMode(Doctrine::HYDRATE_RECORD); // Unnecessary, HYDATE_RECORD is default method
    $resultSet = $q->execute(); // $resultSet is an Doctrine_Collection object
    foreach ($resultSet as $post) {
        // $post is an Post object
        echo $post->getTitle();
        echo $post['title']; // Each Doctrine's Model object implements ArrayAccess interface so this is possible
        echo $post->myCustomMethod();
  3. HYDRATE_SINGULAR_SCALAR – Will return the value of first column of query’s result:

     $q = Doctrine_Query::create()
       ->from('Post p')
       ->where('p.id = ?', 321)
    $createdAt = $q->execute(); // $createdAt has value of first column from first record from result set (eg.: 2008-04-06 21:22:35)

There is a few more methods , you can read about each in documentation.

Solution 2

$q->fetchOne(array(), Doctrine_Core::HYDRATE_ARRAY);

It will return just a simple array instead of a doctrine collection object.

Note: Use and implement solution 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply