Question 42140 in PHP Question posted in
Official manual can be found here.

How to list only active records with select from? – PHP

I need to make a query to return only active records which in this case are imo_status == 1

What is the best way to make this query? I’m using CI3

Below is the source code.

// LISTA OS AGENCIAMENTOS NO BANCO DE DADOS
public function getProperties()
{   

    $this->db->select('*');
    $this->db->from('ci_properties');
    $this->db->where('imo_status' == 1);
        return $this->db->get("ci_properties")->result_array();

    /*$query = $this->db->get("ci_properties");
    return $query->result_array();*/
}
Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    I solved this

    public function getProperties()
{   

    $this->db->select('*');
    $this->db->from('ci_properties');
    $this->db->where('imo_status', 1);
        $query = $this->db->get();        
        return $query->result_array();
}

  2. 0

    You build the query then don’t use it:

    return $this->db->get("ci_properties")->result_array();

    This wipes out the query builder and basically does a ‘get all’ from ‘ci_properties’. To use you’re query:

    $query = $this->db->get();        
return $query->result();

    This is because you have already specified the table in the ‘from’ part, get(‘table name’), will get all.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search