mysql 全文检索中文解决方法及实例代码

mysql 全文检索中文解决方法

            最近公司项目要求这样的功能，在数据库中检索中文，很是棘手，上网查询下资料，找的类似文章，这里及记录下，希望能帮助到大家，

实例代码：   

<?php
/*
mysql全文检索中文解决方案！
*/
error_reporting(e_error | e_warning | e_parse);
ini_set('display_errors', '1');
//数据库支持
class saemysql{
//phpmysql操作类
}
$dbs=new saemysql;
//数据加入
echo '2';
/*创建数据表*/
$dbs->runsql('create table if not exists `ces_articles` (
`id` mediumint(8) unsigned not null auto_increment,
`title` varchar(255) collate utf8_unicode_ci not null default \'\',
`url` varchar(255) character set utf8 collate utf8_bin default null,
primary key (`id`),
fulltext key `url` (`url`)
) engine=myisam auto_increment=1 default charset=utf8 collate=utf8_unicode_ci row_format=dynamic');
/*数据加入*/
$title='我爱大家啊，大家好';
$dbs->runsql('insert into `ces_articles` (id,title,url) values (0,\''. $title.'\',\''.str_replace('\u','u',trim(json_encode($title))).'\')');
$title='中国是什么';
$dbs->runsql('insert into `ces_articles` (id,title,url) values (0,\''. $title.'\',\''.str_replace('\u','u',trim(json_encode($title))).'\')');
$title='http://ask.1912news.com';
$dbs->runsql('insert into `ces_articles` (id,title,url) values (0,\''. $title.'\',\''.str_replace('\u','u',trim(json_encode($title))).'\')');
$title='问答系统';
$dbs->runsql('insert into `ces_articles` (id,title,url) values (0,\''. $title.'\',\''.str_replace('\u','u',trim(json_encode($title))).'\')');
$title='1912网';
$dbs->runsql('insert into `ces_articles` (id,title,url) values (0,\''. $title.'\',\''.str_replace('\u','u',trim(json_encode($title))).'\')');
$title='零九网络';
$dbs->runsql('insert into `ces_articles` (id,title,url) values (0,\''. $title.'\',\''.str_replace('\u','u',trim(json_encode($title))).'\')');
//搜索：
$_get['q']="中国";
echo 'q';
if(isset($_get['q'])){$sql=' match(url) against (\''.str_replace('\u','u',trim(json_encode($_get['q']))).'\' in boolean mode)';}
$query = $dbs->getdata('select * from `ces_articles` where '.$sql.' limit 10');
echo 'q';
if($query){
foreach ($query as $article){
echo $article['id'];
}
}

?>

感谢阅读，希望能帮助到大家，谢谢大家对本站的支持！