mysql 全文檢索中文解決方法及實例代碼分享

<?php /*  mysql全文檢索中文解決方案！  */  error_reporting(E_ERROR | E_WARNING | E_PARSE);  ini_set(&#39;display_errors&#39;, &#39;1&#39;);  //數據庫支持  class SaeMysql{  //phpmysql操作類  }  $DBS=new SaeMysql;  //數據加入  echo &#39;2&#39;;  /*創建數據表*/  $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-&gt;runSql('INSERT?INTO?`ces_articles`?(id,title,url)?VALUES?(0,''.?$title.'',''.str_replace('u','u',trim(json_encode($title))).'')');  $title='中國是什么';  $DBS-&gt;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-&gt;runSql('INSERT?INTO?`ces_articles`?(id,title,url)?VALUES?(0,''.?$title.'',''.str_replace('u','u',trim(json_encode($title))).'')');  $title='問答系統';  $DBS-&gt;runSql('INSERT?INTO?`ces_articles`?(id,title,url)?VALUES?(0,''.?$title.'',''.str_replace('u','u',trim(json_encode($title))).'')');  $title='1912網';  $DBS-&gt;runSql('INSERT?INTO?`ces_articles`?(id,title,url)?VALUES?(0,''.?$title.'',''.str_replace('u','u',trim(json_encode($title))).'')');  $title='零九網絡';  $DBS-&gt;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-&gt;getData('SELECT?*?FROM?`ces_articles`?where?'.$sql.'?LIMIT?10');  echo?'q';  if($query){  foreach?($query?as?$article){  echo?$article['id'];  }  }    ?&gt;