can anyone help

UKlee

Hi guys great site by the way.

ok I have a question well more than one but for now I need to ask this if I stor information in a mysql databse using the time format 00:00:00 can this be used to add up hours the problem I have is this I use software to grab information from flight simulator that sends to a php form so basically its posting then adding to a databse. this is all well and works fine it creates a new entry for every flight that is entered no problem . But what I wish to do or would like to try and do is this also send the information to another datbase and have the time add onto the time you have already logged in this field.Remebering that the code for the software must remain the same or the $POST[xxxx] must remain the same i have attempted to write a script to do this but php time is my nemisis.I have highlighted my addin code in red I know im wrong here as I have seen $variable= $something + $something adding two together but am unsure of how this is done in order to make the time add to the already recorded time in that other database sorry this post is so long if you can help or point me in the right direction that would be great.

thanks in advance

Lee

<?php

// ALL IS OK REGISTER THE FLIGHT
	$query = "INSERT INTO flights(id,datestamp,UserName,CompanyName,PilotName,FlightId,OnlineNetworkNbr,FlightDate,AircraftName,AircraftType,NbrPassengers,CargoWeight,Mtow,StartAircraftWeight,EndAircraftWeight,StartFuelQuantity,EndFuelQuantity,DepartureIcaoName,ArrivalIcaoName,DepartureLocalHour,ArrivalLocalHour,DepartureGmtHour,ArrivalGmtHour,TotalBlockTime,TotalBlockTimeNight,TotalAirbornTime,TotalTimeOnGround,TotalDistance,MaxAltitude,CruiseSpeed,CruiseMachSpeed,CruiseTimeStartSec,CruiseTimeStopSec,CruiseFuelStart,CruiseFuelStop,LandingSpeed,LandingPitch,TouchDownVertSpeedFt,CaptainSentMayday,CrashFlag,FlightResult,PassengersOpinion,PassengersOpinionText,FailureText,CasualtiesText,PilotBonusText,BonusPoints,PilotPenalityText,PenalityPoints) VALUES('',now(),'$_POST[UserName]','$_POST[CompanyName]','$_POST[PilotName]','$_POST[FlightId]','$_POST[OnlineNetworkNbr]','$_POST[FlightDate]','$_POST[AircraftName]','$_POST[AircraftType]','$_POST[NbrPassengers]','$_POST[CargoWeight]','$_POST[Mtow]','$_POST[StartAircraftWeight]','$_POST[EndAircraftWeight]','$_POST[StartFuelQuantity]','$_POST[EndFuelQuantity]','$_POST[DepartureIcaoName]','$_POST[ArrivalIcaoName]','$_POST[DepartureLocalHour]','$_POST[ArrivalLocalHour]','$_POST[DepartureGmtHour]','$_POST[ArrivalGmtHour]','$_POST[TotalBlockTime]','$_POST[TotalBlockTimeNight]','$_POST[TotalAirbornTime]','$_POST[TotalTimeOnGround]','$_POST[TotalDistance]','$_POST[MaxAltitude]','$_POST[CruiseSpeed]','$_POST[CruiseMachSpeed]','$_POST[CruiseTimeStartSec]','$_POST[CruiseTimeStopSec]','$_POST[CruiseFuelStart]','$_POST[CruiseFuelStop]','$_POST[LandingSpeed]','$_POST[LandingPitch]','$_POST[TouchDownVertSpeedFt]','$_POST[CaptainSentMayday]','$_POST[CrashFlag]','$_POST[FlightResult]','$_POST[PassengersOpinion]','$_POST[PassengersOpinionText]','$_POST[FailureText]','$_POST[CasualtiesText]','$_POST[PilotBonusText]','$_POST[BonusPoints]','$_POST[PilotPenalityText]','$_POST[PenalityPoints]')";
    if(!@mysql_query($query)){echo "#Answer# SQL Error - ".mysql_error();return;}

[COLOR=Red]

[B]$pilot_id=$_POST["UserName"];

$dbh=mysql_connect ("localhost", "myusername", "mypassword") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("mydatabse");
$query = mysql_query("SELECT hours FROM members WHERE pilot_id ='$pilot_id'") or die (mysql_error());
$row_query = mysql_fetch_assoc($query);
$Calculatetime=AddTime($row[hours],$_POST[TotalBlockTime]);



	mysql_query("UPDATE members SET hours='$Calculatetime' WHERE pilot_id='$pilot_id'") 
