예제 #1
0
파일: select.php 프로젝트: pnixx/boot
 /**
  * Добавление join к запросу
  * @param string $table
  * @param string|array|null $on
  * @throws DB_Exception
  */
 public function joins($table, $on = null)
 {
     //Если указано кол-во таблиц больше 1, то хз че делать
     if (count($this->_table) > 1) {
         throw new DB_Exception("Must be table count 1");
     }
     //Добавочное условие
     if ($on === null) {
         $where = null;
     } else {
         $where = " AND " . $this->make_where($table, $on);
     }
     //Добавляем
     $this->_joins .= " INNER JOIN " . $this->driver->escape_identifier($table) . " ON " . $this->driver->escape_identifier($table) . "." . $this->driver->escape_identifier($this->_table[0] . "_id") . " = " . $this->driver->escape_identifier($this->_table[0]) . "." . $this->driver->escape_identifier("id") . $where;
 }