function getActivityCombo() { // Select all the rows in the categories table marked as a persistent activity $query = "SELECT * FROM categories WHERE is_per_activity = 1 ORDER BY name ASC"; echo executePDO(false, $query, array(), function ($PDO_prep) { $spaces = " "; $select = "<select name='activity'>\n"; $select = $select . "{$spaces} <option value='no-selection' id='no-activity'>Add Activity</option>\n"; while ($row = $PDO_prep->fetch(PDO::FETCH_ASSOC)) { $select = $select . "{$spaces} <option value='{$row['path']}'>{$row['name']}</option>\n"; } $select = $select . "{$spaces}</select>\n"; return $select; }); }
function getVenueCombo() { // Select all the rows in the categories table marked as a venue $query = "SELECT * FROM categories WHERE is_venue = 1 ORDER BY name ASC"; echo executePDO(false, $query, array(), function ($PDO_prep) { $spaces = " "; $select = "<select id='venue-type' name='venue-type' style='width:100%;'>\n"; $select = $select . "{$spaces} <option value='no-selection' id='no-cat'>Select Category</option>\n"; while ($row = $PDO_prep->fetch(PDO::FETCH_ASSOC)) { $select = $select . "{$spaces} <option value='{$row['path']}'>{$row['name']}</option>\n"; } $select = $select . "{$spaces}</select>\n"; return $select; }); }
// Add GEO Clause if ($catClause != "" || $dateClause != "") { $query = $query . " AND "; $query = $query . "(venues.lat > :start_lat AND venues.lat < :end_lat AND venues.lng > :start_lng AND venues.lng < :end_lng)"; $parm_vals[':start_lat'] = $startLat; $parm_vals[':end_lat'] = $endLat; $parm_vals[':start_lng'] = $startLng; $parm_vals[':end_lng'] = $endLng; } // Close Where parenthesis (opened before adding clauses) and LIMIT Clause $query = "{$query} ) LIMIT :first_rec ,{$NUM_EVENTS}"; $parm_vals[':first_rec'] = $page * $NUM_EVENTS; echo header("Content-type: text/json"); try { $results = executePDO(false, $query, $parm_vals, function ($PDO_prep) { $json_record_format = '{event_name : "%s", venue_name : "%s", performer_name : "%s", event_format_id : %d, persistent : %s, lat : %f, lon : %f, type : "%s", date : "%s", time : "%s"}'; $json_record_array = array(); $count = 0; // Iterate through the rows while ($row = $PDO_prep->fetch(PDO::FETCH_ASSOC)) { // check the documentation for the other options here $json_record_array[$count] = sprintf($json_record_format, str_replace('"', "”", str_replace("'", "’", $row['EVENT_NAME'])), str_replace('"', "”", str_replace("'", "’", $row['VENUE_NAME'])), str_replace('"', "”", str_replace("'", "’", $row['performer_id'])), $row['event_format_id'], $row['persistent'], $row['lat'], $row['lng'], $row['type'], $row['date'], $row['time']); $count++; } return $json_record_array; }); echo "[" . join(",", $results) . "]"; } catch (Execution $e) { //@todo: need to handle this error case in the browser echo "{ error : " . $e->getMessage() . "}"; }
$query = "SELECT venues.*, categories.name AS type FROM venues, categories WHERE venues.name LIKE :searchString AND lat BETWEEN :startLat AND :endLat AND lng BETWEEN :startLng AND :endLng AND venues.type = categories.path"; # Add Venue Name Search String $searchString = $_GET["searchString"]; $startLat = $_GET["startLat"]; $endLat = $_GET["endLat"]; $startLng = $_GET["startLng"]; $endLng = $_GET["endLng"]; $parm_vals['searchString'] = "%" . $searchString . "%"; $parm_vals['startLat'] = $startLat; $parm_vals['endLat'] = $endLat; $parm_vals['startLng'] = $startLng; $parm_vals['endLng'] = $endLng; echo header("Content-type: text/json"); try { $results = executePDO(false, $query, $parm_vals, function ($PDO_prep) { $json_record_format = '{venueId : "%s", venueName : "%s", address : "%s", phone : "%s", description : "%s", lat : %f, lng : %f, type : "%s"}'; $json_record_array = array(); $count = 0; // Iterate through the rows while ($row = $PDO_prep->fetch(PDO::FETCH_ASSOC)) { // check the documentation for the other options here $json_record_array[$count] = sprintf($json_record_format, str_replace('"', "”", str_replace("'", "’", $row['id'])), str_replace('"', "”", str_replace("'", "’", $row['name'])), str_replace('"', "”", str_replace("'", "’", $row['address'])), str_replace('"', "”", str_replace("'", "’", $row['phone'])), str_replace('"', "”", str_replace("'", "’", $row['description'])), $row['lat'], $row['lng'], $row['type']); $count++; } return $json_record_array; }); echo "[" . join(",", $results) . "]"; } catch (Execution $e) { //@todo: need to handle this error case in the browser echo "{ error : " . $e->getMessage() . "}"; }