<SCRIPT type=text/javascript> function CD_ZP(objVal){ var str=""+objVal; var strl=str.length; return(strl!=2?"0"+str:str) }; function pa_time(Time_Left){ if(Time_Left == 0) { //Time_Left = 0; window.open("test.php","_self"); }else{ var heures = Math.floor(Time_Left / 3600); var minutes = Math.floor(((Time_Left / 3600) - Math.floor(Time_Left / 3600)) * 60); var seconds = Time_Left - ((Math.floor(Time_Left / 60)) * 60); document.getElementById("pa_time").innerHTML = CD_ZP(heures) + ':' + CD_ZP(minutes) + ':' + CD_ZP(seconds); setTimeout('pa_time(' + (Time_Left-1) + ');', 1000); } } </SCRIPT> <? //+++++++++++++++++++++++++++++++++++++++++++++++++++++ //on se connecte a la bdd mysql_connect ('localhost','root',''); $BD_base = "dolbizz"; @mysql_select_db($BD_base) or die("Impossible de se connecter à la base de données."); //+++++++++++++++++++++++++++++++++++++++++++++++++++++ $id = 1; $req = mysql_query("SELECT mktime,pa FROM tutoriaux_tabletest WHERE id='$id'") or die (mysql_error()); $data = mysql_fetch_array($req); $pa=$data['pa']; $pa_fini=$data['mktime'];//le mktime de la table correspond a la date de fin du compte a rebours $mktime=mktime(); if($pa_fini<=$mktime){//si l date de fin est <= au temps d'aujourdhui $pa = $pa-1; $mktime = $mktime + 60;//test pour 1 minute mysql_query("UPDATE tutoriaux_tabletest Set mktime = '$mktime', pa='$pa' WHERE id='$id'") or die (mysql_error()); } $req = mysql_query("SELECT mktime,pa FROM tutoriaux_tabletest WHERE id='$id'") or die (mysql_error()); $data = mysql_fetch_array($req); $pa=$data['pa']; $pa_fini=$data['mktime'];//le mktime de la table correspond a la date de fin du compte a rebours $mktime=mktime(); echo 'Pa:'.$pa.' '; echo 'Prochain dans: <SCRIPT type=text/javascript>pa_time('; $req = mysql_query("SELECT mktime FROM tutoriaux_tabletest WHERE id='$id'") or die (mysql_error()); $data = mysql_fetch_array($req); $pa_fini=$data['mktime'];//réupération de la date en seconde de la fin //du compte à rebours echo $pa_fini-mktime();//ici le script va faire la difference entre la date en secondes de maintenant et la date de fin pour savoir dans combien de temps le compte a rebours fini echo ')</SCRIPT>';