Countdown then mysql query help.

[thecard]

Whats the best way to make a countdown timer in php to:

 

Countdown from 10 seconds

and then do a mysql query?

[ILYAS415]

There is no best way... well you cant actually create a countdown timer with php i think.

You can use cron jobs.

Or you can use javascript.

 

I would actually recommend javascript...

something like...

 

setInterval("func()", 10000); //run javascript func() function every 10 seconds

[discomatt]

Javascript is your best bet. When the java timer reaches 0, call a php page in an invisible iframe that executes the desired query.

[thecard]

Thanks but please can you explain or write the code on how I would do that.

Sorry, I'm ok at php, but not very experienced by any means!

[discomatt]

I won't code for you, but I will help direct you.

 

Here's a GREAT article on IFRAMEs and JavaScript

http://www.devarticles.com/c/a/JavaScript/Working-with-IFRAME-in-JavaScript/

 

Simple javascript timer

http://java-scripts.net/javascripts/Countdown-Timer.phtml

 

The reason I'm showing you these is because if someone codes this for you, you won't learn anything If you don't learn anything, you'll be back here asking for help with no idea what your code does. This frustrates most of us, and it may take a long time to get things fixed.

 

Learn it yourself, and you know exactly what is breaking when it does.

[thecard]

Yeah, great.

I agree!

 

[jonsjava]

If you don't need a visual, it's doable in PHP:

<?php
sleep(10);
?>