如何使图表图形php - How to make Chart grapht php?

How to make Chart grapht php?

本文关键字：php 图形何使图 | 更新日期: 2023-09-27

我想根据数据索引计数数据库的结果，并重新设置。

$sql="SELECT * FROM hit WHERE date BETWEEN (CURDATE() - INTERVAL 7 DAY) AND CURDATE() ";
    $sor=$this->vt()->query($sql);
    $array=array();
    $cek=$sor->FetchAll(PDO::FETCH_ASSOC);

数据库id
日期
类型
ip
类别
页
ref
reflink

结果

    Array
(
    [0] => Array
        (
            [id] => 18
            [category] => 0
            [page] => 0
            [ip] => ::1
            [tip] => t
            [date] => 2016-10-24 
            [ref] => 
            [reflink] => 
        )
    [1] => Array
        (
            [id] => 19
            [category] => 0
            [page] => 0
            [ip] => ::1
            [type] => t
            [date] => 2016-10-24 
            [ref] => 
            [reflink] => 
        )
    [2] => Array
        (
            [id] => 20
            [category] => 0
            [page] => 0
            [ip] => ::1
            [type] => t
            [date] => 2016-10-24
            [ref] => 
            [reflink] => 
        )

    [3] => Array
        (
            [id] => 26
            [category] => 0
            [page] => 0
            [ip] => 127.0.0.1
            [type] => t
            [date] => 2016-10-28
            [ref] => 
            [reflink] => 
        )
)

我让日期有意义。我想把这些值显示为图形
24.10: 3
28.10: 1
这些价值如何日复一日地计算?例如

这里是

foreach ($array as $value) {
    $date[] = $value['date'];
}
print_r (array_count_values($date));