查詢資料庫後數組統計次數，並達到如圖效果？-php教程-PHP中文網

回覆內容：

首頁

後端開發

php教程

查詢資料庫後數組統計次數，並達到如圖效果？

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Aug 08, 2016 am 09:06 AM

linux mysql php

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

熱AI工具

熱工具

熱門話題

gmail信箱登陸入口在哪裡

7859

Java教學

1649

CakePHP 教程

1403

Laravel 教程

1300

PHP教程

1242

Related knowledge

Linux體系結構：揭示5個基本組件 Apr 20, 2025 am 12:04 AM

Linux系統的五個基本組件是：1.內核，2.系統庫，3.系統實用程序，4.圖形用戶界面，5.應用程序。內核管理硬件資源，系統庫提供預編譯函數，系統實用程序用於系統管理，GUI提供可視化交互，應用程序利用這些組件實現功能。

MySQL和PhpMyAdmin：核心功能和功能 Apr 22, 2025 am 12:12 AM

MySQL和phpMyAdmin是強大的數據庫管理工具。 1）MySQL用於創建數據庫和表、執行DML和SQL查詢。 2）phpMyAdmin提供直觀界面進行數據庫管理、表結構管理、數據操作和用戶權限管理。

如何安全地將包含函數和正則表達式的JavaScript對象存儲到數據庫並恢復？ Apr 19, 2025 pm 11:09 PM

安全地處理JSON中的函數和正則表達式在前端開發中，經常需要將JavaScript...

Linux上的Docker：Linux系統的容器化 Apr 22, 2025 am 12:03 AM

Docker在Linux上重要，因為Linux是其原生平台，提供了豐富的工具和社區支持。 1.安裝Docker：使用sudoapt-getupdate和sudoapt-getinstalldocker-cedocker-ce-clicontainerd.io。 2.創建和管理容器：使用dockerrun命令，如dockerrun-d--namemynginx-p80:80nginx。 3.編寫Dockerfile：優化鏡像大小，使用多階段構建。 4.優化和調試：使用dockerlogs和dockerex