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: