Visitantes Únicos
DATE_FORMAT(LAST_DAY(NOW()) - ((7 + WEEKDAY(LAST_DAY(NOW())) - 7) % 7), '%Y-%m-%d'));");
$q_month = mysqli_query($con, "SELECT LOW_PRIORITY COUNT(id) AS c FROM stat_visit WHERE id IN (SELECT visit FROM stat_view WHERE dtime > LAST_DAY(NOW() - INTERVAL 1 MONTH) + INTERVAL 1 DAY);");
$q_year = mysqli_query($con, "SELECT LOW_PRIORITY COUNT(id) AS c FROM stat_visit WHERE id IN (SELECT visit FROM stat_view WHERE dtime > DATE_FORMAT(NOW() ,'%Y-01-01'));");
$r_total = mysqli_fetch_array($q_total);
$r_week = mysqli_fetch_array($q_week);
$r_month = mysqli_fetch_array($q_month);
$r_year = mysqli_fetch_array($q_year);
?>
- Totales:
- Semana:
- Mes:
- Año: