读书人

CI里数组转换有关问题

发布时间: 2012-09-15 19:09:28 作者: rapoo

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

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

$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();

出的结果是
Array
(
[0] => Array
(
[count] => 0
)

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

[2] => Array
(
[count] => 0
)

[3] => Array
(
[count] => 0
)

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

[5] => Array
(
[count] => 0
)

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

[7] => Array


(
[count] => 1
)

[8] => Array
(
[count] => 0
)

[9] => Array
(
[count] => 0
)

[10] => Array
(
[count] => 0
)

[11] => Array
(
[count] => 0
)

)

现在想要把数组变成
Array
(
[0] => 0

[1] => 1

[2] => 0

[3] => 0

[4] => 1

[5] => 0

[6] => 1

[7] => 1

[8] => 0

[9] => 0

[10] => 0

[11] => 0
)

要用什么样的方法,求解啊。


[解决办法]
foreach ( $array1 as $v ) {
$result[] = current($v->row_array());
}
print_r($result);

读书人网 >PHP

热点推荐