php 按字母搜索 代码,PHP/MYSQL实现按字母检索

方法一：建一个拼音表 t_cosler ，存放每个字母开头的第一个汉字的编号和最后一个汉字的编号。

BatchFile code+------+--------+-------+

| f_PY | cBegin | cEnd  |

+------+--------+-------+

| A    |  45217 | 45252 |

| B    |  45253 | 45760 |

.....

| Z    |  54481 | 55289 |

+------+--------+-------+

然后直接查询就行了。

SQL codemysql> create table t_cosler(

->  f_PY char primary key,

->  cBegin  SMALLINT UNSIGNED not null,

->  cEnd    SMALLINT UNSIGNED not null

-> );

Query OK, 0 rows affected (0.09 sec)

mysql> insert into t_cosler values

-> ('A',0xB0A1,0xB0C4),

-> ('B',0xB0C5,0xB2C0),

-> ('C',0xB2C1,0xB4ED),

-> ('D',0xB4EE,0xB6E9),

-> ('E',0xB6EA,0xB7A1),

-> ('F',0xB7A2,0xB8C0),

-> ('G',0xB8C1,0xB9FD),

-> ('H',0xB9FE,0xBBF6),

-> ('J',0xBBF7,0xBFA5),

-> ('K',0xBFA6,0xC0AB),

-> ('L',0xC0AC,0xC2E7),

-> ('M',0xC2E8,0xC4C2),

-> ('N',0xC4C3,0xC5B5),

-> ('O',0xC5B6,0xC5BD),

-> ('P',0xC5BE,0xC6D9),

-> ('Q',0xC6DA,0xC8BA),

-> (