SHOW:
|
|
- or go back to the newest paste.
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); |
2 | + | // $totalpengunjung = mysqli_result(mysqli_query($conn,"SELECT COUNT(hits) FROM statistik"),0); |
3 | /* | |
4 | while ($row = $result->fetch_row()) { | |
5 | printf ("%s (%s)\n", $row[0], $row[1]); | |
6 | } | |
7 | */ | |
8 | $ar = mysqli_fetch_row(mysqli_result(mysqli_query($conn,"SELECT COUNT(hits) FROM statistik"),0) ); | |
9 | $totalpengunjung =$ar[0]; | |
10 | ||
11 | $hits = mysqli_fetch_assoc(mysqli_query($conn,"SELECT SUM(hits) as hitstoday FROM statistik WHERE tanggal='$tanggal' GROUP BY tanggal")); | |
12 | $totalhits = mysqli_result(mysqli_query($conn,"SELECT SUM(hits) FROM statistik"),0); | |
13 | $tothitsgbr = mysqli_result(mysqli_query($conn,"SELECT SUM(hits) FROM statistik"),0); | |
14 | $bataswaktu = time() - 300; | |
15 | $pengunjungonline = mysqli_num_rows(mysqli_query($conn,"SELECT * FROM statistik WHERE online > '$bataswaktu'")); |