$stmt->execute(); $stmt->bind_result($id, $name, $latitude, $longitude); while ($stmt->fetch()) { $search_results[] = array($id, $name, $latitude, $longitude); } $stmt->close(); } echo json_encode($search_results); break; case 'GetPlaces': if (!isset($_COOKIE['session'])) { die("Your session has expired due to inactivity.\n\nPlease reload the page."); } else { $key = $_COOKIE['session']; if (IsValidKey($key)) { RemoveKey($key); $key = InsertKey(); setcookie('session', $key, time() + KEY_TIMEOUT, '/', '', false, true); } else { setcookie('session', $key, time() - 86400, '/', '', false, true); die("Your session has expired due to inactivity.\n\nPlease reload the page."); } } RemoveExpiredKeys(); $value = json_decode($_GET['value']); $category_controller = new CategoryController($value->categories); $centre_latitude = $value->position[0]; $centre_longitude = $value->position[1]; $sql = <<<SQL t\t\tSELECT t\t\t\t*
define('KEY_TIMEOUT', 60 * 60); // 60 minutes $key = InsertKey(); setcookie('master', $key, time() + KEY_TIMEOUT, '/', '', false, true); } else { $editable = false; define('KEY_TIMEOUT', 5 * 60); // 5 minutes if (isset($_COOKIE['master'])) { setcookie('master', $_COOKIE['master'], time() - 86400, '/', '', false, true); } } include 'access.php'; InsertAccess(); if (isset($_COOKIE['session'])) { RemoveKey($_COOKIE['session']); } RemoveExpiredKeys(); $key = InsertKey(); setcookie('session', $key, time() + KEY_TIMEOUT, '/', '', false, true); ?> <!DOCTYPE html> <html> <head> <script> map_min_zoom=<?php echo $editable ? 5 : 11; ?> ; place_limit=<?php echo $editable ? -1 : 30;