[edwient]

anyone here pls help me, how to create a countdown timer like in ebay, i'm using PHP and MySQL

i've try by SQL query ex:
id int, dt datetime

SELECT (now() - dt) FROM tanggal WHERE id ='1'

i thought it ll ve a result x Days y Hours z Minutes q Seconds

but i think it will work if i combine with the PHP script.
any solutions / codes / scripts / tutorials?

thanks you guys..

[captainkoala]

you can set a time() stamp field in a database, and use getdate() to parse it.

example

PHP Code:

<?php



//list fields and convert to seconds

$countdown['days']=(5) * 24 * 60 * 60;

$countdown['hours']=(3) * 60 * 60;

// etc, etc

$countsum=time() + $countdown['days'] + $countdown['hours']; //and so on

// the above would be the timestamp to enter into the table



##########



// 'dumbed down' query

$result=mysql_query("SELECT * FROM tanggal WHERE id='id';");



while ($row=mysql_fetch_assoc($result))

    $time=$row['timestamp'] - time(); //this field would be a PHP timestamp (time())



$count=getdate($time);



$x=getdate(); //todays information



$count['mday'] -= $x['mday'];

$count['hour'] -= $x['mday'];

$count['minutes'] -= $x['minutes'];



echo "$count[mday] Days $count[hour] Hours $count[minutes] Minutes"; //etc



// untested, but should work

?>

I'm not at home, or I would test it, but it should work.

/edit; I just realised that this will not work for countdowns in the next month

[kenetix]

you could use the unix timestamp (time()) and set that as the expiry

so say, the time will expire 3 days from the day you add the product,
time() + 3*24*60*60

and when you retrieve the info from the database just compare the present time and the expiry time.

PHP Code:

if($expirytime < $currenttime){

echo"expired";

}

else{

$remainingtime = $currenttime - $expirytime;

} 

$remainingtime will be the number of seconds before the product expires. Just convert it to hours and minutes.