I cant get $result['query'] in my view pag

问题:

My controller Erp_c:

$result['query2']= $this->erp_m->selectattend1($user,$en,$year,$month);
$this->load->('salview',$result);

In model Erp_m:

function selectattend1($user,$en,$year,$month)
{
  $query2=$this->db->query(" SELECT COUNT(*)
FROM attendance3
WHERE name = '$en'
AND attend = 'Absent'
AND MONTH = '$month'
AND year = '$year'
AND user = '$user' ");

return $query2->result(); 

}

In view page salview.php:

 foreach($query2 as $row)

{
$al=$row->count(*);///here what i put ,that is my doubt
,because $result['query']= Array ( [0] => stdClass Object ( [COUNT(*)] => 1 ) )
}

How can I get count value in view page?

回答1:

In Controller

$result['query2']= $this->erp_m->selectattend1($user,$en,$year,$month);//get data
$result['count']= $this->erp_m->get_selectattend1_count($user,$en,$year,$month);//get count

In Model

function selectattend1($user,$en,$year,$month)
{
    $query2 = $this->db->query(" SELECT COUNT(*)
            FROM attendance3
            WHERE name = '$en'
            AND attend = 'Absent'
            AND MONTH = '$month'
            AND year = '$year'
            AND user = '$user' ");

    $result = $query2->result_array();
    return $result;
}

function get_selectattend1_count($user,$en,$year,$month)
{
    $query2 = $this->db->query(" SELECT COUNT(*)
            FROM attendance3
            WHERE name = '$en'
            AND attend = 'Absent'
            AND MONTH = '$month'
            AND year = '$year'
            AND user = '$user' ");

    $result = $query2->result_array();
    $count = count($result);
    return $count;
}

In View

you can access both veriables $query2 and $count

foreach($query2 as $row)
{
    echo $row['field_name'];
}