|
Server : Apache/2.2.17 (Unix) mod_ssl/2.2.17 OpenSSL/0.9.8e-fips-rhel5 DAV/2 PHP/5.2.17 System : Linux localhost 2.6.18-419.el5 #1 SMP Fri Feb 24 22:47:42 UTC 2017 x86_64 User : nobody ( 99) PHP Version : 5.2.17 Disable Function : NONE Directory : /home/queenjbs/www/admin/ |
Upload File : |
<?include $_SERVER['DOCUMENT_ROOT']."/admin/adminTopMenu.html";?>
<?
// =============================================== Query
//$tableName = "notice";
if(!$pageCount) $pageCount = 31;
$show_one_page = $pageCount;
$show_view_page = 10;
$page = ( $page ) ? $page : 1;
$offset = ($page-1)*$show_one_page;
if($key_word) {
$key_word = str_replace(" ","",$key_word);
$where = "AND $key LIKE '%$key_word%'";
}
if($tabs == 2){
$where .=" and auth_code = 10";
}else if($tabs == 3){
$where .=" and auth_code = 3";
}
$order_by = ' ORDER BY id DESC';
$url_tail = "&tab=$tab&tabs=$tabs&key=$key&order_by=$order_by";
$query_limit = "limit $offset,$show_one_page";
$QUERY_TOTAL = "SELECT count(*) FROM user_hit where 1=1 $where $order_by";
$QUERY_PAGE = "SELECT * FROM user_hit where 1=1 $where $order_by $query_limit";
//SELECT *, DATE_FORMAT(writedate, '%Y.%m.%d') AS date FROM tour_community WHERE 1=1 and idx not in (1179,1186) ORDER BY sort DESC ,depth ASC limit 0,15
//echo $QUERY_PAGE;
$total_count = get_db($QUERY_TOTAL);
$Num = $total_count - $offset;
$total_page = ceil( $total_count / $show_one_page);
$start_num = $total_count - $offset; //
$viewlist2 = ( !$total_count ) ? "" : Get_viewpage2($page,$total_count,$show_one_page,$show_view_page,$url_tail);
$result= mysql_query($QUERY_PAGE,$db_con);
if(!$result) {
error("DB_ERROR");
exit;
}
$total = mysql_affected_rows();
//오늘 등록 한사람;
//$today = date("Y-m-d");
//$todayCnt = Get_db("SELECT count(*) FROM member WHERE cdate LIKE '$today%'");
?>
<div id="contents">
<h2>Main counter List</h2>
<div id="content">
<table summary="관리자모드 게시판입니다" cellspacing="0" width="1000">
<colgroup>
<col width="50" />
<col width="30" />
<col width="40" />
<col width="100" />
<col />
<col width="90" />
<col width="80" />
<col width="80" />
</colgroup>
<thead>
<tr>
<th>위치</th>
<th>날짜</th>
<th>접속자수</th>
</tr>
</thead>
<tbody>
<?
if(!$total){
//echo "<tr><td colspan='$colsNum' align=center height='50px'>등록된 정보가 없습니다.</td></tr>";
echo "<tr><td colspan='2' align=center height='50px'>登録された情報がございません</td></tr>";
}else{
for($i=0; $i<$total; $i++) {
$row = mysql_fetch_array($result);
//$created = substr($row[created],0,10);
?>
<tr>
<td><?=$row[name]?></td>
<td><?=$row[startDay]?></td>
<td><b><?=$row[hit]?></b></td>
</tr>
<?
$Num--;
}
}
?>
</tbody>
</table>
<div class="page_list">
<!-- prev/next_std -->
<?=$viewlist2?>
<!-- prev/next_end -->
</div>
</div>
</div>
<p></p>
</body>
</html>