算上与codeigniter每行 [英] count each rows with codeigniter

问题描述

我有两个表 表TOPIK和表多申

i have two tables table topik and table dosen

dosen table---->|dosen_id|dosen_nama|     topik---->|dosen_id1|dosen_id2|
                   1         a                           1       2
                   2         b                           2       1
                   3         c                           1       3

我要计算行dosen_id1和dosen_id2作为一个结果是这样

i want count rows dosen_id1 and dosen_id2 as a results like this

|dosen_nama|count|
      a       3
      b       2
      c       1

什么code的模式，我必须写？ 请帮我...

what code in model i must write? please help me...

更新

这是我的控制器

$data['jumlah'] = $this->topikdo_model->get_all_topikdo_jumlah();

这是我的看法。

<table class="table table-bordered  table-striped  table-hover ">
        <tbody>
            <tr>

                <th>SANDOS</th>
                <th>Nama</th>
                <th>Jumlah Bimbingan</th>
                <th>Aksi</th>
            </tr>
            <?php
            $no=1;
            foreach($daftardosen as $row)
            {
            ?>
            <tr>

                <td><?php echo $row->dosen_id;?></td>
                <td><?php echo $row->dosen_nama;?></td>
                <td><?php echo $jumlah;?></td>
                <td align='center'>

                    <?php
                    echo anchor('topikdo_controller/rincian_daftardosen/'.$row->dosen_id,'Rincian');
                    ?>
                </td>
            </tr>
            <?php $no++;
            }
            ?>
         </tbody>
    </table>

我已经writen查询模型像罗希尼sugested 模型

i have writen query in model like rohini sugested model

$sql="SELECT d.dosen_nama, count(t.a) 
  FROM dosen as d, (Select topik_pembimbing1 as a 
                    FROM topik 
                    UNION ALL 
                    SELECT topik_pembimbing2 as a 
                    FROM topik) as t 
  WHERE d.dosen_id = t.a 
  GROUP BY d.dosen_nama"; 
$data=$this->db->query($sql);return $data->result(); 

但有消息错误数组串转换？ 对不起,,,我没有到Internet的任何连接前几天...

But there was message error "array to string conversion"... i am sorry,,, i dont have any connection to the internet few days ago...

推荐答案

您可以简单地执行一个查询，以获得所需的结果。

You can simply execute a query to get the desired result.

SELECT dosen_nama, ((SELECT COUNT(*) FROM topik WHERE dosen_id1=d.dosen_id) +  (SELECT COUNT(*) FROM topik WHERE dosen_id2=d.dosen_id)) AS COUNT
FROM dosen d

这篇关于算上与codeigniter每行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！