PHP DB Query::get_where Examples

Example #1

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

 /**
  * 
  * @get_where
  *
  * */
 public function testGetWhere()
 {
     $result = DB::get_where($this->table, array('age >' => 21));
     $this->assertGreaterThan(0, $result->num_rows());
     $limit = 2;
     $result = DB::get_where($this->table, array('age >' => 21), $limit);
     $name = $result->row()->name;
     $this->assertEquals($result->num_rows(), $limit);
     $offset = 1;
     $result = DB::get_where($this->table, array('age >' => 21), $limit, $offset)->row();
     $this->assertFalse($result->name == $name);
 }