Site Stats > Transaction"; $green_box_img = "icon_community.gif"; $green_box = "Site Stats"; include "../include/header.php"; $query_month = "SELECT COUNT(*) FROM site_stats GROUP BY MONTH(wdate), YEAR(wdate)"; $res_month = mysqli_query($connect, $query_month,$connect); $tot_month = mysqli_num_rows($res_month); $visitor_sum = ""; for($vm=0;$vm<$tot_month;$vm++) { $row_month = mysqli_fetch_array($res_month); $visitor_sum = $visitor_sum + $row_month[0]; } $visit_tot = $visitor_sum / $tot_month; $visit_tot = round($visit_tot); ?>

Transaction   = DATE_SUB(CURRENT_date,interval 6 day) group by dnr,tdr order by cnt desc, tdr desc limit 1"; //echo "$query_day "; $result_day=mysqli_query($connect, $query_day,$connect); ?> = DATE_SUB(CURRENT_date,interval 24 HOUR) group by tm order by tmr desc;"; //echo $query_h; $result_h=mysqli_query($connect, $query_h,$connect); $rows_h=mysqli_fetch_array($result_h); mysqli_free_result($result_h); if($rows_h[1]>12){ $busit_hour= "PM. "." ".(int)($rows_h[1]-12); } else if($rows_h[1] == 12) { $busit_hour= "PM. 12"; }else{ $busit_hour= "AM. "." ".(int)$rows_h[1]; } ?> "; $date_ma=getdate($time_stamp_ma); if($date_ma[mon]<10){ $data_month="0"."$date_ma[mon]"; }else{ $data_month=$date_ma[mon] ; } if($date_ma[mday]<10){ $data_day="0"."$date_ma[mday]"; }else{ $data_day=$date_ma[mday] ; } $date_cf=$date_ma[year].$data_month.$data_day."000000"; $current_cf=date(Ymd)."000000"; //echo "$date_cf "; //echo "$current_cf "; $query_ma1="select count(anum),avg(auct_end-auct_start) from auct_master where (auction='2')&&(end_chk ='Y')&&(auct_start!='')&&(auct_end!='')&&(auct_end> '$date_cf')&&(auct_end<'$current_cf')"; // $result_ma1=mysqli_query($connect, $query_ma1,$connect); //echo $query_ma1; $total_ma1=mysqli_fetch_array($result_ma1); mysqli_free_result($result_ma1); $real_time=floor($total_ma1[1]/10000); //echo $real_time; $real_time0=substr($real_time,0,2); //echo $real_time0; $real_time1=substr($real_time,2,2); // ex, 1330 --> 13day 30hour $real_day0=$real_time0; //original day $real_day1=floor($real_time1/24); //remain day $real_day=$real_day0 + $real_day1; $real_hour=floor($real_time%24); //remain hour of one day ?> 1. Average visitor per month 2. The Busiest day of week "; } mysqli_free_result($result_day); ?> 3. The Busiest Hours 4. Average time to sell