做一个主题的时候遇到的问题,需要将TAG按照首字母分类进行排序。百度查到一组基于php和mysql的代码很好用,将代码分享于此,存档备案。请忽略效率之类的东西,这玩意儿要效率就没技巧。
function Nobird_GET_PYTAG($re){ // eg: Nobird_GET_PYTAG('B'); global $zbp; $shouzimu=strtoupper($re); //传过来的参数转大写 $array = $zbp->GetTagList('','',array('tag_Count'=>'DESC'),'',''); $str=''; $i=0; foreach($array as $tag){ //对每一列进行判断{$tag->Name} $panduan=ff_letter_first($tag->Name);//调用下面的方法 if($panduan==$shouzimu){ //如果判断的值==首字母 print_r($tag->Name); //打印出来 debug $str.=$tag->Name; $i++;if ($i==2){break;} //限制每个首字母最多查询量 } } @file_put_contents($zbp->usersdir . 'theme/'.$GLOBALS['Nobird_Theme_Name'].'/include/'.$GLOBALS['Nobird_Theme_Name'].'_PYTAG.php', $str,FILE_APPEND); //输出到文本 } //生成字母前缀 function ff_letter_first($s0){ $firstchar_ord=ord(strtoupper($s0{0})); if (($firstchar_ord>=65 and $firstchar_ord<=91)or($firstchar_ord>=48 and $firstchar_ord<=57)) return $s0{0}; $s=iconv("UTF-8","gb2312", $s0); $asc=ord($s{0})*256+ord($s{1})-65536; if($asc>=-20319 and $asc<=-20284)return "A"; if($asc>=-20283 and $asc<=-19776)return "B"; if($asc>=-19775 and $asc<=-19219)return "C"; if($asc>=-19218 and $asc<=-18711)return "D"; if($asc>=-18710 and $asc<=-18527)return "E"; if($asc>=-18526 and $asc<=-18240)return "F"; if($asc>=-18239 and $asc<=-17923)return "G"; if($asc>=-17922 and $asc<=-17418)return "H"; if($asc>=-17417 and $asc<=-16475)return "J"; if($asc>=-16474 and $asc<=-16213)return "K"; if($asc>=-16212 and $asc<=-15641)return "L"; if($asc>=-15640 and $asc<=-15166)return "M"; if($asc>=-15165 and $asc<=-14923)return "N"; if($asc>=-14922 and $asc<=-14915)return "O"; if($asc>=-14914 and $asc<=-14631)return "P"; if($asc>=-14630 and $asc<=-14150)return "Q"; if($asc>=-14149 and $asc<=-14091)return "R"; if($asc>=-14090 and $asc<=-13319)return "S"; if($asc>=-13318 and $asc<=-12839)return "T"; if($asc>=-12838 and $asc<=-12557)return "W"; if($asc>=-12556 and $asc<=-11848)return "X"; if($asc>=-11847 and $asc<=-11056)return "Y"; if($asc>=-11055 and $asc<=-10247)return "Z"; return 0;//null }
不得不说ZBP的Getlist系列很好用(虽然我还没太用懂)。
转载请注明:鸟儿博客 » Z-Blog PHP 通过首字母查询TAG