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.
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;?>