Convert the result Set into Database Object in codeigniter

Question

I am trying to write a CSV in Codeignter for a result set fetched from db.

I am already using the solution mentioned here. Reports in Codeigniter

But the issue is that it writes the whole table. Now I want to fetch and write specific records. So here is my model code.

    $where = "hangtag_spoc_number = 2202";
    $result = $this->db->select('*')
            ->from('hangtag_request')
            ->where($where)
            ->get()
            ->result_array();
    return $result;

It gives me this error.

You must submit a valid result object

If I change the model code to this

    return $query = $this->db->get('hangtag_request');

It works perfectly. Is there any way I can make my model code to return the results in the form of DB object? Coz it seems thats the form we need.

Thanks.

Rajeev Ranjan · Accepted Answer · 2014-07-09 11:37:34Z

1

If you need result object then you shouldn't use the result_array()

$this->db->get();

The above statement runs the selection query and returns the result.It does return in form that can be used for presentation.

result_array()

This function returns the query result as an array, or an empty array when no result is produced.

Its good to use return $query = $this->db->get('hangtag_request'); for obtaining result object.

answered Jul 9, 2014 at 11:37

Rajeev Ranjan

4,1523 gold badges30 silver badges42 bronze badges

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

Comments

Omicans · Accepted Answer · 2014-07-09 11:36:31Z

1

I got it solved.

Just had to remove result_array() so the correct code becomes

$where = "hangtag_spoc_number = 2202";
$result = $this->db->select('*')
        ->from('hangtag_request')
        ->where($where)
        ->get();
return $result;

answered Jul 9, 2014 at 11:36

Omicans

5611 gold badge10 silver badges28 bronze badges

Collectives™ on Stack Overflow

Convert the result Set into Database Object in codeigniter

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related