View difference between Paste ID: Y8jaqmHQ and Rq9VTxCy
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'"));