function search_handler($query, $config) { $result = 0; $stand = 32; $lim1 = 0; $lim2 = 32; extract($query); if (isset($p)) { if ($p != '1') { $lim1 = $stand * ($p - 1); $lim2 = $lim1 + $stand; } } $sear = new search(new dbc($config), $filterby); $products = new product(new dbc($config)); //new search if (isset($search1)) { if (empty($searchkey1)) { if ($sub_category == '*' && $supplier == '*') { $count = $sear->count_new_pro_list(); $result = $sear->search10_subcat10_supp10($lim1, $lim2); } if ($sub_category != '*' && $supplier == '*') { $count = $sear->count_search10_subcat11_supp10($sub_category); $result = $sear->search10_subcat11_supp10($sub_category, $lim1, $lim2); } if ($sub_category == '*' && $supplier != '*') { $count = $sear->count_search10_subcat10_supp11($supplier); $result = $sear->search10_subcat10_supp11($supplier, $lim1, $lim2); } if ($sub_category != '*' && $supplier != '*') { $count = $sear->count_search10_subcat11_supp11($sub_category, $supplier); $result = $sear->search10_subcat11_supp11($sub_category, $supplier, $lim1, $lim2); } } //active search if (!empty($searchkey1)) { if ($sub_category == '*' && $supplier == '*') { $count = $sear->count_search11_subcat10_supp10($searchkey1); $result = $sear->search11_subcat10_supp10($searchkey1, $lim1, $lim2); } if ($sub_category != '*' && $supplier == '*') { $count = $sear->count_search11_subcat11_supp10($sub_category, $searchkey1); $result = $sear->search11_subcat11_supp10($sub_category, $searchkey1, $lim1, $lim2); } if ($sub_category == '*' && $supplier != '*') { $count = $sear->count_search11_subcat10_supp11($supplier, $searchkey1); $result = $sear->search11_subcat10_supp11($supplier, $searchkey1, $lim1, $lim2); } if ($sub_category != '*' && $supplier != '*') { $count = $sear->count_search11_subcat11_supp11($sub_category, $supplier, $searchkey1); $result = $sear->search11_subcat11_supp11($sub_category, $supplier, $searchkey1, $lim1, $lim2); } } } if (isset($search2)) { if (empty($searchkey2)) { if ($category == '*' && $supplier == '*') { $count = $sear->count_active_pro_list(); $result = $sear->search20_subcat20_supp20($lim1, $lim2); } if ($category != '*' && $supplier == '*') { $count = $sear->count_search20_subcat21_supp20($category); $result = $sear->search20_subcat21_supp20($category, $lim1, $lim2); } if ($category == '*' && $supplier != '*') { $count = $sear->count_search20_subcat20_supp21($supplier); $result = $sear->search20_subcat20_supp21($supplier, $lim1, $lim2); } if ($category != '*' && $supplier != '*') { $count = $sear->count_search20_subcat21_supp21($category, $supplier); $result = $sear->search20_subcat21_supp21($category, $supplier, $lim1, $lim2); } } if (!empty($searchkey2)) { if ($category == '*' && $supplier == '*') { $count = $sear->count_search21_subcat20_supp20($searchkey2); $result = $sear->search21_subcat20_supp20($searchkey2, $lim1, $lim2); } if ($category != '*' && $supplier == '*') { $count = $sear->count_search21_subcat21_supp20($category, $searchkey2); $result = $sear->search21_subcat21_supp20($category, $searchkey2, $lim1, $lim2); } if ($category == '*' && $supplier != '*') { $count = $sear->count_search21_subcat20_supp21($supplier, $searchkey2); $result = $sear->search21_subcat20_supp21($supplier, $searchkey2, $lim1, $lim2); } if ($category != '*' && $supplier != '*') { $count = $sear->count_search21_subcat21_supp21($category, $supplier, $searchkey2); $result = $sear->search21_subcat21_supp21($category, $supplier, $searchkey2, $lim1, $lim2); } } } //archived search if (isset($search3)) { if (empty($searchkey3)) { if ($category == '*' && $supplier == '*') { $count = $sear->count_archived_pro_list(); $result = $sear->search30_subcat30_supp30($lim1, $lim2); } if ($category != '*' && $supplier == '*') { $count = $sear->count_search30_subcat31_supp30($category); $result = $sear->search30_subcat31_supp30($category, $lim1, $lim2); } if ($category == '*' && $supplier != '*') { $count = $sear->count_search30_subcat30_supp31($supplier); $result = $sear->search30_subcat30_supp31($supplier, $lim1, $lim2); } if ($category != '*' && $supplier != '*') { $count = $sear->count_search30_subcat31_supp31($category, $supplier); $result = $sear->search30_subcat31_supp31($category, $supplier, $lim1, $lim2); } } if (!empty($searchkey3)) { if ($category == '*' && $supplier == '*') { $count = $sear->count_search31_subcat30_supp30($searchkey3); $result = $sear->search31_subcat30_supp30($searchkey3, $lim1, $lim2); } if ($category != '*' && $supplier == '*') { $count = $sear->count_search31_subcat31_supp30($category, $searchkey3); $result = $sear->search31_subcat31_supp30($category, $searchkey3, $lim1, $lim2); } if ($category == '*' && $supplier != '*') { $count = $sear->count_search31_subcat30_supp31($supplier, $searchkey3); $result = $sear->search31_subcat30_supp31($supplier, $searchkey3, $lim1, $lim2); } if ($category != '*' && $supplier != '*') { $count = $sear->count_search31_subcat31_supp31($category, $supplier, $searchkey3); $result = $sear->search31_subcat31_supp31($category, $supplier, $searchkey3, $lim1, $lim2); } } } $count = mysqli_fetch_row($count); $count = $count[0]; $noPag = $count / $stand; if ($noPag == '0') { $noPag = 1; } if ($noPag == '0') { $noPag = 1; } if ($count < $stand) { $noPag = 1; } elseif ($count % $stand == true) { $noPag += 1; } if ($count < $lim2) { $lim2 = $count; } return $y = array($result, $count, $lim2, $noPag); }