query("set names cp1251"); // Is there a posted query string? if(isset($_POST['queryString'])) { $queryString = trim($db->real_escape_string(iconv('UTF-8', 'windows-1251', $_POST['queryString']))); $q_row = explode(" ",$queryString); //print_r($q_row); $search = array(); foreach($q_row as $row){ $search[] = "(catalogs_products.name LIKE '%".$row."%' OR catalogs_products.text LIKE '%".$row." %' OR catalogs_products.art LIKE '%".$row." %' OR catalogs_rubrics.name LIKE '%".$row."%' OR catalogs_brends.name LIKE '%".$row."%' OR catalogs_modifications.code='".$row."')"; } //print_r($search); // Is the string length greater than 0? if(strlen($queryString) >0) { $sql = "SELECT catalogs_rubrics.translit as translit2,catalogs_rubrics.name as rubric,catalogs_brends.name as brend,catalogs_products.* FROM catalogs_products LEFT JOIN catalogs_rubrics ON catalogs_rubrics.id=catalogs_products.rubric_id LEFT JOIN catalogs_brends ON catalogs_brends.id=catalogs_products.brend_id LEFT JOIN catalogs_modifications ON catalogs_modifications.product_id=catalogs_products.id WHERE catalogs_products.count_modifications>0 "; //(catalogs_products.name LIKE '%".$queryString."%' OR catalogs_rubrics.name LIKE '%".$queryString."%' OR catalogs_brends.name LIKE '%".$queryString."%') if(count($search))$sql .= "AND (" . implode(" AND ",$search) . ") "; $sql .= " GROUP BY catalogs_products.id ORDER BY catalogs_products.id DESC limit 6"; $query = $db->query($sql); if($query) { // While there are results loop through them - fetching an Object. // Store the category id $catid = 0; while ($result = $query ->fetch_object()) { echo''; } echo 'Âñå ðåçóëüòàòû ïîèñêà'; } else { echo 'ERROR: There was a problem with the query.'; } } else { // Dont do anything. } // There is a queryString. } else { echo 'There should be no direct access to this script!'; } } ?>