ホームページ > バックエンド開発 > PHPチュートリアル > CI框架里用pChart作报表数组不好识别

CI框架里用pChart作报表数组不好识别

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
リリース: 2016-06-13 10:44:31
オリジナル
1072 人が閲覧しました

CI框架里用pChart做报表数组不好识别
这是查询的代码
$array1[0]= $this->db->query('select count(customer_id) '.$str2.' where bl_salesman_id='.$_POST["EmployeeId"]." and year(create_time)='2012' and month(create_time)='01'");
  $array1[1]= $this->db->query('select count(customer_id) '.$str2.' where bl_salesman_id='.$_POST["EmployeeId"]." and year(create_time)='2012' and month(create_time)='02'");
  $array1[2]= $this->db->query('select count(customer_id) '.$str2.' where bl_salesman_id='.$_POST["EmployeeId"]." and year(create_time)='2012' and month(create_time)='03'");
  $array1[3]= $this->db->query('select count(customer_id) '.$str2.' where bl_salesman_id='.$_POST["EmployeeId"]." and year(create_time)='2012' and month(create_time)='04'");
  $array1[4]= $this->db->query('select count(customer_id) '.$str2.' where bl_salesman_id='.$_POST["EmployeeId"]." and year(create_time)='2012' and month(create_time)='05'");
  $array1[5]= $this->db->query('select count(customer_id) '.$str2.' where bl_salesman_id='.$_POST["EmployeeId"]." and year(create_time)='2012' and month(create_time)='06'");
  $array1[6]= $this->db->query('select count(customer_id) '.$str2.' where bl_salesman_id='.$_POST["EmployeeId"]." and year(create_time)='2012' and month(create_time)='07'");
  $array1[7]= $this->db->query('select count(customer_id) '.$str2.' where bl_salesman_id='.$_POST["EmployeeId"]." and year(create_time)='2012' and month(create_time)='08'");
  $array1[8]= $this->db->query('select count(customer_id) '.$str2.' where bl_salesman_id='.$_POST["EmployeeId"]." and year(create_time)='2012' and month(create_time)='09'");
  $array1[9]= $this->db->query('select count(customer_id) '.$str2.' where bl_salesman_id='.$_POST["EmployeeId"]." and year(create_time)='2012' and month(create_time)='10'");
  $array1[10]= $this->db->query('select count(customer_id) '.$str2.' where bl_salesman_id='.$_POST["EmployeeId"]." and year(create_time)='2012' and month(create_time)='11'");
  $array1[11]= $this->db->query('select count(customer_id) '.$str2.' where bl_salesman_id='.$_POST["EmployeeId"]." and year(create_time)='2012' and month(create_time)='12'");
 

$result = array();


foreach ( $array1 as $v ) {
$result[] = $v->row_array();

}
   
  print_r($result);
exit();
$_SESSION =$v;



结果是:
Array
(
  [0] => Array
  (
  [count(customer_id)] => 4
  )

  [1] => Array
  (
  [count(customer_id)] => 1
  )

  [2] => Array
  (
  [count(customer_id)] => 1
  )

  [3] => Array
  (
  [count(customer_id)] => 2
  )

  [4] => Array
  (
  [count(customer_id)] => 2
  )

  [5] => Array
  (
  [count(customer_id)] => 1
  )

  [6] => Array
  (
  [count(customer_id)] => 1
  )

  [7] => Array
  (
  [count(customer_id)] => 3
  )

  [8] => Array
  (
  [count(customer_id)] => 2

関連ラベル:
このウェブサイトの声明
この記事の内容はネチズンが自主的に寄稿したものであり、著作権は原著者に帰属します。このサイトは、それに相当する法的責任を負いません。盗作または侵害の疑いのあるコンテンツを見つけた場合は、admin@php.cn までご連絡ください。
人気のチュートリアル
詳細>
最新のダウンロード
詳細>
ウェブエフェクト
公式サイト
サイト素材
フロントエンドテンプレート