PHP按照首字符拼音对数据进行分类

在工作中, 需要将数据表里查出的数据按照首字母进行分类, 参照某个大神博客(链接已忘记), 实现了这个功能, 运行结果如下:


image.png

完整代码如下:

<?php
// 原始数据
$src = '[{"id":"1","name":"媒体(白名单)","pid":"0"},{"id":"2","name":"党媒公共平台","pid":"0"},{"id":"3","name":"政府机构","pid":"0"},{"id":"4","name":"其他","pid":"0"},{"id":"5","name":"中央媒体","pid":"1"},{"id":"6","name":"地方媒体","pid":"1"},{"id":"7","name":"门户媒体","pid":"4"},{"id":"8","name":"综合媒体","pid":"4"},{"id":"9","name":"专业媒体","pid":"4"},{"id":"11","name":"河北省","pid":"6"},{"id":"12","name":"山东省","pid":"6"},{"id":"13","name":"辽宁省","pid":"6"},{"id":"34","name":"北京","pid":"6"},{"id":"45","name":"视频","pid":"9"},{"id":"46","name":"教育","pid":"9"},{"id":"79","name":"法律","pid":"9"},{"id":"80","name":"其他","pid":"9"},{"id":"81","name":"文学","pid":"9"}]';
$result = json_decode($src, true);
echo json_encode(sortByPinyin($result), JSON_UNESCAPED_UNICODE);

function sortByPinyin($collects)
{
    $res = [];
    foreach ($collects as $collect) {
        $char = substr($collect['name'], 0, 1);
        if (is_numeric($char)) {
            $res['#'][] = $collect;
            continue;
        }
        $res[getFirstChar($collect['name'])][] = $collect;
    }
    ksort($res, SORT_STRING);
    return $res;
}


function getFirstChar($s0)
{
    //获取单个汉字拼音首字母。注意:此处不要纠结。汉字拼音是没有以U和V开头的
    $c = ord($s0{0});
    // if($c <= ord("z") )return strtoupper($s0{0});
    if ($c < ord('A')) {
        return '#';
    } elseif ($c > ord('Z') && $c < ord('a')) {
        return '#';
    } elseif ($c > ord('z') && $c < 127) {
        return '#';
    } elseif ($c < 127) {
        return strtoupper($s0{0});
    }
    // $s1 = iconv("UTF-8","gb2312", $s0);
    $s1 = mb_convert_encoding($s0, "GBK", "UTF-8");
    // $s2 = iconv("gb2312","UTF-8", $s1);
    $s2 = mb_convert_encoding($s1, "UTF-8", "GBK");
    if ($s2 == $s0) {
        $s = $s1;
    } else {
        $s = $s0;
    }
    $asc = ord($s{0}) * 256 + ord($s{1}) - 65536;
    if ($asc >= -20319 && $asc <= -20284) return "A";
    if ($asc >= -20283 && $asc <= -19776) return "B";
    if ($asc >= -19775 && $asc <= -19219) return "C";
    if ($asc >= -19218 && $asc <= -18711) return "D";
    if ($asc >= -18710 && $asc <= -18527) return "E";
    if ($asc >= -18526 && $asc <= -18240) return "F";
    if ($asc >= -18239 && $asc <= -17923) return "G";
    if ($asc >= -17922 && $asc <= -17418) return "H";
    if ($asc >= -17922 && $asc <= -17418) return "I";
    if ($asc >= -17417 && $asc <= -16475) return "J";
    if ($asc >= -16474 && $asc <= -16213) return "K";
    if ($asc >= -16212 && $asc <= -15641) return "L";
    if ($asc >= -15640 && $asc <= -15166) return "M";
    if ($asc >= -15165 && $asc <= -14923) return "N";
    if ($asc >= -14922 && $asc <= -14915) return "O";
    if ($asc >= -14914 && $asc <= -14631) return "P";
    if ($asc >= -14630 && $asc <= -14150) return "Q";
    if ($asc >= -14149 && $asc <= -14091) return "R";
    if ($asc >= -14090 && $asc <= -13319) return "S";
    if ($asc >= -13318 && $asc <= -12839) return "T";
    if ($asc >= -12838 && $asc <= -12557) return "W";
    if ($asc >= -12556 && $asc <= -11848) return "X";
    if ($asc >= -11847 && $asc <= -11056) return "Y";
    if ($asc >= -11055 && $asc <= -10247) return "Z";
    return "#";
}
©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容

  • 关于Mongodb的全面总结 MongoDB的内部构造《MongoDB The Definitive Guide》...
    中v中阅读 32,137评论 2 89
  • Android 自定义View的各种姿势1 Activity的显示之ViewRootImpl详解 Activity...
    passiontim阅读 175,738评论 25 709
  • 自己写作业 下午一下班回家,首先找孩子,老爸告诉我在写作业,我到孩子房间一看,正在看书,我催...
    松鼠家阅读 1,300评论 2 0
  • 看完《后来的我们》,我感触良多。我没有北漂的经历,没有真正的在外面的世界打拼过,触动我的是两个人一路走来的过程。热...
    Jango哑炮阅读 2,656评论 0 1