PHP DB Query::join Examples

Example #1

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

 /**
  *
  * @join
  *
  * */
 public function testJoin()
 {
     $city_id = 1;
     // Istanbul
     $result = DB::join($this->table_city . ' t2', 't2.id = t1.city_id', 'inner')->from($this->table . ' t1')->where('t1.city_id', $city_id)->get();
     $this->assertEquals($result->row()->city, 'Istanbul');
 }