View difference between Paste ID: Csfag9nX and wNGiGd6p

 <?php
 setcookie("counter","visitor",time()+3600);
 
 include "conn.php";
 
 $tanggal=date("Y-m-d H:i:s");
 echo "<br/>tanggal=$tanggal";
 if (!isset($_COOKIE['counter']))
 {
 	echo "<br/>cookie tidak ada";
 $query = mysql_query("select * from counter where tgl='$tanggal'");
 while ($rows=mysql_fetch_array($query))
 {
 	$visit=$rows[1];
 }
 	echo "<br/>visit = $visit";
 }else{
 	echo "<br/>cookie ada";
 }
 
 if (empty($visit))
 {
 	mysql_query("insert into counter values('$tanggal',1)");
 	echo "<br/>insert 1";
 }
 else
 {	$visit=$visit+1;
 	mysql_query("update counter set jml='$visit' where tgl='$tanggal'");
 	echo "<br/>update";
 }
 
 
 
 $hariini=date("Y-m-d");
 $query=mysql_query("select distinctrow sum(jml) as tot from counter where year(tgl) = left('$hariini',4) and month(tgl) = mid('$hariini',6,2) and day(tgl) = mid('$hariini',9,2)");
 while ($rows=mysql_fetch_array($query))
 {
 	$jmlhariini=$rows[0];
 /*
 disini akan di kumpulkan nilai counter hari ini saja.. jadi kl di refresh
 maka disini akan bertambah
 */
 }
 
 $query=mysql_query("select distinctrow sum(jml) as tot from counter");
 while ($rows=mysql_fetch_array($query))
 {
 	$totvisit=$rows[0];
 /*
 total keseluruhan counter
 */
 }
 
 
 ?>
 
 <html>
 <body>
 	<table align="left" border="0" width="100%">
 	<tr>
 	<td>
 	<font face="verdana" size="1" color="#000000"><center><?php echo $jmlhariini?> hits today, <?php echo $totvisit?> hits since 21/04/11 </font>
 	</td>
 	</tr>
 	</table>
 
 </body>
 </html>