PHP CI_DB_query_builder::get_where Exemples

get_where() public méthode

Allows the where clause, limit and offset to be added directly

public get_where ( string $table = '', string $where = NULL, integer $limit = NULL, integer $offset = NULL ) : CI_DB_result
$table	string
$where	string
$limit	integer
$offset	integer
Résultat	CI_DB_result

Exemple #1

Fichier : MY_base_model.php Projet : Speennaker/cometogether

 protected function is_unique($field, $value, $id)
 {
     $where = [$field => $value];
     if ($id) {
         $where[] = "id != {$id}";
     }
     return !$this->db->get_where($this->table, $where)->row_array();
 }

Exemple #2

Fichier : MY_base_model.php Projet : Speennaker/tanyaprykhodko

 public function get_by_id($id)
 {
     return $this->db->get_where($this->table, ['id' => $id])->row_array();
 }