or die (mysql_error());[/[/B]COLOR]




function AddTime($Time1,$Time2)
{
	$timea=explode(":",$Time1);
	$timeb=explode(":",$Time2);
	$secondes=($timea[0]+$timeb[0])*3600;
	$secondes+=($timea[1]+$timeb[1])*60;
	$secondes+=$timea[2]+$timeb[2];
    $hours = floor($secondes / 3600);
    $minute = floor(($secondes - ($hours * 3600)) / 60);
    $secconde = $secondes - ($hours * 3600) - ($minute * 60);
  return sprintf("%02d:%02d:%02d", $hours, $minute, $secconde);
}


?>

rachel2004

You had somewhat of a wordy post, but hopefully I understood enough of it to take a stab at your question: you want to add times, right?

If that's what you want, work with Unix timestamp values. Once you add all of your times up, use the PHP floor() or ceil() functions to round down or round up your values.

If your time values are in the format 00:00:00, you need to first convert them to Unix timestamp values, of course. In PHP, consider using the mktime() function. If you are using MySQL as your database, consider using MySQL's unix_timestamp() function to SELECT a date/time column as a Unix timestamp.

See the manuals for either for more specifics.

justsomeone

Please, please, please use paragraphs and punctuation when you post. It makes it so much easier to understand what your question is.

I would approach this by creating two functions to convert time between "number of seconds" and HH:MM:SS representations. The code snippet below is untested, I don't have access to PHP here. You might also find it a little verbose, but I find that easier to debug. You can always compress the code once it's working. You might even recognise some of the code 😉

function cvtHHMMSStoSeconds($inTime){

$timebits=explode(":",$inTime);
$hours=timebits[0];
$minutes=timebits[1];
$seconds=timebits[2];

$totalSeconds = ($hours * 3600) + ($minutes * 60) + $seconds;

return $totalSeconds;

}


function cvtSecondsToHHMMSS($inSeconds){

$hours = floor($inSeconds/3600);
$minutes = floor($inSeconds-($hours*3600)/60);
$secconds = $inSeconds - (($hours*3600) + ($minutes*60));

return sprintf("%02d:%02d:%02d", $hours, $minutes, $secconds); 

}

now the add time function can be as simple as

 
function addTimes($time1, $time2){

$addedTime = cvtHHMMSStoSeconds($time1) + cvtHHMMSStoSeconds($time2);
return cvtSecondsToHHMMSS($addedTime);
}

Looking at your original code, though, I would imagine it works fine. Can you be specific about what you expect to happen adn what you've discovered is actually happening?

UKlee

sorry about the paragraph issue, Yes the code adds the time from the software into a table along with all other info, I also have the blocktime adding to another table ,but it keeps replacing the information already stored what I would like it to do is add to this information rather than replace it.

thank you for your reply I will try out your code and let you know how I get on

kind regards

Lee

justsomeone

Hmm... so it's overwriting your time with the new one instead of adding it.

There are three possible causes for this:

The times you pass to AddTime are wrong (specifically the original time isn't getting passed in)
The AddTime function isn't working properly
Something bad is happening at your SQL update.

Use some logging or echos to see which of the above is happening.

I think your problem is actually with number one above:

$query = mysql_query("SELECT hours FROM members WHERE pilot_id ='$pilot_id'") or die (mysql_error());
$row_query = mysql_fetch_assoc($query);
$Calculatetime=AddTime($row[hours],$_POST[TotalBlockTime]);

Your returned row is actually called $row_query, not $row. So one of your two parameters is always going to be unset.
I believe you should have quotes around the i array indices in the last line as well:

$Calculatetime=AddTime($row_query["hours"], $_POST["TotalBlockTime"]);

UKlee

I would like to thank you both for replying to my post , the problem is now solved and yes justsomeone it was indeed the way i had my script.

$Calculatetime=AddTime($row_query["hours"], $_POST["TotalBlockTime"]);

thank you once again great website and community here i will pass on the word and ofcourse stay to learn more.

kind regards

Lee

justsomeone

UKlee wrote:
I would like to thank you both for replying to my post , the problem is now solved and yes justsomeone it was indeed the way i had my script.

$Calculatetime=AddTime($row_query["hours"], $_POST["TotalBlockTime"]);

thank you once again great website and community here i will pass on the word and ofcourse stay to learn more.

kind regards

Lee

Very welcome, man. It's how we all learn! 😃