CodeIgniter problem retrieving and displaying data from DB

Question

Here is my function. It is very simple.

function load_data() {

        $query = $this->db->query('SELECT * FROM configurations WHERE username="' . $this->session->userdata('username') . '"');
        return $query;
   }

My controller has this line of code:

$data['query'] = $this->configurations->load_data();

In my view, I tried:

foreach($query->result_array() as $row) {

echo $row->first;

}

But I get an error that I am trying to get a property of a non-object. Isn't the query being returned from the model as an object?

This is a re-post of this question: stackoverflow.com/questions/4708994/codeigniter-syntax — kevtrout
– kevtrout, Commented Jan 18, 2011 at 0:17
Please don't ask the same question over again. You can edit your question, leave comments on answers, etc. I've merged your previous question into this one. — user1228
– user1228, Commented Jan 18, 2011 at 14:38

Sein Oxygen · Accepted Answer · 2011-01-17 01:41:54Z

5

You should use $query->result_array, row_array, result, or row otherwise your returning the object intead get the results. Check the CI manual.

answered Jan 17, 2011 at 1:41

Sein Oxygen

3173 silver badges15 bronze badges

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

Comments

ifaour · Accepted Answer · 2011-01-17 15:43:04Z

2

You are returning the results as array and using $row as object!
Try:

foreach($query->result() as $row) {

Refer.

answered Jan 17, 2011 at 15:43

ifaour

38.1k12 gold badges74 silver badges79 bronze badges

Comments

Lance · Accepted Answer · 2011-01-17 00:37:12Z

1

Try changing $this->load->model('login/configurations', '', TRUE); to $this->load->model('login/configurations', 'configurations', TRUE); and see if it works. If it does, it is related to how you're extending your model class. That is, it would be related to what name you give inside configurations.php.

Hope this helps.

answered Jan 17, 2011 at 0:37

Lance

1,89714 silver badges13 bronze badges

1 Comment

Lance Over a year ago

Try returning $query->result_array() as Sein Oxygen suggested. I think he's on to something. :-)

kevtrout · Accepted Answer · 2011-01-17 20:35:53Z

Your undefined variable error tells me that your query might not be running correctly. To diagnose...enable the profiler to check your query.

From the documentation:

$this->output->enable_profiler();

Permits you to enable/disable the Profiler, which will display benchmark and other data at the bottom of your pages for debugging and optimization purposes.

To enable the profiler place the following function anywhere within your Controller functions: $this->output->enable_profiler(TRUE);

When enabled a report will be generated and inserted at the bottom of your pages.

Your query will be shown at the end of the page

Double check your query syntax to make sure it is running properly, and

Ross · Accepted Answer · 2011-01-17 10:02:11Z

0

your code in it's current state is returning an object of objects and arrays:

print_r($query)

CI_DB_mysql_result Object
(
    [conn_id] => Resource id #29
    [result_id] => Resource id #39
    [result_array] => Array
        (
        )

    [result_object] => Array
        (
        )

    [current_row] => 0
    [num_rows] => 3
    [row_data] => 
)

you need to access the individual properties to get to the actual data.

$result=$query->result();
print_r($result);

should do it

answered Jan 17, 2011 at 10:02

Ross

18k7 gold badges46 silver badges65 bronze badges

Comments

Elemental · Accepted Answer · 2011-01-17 15:29:18Z

0

Had this issue before - basic problem is that if the Query returns no result set then $query->result_array() == NULL

NULL is not a list and can't be processed in a foreach. I have found that checking for this condition solves this issue.

answered Jan 17, 2011 at 15:29

Elemental

7,5522 gold badges31 silver badges37 bronze badges

2 Comments

sehummel Over a year ago

That didn't work. I tried: if ($query->result_array() != NULL) { foreach($query->result_array() as $row) { echo $row->first; } } Other thoughts?

Elemental Over a year ago

I checked my code (as @Sein above suggests) I return the array and not the object from LoadData(). I voted for his answer.

Paulraj · Accepted Answer · 2011-01-19 22:25:12Z

0

From your question, you are getting the result as a pure array (result_array) but printing the data as object ($row->first).

result() or row() is returning in object but result_array is returning in array.

change your view part like,

  foreach($query->result_array() as $row) {

     echo $row['first'];

   }

or if you want to use an object then,

foreach($query->result() as $row) {

     echo $row->first;

   }

Generating Query Results in Codeigniter

answered Jan 19, 2011 at 22:25

Paulraj

3,4173 gold badges38 silver badges43 bronze badges

Collectives™ on Stack Overflow

CodeIgniter problem retrieving and displaying data from DB

7 Answers 7

Comments

Comments

1 Comment

Comments

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

Comments

Comments

1 Comment

Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related