PHP DB Query::group_by Examples

Example #1

File: MysqlTest.php Project: atayahmet/database-active-record-class

 /**
  *
  * @or_having
  *
  * */
 public function testOrHaving()
 {
     $result1 = DB::group_by('age')->having("age > 18")->or_having("age > 21")->get($this->table);
     $total1 = $result1->num_rows();
     $assert1 = $result1->row()->age;
     $result2 = DB::group_by('age')->having("age < 18")->or_having("age > 25")->get($this->table);
     $total2 = $result2->num_rows();
     $assert2 = $result2->row()->age;
     $this->assertGreaterThan(0, $total1);
     $this->assertGreaterThan(0, $total2);
     $this->assertFalse($assert1 == $assert2);
 }