我试图用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 回答
这是我会做的: