note 47285 deleted from function.date by didou
| From: | didou@php.net | Date: | Wed, 10 Nov 2004 13:37:05 +0000 |
| Subject: | note 47285 deleted from function.date by didou | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-80346@lists.php.net to get a copy of this message | ||
Note Submitter: heryanto752004 at transmedia dot co dot id
----
Are you looking for countdown clock in php ?
look at this program in the list bellow !
There are 2 step
1st step
--------
<?
//Konek ke database
$database="dmshop";
$hostname="localhost";
$username="";
$password="";
if (!$dbh=mysql_connect($hostname,$username,$password)){
echo mysql_error();
exit;
}
mysql_select_db($database,$dbh);
//query ke tabel
$sqlgame="select * from game where game_id=29";
$resgame=mysql_query($sqlgame,$dbh);
$rowgame=mysql_fetch_row($resgame);
//cari tglakhir,blnakhir,tahunakhir
$blnakhir=substr($rowgame[3],0,2);
$tglakhir=substr($rowgame[3],3,2);
$tahunakhir=substr($rowgame[3],6,4);
//selesai cari tglakhir,blnakhir,tahunakhir
//cari tglserver,blnserver,tahunserver
$tglserver=date("d");
$blnserver=date("m");
$tahunserver=date("Y");
//selesai cari tglserver,blnserver,tahunserver
//cari nilai interval antara datatglserver dan datatglakhir
$calculation0 =round(((mktime (24,0,0,$blnserver,$tglserver,$tahunserver) - time(void))/3600));
//datatglserver
$datahari0 = (int)($calculation0/24);
$calculation2 =round(((mktime (24,0,0,$blnakhir,$tglakhir,$tahunakhir) - time(void))/3600));
//datatglakhir
$datahari2 = (int)($calculation2/24);
$datahariinterval= $datahari2-$datahari0;
//Mengambil jam,menit,detik dari Server PC
$tglserver = getDate();
$datadetikserver = $tglserver["seconds"];
$datamenitserver = $tglserver["minutes"];
$datajamserver = $tglserver["hours"];
//Deklarasi variabel
print "var s=$datadetikserver; // Nilai awal variabel detik\n";
print "var i=$datamenitserver; // Nilai awal variabel menit\n";
print "var H=$datajamserver; // Nilai awal variabel jam\n";
print "var d=$datahariinterval; // Nilai awal variabel hari\n";
print "var batas_s=60; // Batas nilai awal variabel detik\n";
print "var batas_i=60; // Batas nilai awal variabel menit\n";
print "var batas_H=24; // Batas nilai awal variabel jam\n";
print "var batas_d=31; // Batas nilai awal variabel hari\n";
print "var sinyal_i=0; // variabel sinyal menit untuk dikurangi nilainya menjadi 1\n";
print "var sinyal_H=0; // variabel sinyal menit untuk dikurangi nilainya menjadi 1\n";
print "var sinyal_d=0; // variabel sinyal hari untuk dikurangi nilainya menjadi 1\n";
print "var sinyal_i_value_awal=$datamenitserver; //Nilai awal untuk tag input menit\n";
print "var sinyal_H_value_awal=$datajamserver; //Nilai awal untuk tag input jam\n";
print "var sinyal_d_value_awal=$datahariinterval; //Nilai awal untuk tag input hari\n";
?>