| Line 1177... |
Line 1177... |
| 1177 |
$lowUsed = floatval($_SESSION['lowestPrice']['Used']);
|
1177 |
$lowUsed = floatval($_SESSION['lowestPrice']['Used']);
|
| 1178 |
$lowDigital = floatval($_SESSION['lowestPrice']['Digital']);
|
1178 |
$lowDigital = floatval($_SESSION['lowestPrice']['Digital']);
|
| 1179 |
$lowBook = floatval($_SESSION['lowestPrice']['Book']);
|
1179 |
$lowBook = floatval($_SESSION['lowestPrice']['Book']);
|
| 1180 |
$count = count($_SESSION['resultArr']);
|
1180 |
$count = count($_SESSION['resultArr']);
|
| 1181 |
$userId = (empty($_SESSION['sessData']['userID']) ? 'NULL' : $_SESSION['sessData']['userID']);
|
1181 |
$userId = (empty($_SESSION['sessData']['userID']) ? 'NULL' : $_SESSION['sessData']['userID']);
|
| - |
|
1182 |
$ip = inet_pton($_SERVER['REMOTE_ADDR']);
|
| 1182 |
|
1183 |
|
| 1183 |
$sql = "INSERT
|
1184 |
$sql = "INSERT
|
| 1184 |
INTO searches
|
1185 |
INTO searches
|
| 1185 |
(sessId, access, zip, condNew, condUsed, mediaCD, mediaRecord, mediaDigital, mediaBook, data, lowNew, lowUsed, lowDigital, lowBook, count, userId)
|
1186 |
(sessId, access, ip, zip, condNew, condUsed, mediaCD, mediaRecord, mediaDigital, mediaBook, data, lowNew, lowUsed, lowDigital, lowBook, count, userId)
|
| 1186 |
VALUES ('" . session_id() . "', '$access', '$zip', '$condNew', '$condUsed', '$mediaCD', '$mediaRecord', '$mediaDigital', '$mediaBook', '$data', $lowNew, $lowUsed, $lowDigital, $lowBook, $count, $userId)";
|
1187 |
VALUES ('" . session_id() . "', '$access', '$ip', '$zip', '$condNew', '$condUsed', '$mediaCD', '$mediaRecord', '$mediaDigital', '$mediaBook', '$data', $lowNew, $lowUsed, $lowDigital, $lowBook, $count, $userId)";
|
| 1187 |
|
1188 |
|
| 1188 |
if (!($result = mysqli_query($conn, $sql))) {
|
1189 |
if (!($result = mysqli_query($conn, $sql))) {
|
| 1189 |
error_log("MySQL Write Searches Error: " . mysqli_error($conn) . " (" . mysqli_errno($conn) . ")");
|
1190 |
error_log("MySQL Write Searches Error: " . mysqli_error($conn) . " (" . mysqli_errno($conn) . ")");
|
| 1190 |
}
|
1191 |
}
|
| 1191 |
|
1192 |
|
| Line 1493... |
Line 1494... |
| 1493 |
}
|
1494 |
}
|
| 1494 |
|
1495 |
|
| 1495 |
// compare score for sort low to high
|
1496 |
// compare score for sort low to high
|
| 1496 |
function compare_score($a, $b) {
|
1497 |
function compare_score($a, $b) {
|
| 1497 |
return ($a['score'] > $b['score']);
|
1498 |
return ($a['score'] > $b['score']);
|
| - |
|
1499 |
}
|
| - |
|
1500 |
|
| - |
|
1501 |
function my_error_log($msg) {
|
| - |
|
1502 |
error_log("[" . date("d-M-Y H:m:s") . "] " . $msg . PHP_EOL, 3, $_SERVER['DOCUMENT_ROOT'] . "/../MyFiles/logs/my_php_error.log");
|
| 1498 |
}
|
1503 |
}
|