관리자페이지 문의드립니다.

<?php
// 상단에 통계 표시 부분
$today_count = sql_fetch(" SELECT COUNT(*) AS cnt FROM {$write_table} WHERE wr_datetime >= '".date('Y-m-d 00:00:00')."' AND wr_datetime <= '".date('Y-m-d 23:59:59')."' ");
$week_count = sql_fetch(" SELECT COUNT(*) AS cnt FROM {$write_table} WHERE wr_datetime >= DATE_SUB(NOW(), INTERVAL 7 DAY) ");
$month_count = sql_fetch(" SELECT COUNT(*) AS cnt FROM {$write_table} WHERE wr_datetime >= DATE_SUB(NOW(), INTERVAL 1 MONTH) ");
?>

<div class="stat-container">
   <a href="?period=today" class="stat-box">
       오늘 : <?php echo number_format($today_count['cnt']); ?>개
   </a>
   <a href="?period=week" class="stat-box">
       1주일 : <?php echo number_format($week_count['cnt']); ?>개
   </a>
   <a href="?period=month" class="stat-box">
       1개월 : <?php echo number_format($month_count['cnt']); ?>개
   </a>
</div>

<?php
// 리스트 쿼리 수정 부분 
$period = $_GET['period'];
$where = "";

if($period) {
   switch($period) {
       case 'today':
           $where = " AND wr_datetime >= '".date('Y-m-d 00:00:00')."' AND wr_datetime <= '".date('Y-m-d 23:59:59')."' ";
           break;
       case 'week':
           $where = " AND wr_datetime >= DATE_SUB(NOW(), INTERVAL 7 DAY) ";
           break;
       case 'month':
           $where = " AND wr_datetime >= DATE_SUB(NOW(), INTERVAL 1 MONTH) ";
           break;
   }
}

$sql = " SELECT * FROM {$write_table} WHERE 1=1 {$where} ORDER BY wr_id DESC ";
?>