CODEWITHSUNDEEP
phpcodeignitercodeigniter-3
Firdaus
Firdaus

Reputation: 143

How get the id from codeigniter controller

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

Upvotes: 0

Views: 1555

Answers (3)

Pradeep
Pradeep

Reputation: 9717

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

Upvotes: 2

NavilPolyakov
NavilPolyakov

Reputation: 11

In example: // controller-part:

 $query = $this->partner_vs_skill_model->get_partner_skill();
 echo $query;

// model"

<?php
      class partner_vs_sill_model extends CI_Model{
       public function get_partner_skill(){
        $result = $this->db->get('tb_name')->row_array();
        return $result
         }
      }

Upvotes: 1

Roledenez
Roledenez

Reputation: 761

you are getting an array of results to $query variable. what I am suggesting is to use below kind of code snippet to loop through the result and get the skill_tag variable

    foreach ($query->result() as $row) {
    echo $row->skill_tag
}

Upvotes: 0

Related Questions