Codeigniter query returning blank

Question

I'm using the latest CodeIgniter version (3.1.4). I'm running the following basic query:

$query = $this->db->query("SELECT * FROM mytable;");

and getting a blank result - num_rows and row_data are both blank. Here's a print_r output of $query:

CI_DB_mysqli_result Object
(
    [conn_id] => mysqli Object
        (
            [affected_rows] => 2
            [client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $
            [client_version] => 50012
            [connect_errno] => 0
            [connect_error] => 
            [errno] => 0
            [error] => 
            [error_list] => Array
            (
            )

            [field_count] => 7
            [host_info] => Localhost via UNIX socket
            [info] => 
            [insert_id] => 0
            [server_info] => 5.6.35
            [server_version] => 50635
            [stat] => Uptime: 2988249  Threads: 2  Questions: 13445030  Slow queries: 9  Opens: 784  Flush tables: 1  Open tables: 469  Queries per second avg: 4.499
            [sqlstate] => 00000
            [protocol_version] => 10
            [thread_id] => 922470
            [warning_count] => 0
        )

    [result_id] => mysqli_result Object
    (
        [current_field] => 0
        [field_count] => 7
        [lengths] => 
        [num_rows] => 2
        [type] => 0
    )

    [result_array] => Array
    (
    )

    [result_object] => Array
    (
    )

    [custom_result_object] => Array
    (
    )

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

Can anyone help me figure out what's wrong here?

DFriend · Accepted Answer · 2017-04-03 22:06:20Z

3

Those values will remain blank until you call one of the methods that generate a result - documented here.

Try this

$query = $this->db->query("SELECT * FROM mytable;");
echo "Rows: ". $query->num_rows(). "<br>";
$data = $query->result();
var_dump($data);

See anything?

answered Apr 3, 2017 at 22:06

DFriend

8,9741 gold badge16 silver badges26 bronze badges

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

1 Comment

Alex B Over a year ago

Yes, works now, thank you. I take it this is because of the move from mysql to mysqli in more recent versions of CI? Was using version 2.x prior to this, and never had issues.

ubm · Accepted Answer · 2017-04-04 04:07:29Z

0

I hope this change will helps you

$query = $this->db->query("SELECT * FROM mytable;");
$data = $query->result();
return $data;

you can rewrite this query in other ways

$this->db->select('*');
$this->db->from('mytable');
$data=$this->db->get();

for data result

return $data->result();

for number of rows

 return $data->num_rows();

edited Apr 4, 2017 at 4:07

answered Apr 4, 2017 at 4:02

ubm

63611 silver badges21 bronze badges

Collectives™ on Stack Overflow

Codeigniter query returning blank

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related