| Код |
<?php
/*
Class MysqlSearch
Anton Velichko 10.02.2006
*/
class MysqlSearch {
var $host = ''; //Сервер подключения Mysql
var $user = 'root'; //Пользователь
var $password = ''; //Пароль
var $database = ''; //База данных
var $__activeLink = '';
var $__connectKey = '';
var $__searchMass = array();
var $where = array(); //Массив типа таблица=>row
var $what = ''; //Строка поиска
var $resultMass = array();
function MysqlSearch($host = '',$user = '',$password = '',$database = '') {
$this->host = $host;
$this->user = $user;
$this->password = $password;
$this->database = $database;
$this->__connectKey = mysql_connect($this->host,$this->user,$this->password);
mysql_select_db($this->database,$this->__connectKey);
}
function newSearch($what,$where) {
if(is_array($where) && isset($what)) {
$this->what = $what;
$this->where = $where;
$this->splitWhat();
$this->createQuery();
}
}
function getResults() {
return $this->resultMass;
}
function createQuery() {
foreach($this->where as $key => $value) {
$query = "select * from $key where ";
for($i=0;$i<count($this->__searchMass);$i++) {
foreach($value as $val)
$query.='( '.$val." rlike '".$this->__searchMass[$i]."' ) or ";
}
$query = substr($query,0,strlen($query)-4);
//echo $query;
$this->__activeLink = mysql_query($query,$this->__connectKey);
while($row = mysql_fetch_assoc($this->__activeLink)) array_push($this->resultMass,$row);
}
}
function splitWhat() {
$separators = " ,.!?-";
$wordArray = array();
$total = 0;
for($token = strtok($this->what,$separators);$token !== false;$token = strtok($separators)) {
if($token != "" ) {
if(!isset($word_count[strtolower($token)])) {
$word_count[strtolower($token)] = 1;
array_push($wordArray,strtolower($token));
}
else $word_count[strtolower($token)]++;
$total++;
}
}
for($i=0;$i<count($wordArray);$i++) {
$this->createResultMass($i,count($wordArray),$wordArray);
}
}
function createResultMass($start,$end,$mass) {
if($end > $start) {
$val = '';
for($i=$start;$i<$end;$i++) $val .= ' '.$mass[$i];
array_push($this->__searchMass,$val);
$this->createResultMass($start,$end-1,$mass);
}
}
}
/* Пример использования
$search = new MysqlSearch('host','user','password','db');
$search->newSearch('search string',array("table"=>"массив полей"));
print_r($search->getResults());
*/
?>
|
Ну как-то так короче...
Добавлено @ 19:18
| Код |
ALTER TABLE `ldu_news` ADD FULLTEXT ( `news_text`, `news_title` );
|
А так? |
http://dev.mysql.com/doc/refman/4.0/ru/fulltext-search.html 
