PHP处理分类点击次数,类别中点击次数最多的高亮显示

0 阅读2分钟

背景和需求

类似于我的前端导航,地址:www.haorooms.com/nav, 导航的左侧是分类,分类下面有很多链接。我现在想统计所有分类下面点击次数最多的一个,并把其颜色做特殊处理!

大致的数据结构如下:

{
    "content": [
        {
            "id": "1",
            "name": "htmldrive",
            "url": "http://www.htmldrive.net/",
            "cate": "前端开发",
            "clickpoint": "100"
        },
        {
            "id": "2",
            "name": "17素材网",
            "url": "http://www.17sucai.com/",
            "cate": "前端开发",
            "clickpoint": "151"
        },
        {
            "id": "3",
            "name": "阿里妈妈图标库",
            "url": "http://www.iconfont.cn/",
            "cate": "前端开发",
            "clickpoint": "2"
        },
        {
            "id": "53",
            "name": "Animate.css",
            "url": "http://www.haorooms.com/uploads/example/Animatecss/",
            "cate": "前端开发",
            "clickpoint": "21"
        },
        {
            "id": "55",
            "name": "Dafont",
            "url": "http://www.dafont.com/",
            "cate": "字体",
            "clickpoint": "1"
        }
 ]
}

如何对这些数据进行分类高亮显示呢?

方法和思路

最好的处理方式是在后端PHP中对齐进行处理。

思路:我们可以创建一个新的过渡数组,对原来的数组进行循环,创建一个分类的数组,然后把点击次数中的最大值和ID放到这个数组中。通过比较,获取分类中点击次数最多的ID和点击次数,然后把这个次数最多的ID放在一个新的数组中,循环原来的数据,通过inarray(),函数判断次数最多的ID是不是在这个数组当中,是的话,就给数据增加一个标示字段1,不是的话就是0。那么标示字段为1的就是分类中点击次数最多的。

调整之后输出的json是:

  {
        "content": [
            {
                "id": "1",
                "name": "htmldrive",
                "url": "http://www.htmldrive.net/",
                "cate": "前端开发",
                "clickpoint": "100",
              "max": 0
            },
            {
                "id": "2",
                "name": "17素材网",
                "url": "http://www.17sucai.com/",
                "cate": "前端开发",
                "clickpoint": "151",
                "max": 1
            },
            {
                "id": "3",
                "name": "阿里妈妈图标库",
                "url": "http://www.iconfont.cn/",
                "cate": "前端开发",
                "clickpoint": "2",
               "max": 0
            },
            {
                "id": "53",
                "name": "Animate.css",
                "url": "http://www.haorooms.com/uploads/example/Animatecss/",
                "cate": "前端开发",
                "clickpoint": "21",
                "max": 0
            },
            {
                "id": "55",
                "name": "Dafont",
                "url": "http://www.dafont.com/",
                "cate": "字体",
                "clickpoint": "1",
               "max": 0
            }
     ]
    }

php的代码如下:

    $sql = "select  id,name,url,cate,clickpoint  from commonwebsite order by id asc ";
   $res= $db->getAll($sql);
   $temp_arr = array();
   foreach ($res as $key => $value) {
    if(!isset($temp_arr[$value['cate']])){
      $temp_arr[$value['cate']] = array();
      $temp_arr[$value['cate']]['max'] = $value['clickpoint'];
      $temp_arr[$value['cate']]['id'] = $value['id'];
    }else{
      if($value['clickpoint']>$temp_arr[$value['cate']]['max']){
        $temp_arr[$value['cate']]['max'] = $value['clickpoint'];
        $temp_arr[$value['cate']]['id'] = $value['id'];
      }
    }
   }
  $temp_id = array(); //创建一个存放ID的临时数组
   foreach ($temp_arr as $val) {//循环之前创建的临时数组,存放分类和最多点击次数的
    $temp_id[] = $val['id']; //将点击次数最多的ID赋值给了临时数组
   }
     foreach ($res as $key => $vals) { //循环原来的数据
      if(in_array($vals['id'], $temp_id)){//如果次数最多的ID在原来的数组的ID中,那个加一个字段max并设置其值为1
        $res[$key]['max'] =1;
      }else{
        $res[$key]['max'] =0;//否则不是点击次数最多的,设置为0
      }
   }
    $result['content'] = $res;
       die(json_encode($result)); //json输出
   exit();