Guest User

statistik.php

a guest
May 3rd, 2014
228
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.70 KB | None | 0 0
  1.  $pengunjung       = mysqli_num_rows(mysqli_query($conn,"SELECT * FROM statistik WHERE tanggal='$tanggal' GROUP BY ip"));
  2.  $totalpengunjung  = mysqli_result(mysqli_query($conn,"SELECT COUNT(hits) FROM statistik"),0);
  3.  $hits             = mysqli_fetch_assoc(mysqli_query($conn,"SELECT SUM(hits) as hitstoday FROM statistik WHERE tanggal='$tanggal' GROUP BY tanggal"));
  4.  $totalhits        = mysqli_result(mysqli_query($conn,"SELECT SUM(hits) FROM statistik"),0);
  5.  $tothitsgbr       = mysqli_result(mysqli_query($conn,"SELECT SUM(hits) FROM statistik"),0);
  6.  $bataswaktu       = time() - 300;
  7.  $pengunjungonline = mysqli_num_rows(mysqli_query($conn,"SELECT * FROM statistik WHERE online > '$bataswaktu'"));
Advertisement
Add Comment
Please, Sign In to add comment