Reputation: 1423
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?
Upvotes: 25
Views: 49456
Reputation: 26921
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();
Upvotes: 55