Query resulting empty in Codeigniter

Question

I have piece of PHP code written in Codeigniter framework that returns nothing (an empty set). Have a look at it and tell me what is wrong with it.

function sbsn($serial){
    $this->db->select('asset_types.name as type_name,asset_brands.name as brand_name');
    $this->db->from('asset_types,asset_brands,assets');
    $this->db->where('assets.type_code','asset_types.code');
    $this->db->where('assets.brand_code','asset_brands.code');
    $this->db->where('serial_no',$serial); 
    $result = $this->db->get();
    return $result;
}

Have you run the equivalent query in your database console? In CodeIgniter, can you turn on query logging to ensure the statement is being sent to the database server as you intend? — halfer
– halfer, Commented Feb 17, 2013 at 10:16
Are your Where statements correct? Your checking if assets.type_code is a string of 'asset_types.code' — Jeemusu
– Jeemusu, Commented Feb 17, 2013 at 14:11

umefarooq · Accepted Answer · 2013-02-17 10:10:39Z

3

hi with db get you are only getting result set not record to get results from result you have to the following thing

$this->db->get()->result(); // will return an array of objects
$this->db->get()->result_array(); //will return result in pure array
$this->db->get()->row() // just single row as object
$this->db->get()->row_array() // just single row as array

you can use $result to perform the same above things
$result->result();
$result->row();

for more information read generating result user guide

answered Feb 17, 2013 at 10:10

umefarooq

4,5941 gold badge31 silver badges41 bronze badges

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

Comments

Sudhir Bastakoti · Accepted Answer · 2013-02-17 10:20:43Z

1

change:

$result = $this->db->get();

to

$result = $this->db->get()->row_array();  //to get single row
//OR
$result = $this->db->get()->result_array();  //to get multiple rows

OR try using JOIN, like

$this->db->select('asset_types.name as type_name,asset_brands.name as brand_name');
$this->db->from('assets');
$this->db->join('asset_types', 'asset_types.code = assets.type_code', 'left');
$this->db->join('asset_brands', 'asset_brands.code = assets.brand_code', 'left');
$this->db->where('assets.serial_no',$serial); 
$result = $this->db->get()->result_array();
return $result;

edited Feb 17, 2013 at 10:20

answered Feb 17, 2013 at 10:09

Sudhir Bastakoti

100k15 gold badges163 silver badges169 bronze badges

2 Comments

deviloper Over a year ago

although it is identical to using: $result->result() as $sth in view file, but yet it doesnt work sudhir!

Sudhir Bastakoti Over a year ago

try doing echo $this->db->last_query(); after get(); to check if your sql is like you want it to be ..?

deviloper · Accepted Answer · 2013-02-18 07:03:47Z

1

The problem can be easily solved by joining the tables in the following way.

$this->db->select('at.name as type_name,ab.name as brand_name');
$this->db->from('asset_types as at,asset_brands as ab');
$this->db->join('assets as a', 'a.type_code = at.code and a.brand_code as ab.code');
$this->db->where('a.serial_no',$serial); 
$result = $this->db->get()->result_array();
return $result;

answered Feb 18, 2013 at 7:03

deviloper

7,25210 gold badges52 silver badges79 bronze badges

Collectives™ on Stack Overflow

Query resulting empty in Codeigniter

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related