phpcodeignitermodel-view-controllermaxresultset

Pass MAX() value from model to controller to view in CodeIgniter


I trying to show the MAX value of a field in my codeigniter, but still confuse to showing it.

I've try some answer in stackoverflow but still not work to implementing in my project.

this is my model

public function getCountIdMember()
{
    $this->db->select_max('id_member');
    $this->db->from('member');
    $query = $this->db->get();
    return $query->result_array();        
}

this is my controller

public function validation()
{
    $data['member'] = $this->Member_model->getCountIdMember();
}

This is my view

<?= $member['id_member']; ?>

I expect the output value in my view is (id_member) example 97 or more.


Solution

  • Try this, in your model

    public function getCountIdMember(){
            $this->db->select_max('id_member');
            $this->db->from('member');
            $query = $this->db->get();
            if($query->num_rows() > 0){
               return $query->row('id_member');        
            }else{
               return 1;
            }
    }
    

    Contorller:

    public function validation(){
          $data = array();
          $data['member'] = $this->Member_model->getCountIdMember();//here you can get only your id
          //echo var_dump($data);die;
          $this->load->view('yourViewName',$data);
    
    }
    

    View:

    <?php echo $member;?>