'.EM_18.'';
include('footer.php');
die;
}
//*************************************************************************************************
$catId = $_GET["catId"];
//*************************************************************************************************
if ( $catId != "" )
{
$catWhere = " AND P.CATEGORY_ID IN (".getChildCategoryList($catId)." 0)";
}
else
$catWhere = "";
//*************************************************************************************************
if ( $searchText != "" && strlen($searchText) > 3 && $_GET["searchType"] != "ProductAlphabet" && $_GET["x"] == "" )
{
$res = executeQuery("SELECT ID FROM ".PREFIX."SEARCH WHERE TEXT LIKE '".handleSingleQuote($searchText)."'");
if ( $row = getRow($res) )
executeUpdate("UPDATE ".PREFIX."SEARCH SET DATE = '".getTimezoneTime($TIMEZONE)."' WHERE ID = ".$row['ID']);
else
executeUpdate("INSERT INTO ".PREFIX."SEARCH(ID, TEXT, TYPE, DATE) VALUES(".getNextId("SEARCH").", '".handleSingleQuote($searchText)."', '$searchType', '".getTimezoneTime($TIMEZONE)."')");
free($res);
}
//*************************************************************************************************
if ( $searchType == "Product Description" )
$sql = "SELECT IFNULL(P.MIN_PRICE, 0) AS PRICE_MIN, IFNULL(P.MAX_PRICE, 0) AS PRICE_MAX, IFNULL(P.STORE_COUNT, 0) AS STORE_COUNT, P.ID AS ID, P.TITLE AS TITLE, P.DETAIL AS DETAIL, P.FILENAME AS PFILENAME, C.ID AS CID, C.FILENAME AS CFILENAME, C.TITLE AS CATEGORY FROM ".PREFIX."CATEGORY C, ".PREFIX."PRODUCT P WHERE C.ID = P.CATEGORY_ID ".$catWhere." AND C.ISVALID='Y' AND P.ISVALID='Y' AND MATCH(P.DETAIL) AGAINST ('".$searchText."') AND C.LANGUAGE_ID LIKE('%".$_SESSION['lang']."%') ORDER BY MAX_BID DESC, CATEGORY";
else if ( $searchType == "ProductAlphabet" )
$sql = "SELECT IFNULL(P.MIN_PRICE, 0) AS PRICE_MIN, IFNULL(P.MAX_PRICE, 0) AS PRICE_MAX, IFNULL(P.STORE_COUNT, 0) AS STORE_COUNT, P.ID AS ID, P.TITLE AS TITLE, P.DETAIL AS DETAIL, P.FILENAME AS PFILENAME, C.ID AS CID, C.FILENAME AS CFILENAME, C.TITLE AS CATEGORY FROM ".PREFIX."CATEGORY C, ".PREFIX."PRODUCT P WHERE C.ID = P.CATEGORY_ID ".$catWhere." AND C.ISVALID='Y' AND P.ISVALID='Y' AND P.TITLE LIKE '".$searchText."%' AND C.LANGUAGE_ID LIKE('%".$_SESSION['lang']."%') ORDER BY MAX_BID DESC, CATEGORY";
else // Product Title
{
$catG="";
if(isset($_REQUEST['catg'])){
$catG = " AND C.ID='".$_REQUEST['catg']."' ";
}
//$sql = "SELECT IFNULL(P.MIN_PRICE, 0) AS PRICE_MIN, IFNULL(P.MAX_PRICE, 0) AS PRICE_MAX, IFNULL(P.STORE_COUNT, 0) AS STORE_COUNT, P.ID AS ID, P.TITLE AS TITLE, P.DETAIL AS DETAIL, P.FILENAME AS PFILENAME, C.ID AS CID, C.FILENAME AS CFILENAME, C.TITLE AS CATEGORY, IF (INSTR(P.TITLE, '".$searchText."')>0, 1, 0) AS TITLE_REL, IF (INSTR(P.DETAIL, '".$searchText."')>0, 1, 0) AS DETAIL_REL,R.BID_AMOUNT FROM ".PREFIX."PRODUCT P,".PREFIX."CATEGORY C left join PRICECOMPARISON_SEARCH_RANK R on C.ID=R.CATID WHERE C.ID = P.CATEGORY_ID ".$catWhere." AND C.ISVALID='Y' AND P.ISVALID='Y' AND ((".getSearchColumn('P.TITLE', $searchText).") OR (".getSearchColumn('P.DETAIL', $searchText).")) AND C.LANGUAGE_ID LIKE('%".$_SESSION['lang']."%') $catG GROUP BY P.MANUFACTURER_CODE ORDER BY R.BID_AMOUNT DESC,MAX_BID DESC, TITLE_REL DESC, DETAIL_REL DESC, P.STORE_COUNT DESC";
$sql = "SELECT IFNULL(P.MIN_PRICE, 0) AS PRICE_MIN, IFNULL(P.MAX_PRICE, 0) AS PRICE_MAX, IFNULL(P.STORE_COUNT, 0) AS STORE_COUNT,P.ID AS ID, P.TITLE AS TITLE, P.DETAIL AS DETAIL, P.FILENAME AS PFILENAME, C.ID AS CID, C.FILENAME AS CFILENAME, C.TITLE AS CATEGORY, IF (INSTR(P.TITLE, '".$searchText."')>0, 1, 0) AS TITLE_REL, IF (INSTR(P.DETAIL, '".$searchText."')>0, 1, 0) AS DETAIL_REL,R.BID_AMOUNT FROM ".PREFIX."PRODUCT P,".PREFIX."CATEGORY C left join PRICECOMPARISON_SEARCH_RANK R on C.ID=R.CATID WHERE C.ID = P.CATEGORY_ID ".$catWhere." AND C.ISVALID='Y' AND P.ISVALID='Y' AND MATCH (P.TITLE) AGAINST ('\"".$searchText."\"' in boolean mode) AND C.LANGUAGE_ID LIKE('%".$_SESSION['lang']."%') $catG GROUP BY P.MANUFACTURER_CODE ORDER BY R.BID_AMOUNT DESC,MAX_BID DESC, TITLE_REL DESC, DETAIL_REL DESC, P.STORE_COUNT DESC";
if(isset($_GET['limit']) && $_GET['limit']>0)
$start_limit=$limit=$_GET['limit'];
else
$start_limit=$limit=0;
if(isset($_GET['total_products']) && $_GET['total_products']>0)
{ $total_pages=$total_products=$_GET['limit']; }
else
{
$result = executeQuery($sql);
$total_pages = (getTotalRows($result) - $limit);
}
$sql = "SELECT IFNULL(P.MIN_PRICE, 0) AS PRICE_MIN, IFNULL(P.MAX_PRICE, 0) AS PRICE_MAX, IFNULL(P.STORE_COUNT, 0) AS STORE_COUNT,P.ID AS ID, P.TITLE AS TITLE, P.DETAIL AS DETAIL, P.FILENAME AS PFILENAME, C.ID AS CID, C.FILENAME AS CFILENAME, C.TITLE AS CATEGORY, IF (INSTR(P.TITLE, '".$searchText."')>0, 1, 0) AS TITLE_REL, IF (INSTR(P.DETAIL, '".$searchText."')>0, 1, 0) AS DETAIL_REL,R.BID_AMOUNT FROM ".PREFIX."PRODUCT P,".PREFIX."CATEGORY C left join PRICECOMPARISON_SEARCH_RANK R on C.ID=R.CATID WHERE C.ID = P.CATEGORY_ID ".$catWhere." AND C.ISVALID='Y' AND P.ISVALID='Y' AND MATCH (P.TITLE) AGAINST ('\"".$searchText."\"' in boolean mode) AND C.LANGUAGE_ID LIKE('%".$_SESSION['lang']."%') $catG GROUP BY P.MANUFACTURER_CODE ORDER BY R.BID_AMOUNT DESC,MAX_BID DESC, TITLE_REL DESC, DETAIL_REL DESC, P.STORE_COUNT DESC LIMIT $limit, $total_pages";
// $sql = "SELECT IFNULL(P.MIN_PRICE, 0) AS PRICE_MIN, IFNULL(P.MAX_PRICE, 0) AS PRICE_MAX, IFNULL(P.STORE_COUNT, 0) AS STORE_COUNT, P.ID AS ID, P.TITLE AS TITLE, P.DETAIL AS DETAIL, P.FILENAME AS PFILENAME, C.ID AS CID, C.FILENAME AS CFILENAME, C.TITLE AS CATEGORY, IF (INSTR(P.TITLE, '".$searchText."')>0, 1, 0) AS TITLE_REL, IF (INSTR(P.DETAIL, '".$searchText."')>0, 1, 0) AS DETAIL_REL,R.BID_AMOUNT FROM ".PREFIX."PRODUCT P,".PREFIX."CATEGORY C left join PRICECOMPARISON_SEARCH_RANK R on C.ID=R.CATID WHERE C.ID = P.CATEGORY_ID ".$catWhere." AND C.ISVALID='Y' AND P.ISVALID='Y' AND ((".getSearchColumn('P.TITLE', $searchText).")) AND C.LANGUAGE_ID LIKE('%".$_SESSION['lang']."%') $catG GROUP BY P.MANUFACTURER_CODE ORDER BY R.BID_AMOUNT DESC,MAX_BID DESC, TITLE_REL DESC, DETAIL_REL DESC, P.STORE_COUNT DESC";
if(isset($_REQUEST['sql'])){
echo "main: ".$sql." ";
}
//////////////////// SQL for Category wise result grouping //////////////////////
/*$sqlG="SELECT count(P.TITLE) AS CNT,C.ID AS CID,C.TITLE AS TTL
FROM PRICECOMPARISON_CATEGORY C, PRICECOMPARISON_PRODUCT P
WHERE C.ID = P.CATEGORY_ID AND C.ISVALID='Y' AND P.ISVALID='Y' AND (( P.TITLE LIKE '%".$searchText."%' ) OR ( P.DETAIL LIKE '%".$searchText."%' )) AND C.LANGUAGE_ID LIKE('%".$_SESSION['lang']."%') GROUP BY C.ID ORDER BY RAND() LIMIT 3";*/
$sqlG="SELECT count(P.TITLE) AS CNT,C.ID AS CID,C.TITLE AS TTL
FROM PRICECOMPARISON_CATEGORY C, PRICECOMPARISON_PRODUCT P
WHERE C.ID = P.CATEGORY_ID AND C.ISVALID='Y' AND P.ISVALID='Y' AND
MATCH (P.TITLE) AGAINST ('".$searchText."')
AND C.LANGUAGE_ID LIKE('%".$_SESSION['lang']."%') GROUP BY C.ID ORDER BY RAND() LIMIT 3";
if(isset($_REQUEST['sql1'])){
echo "rendom: ".$sqlG." ";
}
}
if($_GET['test']=='yes'){
echo $sql;}
//echo $sql; die;
//*************************************************************************************************
// Handle Magic Quotes
$searchText = str_replace("\\'", "'", $searchText);
$searchText = str_replace( '\"', '"', $searchText);
$_GET["searchText"] = str_replace("\\'", "'", $_GET["searchText"]);
$_GET["searchText"] = str_replace( '\"', '"', $_GET["searchText"]);
//*************************************************************************************************
$pageTitle = "Search Products : " . $searchText;
$pageSize = 15;
//*************************************************************************************************
include ("header.php");
$resP=$restest=executeQuery($sql);
$mySqlStart = getMicroTime();
//$resP = breakPages($sql);
$mySqlEnd = getMicroTime();
//$total_rows=getTotalRows($resP);
if(isset($_REQUEST['sql'])){
echo "Total Rows : ".getTotalRows($resP);
}
//*************************************************************************************************
?>
Merketing Text: ".$text;
}else{
$text="Marketting Text: No Marketting Text Available.";
//$text="XXXXX is a company that delivers a qualified traffic of a comparison engine with the risk-free probability of the cost per sale advertising model. Aa XXXXX";
}
$tipdata=getPartialStringtip($pDetail, 200, '');
$tipdat=str_replace('"', '`', substr($tipdata, 0, 200));
$tipdat=str_replace("'", '`', substr($tipdat, 0, 200));
$mt=str_replace('"', '`', substr($text, 0, 150));
//$tipdat=trim(substr($tipdata, 0, 150),'"');
//$mt=trim(substr($text, 0, 200),'"');
?>
:
';
$result_store_name=executeQuery("SELECT NAME FROM PRICECOMPARISON_USERINFO WHERE USERID='".$lowest_price['USERID']."'");
$store_name=getRow($result_store_name);
echo $store_name['NAME'];
echo '';
}
?>
";
echo "
