Empty database output in CI

Question

I'm building a simple app and trying to test DB result output. But unfortunately all I'm getting is an array of size 0. Here's the controller code excerpt:

$data['query'] = $this->db->query('SELECT role_id, role_privilege FROM role');
$this->load->view('welcome_message', $data);

And a view code excerpt:

<?php
        echo count($query->result_array())."<br/>";
        foreach ($query->result() as $row){
            echo $row->role_id . '<br/>';
            echo $row->role_privilege . '<br/>';
        }
        echo 'Total result '.$query->num_rows();
    ?>

And what I get is next:

0
Total result

Running query from a command line gives a 2 rowed output. Can someone point out what i'm missing?

EDITED:
This issue is also discussed here .

EDITED:
Maybe some platform specific stuff (I really doubt that)? I'm running LAMP (php 5.3.2, mysql 5.1.37, apache 2.2.15).

EDITED:
This prints out a "Array ( )" string. My DB is 100% filled. I can say that for sure, because I did

INSERT INTO role(role_privilege) VALUES ('ROLE_MODERATOR');
INSERT INTO role(role_privilege) VALUES ('ROLE_USER');

and then checked it through a command line.

EDITED:
After I put this into my controller:

echo $this->db->last_query(); exit;

I get next output:

SELECT role_id, role_privilege FROM role

And that's exact sql query that I needed. Unfortunately results are o sized array.

In your controller, add this after the query line: echo $this->db->last_query();exit; Then paste the sql query in your original post. Might help with debugging. — k00k
– k00k, Commented May 8, 2010 at 14:07
Be sure that there is really some data in your table. You may be unknowingly querying an empty table. — BoltClock
– BoltClock, Commented May 8, 2010 at 17:53

Denys S. · Accepted Answer · 2010-05-08 22:01:41Z

2

Well, this here problem is basically not a CI related one, but strange thing is that CI couldn't track this error. Here's what was going on:

While installing php I haven't specified --with-mysql-socket parameter and it looks like php tried to use a /tmp/mysql.sock (default one) which obviously was not specified in my.cnf. So CI tried to bind to a nonexistent socket. Changing mysql params in a php.ini solved the problem.

answered May 8, 2010 at 22:01

Denys S.

6,56313 gold badges45 silver badges65 bronze badges

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

1 Comment

BoltClock Over a year ago

Ah, that must've been pretty tricky to track down. Glad you figured it out!

k00k · Accepted Answer · 2010-05-08 17:42:43Z

0

Well, it sounds like your db access is set up properly because you're not getting an error. Which I think also means that the table exists. I know you said you ran that query from the command line, but are you certain you're accessing the same data set/server/table? No weird versioning or anything? It sounds like there aren't records in the role table. Sorry, just grasping at straws as your code looks right.

How about doing

SELECT * FROM role

and then doing a

print_r($query->result_array());

in your view? That should reveal column names at least so you know you're accessing the right data.

Try that and report back with any detail and hopefully it will supply some hints.

answered May 8, 2010 at 17:42

k00k

17.6k14 gold badges62 silver badges87 bronze badges

Collectives™ on Stack Overflow

Empty database output in CI

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related