首页 文章

Codeigniter - 如何显示数据库中的数据'where id = $ value'

提问于
浏览
0

我试图用codeigniter进行年度报告 . 期望输出如下:
月01 = 0数据,月02 = 10数据并继续......

Controller

$this->load->model('dash_model');

$data = array();
$data['mont'] = array$this->dash_model->monthreport();

$this->output->enable_profiler(TRUE);
$this->parser->parse('blank.htm', $data);

当我在没有CodeIgniter的情况下尝试用PHP编写代码时,它确实有效 .

for($i=1; $i<=12; )
{
    $month=array("","01","2","3","4","5","6","7","8","9","10","11","12");
    $m = $month[$i];

    $query = "SELECT count(*) as trans_email 
              FROM trans_email 
              WHERE lup LIKE '2014-$m%' ";
    $qu = mysql_query($query);

    $data=mysql_fetch_array($qu);
    $komp = $data['trans_email'];
}

我试图实现上面的代码来模拟CodeIgniter

dash model

for($i=1; $i<=12; )
 {
     $month=array("","01","2","3","4","5","6","7","8","9","10","11","12");
     $m = $month[$i];
     $query2=$this->db->query("SELECT count(*) as rr 
                               FROM trans_email 
                               WHERE lup LIKE '2014-$m%' ");

     $resultArray[$i]=$query2->result_array();

     $i++;
 }
 return $resultArray;

View

{mont}
month {rr}
{/mont}

结果不如预期 .

如何返回多达12次的数组中的查询,并产生12个输出,如下所示:
月01 = 0数据,月02 = 10数据并继续......

How to query that I have a loop, its value can I throw into the controller

1 回答

  • 0

    这是我会做的:

    $months = array(
         '01',
         '02',
          ...
         );
     $this->db->select('count(*) as rr');
     foreach($months as $month){
             $this->db->like('lup', $month);
     }
     $query = $this->db->get('trans_email')
    

相关问题