incident-latest.php

   1 <?php
   2 require_once('require/class.Connection.php');
   3 require_once('require/class.Accident.php');
   4 require_once('require/class.Language.php');
   5 $Accident = new Accident();
   6 $title = _("Latest incidents");
   7 require_once('header.php');
   8
   9 $page_url = $globalURL.'/accident-latest';
  10
  11 if(!isset($_GET['limit']))
  12 {
  13         $limit_start = 0;
  14         $limit_end = 25;
  15         $absolute_difference = 25;
  16 } else {
  17         $limit_explode = explode(",", $_GET['limit']);
  18         $limit_start = $limit_explode[0];
  19         $limit_end = $limit_explode[1];
  20         if (!ctype_digit(strval($limit_start)) || !ctype_digit(strval($limit_end))) {
  21                 $limit_start = 0;
  22                 $limit_end = 25;
  23         }
  24 }
  25 $absolute_difference = abs($limit_start - $limit_end);
  26 $limit_next = $limit_end + $absolute_difference;
  27 $limit_previous_1 = $limit_start - $absolute_difference;
  28 $limit_previous_2 = $limit_end - $absolute_difference;
  29
  30
  31 print '<div class="info column">';
  32 print '<h1>'._("Latest incidents").'</h1>';
  33 print '</div>';
  34
  35 print '<div class="table column">';
  36 print '<p>'._("The table below shows the latest Incidents.").'</p>';
  37 $spotter_array = $Accident->getAccidentData($limit_start.",".$absolute_difference,'incident');
  38 //print_r($spotter_array);
  39 if (!empty($spotter_array) && $spotter_array[0]['query_number_rows'] != 0) {
  40         include('table-output.php');
  41         print '<div class="pagination">';
  42         if ($limit_previous_1 >= 0) print '<a href="'.$page_url.'/'.$limit_previous_1.','.$limit_previous_2.'">&laquo;'._("Previous Page").'</a>';
  43         if ($spotter_array[0]['query_number_rows'] == $absolute_difference) print '<a href="'.$page_url.'/'.$limit_end.','.$limit_next.'">'._("Next Page").'&raquo;</a>';
  44         print '</div>';
  45 }
  46 print '</div>';
  47
  48 require_once('footer.php');
  49 ?>