Joomla 3.x Релевантный поиск по zoo (jbzoo)

тему в раздел "юмор"

Ну я тестил с разными: http://salonsuzana.ru/allcoupons.html

Через хаки...

Код (CODE):

1. if($search){
2.  
3. $searchData = explode(' ', $search);
4. $searchWhere = array();
5.  
6. $from .=' LEFT JOIN '. ZOO_TABLE_SEARCH .' AS s ON a.id = s.item_id';
7.  
8. foreach($searchData as $searchWord){
9.  
10. $searchWord =JString::trim($searchWord);
11.  
12. $searchWhere[]= implode(' OR ', array(
13. // 'LOWER(a.name) REGEXP ' . $this->db->Quote('^' . $this->db->escape($searchWord, true) . '', false),
14. // 'LOWER(a.name) REGEXP ' . $this->db->Quote('' . $this->db->escape($searchWord, true) . '$', false),
15. // 'LOWER(a.name) REGEXP ' . $this->db->Quote(' ' . $this->db->escape($searchWord, true) . '', false),
16. // 'LOWER(a.name) REGEXP ' . $this->db->Quote('' . $this->db->escape($searchWord, true) . ' ', false),
17. 'LOWER(a.name) REGEXP '. $this->db->Quote('[[:<:]]'. $this->db->escape($searchWord,true).'[[:>:]]',false)
18.  
19. ));
20. }
21.  
22. $where[]='(('. implode(') AND (', $searchWhere).'))';
23. }

 

По сути это построение запроса же:

Код (CODE):

1. $from .=' LEFT JOIN '. ZOO_TABLE_SEARCH .' AS s ON a.id = s.item_id';
2.  
3.  
4. $searchWhere[]= implode(' OR ', array(
5. // 'LOWER(a.name) REGEXP ' . $this->db->Quote('^' . $this->db->escape($searchWord, true) . '', false),
6. // 'LOWER(a.name) REGEXP ' . $this->db->Quote('' . $this->db->escape($searchWord, true) . '$', false),
7. // 'LOWER(a.name) REGEXP ' . $this->db->Quote(' ' . $this->db->escape($searchWord, true) . '', false),
8. // 'LOWER(a.name) REGEXP ' . $this->db->Quote('' . $this->db->escape($searchWord, true) . ' ', false),
9. 'LOWER(a.name) REGEXP '. $this->db->Quote('[[:<:]]'. $this->db->escape($searchWord,true).'[[:>:]]',false)
10.  
11. ));
12. }
13.  
14. //AND и то и то
15. $where[]='(('. implode(') AND (', $searchWhere).'))';
16. }