CODEWITHSUNDEEP
phparrayscodeigniterstdclass
Roxana Slj
Roxana Slj

Reputation: 331

Object of class stdClass could not be converted to string in php codeigniter

I am trying to get data from my database , based on the company_name but getting error:

Error:Object of class stdClass could not be converted to string

staff controller :

function index()
{
  $user_id =  $this->session->userdata('manager');
    // echo "index"; die; 
   $company_name = $this->staff_model->getCompanyName($user_id);

  //  print_r($company_name); 
  //      die;
   $data['staff'] = $this->staff_model->getStaffDetails($company_name);  //Error on this line

// print_r($data); 
// die;
   $this->load->view('manager/staff/index',$data);
}

staff_model

 <?php
class Staff_model extends CI_Model
{
        //table name: user_login
        function getCompanyName($user_id)
        {
          $company_name=$this->db->select('company_name')->from('user_login')->where(array('id' => $user_id,'delete_flag'=>0))->get()->row();
          return $company_name;
        }
        function getStaffDetails($company_name)
        { 
         $delete_flag=0;
         return  $this->db->get_where('user_login',array('delete_flag!='=>$delete_flag , 'company_name'=>$company_name))->result();  //Error on this line 

         // $query = $this->db->select('*')
          //   ->from('user_login')
          //   ->where("(delete_flag = '$delete_flag )")
          //   ->where("(company_name = $company_name)"); //Error on this line
         //   return $query();  }

And running

 print_r($company_name); 
            die;

results:

stdClass Object ( [company_name] => ASGB )

Would appreciate if anyone can help.

Upvotes: 1

Views: 959

Answers (1)

KUMAR
KUMAR

Reputation: 1995

Change in your Model of Codeigniter:-

staff_model:-

<?php
class Staff_model extends CI_Model
{
        //table name: user_login
        function getCompanyName($user_id)
        {
            $company_name = $this->db->select('company_name')
               ->from('user_login')
               ->where(array('id' => $user_id,'delete_flag'=>0))
               ->get()->row();
            return $company_name->company_name;   //change this.
        }
        
}

Note:- This method returns a single result row. If your query has more than one row, it returns only the first row. The result is returned as an object.

$row = $query->row();

echo $row->column_name; // accessing variable of row(); function by ->(Arrow(->) operator:).

Fore more reference regarding this check :-

https://www.codeigniter.com/userguide3/database/results.html#result-rows

Upvotes: 2

Related Questions