SELECT with LIMIT in Codeigniter

    |
  • Added:
  • |
  • In: Basic PHP

I have a site develop in Codeigniter, and in my model I have a function like this:

function nationList($limit=null, $start=null) { if ($this->session->userdata('language')=="it") $this->db->select('nation.id, nation.name_it as name'); if ($this->session->userdata('language')=="en") $this->db->select('nation.id, nation.name_en as name'); $this->db->from('nation'); $this->db->order_by("name", "asc"); $this->db->limit($limit, $start); $query = $this->db->get(); $nation = array(); foreach ($query->result() as $row) array_push($nation, $row); return $nation; } 

And if into my controller I call the function without limit and start doesn't return result like this:

$data["nationlist"] = $this->Nation_model->nationList(); 

Instead if I set limit and start works! If limit and start are null, Why doesn't return result? I don't want to make a second function or a control if limit and start are null. How can I solve this when limit and start are null without a control or a second function to make useful the code and more efficient?

This Question Has 1 Answeres | Orginal Question | Alessandro Minoccheri

Try this...

function nationList($limit=null, $start=null) { if ($this->session->userdata('language')=="it") $this->db->select('nation.id, nation.name_it as name'); if ($this->session->userdata('language')=="en") $this->db->select('nation.id, nation.name_en as name'); $this->db->from('nation'); $this->db->order_by("name", "asc"); if($limit!='' && $start!=''){ $this->db->limit($limit, $start); } $query = $this->db->get(); $nation = array(); foreach ($query->result() as $row) array_push($nation, $row); return $nation; } 

Search
I am...

Sajjad Hossain

I have five years of experience in web development sector. I love to do amazing projects and share my knowledge with all.

Connect Social With PHPAns
Top