Управление сайтом

Файловый менеджер

Имя файла	searchEngine.php
Содержимое	<?php $base_url="../../"; require_once($base_url."../func.php"); $l=db_connect(); header("Content-type: text/html; charset=windows-1251"); $searchStr = iconv('UTF-8', 'WINDOWS-1251', $_POST['searchStr']); /$query = "SELECT firma.id, firma.name, firma.adress, firma.home, firma.email, firma.last_modified, firma.status, GROUP_CONCAT(otrasl2.name_otrsl SEPARATOR '//') AS otrasli FROM rubrik2 JOIN otrasl2 ON otrasl2.id = rubrik2.id_rubrik JOIN firma ON firma.id = rubrik2.id_firm WHERE firma.name LIKE '%{$searchStr}%' GROUP BY firma.name";/ $query = "SELECT firma.id, firma.name, firma.adress, firma.home, firma.email, firma.last_modified, firma.status, GROUP_CONCAT(otrasl2.name_otrsl SEPARATOR '//') AS otrasli FROM firma LEFT JOIN rubrik2 ON firma.id = rubrik2.id_firm LEFT JOIN otrasl2 ON otrasl2.id = rubrik2.id_rubrik WHERE firma.name LIKE '%{$searchStr}%' GROUP BY firma.name"; $searchResult = fetchAll($query); //convert cp1251 from DB to utf-8 for json_encode for ($i = 0; $i < count($searchResult); $i++) { $searchResult[$i]['otrasli'] = iconv("WINDOWS-1251", "UTF-8", $searchResult[$i]['otrasli']); $searchResult[$i]['name'] = iconv("WINDOWS-1251", "UTF-8", $searchResult[$i]['name']); $searchResult[$i]['adress'] = iconv("WINDOWS-1251", "UTF-8", $searchResult[$i]['adress']); } $searchResult = json_encode($searchResult); print($searchResult); ?>

/admin/firma2/search/

/admin/firma2/search