ホームページ  >  記事  >  バックエンド開発  >  CI での配列変換に関する問題

CI での配列変換に関する問題

WBOY
WBOYオリジナル
2016-06-13 13:15:15818ブラウズ

CI里数组转换问题
查询数组
$str2="from crm_ltsz_customer_info_def";

if($_POST["EmployeeId"]!="" && $_POST["EmployeeId"]!= null)
{
$str3=" bl_salesman_id=".$_POST["EmployeeId"]." および ";
};

$array1[0]= $this-> ;db->query('select count(customer_id) as `count` '.$str2.' where '.$str3." year(create_time)=".$_POST["CreateTime"]." and month(create_time )='01'");
$array1[1]= $this->db->query('select count(customer_id) as `count` '.$str2.' where '.$str3. " year(create_time)=".$_POST["CreateTime"]." and month(create_time)='02'");
$array1[2]= $this->db->query(' select count(customer_id) as `count` '.$str2.' where '.$str3." year(create_time)=".$_POST["CreateTime"]." and month(create_time)='03'");
$array1[3]= $this->db->query('select count(customer_id) as `count` '.$str2.' where '.$str3." year(create_time)=. $_POST["CreateTime"]." and month(create_time)='04'");
$array1[4]= $this->db->query('select count(customer_id) as `count ` '.$str2.' where '.$str3." year(create_time)=".$_POST["CreateTime"]." and month(create_time)='05'");
$array1[5] = $this->db->query('select count(customer_id) as `count` '.$str2.' where '.$str3." year(create_time)=".$_POST["CreateTime"]. " and month(create_time)='06'");
$array1[6]= $this->db->query('select count(customer_id) as `count` '.$str2.' where '.$str3." year(create_time)=".$_POST["CreateTime"]." and month(create_time)='07'");
$array1[7]= $this->db- >query('select count(customer_id) as `count` '.$str2.' where '.$str3." year(create_time)=".$_POST["CreateTime"]." and month(create_time)=' 08'");
$array1[8]= $this->db->query('select count(customer_id) as `count` '.$str2.' where '.$str3." year( create_time)=".$_POST["CreateTime"]." and month(create_time)='09'");
$array1[9]= $this->db->query('select count( customer_id) as `count` '.$str2.' where '.$str3." year(create_time)=".$_POST["CreateTime"]." and month(create_time)='10'");
$array1[10]= $this->db->query('select count(customer_id) as `count` '.$str2.' where '.$str3." year(create_time)=".$_POST[ "CreateTime"]." and month(create_time)='11'");
$array1[11]= $this->db->query('select count(customer_id) as `count` '. $str2.' where '.$str3." year(create_time)=".$_POST["CreateTime"]." and month(create_time)='12'");

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

出た結果は
配列
(
[0] =>配列
(
[カウント] => 0
)

[1] =>配列
(
[カウント] => 1
)

[2] =>配列
(
[カウント] => 0
)

[3] =>配列
(
[カウント] => 0
)

[4] =>配列
(
[カウント] => 1
)

[5] =>配列
(
[カウント] => 0
)

[6] =>配列
(
[カウント] => 1
)

[7] =>配列

声明:
この記事の内容はネチズンが自主的に寄稿したものであり、著作権は原著者に帰属します。このサイトは、それに相当する法的責任を負いません。盗作または侵害の疑いのあるコンテンツを見つけた場合は、admin@php.cn までご連絡ください。