getResult() method Doctrine

Question

What is the format of the array returned using the getResult() method in the following example, using Doctrine and Symfony2:

$query = $this->_em->createQuery('SELECT p.id, p.nameProduct FROM ArkiglassProductBundle:Product p');
        return $query->getResult();

And I would like to know how to access each case and print every row.

Answer 1

<?php
$query = $em->createQuery('SELECT u.username, u.name FROM CmsUser u');
$users = $query->getResults(); // array of CmsUser username and name values
echo $users[0]['username'];

taken from the doctrine documentation