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'")); |