CodeIgniter Forums
result from query - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: result from query (/showthread.php?tid=42727)

result from query - El Forum - 06-17-2011

[eluser]senjy[/eluser]
Hi,

I guess wthy in my model, i have 0 result when i do this with object return.

Model "queries"
Code:
function get_data() {
        $query = $this->db->query("....");
        return $query->result();  
    }
return null

but when it's array, it's ok.

Code:
function get_data() {
        $query = $this->db->query("....");
        return $query->result_array();  
    }
return many data

my Controller
Code:
$this->load->model('queries'); // model
        $data['query'] = $this->requetes->get_data();
        echo '<pre>';
        var_dump($data['query']);
        echo '</pre>';

what's wrong ?

result from query - El Forum - 06-17-2011

[eluser]marjune[/eluser]
when your using this code below
Code:
function get_data() {
        $query = $this->db->query("....");
        return $query->result();  
}

your controller

Code:
$this->load->model('queries'); // model
$data = $this->requetes->get_data();
foreah($data as $data){
   echo $data->fieldname;
}


result from query - El Forum - 06-17-2011

[eluser]senjy[/eluser]
display error
Code:
Fatal error: Cannot access empty property in D:\htdocs\system\database\drivers\mysql\mysql_result.php on line 162


result from query - El Forum - 06-17-2011

[eluser]InsiteFX[/eluser]
Because it returns an empty array! You need to check your returned values for errors and no records.

InsiteFX

result from query - El Forum - 06-17-2011

[eluser]marjune[/eluser]
Code:
function get_data() {
        $query = $this->db->query("....");
        if($query)
           return $query->result();  
        else
           return 0;
}


result from query - El Forum - 06-17-2011

[eluser]senjy[/eluser]
if i use $query->result() i don't have result

but

if i use $query->result_array() it's ok

result from query - El Forum - 06-17-2011

[eluser]marjune[/eluser]
did you try this
Code:
function get_data() {
        $query = $this->db->query("....");
        if($query)
           return $query->result();  
        else
           return 0;
}
Code:
$this->load->model('queries'); // model
$data = $this->requetes->get_data();
foreah($data as $data){
   echo $data->fieldname;
}


result from query - El Forum - 06-17-2011

[eluser]InsiteFX[/eluser]
Code:
function get_data()
{
    $query = $this->db->query("....");

    if($query->num_rows() > 0)
    {
        return $query->result();
    }
    else
    {
        return FALSE;
    }
}

InsiteFX