Ik heb een php pagina gemaakt en gezet op www.mobihit.com/google/report.php ( inloggen met fleetinfo ps as usern)
echter als ik de volgende selectie uitvoer, zie ik nergens een foutmelding maar ook geen data.... kan mij iemand helpen met eens door de code te kijken want ik ben er al moe op gezien ???????????????
$hulp = mktime($tijdtot_uur,$tijdtot_minuten,0,$datumtot_maand,$datumtot_dag,$datumtot_jaar);
if(checkdate($datumtot_maand,$datumtot_dag,$datumtot_jaar) == false)
$fout .= "De opgegeven datum tot is niet geldig!<br/>";
$datumtot = date('m/d/Y H:i:s',$hulp);
$strdatumvan = strtotime($datumvan);
$strdatumtot = strtotime($datumtot);
if($strdatumvan > $strdatumtot)
$fout .= "De opgegeven datum van ligt niet voor de opgegeven datum tot!<br/>";
if($fout == "")
{
$result = mysql_query("SELECT * FROM VT_VGD_VEHICLEGPSDATA
where VGD_VEH_ID = '$voertuig'
and VGD_DATE_TIME >= '$datumvan'
and VGD_DATE_TIME <= '$datumtot'
order by VGD_DATE_TIME");
$count_rows = mysql_num_rows($result);
if($action=="ritoverzicht")
$code .= "<h1>RITOVERZICHT ".strtoupper($voertuig_naam)." (".date('d-m-yy')." ".date('H:i:s').")</h1>";
if($action=="ritstartstop")
$code .= "<h1>RIT START STOP ".strtoupper($voertuig_naam)." (".date('d-m-yy')." ".date('H:i:s').")</h1>";
$code .= "<br/>";
$code .= "<table width='100%' cellspacing='0' cellpadding='0'>
<th>datum (dd-mm-jj)</th>
<th>tijd (uu:mm:ss)</th>
<th align='left'>adres</th>
<th>status</th>
<th align='right'>kilometerstand</th>";
if($count_rows > 0)
{
//teller
$i = 0;
while($i<$count_rows)
{
$vehicle = mysql_fetch_array($result);
$startstop = $vehicle['VGD_START_STOP'];
if(strcmp($startstop,$start) == 0)//strings are equal
{
$startstop_text = $start_text;
$vehicleID = $vehicle['VGD_ID'];
$stop_result = mysql_query("SELECT *,
from VT_VGD_VEHICLEGPSDATA
where VGD_VEH_ID = '$voertuig'
and VGD_DATE_TIME >= '$datumvan'
and VGD_DATE_TIME <= '$datumtot'
and VGD_ID > '$vehicleID'
and VGD_START_STOP = '$stop'");
//difference in start/stop: "stilstand"
if($still_stoptime != 0)
{
$still_startdateparts = explode("/", $vehicle['DDMMYY']);
$still_starttimeparts = explode(":", $vehicle['TIME']);
$still_starttime = mktime($still_starttimeparts[0],$still_starttimeparts[1],$still_starttimeparts[2],$still_startdateparts[1],$still_startdateparts[0],$still_startdateparts[2]);
$still_difference = $still_starttime - $still_stoptime;
$still_totaldifference = $still_totaldifference + $still_difference;
}
$stop_count_rows = mysql_num_rows($stop_result);
if($stop_count_rows > 0)
{
//only the first row is important now
$stop_vehicle = mysql_fetch_array($stop_result);
$startkilometres = $vehicle['VGD_ADD'];
$startkilometres = $startkilometres/1000;
$startkilometres_rounded = number_format($startkilometres,2,',','.');
$code .= "<tr><td> </td></tr>";
$code .= "<tr>
<td class='tdStartStop' align='center'>".$vehicle['DDMMYY']."</td>
<td class='tdStartStop' align='center'>".$vehicle['TIME']."</td>
<td class='tdStartStop'>".$vehicle['VGD_ADDRESS']."</td>
<td class='tdStartStop' align='center'>".$startstop_text."</td>
<td class='tdStartStop' align='right'>".$startkilometres_rounded."</td></tr>";
$stopkilometres = $stop_vehicle['VGD_ADD'];
$stopkilometres = $stopkilometres/1000;
$stopkilometres_rounded = number_format($stopkilometres,2,',','.');
$code .= "<tr>
<td class='tdStartStop' align='center'>".$stop_vehicle['DDMMYY']."</td>
<td class='tdStartStop' align='center'>".$stop_vehicle['TIME']."</td>
<td class='tdStartStop'>".$stop_vehicle['VGD_ADDRESS']."</td>
<td class='tdStartStop' align='center'>".$stop_text."</td>
<td class='tdStartStop' align='right'>".$stopkilometres_rounded."</td></tr>";
$code .= "<tr><td class='tdStartStop'> </td>
<td class='tdStartStop'><hr align='center' width='75%' color='#000000'></td>
<td class='tdStartStop' colspan='2'></td>
<td class='tdStartStop'><hr align='right' width='75%' color='#000000'></td></tr>";
//difference in time
$startdateparts = explode("/", $vehicle['DDMMYY']);
$stopdateparts = explode("/", $stop_vehicle['DDMMYY']);
$starttimeparts = explode(":", $vehicle['TIME']);
$stoptimeparts = explode(":", $stop_vehicle['TIME']);
$starttime = mktime($starttimeparts[0],$starttimeparts[1],$starttimeparts[2],$startdateparts[1],$startdateparts[0],$startdateparts[2]);
$stoptime = mktime($stoptimeparts[0],$stoptimeparts[1],$stoptimeparts[2],$stopdateparts[1],$stopdateparts[0],$stopdateparts[2]);
$still_stoptime = $stoptime;
$difference = $stoptime - $starttime;
$totaldifference = $totaldifference + $difference;
//hours
$differenceinhours = floor($difference/3600);
$difference = $difference - ($differenceinhours*3600);
if($differenceinhours < 10)
$differenceinhours = "0".$differenceinhours;
//minutes
$differenceinminutes = floor($difference/60);
$difference = $difference - ($differenceinminutes*60);
if($differenceinminutes < 10)
$differenceinminutes = "0".$differenceinminutes;
//seconds
$differenceinseconds = $difference;
if($differenceinseconds < 10)
$differenceinseconds = "0".$differenceinseconds;
//difference in kilometres
$differencekilometres = $stopkilometres - $startkilometres;
$totalkilometres = $totalkilometres + $differencekilometres;
$differencekilometres_rounded = number_format($differencekilometres,2,',','.');
//amount of visits
$amountofvisits = $amountofvisits + 1;
$code .= "<tr><td class='tdStartStop'> </td>
<td class='tdStartStop' align='center'>".$differenceinhours.":".$differenceinminutes.":".$differenceinseconds."</td>
<td class='tdStartStop' colspan='2'></td>
<td class='tdStartStop' align='right'>".$differencekilometres_rounded."</td></tr>";
$code .= "<tr><td> </td></tr>";
}
}
if(strcmp($startstop,$stop) == 0)//strings are equal
$startstop_text = $stop_text;
if(strcmp($startstop,$checkpoint_0) == 0)//strings are equal
$startstop_text = $checkpoint_text;
if(strcmp($startstop,$checkpoint_0x00) == 0)//strings are equal
$startstop_text = $checkpoint_text;
if($action=="ritoverzicht")
ModeEdit: Code tags toegevoegd.
