Basic Components - Query - Method overloading.php 493 Bytes
Newer Older
doctrine's avatar
doctrine committed
1
<?php
2
$conn = Doctrine_Manager::getInstance()->openConnection(new PDO("dsn","username","password"));
doctrine's avatar
doctrine committed
3

4
$query = new Doctrine_Query($conn);
doctrine's avatar
doctrine committed
5 6 7

$query->from("User-b")
      ->where("User.name LIKE 'Jack%'")
8
      ->orderby("User.created")
doctrine's avatar
doctrine committed
9 10
      ->limit(5);

11 12 13 14 15 16 17 18
$users = $query->execute();

$query->from("User.Group.Phonenumber")
      ->where("User.Group.name LIKE 'Actors%'")
      ->orderby("User.name")
      ->limit(10)
      ->offset(5);
      
doctrine's avatar
doctrine committed
19 20
$users = $query->execute();
?>