converting array to stdClass in CodeIgniter

Question

I am returning data from two tables in CodeIgniter with the function below

public function test()
{
    $this->db->select('*');
    $this->db->from('WHOUSE1.DLY_BWR_DLY_PERFORMANCE');
    $this->db->join('WHOUSE1.DATE_DIM', 'WHOUSE1.DATE_DIM.DATE_KEY = WHOUSE1.DLY_BWR_DLY_PERFORMANCE.BDP_DATE');
    $query = $this->db->get();
    return $query->result_array();
}

Using var_dump I am getting the result below

array (size=3226)
0 => 
array (size=121)
  'BDP_ID' => string '945149' (length=6)
  'BDP_COST_CENTRE_NUMBER' => string '1376' (length=4)
  'BDP_DATE' => string '20040807' (length=8)
  'BDP_DAY_CODE' => string '6' (length=1)
  'BDP_TAKE' => string '4923.78' (length=7)
  'BDP_PAYOUT' => string '3779.22' (length=7)
  'BDP_ACTUAL_SLIPPAGE' => string '636' (length=3)

1 => 
array (size=121)
  'BDP_ID' => string '945150' (length=6)
  'BDP_COST_CENTRE_NUMBER' => string '1376' (length=4)
  'BDP_DATE' => string '20040809' (length=8)
  'BDP_DAY_CODE' => string '1' (length=1)
  'BDP_TAKE' => string '2848.3' (length=6)
  'BDP_PAYOUT' => string '4190.34' (length=7)
  'BDP_ACTUAL_SLIPPAGE' => string '280' (length=3)

But what I will like to get is this

  array (size=3226)
  0 => 
  object(stdClass)[27]
  'BDP_ID' => string '945149' (length=6)
  'BDP_COST_CENTRE_NUMBER' => string '1376' (length=4)
  'BDP_DATE' => string '20040807' (length=8)
  'BDP_DAY_CODE' => string '6' (length=1)
  'BDP_TAKE' => string '4923.78' (length=7)
  'BDP_PAYOUT' => string '3779.22' (length=7)
  'BDP_ACTUAL_SLIPPAGE' => string '636' (length=3)

  1 => 
  object(stdClass)[29]
  'BDP_ID' => string '945150' (length=6)
  'BDP_COST_CENTRE_NUMBER' => string '1376' (length=4)
  'BDP_DATE' => string '20040809' (length=8)
  'BDP_DAY_CODE' => string '1' (length=1)
  'BDP_TAKE' => string '2848.3' (length=6)
  'BDP_PAYOUT' => string '4190.34' (length=7)
  'BDP_ACTUAL_SLIPPAGE' => string '280' (length=3)

I can't seem to get a way of converting the array into object(stdClass) Any help will be appreciated as am new to CodeIgniter.

Does this answer your question? How to convert an array to object in PHP? — steven7mwesigwa
– steven7mwesigwa, Commented Sep 28, 2020 at 18:51

Beaudinn Greve · Accepted Answer · 2014-12-12 14:21:43Z

1

Array to stdClass can be done in php this way.

stdClass:: __set_state(array());

Or a nicer way.

$a = (object) array();

answered Dec 12, 2014 at 14:21

Beaudinn Greve

82012 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Suresh Kumar Kumawat · Accepted Answer · 2018-07-27 07:31:43Z

1

Use this code in Your Model ( change your table name and select, distinct fileds )

        $this->db->select('DISTINCT(subcategory)');
        $this->db->from('tbl_property');  
        $this->db->where('status','1');                          
        $data           = $this->db->get()->result(); 
        $sub_id         = array();
        foreach ($data as $row)
        {
            array_push($sub_id,$row->subcategory);
        }
        $this->db->from('tbl_subcategory');  
        $this->db->where_in('id',$sub_id);                          
        $data1          = $this->db->get()->result();
        return $data1;

answered Jul 27, 2018 at 7:31

Suresh Kumar Kumawat

1328 bronze badges

Comments

Ing. Michal Hudak · Accepted Answer · 2013-11-10 00:16:26Z

0

use

return $query->result();

This function returns the query result as an array of objects, or an empty array on failure. Typically you'll use this in a foreach loop, like this:

$query = $this->db->query("YOUR QUERY");

foreach ($query->result() as $row)
{
   echo $row->title;
   echo $row->name;
   echo $row->body;
}

Edit:

If you just want to print you can use var_dump() or print_r().

var_dump($obj);
print_r($obj);

If you want an array of all properties and their values use get_object_vars().

$properties = get_object_vars($obj);
print_r($properties);

edited Nov 10, 2013 at 0:16

answered Nov 9, 2013 at 23:49

Ing. Michal Hudak

5,65212 gold badges63 silver badges95 bronze badges

2 Comments

Rebe24 Over a year ago

The function is fails when I use $query->result(); Is there anything else I can do? Thank you.

Rebe24 Over a year ago

I am getting a blank screen, no error is display even though my Apache environment is set to display all error.

John · Accepted Answer · 2013-11-10 00:23:58Z

0

According to the same documentation for Codeigniter I detail:

result_array()

This function returns the query result as a pure array, or an empty array when no 
result `is produced. Typically you'll use this in a foreach loop, like this:`

and ..

result()

This function returns the query result as an array of objects, or an empty array 
on failure.

You should return your data in this way

return $query->result();

answered Nov 10, 2013 at 0:23

John

5844 silver badges19 bronze badges

4 Comments

Rebe24 Over a year ago

Hi John, my function fails using $query->result(); Is there a way to re-write function test() so as not to fail. I only use result_array(); to pull out data so I can explain what I wanted to do

John Over a year ago

Look, public function test() { $this->db->join('WHOUSE1.DATE_DIM', 'WHOUSE1.DATE_DIM.DATE_KEY = WHOUSE1.DLY_BWR_DLY_PERFORMANCE.BDP_DATE'); return $this->db->get('WHOUSE1.DLY_BWR_DLY_PERFORMANCE')->result(); }

Rebe24 Over a year ago

Well, still the same. But can't understand why you voted me down when you couldn't even help. No offense meant.

John Over a year ago

because, the answer comes in codeigniter manual, although I did not vote negative to your question :(

Collectives™ on Stack Overflow

converting array to stdClass in CodeIgniter

4 Answers 4

Comments

Comments

2 Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

2 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related