Guest User

Untitled

a guest
Feb 4th, 2014
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.15 KB | None | 0 0
  1. <?php
  2. setcookie("counter","visitor",time()+3600);
  3.  
  4. include "conn.php";
  5.  
  6. $tanggal=date("Y-m-d H:i:s");
  7.  
  8. if (!isset($_COOKIE['counter']))
  9. {
  10. $query = mysql_query("select * from counter where tgl='$tanggal'");
  11. while ($rows=mysql_fetch_array($query))
  12. {
  13.     $visit=$rows[1];
  14. }
  15. }
  16.  
  17. if (empty($visit))
  18. {
  19.     mysql_query("insert into counter values('$tanggal',1)");
  20. }
  21. else
  22. {   $visit=$visit+1;
  23.     mysql_query("update counter set jml='$visit' where tgl='$tanggal'");
  24. }
  25.  
  26.  
  27. $hariini=date("Y-m-d");
  28. $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)");
  29. while ($rows=mysql_fetch_array($query))
  30. {
  31.     $jmlhariini=$rows[0];
  32. }
  33.  
  34. $query=mysql_query("select distinctrow sum(jml) as tot from counter");
  35. while ($rows=mysql_fetch_array($query))
  36. {
  37.     $totvisit=$rows[0];
  38. }
  39.  
  40.  
  41. ?>
  42.  
  43. <html>
  44. <body>
  45.     <table align="left" border="0" width="100%">
  46.     <tr>
  47.     <td>
  48.     <font face="verdana" size="1" color="#000000"><center><?php echo $jmlhariini?> hits today, <?php echo $totvisit?> hits since 21/04/11 </font>
  49.     </td>
  50.     </tr>
  51.     </table>
  52.  
  53. </body>
  54. </html>
Advertisement
Add Comment
Please, Sign In to add comment