Doctrine 2 - Get all Records

Question

Does anyone know is there is a quick way to get all the records in a table using Doctrine with out using the DQL.

Did I miss something or did you need to just write the public function in the class?

Answer 1

If you have an entity class (Doctrine Repository manual):

$records = $em->getRepository("Entities\YourTargetEntity")->findAll(); 

If you don't have entity class (PDO manual):

$pdo = $em->getCurrentConnection()->getDbh(); $result = $pdo->query("select * from table"); //plain sql query here, it's just PDO $records = $pdo->fetchAll();