[RESOLVED] Countdown JS/PHP

[Derick88]

Hi, I want this script to refresh every seconds. For now I have to refresh the page.. Please Help.

<?
session_start();
include("db_connect.php");
$uname = $_SESSION['username'];
$rs2 = mysql_query("SELECT * FROM batisse WHERE u='$uname'");
while ($row2=mysql_fetch_assoc($rs2))
{
  $endtime2 = $row2['finish'];
}
?>
<script language="JavaScript">
document.write ("<span id='phpshowplace'></span>")
document.write ("<span id='showplace'></span>")
document.getElementById("phpshowplace").innerHTML='<? $diff = $endtime2 - time();
$days = ($diff - ($diff % 86400)) / 86400;
$diff = $diff - ($days * 86400);
$hours = ($diff - ($diff % 3600)) / 3600;
$diff = $diff - ($hours * 3600);
$minutes = ($diff - ($diff % 60)) / 60;
$diff = $diff - ($minutes * 60);
$seconds = ($diff - ($diff % 1)) / 1;
if ($days >= 1){
if ($seconds >= 10){
$timeoutput1 = "$days j et $hours:$minutes:$seconds";
$timeoutput2 = "";
$timeoutput3 = "";
}else{
$timeoutput1 = "$days j et $hours:$minutes:";
$timeoutput2 = "0";
$timeoutput3 = "$seconds";
}
}else if ($days == 0 && $hours == 0){
if ($seconds >= 10){
$timeoutput1 = "$minutes:$seconds";
$timeoutput2 = "";
$timeoutput3 = "";
}else{
$timeoutput1 = "$minutes:";
$timeoutput2 = "0";
$timeoutput3 = "$seconds";
}
}else if ($days == 0){
if ($seconds >= 10){
$timeoutput1 = "$hours:$minutes:$seconds";
$timeoutput2 = "";
$timeoutput3 = "";
}else{
$timeoutput1 = "$hours:$minutes:";
$timeoutput2 = "0";
$timeoutput3 = "$seconds";
}
}?>';
function phpcount() {
document.getElementById("phpshowplace").refresh(true)
setTimeout ("phpcount()", 1000)
}
window.onLoad = phpcount()
</script>

[Sanoz0r]

PHP is "compiled" on the server before the page is sent to your computer (server-side) unlike HTML and Javascript which is interpreted by your browser once the script has been downloaded (client-side).

The only way to reprocess the php code is to refresh the page.

[bradgrafelman]

Why mix PHP in with the Javascript? Javascript is definitely capable of updating a counter every second on its own without PHP's help.

[Derick88]

I found out...

<?
session_start();
include("db_connect.php");
$uname = $_SESSION['id'];
$rs2 = mysql_query("SELECT * FROM batisse WHERE u='$uname'");
while ($row=mysql_fetch_assoc($rs2))
{
  $endtime2 = $row['finish'];
}
$endtime = $endtime2*1000;
echo '<SCRIPT TYPE="text/javascript" LANGUAGE="JavaScript">
function GetCount(){
	dateNow = new Date();
	amount = '.$endtime.' - dateNow.getTime();
	delete dateNow;
	if(amount < 0){
		document.getElementById(\'countbox\').innerHTML="Terminé<br><a href=\'?\'>Continuer</a>";
	}
	else{
		days=0;hours=0;mins=0;secs=0;out="";
		amount = Math.floor(amount/1000);
		days=Math.floor(amount/86400);
		amount=amount%86400;
		hours=Math.floor(amount/3600);
		amount=amount%3600;
		mins=Math.floor(amount/60);
		amount=amount%60;
		secs=Math.floor(amount);
		if(days != 0){out += days +" jour"+((days!=1)?"s":"")+", ";}
		if(days != 0 || hours != 0){out += hours +" heure"+((hours!=1)?"s":"")+", ";}
		if(days != 0 || hours != 0 || mins != 0){out += mins +" minute"+((mins!=1)?"s":"")+", ";}
		out += secs +" secondes";
		out +="<br><a href=\'?action=stop\'>Arrêter</a>";
		document.getElementById(\'countbox\').innerHTML=out;
		setTimeout("GetCount()", 1000);
        amount = amount - 1;
	}
}
window.onload=function(){GetCount();}
</script>
<div id="countbox"></div>';

[Sanoz0r]

🙂