1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51
|
<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 + 10;//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.'<br>';
echo 'Prochain dans: <DIV class=valeur id=pa_time></DIV><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>'; |
Partager