Advertisement
Guest User

Untitled

a guest
May 27th, 2016
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.55 KB | None | 0 0
  1. public function get_options($query)
  2.     {
  3.         $data = array();
  4.  
  5.         $this->db->select(array('cities.insee_code', 'cities.name', 'cities.department_code'))
  6.             ->from($this->table)
  7.             ->like('cities.name', $query)
  8.             ->order_by('name', 'asc')
  9.             ->limit(100, 0);
  10.  
  11.         foreach ($this->db->get()->result() as $row) {
  12.             $data[] = [
  13.                 'id' => $row->insee_code,
  14.                 'text' => $row->name.' ('.$row->department_code.')'
  15.             ];
  16.         }
  17.  
  18.         return $data;
  19.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement