php拼音检索

电玩女神 2022-06-03 00:18 235阅读 0赞

1. 系统使用拼音搜索，表里面加入三个字段即可  
即 拼音字段 pinyin 首字母字段  first\_word 简写字段 short\_cut

如下表：

<table style="border-collapse:collapse"> 
 <tbody> 
 <tr> 
 <td style="width:58.0px; height:14.0px; border-style:solid; border-width:1.0px 1.0px 1.0px 1.0px; border-color:#aaaaaa #aaaaaa #aaaaaa #aaaaaa; padding:0.0px 2.0px 2.0px 2.0px"> id </td> 
 <td style="width:58.0px; height:14.0px; border-style:solid; border-width:1.0px 1.0px 1.0px 1.0px; border-color:#aaaaaa #aaaaaa #aaaaaa #aaaaaa; padding:0.0px 2.0px 2.0px 2.0px"> city </td> 
 <td style="width:58.0px; height:14.0px; border-style:solid; border-width:1.0px 1.0px 1.0px 1.0px; border-color:#aaaaaa #aaaaaa #aaaaaa #aaaaaa; padding:0.0px 2.0px 2.0px 2.0px"> pinyin </td> 
 <td style="width:58.0px; height:14.0px; border-style:solid; border-width:1.0px 1.0px 1.0px 1.0px; border-color:#aaaaaa #aaaaaa #aaaaaa #aaaaaa; padding:0.0px 2.0px 2.0px 2.0px"> first_word </td> 
 <td style="width:58.0px; height:14.0px; border-style:solid; border-width:1.0px 1.0px 1.0px 1.0px; border-color:#aaaaaa #aaaaaa #aaaaaa #aaaaaa; padding:0.0px 2.0px 2.0px 2.0px"> short_cut </td> 
 </tr> 
 <tr> 
 <td style="width:58.0px; height:14.0px; border-style:solid; border-width:1.0px 1.0px 1.0px 1.0px; border-color:#aaaaaa #aaaaaa #aaaaaa #aaaaaa; padding:0.0px 2.0px 2.0px 2.0px"> 1 </td> 
 <td style="width:58.0px; height:14.0px; border-style:solid; border-width:1.0px 1.0px 1.0px 1.0px; border-color:#aaaaaa #aaaaaa #aaaaaa #aaaaaa; padding:0.0px 2.0px 2.0px 2.0px"> 北京 </td> 
 <td style="width:58.0px; height:14.0px; border-style:solid; border-width:1.0px 1.0px 1.0px 1.0px; border-color:#aaaaaa #aaaaaa #aaaaaa #aaaaaa; padding:0.0px 2.0px 2.0px 2.0px"> beijing </td> 
 <td style="width:58.0px; height:14.0px; border-style:solid; border-width:1.0px 1.0px 1.0px 1.0px; border-color:#aaaaaa #aaaaaa #aaaaaa #aaaaaa; padding:0.0px 2.0px 2.0px 2.0px"> b </td> 
 <td style="width:58.0px; height:14.0px; border-style:solid; border-width:1.0px 1.0px 1.0px 1.0px; border-color:#aaaaaa #aaaaaa #aaaaaa #aaaaaa; padding:0.0px 2.0px 2.0px 2.0px"> bj </td> 
 </tr> 
 <tr> 
 <td style="width:58.0px; height:14.0px; border-style:solid; border-width:1.0px 1.0px 1.0px 1.0px; border-color:#aaaaaa #aaaaaa #aaaaaa #aaaaaa; padding:0.0px 2.0px 2.0px 2.0px"> 2 </td> 
 <td style="width:58.0px; height:14.0px; border-style:solid; border-width:1.0px 1.0px 1.0px 1.0px; border-color:#aaaaaa #aaaaaa #aaaaaa #aaaaaa; padding:0.0px 2.0px 2.0px 2.0px"> 杭州 </td> 
 <td style="width:58.0px; height:14.0px; border-style:solid; border-width:1.0px 1.0px 1.0px 1.0px; border-color:#aaaaaa #aaaaaa #aaaaaa #aaaaaa; padding:0.0px 2.0px 2.0px 2.0px"> hangzhou </td> 
 <td style="width:58.0px; height:14.0px; border-style:solid; border-width:1.0px 1.0px 1.0px 1.0px; border-color:#aaaaaa #aaaaaa #aaaaaa #aaaaaa; padding:0.0px 2.0px 2.0px 2.0px"> h </td> 
 <td style="width:58.0px; height:14.0px; border-style:solid; border-width:1.0px 1.0px 1.0px 1.0px; border-color:#aaaaaa #aaaaaa #aaaaaa #aaaaaa; padding:0.0px 2.0px 2.0px 2.0px"> hz </td> 
 </tr> 
 <tr> 
 <td style="width:58.0px; height:14.0px; border-style:solid; border-width:1.0px 1.0px 1.0px 1.0px; border-color:#aaaaaa #aaaaaa #aaaaaa #aaaaaa; padding:0.0px 2.0px 2.0px 2.0px"> 3 </td> 
 <td style="width:58.0px; height:14.0px; border-style:solid; border-width:1.0px 1.0px 1.0px 1.0px; border-color:#aaaaaa #aaaaaa #aaaaaa #aaaaaa; padding:0.0px 2.0px 2.0px 2.0px"> 广州 </td> 
 <td style="width:58.0px; height:14.0px; border-style:solid; border-width:1.0px 1.0px 1.0px 1.0px; border-color:#aaaaaa #aaaaaa #aaaaaa #aaaaaa; padding:0.0px 2.0px 2.0px 2.0px"> guangzhou </td> 
 <td style="width:58.0px; height:14.0px; border-style:solid; border-width:1.0px 1.0px 1.0px 1.0px; border-color:#aaaaaa #aaaaaa #aaaaaa #aaaaaa; padding:0.0px 2.0px 2.0px 2.0px"> g </td> 
 <td style="width:58.0px; height:14.0px; border-style:solid; border-width:1.0px 1.0px 1.0px 1.0px; border-color:#aaaaaa #aaaaaa #aaaaaa #aaaaaa; padding:0.0px 2.0px 2.0px 2.0px"> gz </td> 
 </tr> 
 <tr> 
 <td style="width:58.0px; height:14.0px; border-style:solid; border-width:1.0px 1.0px 1.0px 1.0px; border-color:#aaaaaa #aaaaaa #aaaaaa #aaaaaa; padding:0.0px 2.0px 2.0px 2.0px"> 4 </td> 
 <td style="width:58.0px; height:14.0px; border-style:solid; border-width:1.0px 1.0px 1.0px 1.0px; border-color:#aaaaaa #aaaaaa #aaaaaa #aaaaaa; padding:0.0px 2.0px 2.0px 2.0px"> 上海 </td> 
 <td style="width:58.0px; height:14.0px; border-style:solid; border-width:1.0px 1.0px 1.0px 1.0px; border-color:#aaaaaa #aaaaaa #aaaaaa #aaaaaa; padding:0.0px 2.0px 2.0px 2.0px"> shanghai </td> 
 <td style="width:58.0px; height:14.0px; border-style:solid; border-width:1.0px 1.0px 1.0px 1.0px; border-color:#aaaaaa #aaaaaa #aaaaaa #aaaaaa; padding:0.0px 2.0px 2.0px 2.0px"> s </td> 
 <td style="width:58.0px; height:14.0px; border-style:solid; border-width:1.0px 1.0px 1.0px 1.0px; border-color:#aaaaaa #aaaaaa #aaaaaa #aaaaaa; padding:0.0px 2.0px 2.0px 2.0px"> sh </td> 
 </tr> 
 </tbody> 
</table>

这样不管是搜索全拼还是 输入简拼 或者首字母 均可使用  like  完成

2. 有些旧表并未维护拼音，可以把常见的字存入字表

可将常见字存入常用字拼音表，常见字可参考。

3. 使用第三方库

拼音库：[ https://github.com/overtrue/pinyin][https_github.com_overtrue_pinyin]

[https_github.com_overtrue_pinyin]: https://github.com/overtrue/pinyin