Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $search_word = $modx->db->escape($_GET[‘search’]);
- //Подключение к сфинксу
- $modx->db->connect('localhost:9306', null, null, null);
- //Запрос в сфинск
- $result = $modx->db->query("SELECT * FROM products WHERE MATCH('".$search_word."'); ");
- while( $row = $modx->db->getRow( $result ) ) {
- $ids[] = $row['id']; //Получили все id ресурсов
- }
- // Отключение
- $modx->db->disconnect() ;
- // Повторное подключение
- $modx->db->connect();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement