如何从codeigniter控制器获取id

Question

I have written a query in Codeigniter controller but i am not sure how to use the variable from the database.

Controller:

 $query = $this->partner_vs_skill_model->where('partner_id',$id )
                                       ->like('skill_id', $value)->get_all();    
 $row = count($query);

What I expect is to use the code like below

 echo $query->id;

Database table (partner_vs_skill_model):

id | partner_id | skill_id 
1  |  2         | 3 
2  |  5         | 4

Answer 1

Hope this will help you :

For One row use row(), like :

$query = $this->partner_vs_skill_model->where('partner_id',$id )
                                      ->like('skill_id', $value)->row();
echo $query->id;
echo $query->skill_id;

For multiple rows use result() instead, like :

$query = $this->partner_vs_skill_model->where('partner_id',$id )
                                      ->like('skill_id', $value)->result();

Access it like this :

foreach($query as $row)
{
  echo $row->id;
  echo $row->skill_id;
}

for more : https://www.codeigniter.com/user_guide/database/query_builder.html#selecting-data