function set_pageview_cnt($pagename = "")
{
if ($pagename != "") {
$db = new DbMySqli();
$sql = "select idx from tbl_pageview_cnt";
$sql .= " where pagename = '{$pagename}' and date_format(regdate, '%Y-%m-%d %H') = date_format(now(), '%Y-%m-%d %H')";
$result = $db->query($sql);
$rows = mysqli_num_rows($result);
if ($rows <= 0) {
$data = $db->get_record("tbl_pageview_cnt", "ifnull(max(idx), 0) + 1 as idx");
$idx = $data['idx'];
$sql = "\n\t\t\tinsert tbl_pageview_cnt set\n\t\t\tidx = '{$idx}',\n\t\t\tpagename = '{$pagename}',\n\t\t\thit = '1',\n\t\t\tregdate = date_format(now(), '%Y-%m-%d %H')\n\t\t\t";
//echo $sql . "<br />";
$db->exec_sql($sql);
} else {
$sql = "\n\t\t\tupdate tbl_pageview_cnt set\n\t\t\thit = hit + 1\n\t\t\twhere pagename = '{$pagename}' and regdate = date_format(now(), '%Y-%m-%d %H')\n\t\t\t";
//echo $sql . "<br />
$db->exec_sql($sql);
}
}
}
<?php
include_once $_SERVER['DOCUMENT_ROOT'] . "/common/lib/common.php";
$db = new DbMySqli();
$idx = $_GET['idx'];
$page = $_GET['page'];
$search = $_GET['search'];
$sql = "\nupdate tbl_notice set hit = hit + 1\nwhere idx = '{$idx}'\n";
$db->exec_sql($sql);
$fields = "*";
$where_sql = " where idx = '{$idx}'";
$data = $db->get_record("tbl_notice", $fields, $where_sql);
if ($data == "") {
alert_error("not_data");
}
$title = stripslashes($data['title']);
$name = stripslashes($data['name']);
$regdate = $data['regdate'];
$hit = $data['hit'];
$content = stripslashes($data['content']);
?>
<!DOCTYPE html>
<html lang="ko">
<head>
<meta charset="utf-8">
<meta name="viewport" content="initial-scale=1.0,maximum-scale=1.0,minimum-scale=1.0,user-scalable=yes">
<title>서울대병원 스트레스관리프로그램</title>
<link rel="stylesheet" type="text/css" href="/style.css" />
<style type="text/css">
/* Giving a font-family and Size to give good look */
body{
