Subversion Repositories cheapmusic

Rev

Rev 7 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 7 Rev 8
Line 18... Line 18...
18 
	$_SESSION["lowestPrice"]["Digital"] = findLowest("Digital");
 18 
	$_SESSION["lowestPrice"]["Digital"] = findLowest("Digital");
19 
	$_SESSION["lowestPrice"]["All"] = 0.00;
 19 
	$_SESSION["lowestPrice"]["All"] = 0.00;
20 
	if (array_sum($_SESSION["lowestPrice"]) > 0) {
 20 
	if (array_sum($_SESSION["lowestPrice"]) > 0) {
21 
		$_SESSION["lowestPrice"]["All"] = minNotNull($_SESSION["lowestPrice"]);
 21 
		$_SESSION["lowestPrice"]["All"] = minNotNull($_SESSION["lowestPrice"]);
22 
	}
 22 
	}
- 
 
 23
- 
 
 24 
	saveSearchResult();
23 
}
 25 
}
24 
 
 26 
 
25 
  // search for items on all sites
 27 
  // search for items on all sites
26 
function searchAll($searchKey)
 28 
function searchAll($searchKey)
27 
{
 29 
{
Line 434... Line 436...
434 
	$str .= '    </div>';
 436 
	$str .= '    </div>';
435 
	$str .= '</div>';
 437 
	$str .= '</div>';
436 
 
 438 
 
437 
	return ($str);
 439 
	return ($str);
438 
}
 440 
}
- 
 
 441 
 
- 
 
 442 
	function saveSearchResult() {
- 
 
 443 
	    global $handler;
- 
 
 444 
	    $_sess_db = $handler->getDBSessionId();
- 
 
 445
- 
 
 446 
        $access = mysqli_real_escape_string($_sess_db, time());
- 
 
 447 
//  country
- 
 
 448 
//  currency
- 
 
 449 
        $zip = mysqli_real_escape_string($_sess_db, $_SESSION['buyer']['Zip']);
- 
 
 450 
        $condNew = $_SESSION['filterCondition']['New'] ? 'Y' : 'N';
- 
 
 451 
        $condUsed = $_SESSION['filterCondition']['Used'] ? 'Y' : 'N';
- 
 
 452 
        $mediaCD = $_SESSION['filterMediaType']['CD'] ? 'Y' : 'N';
- 
 
 453 
        $mediaRecord = $_SESSION['filterMediaType']['Record'] ? 'Y' : 'N';
- 
 
 454 
        $mediaDigital = $_SESSION['filterMediaType']['Digital'] ? 'Y' : 'N';
- 
 
 455 
        $data = mysqli_real_escape_string($_sess_db, $_SESSION['searchTerm']);
- 
 
 456 
        $lowNew = floatval($_SESSION['lowestPrice']['New']);
- 
 
 457 
        $lowUsed = floatval($_SESSION['lowestPrice']['Used']);
- 
 
 458 
        $lowDigital = floatval($_SESSION['lowestPrice']['Digital']);
- 
 
 459 
        $count = count($_SESSION['resultArr']);
- 
 
 460 
 
- 
 
 461 
        $sql = "INSERT
- 
 
 462 
                INTO    searches
- 
 
 463 
                (sessId, access, zip, condNew, condUsed, mediaCD, mediaRecord, mediaDigital, data, lowNew, lowUsed, lowDigital, count)
- 
 
 464 
                VALUES  ('" . session_id() . "', '$access', '$zip', '$condNew', '$condUsed', '$mediaCD', '$mediaRecord', '$mediaDigital', '$data', $lowNew, $lowUsed, $lowDigital, $count)";
- 
 
 465 
 
- 
 
 466 
        return mysqli_query($_sess_db, $sql);
- 
 
 467
- 
 
 468 
	}
439 
?>
 469 
?>