if($time==12:30)

Anon

hey, I've downloaded a javascript that displays the time in an input box...
This time updates every second, so the variable will keep changing.

So i just thought, why not make a php script that says: if the time equals 12:30:00, run a mysql query.

The only downside is, it doesn't work!
And i really need this for an hour registration program I'm working on, so I can automatically stop all activities at 12:30, when they have a coffee break.

Can anyone help me?

here's the code btw:

<HEAD>
<TITLE>JavaScript Clock</TITLE>
<SCRIPT LANGUAGE=JAVASCRIPT TYPE="TEXT/JAVASCRIPT">
<!-- Hide script from old browsers

function showMilitaryTime() {
	if (document.theForm.showMilitary[0].checked) {
		return true
	}
	return false
}

function showTheHours(theHour) {
	if (showMilitaryTime() || (theHour > 0 && theHour < 13)) {
		return (theHour)
	}
	if (theHour == 0) {
		return (12)
	}
	return (theHour-12)
}

function showZeroFilled(inValue) {
	if (inValue > 9) {
		return ":" + inValue
	}
	return ":0" + inValue
}

function showAmPm() {
	if (showMilitaryTime()) {
		return ("")
	}
	if (now.getHours() < 12) {
		return (" am")
	}
	return (" pm")
}

function showTheTime() {
	now = new Date

	document.theForm.showTime.value = showTheHours(now.getHours()) +  showZeroFilled(now.getMinutes()) + showZeroFilled(now.getSeconds()) + showAmPm()
	setTimeout("showTheTime()",1000)
}

// End hiding script from old browsers -->
</SCRIPT>

</HEAD>
<BODY BGCOLOR=WHITE onLoad="showTheTime()">
<CENTER>
<FORM NAME="theForm">
<INPUT TYPE=TEXT NAME="showTime" SIZE=11><P>
<INPUT TYPE=RADIO NAME="showMilitary" CHECKED>
<INPUT TYPE=RADIO NAME="showMilitary">
</FORM>
</CENTER>
<?
if ($showTime == 12:30:00)
{
header("location:stoptime.php?time=12:30"); //the first coffee break
}
if ($showTime == 16:30:00)
{
header("location:stoptime.php?time=16:30"); // the end of the workday
}
else
{
// HTML CODE HERE for the page //
}
?>
</BODY>

Anon

In this bit

function showTheTime() {
now = new Date

document.theForm.showTime.value = showTheHours(now.getHours()) + showZeroFilled(now.getMinutes()) + showZeroFilled(now.getSeconds()) + showAmPm()
setTimeout("showTheTime()",1000)
}

you need to have an if time = 12:30 document.theForm.submit where the form then runs the php script to do all the other stuff you need and reload the page.

Your check only runs when the page is loaded - and it's unlikey that the page gets loaded at exactly 12:30.

good luck

Anon

k, i'll try it.. thanks