如何使用codeigniter进行计数评论，

Question

I'm working on a project. how to calculate comment by id?

example

controler:

public function comments() {

$id_alat = $this->db->where('id_alat');
$com = $this->mcrud->getComent($id_alat);
$com = $this->mcrud->getComent($id_alat);
$data = array (
                'com' => $com,
                'content' => 'instrument/instrument');
$this->load->view('layouts/wrapper', $data);
 }

models:

public function getComent($id_alat) {

$sql = "SELECT count (*) as num FROM WHERE tbcoment $id_alat tbcoment.id_alat = {}";
$this->db->query($sql);
} 

view:

comments: <?php echo $com; ?>

Answer 1

Use following code for model

Your Model

public function getComent($id_alat) 
{
    $sql = "SELECT count (*) as num FROM WHERE tbcoment.id_alat = '$id_alat'";
    $res=$this->db->query($sql)->row_object();
    return $res->num; 
}