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
?>