查詢資料庫後數組統計次數，並達到如圖效果？
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB原創
- 2016-08-08 09:06:54961瀏覽
service_channel為投訴管道，投訴次數(c)，投訴人數的應該為(count(t) 相同的次數和) 有多個投訴渠道怎麼實現下面這張圖的效果? 明細忽略.. 謝謝^_^
0 =>
<code>array (size=4) 'c' => string '4' (length=1) 'create_time' => string '2016-08-04' (length=10) 'archivepath_name' => string '1天' (length=75) 'service_channel' => string '12' (length=2)</code>
1 =>
<code>array (size=4) 'c' => string '4' (length=1) 'create_time' => string '2016-08-04' (length=10) 'archivepath_name' => string '1天' (length=75) 'service_channel' => string '12' (length=2)</code>
2 =>
<code>array (size=4) 'c' => string '2' (length=1) 'create_time' => string '2016-08-04' (length=10) 'archivepath_name' => string '1天' (length=75) 'service_channel' => string '12' (length=2)</code>
3 =>
<code>array (size=4) 'c' => string '2' (length=1) 'create_time' => string '2016-08-04' (length=10) 'archivepath_name' => string '1天' (length=75) 'service_channel' => string '12' (length=2)</code>
4 =>
<code>array (size=4) 'c' => string '2' (length=1) 'create_time' => string '2016-08-04' (length=10) 'archivepath_name' => string '1天' (length=75) 'service_channel' => string '12' (length=2)</code>
5 =>
<code>array (size=4) 'c' => string '2' (length=1) 'create_time' => string '2016-08-04' (length=10) 'archivepath_name' => string '1天' (length=75) 'service_channel' => string '12' (length=2)</code>
6 =>
13 =>
<code>array (size=4) 'c' => string '6' (length=1) 'create_time' => string '2016-08-04' (length=10) 'archivepath_name' => string '1天' (length=75) 'service_channel' => string '29' (length=2)</code>
14 =>
<code>array (size=4) 'c' => string '6' (length=1) 'create_time' => string '2016-08-04' (length=10) 'archivepath_name' => string '1天' (length=75) 'service_channel' => string '29' (length=2)</code>
15 =>
<code>array (size=4) 'c' => string '4' (length=1) 'create_time' => string '2016-08-04' (length=10) 'archivepath_name' => string '1天' (length=75) 'service_channel' => string '29' (length=2)</code>
16 =>
<code>array (size=4) 'c' => string '4' (length=1) 'create_time' => string '2016-08-04' (length=10) 'archivepath_name' => string '1天' (length=75) 'service_channel' => string '29' (length=2)</code>
17 =>
<code>array (size=4) 'c' => string '4' (length=1) 'create_time' => string '2016-08-04' (length=10) 'archivepath_name' => string '1天' (length=75) 'service_channel' => string '29' (length=2)</code>
18 =>
<code>array (size=4) 'c' => string '2' (length=1) 'create_time' => string '2016-08-04' (length=10) 'archivepath_name' => string '1天' (length=75) 'service_channel' => string '29' (length=2)</code>
19 =>
<code>array (size=4) 'c' => string '2' (length=1) 'create_time' => string '2016-08-04' (length=10) 'archivepath_name' => string '1天' (length=75) 'service_channel' => string '29' (length=2)</code>
20 =>
<code>array (size=4) 'c' => string '2' (length=1) 'create_time' => string '2016-08-04' (length=10) 'archivepath_name' => string '1天' (length=75) 'service_channel' => string '29' (length=2) </code>
回覆內容：
service_channel為投訴管道，投訴次數(c)，投訴人數的應該為(count(t) 相同的次數和) 有多個投訴渠道怎麼實現下面這張圖的效果? 明細忽略.. 謝謝^_^
0 =>
<code>array (size=4) 'c' => string '4' (length=1) 'create_time' => string '2016-08-04' (length=10) 'archivepath_name' => string '1天' (length=75) 'service_channel' => string '12' (length=2)</code>
1 =>
<code>array (size=4) 'c' => string '4' (length=1) 'create_time' => string '2016-08-04' (length=10) 'archivepath_name' => string '1天' (length=75) 'service_channel' => string '12' (length=2)</code>
2 =>
<code>array (size=4) 'c' => string '2' (length=1) 'create_time' => string '2016-08-04' (length=10) 'archivepath_name' => string '1天' (length=75) 'service_channel' => string '12' (length=2)</code>
3 =>
<code>array (size=4) 'c' => string '2' (length=1) 'create_time' => string '2016-08-04' (length=10) 'archivepath_name' => string '1天' (length=75) 'service_channel' => string '12' (length=2)</code>
4 =>
<code>array (size=4) 'c' => string '2' (length=1) 'create_time' => string '2016-08-04' (length=10) 'archivepath_name' => string '1天' (length=75) 'service_channel' => string '12' (length=2)</code>
5 =>
<code>array (size=4) 'c' => string '2' (length=1) 'create_time' => string '2016-08-04' (length=10) 'archivepath_name' => string '1天' (length=75) 'service_channel' => string '12' (length=2)</code>
6 =>
13 =>
<code>array (size=4) 'c' => string '6' (length=1) 'create_time' => string '2016-08-04' (length=10) 'archivepath_name' => string '1天' (length=75) 'service_channel' => string '29' (length=2)</code>
14 =>
<code>array (size=4) 'c' => string '6' (length=1) 'create_time' => string '2016-08-04' (length=10) 'archivepath_name' => string '1天' (length=75) 'service_channel' => string '29' (length=2)</code>
15 =>
<code>array (size=4) 'c' => string '4' (length=1) 'create_time' => string '2016-08-04' (length=10) 'archivepath_name' => string '1天' (length=75) 'service_channel' => string '29' (length=2)</code>
16 =>
<code>array (size=4) 'c' => string '4' (length=1) 'create_time' => string '2016-08-04' (length=10) 'archivepath_name' => string '1天' (length=75) 'service_channel' => string '29' (length=2)</code>
17 =>
<code>array (size=4) 'c' => string '4' (length=1) 'create_time' => string '2016-08-04' (length=10) 'archivepath_name' => string '1天' (length=75) 'service_channel' => string '29' (length=2)</code>
18 =>
<code>array (size=4) 'c' => string '2' (length=1) 'create_time' => string '2016-08-04' (length=10) 'archivepath_name' => string '1天' (length=75) 'service_channel' => string '29' (length=2)</code>
19 =>
<code>array (size=4) 'c' => string '2' (length=1) 'create_time' => string '2016-08-04' (length=10) 'archivepath_name' => string '1天' (length=75) 'service_channel' => string '29' (length=2)</code>
20 =>
<code>array (size=4) 'c' => string '2' (length=1) 'create_time' => string '2016-08-04' (length=10) 'archivepath_name' => string '1天' (length=75) 'service_channel' => string '29' (length=2) </code>
<code>select create_time,service_channel,c,count(*) as '人数' from a group by create_time,service_channel,c</code>
陳述：
本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn