?> </pre> <h3>Filter</h3> <p>Our database can be searched by sending a <code>GET</code> request to <code><?php echo $baseurl; ?> api/filter/</code> with filter commands as variables. Each request will return the number of trails returned as <code>countReturned</code> and the total number of trails matched by the query as <code>totalMatched</code>. Note, you must set <code>offset</code> and <code>count</code>. For example, <code>GET <?php echo $baseurl; ?> api/filter/?by=city&city=Albuquerque&offset=0&count=6 </code> returns the following information in JSON:</p> <pre> <?php $filterObj = new trails(); $filterResult = $filterObj->filterByLocation("city", "Albuquerque", 0, 6, "Array"); echo json_encode($filterResult, JSON_PRETTY_PRINT); ?> </pre> <h3>Translations</h3> <p>Notice that the JSON response for trail requests includes available translations under the key <code>translations</code>. In the request illustrated above, Spanish (es) is listed as an available translation. In order to retrieve this translation, we will send a <code>GET</code> request: <code>GET <?php echo $baseurl; ?> api/translation/?id=2&lang=es</code></p> <pre> <?php echo json_encode($GetTrail->getTranslation("es", "Array"), JSON_PRETTY_PRINT);
?> about/api/ <?php echo $baseurl; ?> user/login/ <?php echo $baseurl; ?> user/create/account/ <?php echo $baseurl; ?> user/filter/ <?php $allTrailObj = new trails(); $allTrails = $allTrailObj->getAll(); $count = $allTrails['totalMatched']; $trails = $allTrails['trails']; foreach ($trails as $id => $trail) { echo $trail['url']; ?> <?php } foreach ($cities as $id => $city) { echo $baseurl . "filter/?by=city&city=" . $city; ?> <?php }
<?php require "../db.php"; $page_type = "admin"; $reportObj = new trails(); $report = $reportObj->getReport("largeImgURL", "img/placeholder-lg.png"); $count = $report['totalMatched']; $trails = $report['trails']; $title = "Missing Hero Image Report - " . $count . " Total"; $special = "breadcrumb"; $breadcrumb = '<a href="' . $baseurl . 'admin/" class="green-text text-darken-3"><i class="fa fa-home"></i></a>'; $breadcrumb .= ' <i class="fa fa-chevron-right grey-text text-darken-1" style="padding-top:1px;"></i> <a href="' . $baseurl . 'report/" class="green-text text-darken-3">Reports</a> <i class="fa fa-chevron-right grey-text text-darken-1" style="padding-top:1px;"></i> <a href="' . $baseurl . 'report/missing_img.php" class="green-text text-darken-3">Missing Images</a>'; ?> <!DOCTYPE html> <html lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1.0"/> <title>Prescription Trails</title> <!-- CSS --> <?php require "/nfs/users/clind/public_html/prescriptiontrails.org/src/style_base.php"; ?> </head> <body class="<?php echo $bodyclass; ?> ">
<?php require "/nfs/users/clind/public_html/prescriptiontrails.org/admin/db.php"; require "PHPExcel.php"; $exportTrails = new trails(); $export = $exportTrails->getAllSheet(); $count = $export['totalMatched']; $export = $export['trails']; // Instantiate a new PHPExcel object $objPHPExcel = new PHPExcel(); $objPHPExcel->getProperties()->setCreator("PT Webserver")->setLastModifiedBy("Jacob Mayfield")->setTitle("Prescription Trails Data Export")->setSubject("Prescription Trails Data Export")->setCategory("Data Dump"); // Set the active Excel worksheet to sheet 0 $objPHPExcel->setActiveSheetIndex(0); // Initialise the Excel row number $rowCount = 1; // Iterate through each result from the SQL query in turn // We fetch each database result row into $row in turn foreach ($export as $id => $trail) { if ($trail['loopcount'] == 1) { $distance = $trail['loops'][1]['distance']; $steps = $trail['loops'][1]['steps']; } else { $looptext = $trail['loopcount'] . " loops"; $distance = 0; $steps = 0; foreach ($trail['loops'] as $id => $details) { $distance = $trail['loops'][$id]['distance'] + $distance; $steps = $trail['loops'][$id]['steps'] + $steps; } } $objPHPExcel->getActiveSheet()->SetCellValue('A' . $rowCount, $trail['id']);
<?php require "../../../admin/db.php"; require "../../../src/secure.php"; header('Content-Type: application/javascript'); ?> var SearchTrails = [ <?php $all = new trails(); $result = $all->getAll(); $count = $result['totalMatched']; $trails = $result['trails']; $return = array(); foreach ($trails as $id => $trail) { ?> { value: "<?php echo $trail['name']; ?> ", label: "<?php echo $trail['name']; ?> ", id: <?php echo $trail['id']; ?> , }, <?php }
$filtertext .= $_GET['grade']; } $term = $_GET['grade']; $filtertext .= " Trails"; $filtertextsm = $filtertext; $filterObj = new trails(); $filterResult = $filterObj->filterByLocation("grade", $_GET['grade'], 0, 18, "Array"); $filterCount = $filterResult['countReturned']; $totalMatched = $filterResult['totalMatched']; $trails = $filterResult['trails']; } if ($_GET['by'] == "name") { $term = urldecode(filter_input(INPUT_GET, 'name', FILTER_SANITIZE_STRING)); $filtertext = "'" . htmlspecialchars($term, ENT_COMPAT, 'UTF-8') . "'"; $filtertextsm = $filtertext; $filterObj = new trails(); $filterResult = $filterObj->filterByTerm($term, 0, 18, "Array"); $filterCount = $filterResult['countReturned']; $totalMatched = $filterResult['totalMatched']; $trails = $filterResult['trails']; } } require "../src/nav.php"; ?> <ul class="row collapsible white z-depth-2" style="margin-top:-50px; padding-top:0px; padding-bottom:30px;"> <li> <div class="collapsible-header" id="filterheader" style="margin-top:5px;"><div class="container"><div class="row" style="margin-bottom:0px;"><div class="col s12" style="text-align:center; margin-top:-4px;">▼ Filtering Options</div></div></div></div> <div class="collapsible-body"><div class="container"><div class="row" style="margin-bottom:0px;margin-top:5px;"> <div class="input-field col s12 m4"> <select id="filterCity"> <option value="" disabled selected>Choose city</option>
require "/nfs/users/clind/public_html/prescriptiontrails.org/src/nav.php"; require "../filter/error.php"; echo "</div>"; require "/nfs/users/clind/public_html/prescriptiontrails.org/src/drawer.php"; require "/nfs/users/clind/public_html/prescriptiontrails.org/src/js_base.php"; exit; } $coords = array("lat" => $_GET['lat'], "lng" => $_GET['lng']); $filterObj = new trails(); $filterResult = $filterObj->filterByLocation("coord", $coords, 0, 24, "Array"); $filterCount = $filterResult['countReturned']; $totalMatched = $filterResult['totalMatched']; $trails = $filterResult['trails']; $showLocaiton = true; } else { $allTrails = new trails(); $result = $allTrails->getAll(); $count = $result['totalMatched']; $trails = $result['trails']; $showLocaiton = false; } function limit_text($text, $limit) { if (str_word_count($text, 0) > $limit) { $words = str_word_count($text, 2); $pos = array_keys($words); $text = substr($text, 0, $pos[$limit]) . '...'; } return $text; } ?>
//Turn on output buffering, "ob_gzhandler" for the compressed page with gzip. echo '/* cached page - ' . date('l jS \\of F Y h:i:s A', filemtime($cache_file)) . ', Page : ' . $dynamic_url . ' */'; readfile($cache_file); //read Cache file $output = ob_get_contents(); ob_end_clean(); header('Content-Type: application/javascript'); echo $output; exit; //no need to proceed further, exit the flow. } //Turn on output buffering with gzip compression. ob_start(); ######## Your Website Content Starts Below ######### require "/nfs/users/clind/public_html/prescriptiontrails.org/admin/db.php"; $randomtrailObj = new trails(); $navTrails = $randomtrailObj->getAll(); $navTrails = $navTrails['trails']; header('Content-Type: application/javascript'); ob_start(); ?> map = new google.maps.Map(document.getElementById('map'), { center: {lat: 35.104912, lng: -106.629581}, scrollwheel: false, zoom: 11 }); var infowindow = new google.maps.InfoWindow({ content: "placeholder" }); <?php
<?php require "/nfs/users/clind/public_html/prescriptiontrails.org/admin/db.php"; require "/nfs/users/clind/public_html/prescriptiontrails.org/trail/Html2Text.php"; $allTrailObj = new trails(); $allTrails = $allTrailObj->getAllPrint(); $count = $allTrails['totalMatched']; $trails = $allTrails['trails']; ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>Prescription Trails</title> <!-- CSS --> <?php require "/nfs/users/clind/public_html/prescriptiontrails.org/src/style_base.php"; ?> <style> /* -------------------------------------------------------------- Hartija Css Print Framework * Version: 1.0 -------------------------------------------------------------- */ body { width:100% !important; margin:0 !important; padding:0 !important;
require "admin/db.php"; function shuffle_assoc($list) { if (!is_array($list)) { return $list; } $keys = array_keys($list); shuffle($keys); $random = array(); foreach ($keys as $key) { $random[$key] = $list[$key]; } return $random; } $randomtrailObj = new trails(); $randomtrails = $randomtrailObj->getRand(); $count = $randomtrails['totalMatched']; $trails = $randomtrails['trails']; $trails = shuffle_assoc($trails); $ids = array_keys($trails); $trails_master = $trails; $trails = array_slice($trails_master, 0, 12); $trails_next = array_slice($trails_master, 12, 6); $trails_last = array_slice($trails_master, 18, 6); ob_start(); ?> <!DOCTYPE html> <html lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
if ($_GET['by'] == "city" || $_GET['by'] == "zip" || $_GET['by'] == "grade" || $_GET['by'] == "name") { if ($_GET['by'] == "city") { $search = $_GET['city']; if (in_array($_GET['city'], $cities)) { $filterObj = new trails(); $filterResult = $filterObj->filterByLocation("city", filter_input(INPUT_GET, 'city', FILTER_SANITIZE_STRING), intval($_GET['offset']), intval($_GET['count']), "JSON"); } else { $response = array("status" => "error", "type" => "INVALID_CITY", "message" => "City not recognized. " . htmlspecialchars($_GET['city']) . " is not in our system. Filter can be used by city, zip, grade, name, or location. See " . $baseurl . "api/"); echo json_encode($response); exit; } } if ($_GET['by'] == "zip") { $filterObj = new trails(); $filterResult = $filterObj->filterByLocation("zip", intval($_GET['zip']), intval($_GET['offset']), intval($_GET['count']), "JSON"); } if ($_GET['by'] == "grade") { $filterObj = new trails(); $filterResult = $filterObj->filterByLocation("grade", intval($_GET['grade']), intval($_GET['offset']), intval($_GET['count']), "JSON"); } if ($_GET['by'] == "name") { $term = urldecode(filter_input(INPUT_GET, 'name', FILTER_SANITIZE_STRING)); $filterObj = new trails(); $filterResult = $filterObj->filterByTerm($term, intval($_GET['offset']), intval($_GET['count']), "JSON"); } } echo $filterResult; } else { $response = array("status" => "error", "type" => "INVALID_REQUEST", "message" => "Request not recognized. Filter can be used by city, zip, grade, name, or location. See " . $baseurl . "api/"); echo json_encode($response); }