Codeigniter: Extract certain value from an array under controller

Question

Good day!

This is pretty basic to some.

I have this code on my controller:

$data["sales_info"] = $this->The_model->get_sales_info(SELECT * FROM sales WHERE sales_id = 123);

Then get_sales_info() method under The_model stores the specific sales information into an array.

Now, I'm doing some debugging, so from the controller, I want to extract from the $data["sales_info"] and echo only the value of 'sales_date'.

How am I going to do this?

Thank you!

NikuNj Rathod · Accepted Answer · 2017-09-28 06:53:10Z

2

You can try this solution for your problem:

Change the model file to :

The_model.php

class The_model extends MY_Model {
    function get_sales_info($sales_id){
        $this->db->select("*.*");
        if(!empty($sales_id)){
            $this->db->where('sales_id', $sales_id);
            $query = $this->db->get('sales');
            return $query->row();
        } else {
            $query = $this->db->get('sales');
            return $query->result();
        }
    }
}

and change the controller file to:

My_controller.php

$sales_id = 123;
$sales_info = $this->The_model->get_sales_info($sales_id);
echo $sales_info['sales_date'];exit; //how to get value from object

Thanks

edited Sep 28, 2017 at 6:53

answered Sep 28, 2017 at 6:22

NikuNj Rathod

1,6381 gold badge19 silver badges29 bronze badges

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

3 Comments

Jorz Over a year ago

Thanks! It worked! Aaand, question.. can I also echo other data using $sales_info['any_column']? =)

NikuNj Rathod Over a year ago

Yes you can get any column from return get_sales_info function.

user4419336 Over a year ago

I not sure why have exit

Bilal Ahmed · Accepted Answer · 2017-09-28 06:56:23Z

2

This code may help you

$sales_info = $this->The_model->get_sales_info(SELECT * FROM sales WHERE sales_id = 123);
$data['sales_data'] = $sales_info['sales_date'];

edited Sep 28, 2017 at 6:56

Bilal Ahmed

4,0663 gold badges25 silver badges42 bronze badges

answered Sep 28, 2017 at 6:12

Neophyte

1531 silver badge8 bronze badges

Comments

Bira · Accepted Answer · 2017-09-28 06:19:45Z

1

$query = $this->db->get_where('sales', array('sales_id' => 123));

It should be like this, you cannot write the sql in to a method as best practice.

answered Sep 28, 2017 at 6:19

Bira

5,6263 gold badges31 silver badges43 bronze badges

Collectives™ on Stack Overflow

Codeigniter: Extract certain value from an array under controller

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related