accident-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 accidents");
   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 } else {
  16         $limit_explode = explode(",", $_GET['limit']);
  17         $limit_start = $limit_explode[0];
  18         $limit_end = $limit_explode[1];
  19         if (!ctype_digit(strval($limit_start)) || !ctype_digit(strval($limit_end))) {
  20                 $limit_start = 0;
  21                 $limit_end = 25;
  22         }
  23 }
  24 $absolute_difference = abs($limit_start - $limit_end);
  25 $limit_next = $limit_end + $absolute_difference;
  26 $limit_previous_1 = $limit_start - $absolute_difference;
  27 $limit_previous_2 = $limit_end - $absolute_difference;
  28
  29
  30 print '<div class="info column">';
  31 print '<h1>'._("Latest Accidents").'</h1>';
  32 print '</div>';
  33
  34 print '<div class="table column">';
  35 print '<p>'._("The table below shows the latest Accidents.").'</p>';
  36 $spotter_array = $Accident->getAccidentData($limit_start.",".$absolute_difference,'accident');
  37 if (!empty($spotter_array) && isset($spotter_array[0]['query_number_rows']) && $spotter_array[0]['query_number_rows'] != 0) {
  38         include('table-output.php');
  39         print '<div class="pagination">';
  40         if ($limit_previous_1 >= 0) print '<a href="'.$page_url.'/'.$limit_previous_1.','.$limit_previous_2.'">&laquo;'._("Previous Page").'</a>';
  41         if ($spotter_array[0]['query_number_rows'] == $absolute_difference) print '<a href="'.$page_url.'/'.$limit_end.','.$limit_next.'">'._("Next Page").'&raquo;</a>';
  42         print '</div>';
  43 }
  44 print '</div>';
  45
  46 require_once('footer.php');
  47 ?>