space_balls
space_balls

Reputation: 1423

Doctrine 2 - Get all Records

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

Answers (1)

J0HN
J0HN

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

Related Questions