basically I needed a way for someone to hit a start button and it enter the start time with other info in the DB

then a timer starts to count the time since the person hit start.

this sounds simple and I know there are some scripts out there but I needed to personalize this and I could not find any good pre-made ones. I did find one and I completely gutted it and built it to work.
Soooo here it is, enjoy
place this on your page, javascript
Code: Select all
function updateClock ( )
{
var startTime = "<?php echo $openstart; ?>";
var currenthours;
var currentminutes;
var currentseconds;
var currentTime = new Date ( );
//var finaltime;
var finaltime;
var currentHours = currentTime.getHours ( );
var currentMinutes = currentTime.getMinutes ( );
var currentSeconds = currentTime.getSeconds ( );
var totalcurrenttime = currentHours * 3600;
totalcurrenttime = totalcurrenttime + (currentMinutes * 60);
totalcurrenttime = totalcurrenttime + currentSeconds;
var splittime = startTime.split(":");
var starthours = Number(splittime[0]);
var startminutes = Number(splittime[1]);
var startseconds = Number(splittime[2]);
var totalstarttime = starthours * 3600;
totalstarttime = totalstarttime + (startminutes * 60);
totalstarttime = totalstarttime + startseconds;
totalcurrenttime = Number(totalcurrenttime);
totalstarttime = Number(totalstarttime);
finaltime = totalcurrenttime - totalstarttime;
if(finaltime > 3599)
{
finaltime = finaltime / 60;
finaltime = finaltime.toFixed(2);
finaltime = finaltime + '';
var splitthis = finaltime.split(".")
currenthours = splitthis[0] / 60;
currenthours = currenthours.toFixed(2);
currenthours = currenthours + '';
var splithours = currenthours.split(".")
currenthours = splithours[0];
currentminutes = splithours[1] * .6;
currentminutes = currentminutes.toFixed(0);
currentseconds = splitthis[1] * .6;
currentseconds = currentseconds.toFixed(0);
}
else if(finaltime > 60)
{
finaltime = finaltime / 60;
finaltime = finaltime.toFixed(2);
finaltime = finaltime + '';
var splitthis = finaltime.split(".")
currenthours = 0;
currentminutes =splitthis[0];
currentseconds = splitthis[1] * .6;
currentseconds = currentseconds.toFixed(0);
}
else
{
currenthours = 0;
currentminutes = 0;
currentseconds = finaltime;
}
// Pad the minutes and seconds with leading zeros, if required
currenthours = ( currenthours < 10 ? "0" : "" ) + currenthours;
currentminutes = ( currentminutes < 10 ? "0" : "" ) + currentminutes;
currentseconds = ( currentseconds < 10 ? "0" : "" ) + currentseconds;
// Compose the string for display
var currentTimeString = currenthours + ":" + currentminutes + ":" + currentseconds;
// Update the time display
document.getElementById("clock").firstChild.nodeValue = currentTimeString;
}Code: Select all
<span id='clock'> </span>to share a little more code
here is the form code, you can have anything on there you want them to enter or nothing, ban relates to a account number.
Code: Select all
echo "<form action='equip.php?saveresearch=1' method='post' >
<td><input type='text' name='ban' size='15' />
</td><td><input type='submit' value='Start'></td>
</form>";Code: Select all
if($_GET['saveresearch'] == 1)
{
$ban = $_POST['ban'];
$time = date('H:i:s');
$SQL = "INSERT into research(ban,agent,date,StartTime) VALUES ('$ban','$userinfo3[name]',CURDATE(),NOW())"; mysql_query($SQL) or die("could not add to research");
}
$date = date("y-m-d");
$selectresearch="SELECT * from research where date='$date' AND agent='$userinfo3[name]' AND EndTime='00:00:00'";
$selectresearch2=mysql_query($selectresearch) or die("could not select research");
while($selectresearch3=mysql_fetch_array($selectresearch2))
{
$iscurrent = 1;
$openban = $selectresearch3['ban'];
$openstart = $selectresearch3['StartTime'];
$currenttime = date('H:i:s');
}hope someone can use this.