CodeIgniter SELECT query only returns an empty result set [closed]

Question

Closed. This question needs debugging details. It is not currently accepting answers.

Edit the question to include desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem. This will help others answer the question.

Closed 12 days ago.

Improve this question

In my CodeIgniter application, I'm trying to retrieve data from my database table. Here is my code:

database.php:

$active_group = 'default';
$active_record = TRUE;

$db['default']['hostname'] = "localhost";
$db['default']['username'] = "*****";
$db['default']['password'] = "****";

$db['default']['database'] = "mydbname";
$db['default']['dbdriver'] = 'mysqli';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = FALSE;
$db['default']['db_debug'] = FALSE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = '';
$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;

In Model.php:

$sql = "SELECT * from users";

$query = $this->db->query($sql);
print_r($query);

but it return like

CI_DB_mysqli_result Object (
    [conn_id] => 
    [result_id] => 
    [result_array] => Array ( ) 
    [result_object] => Array ( ) 
    [custom_result_object] => Array ( ) 
    [current_row] => 0 
    [num_rows] => 
    [row_data] => 
)
array(0) { }

See, it is an empty result. How can I get a populated result?

$this->db->select('*'); $this->db->from('users'); $query = $this->db->get(); echo $this->db->last_query(); return $query->result_array(); use this and check if the query is executing right or wrong? — Vivek Singh
– Vivek Singh, Commented Mar 31, 2016 at 13:05
try : print_r($query->result_array()); to get your resultset instead of the whole CI query object — JBA
– JBA, Commented Mar 31, 2016 at 13:05

Pathik Vejani · Accepted Answer · 2016-03-31 13:05:19Z

2

Do this:

<?php
$sql = "SELECT * from users";
$query = $this->db->query($sql);
if($query->num_rows() > 0) {
    print_r($query->result_array());
} else {
    $d = array();
    print_r($d);
}
?>

answered Mar 31, 2016 at 13:05

Pathik Vejani

4,49911 gold badges66 silver badges110 bronze badges

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

25 Comments

Pathik Vejani Over a year ago

@Vini did you use if condintion?

Vini Over a year ago

@PathikVejani yes i used if. In localhost it is working well. In live server issue occur.

Avinash Sinha Over a year ago

Check weather database library is loaded or not

Pathik Vejani Over a year ago

@Vini set 'db_debug' => TRUE and check

Vini Over a year ago

@PathikVejani if i set db_debug' => TRUE then this should happen

Unable to connect to your database server using the provided settings.  Filename: C:\Inetpub\vhosts\jobblogger.no\domian\system\database\DB_driver.php

|

Collectives™ on Stack Overflow

CodeIgniter SELECT query only returns an empty result set [closed]

1 Answer 1

25 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

25 Comments

Linked

Related