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'] . "/sitemanage/include/check_admin.php";
include_once $_SERVER['DOCUMENT_ROOT'] . "/sitemanage/include/top.php";
$db = new DbMySqli();
$idx = $_POST['idx'];
$page = $_POST['page'];
$search = $_POST['search'];
$table = "tbl_session2";
$fields = "*";
$where_sql = " where idx = '{$idx}'";
$data = $db->get_record($table, $fields, $where_sql);
if ($data == "") {
alert_error("not_data");
}
$regdate = $data['regdate'];
$userip = $data['userip'];
$name = stripslashes($data['name']);
$state_positive_think1 = stripslashes($data['state_positive_think1']);
$state_positive_reaction1 = stripslashes($data['state_positive_reaction1']);
$state_negative_think1 = stripslashes($data['state_negative_think1']);
$state_negative_reaction1 = stripslashes($data['state_negative_reaction1']);
$state_positive_think2 = stripslashes($data['state_positive_think2']);
$state_positive_reaction2 = stripslashes($data['state_positive_reaction2']);
$state_negative_think2 = stripslashes($data['state_negative_think2']);
$state_negative_reaction2 = stripslashes($data['state_negative_reaction2']);
$positive_emotion = stripslashes($data['positive_emotion']);
$negative_emotion = stripslashes($data['negative_emotion']);
$positive_think = stripslashes($data['positive_think']);
$negative_think = stripslashes($data['negative_think']);
$positive_act = stripslashes($data['positive_act']);
//$members = $_REQUEST['members'];
$day_start = $_REQUEST['day_start'];
$day_end = $_REQUEST['day_end'];
$sort = $_REQUEST['sort'];
$yy = $_REQUEST['yy'];
$mm = $_REQUEST['mm'];
$dd = $_REQUEST['dd'];
//전체 카운터
/*
$table = "iroad_log";
$fields = "total";
$data = $db->get_record($table, $fields);
$total_count = $data['total'];
*/
$data = $db->get_record("iroad_log_data", "sum(hit) as hit");
$total_count = $data['hit'];
if (!$total_count) {
$total_count = 0;
}
if (!$mode) {
$title_name = "로그 분석";
}
if ($mode == 1) {
$title_name = "년도별 분석";
}
if ($mode == 2) {
$title_name = "월별 분석";
}
if ($mode == 3) {
$title_name = "일별 분석";
<?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{
$filesize = $_FILES["filename"]["size"];
$origin_filename = $filename;
$ext = strtolower(get_ext($filename));
new_check_ext($ext);
//금지파일 체크
$filename = get_filename($filepath1, $ext);
move_uploaded_file($_FILES["filename"]["tmp_name"], get_real_filepath($filepath1) . "/" . $filename);
} else {
$filesize = 0;
}
$table = "tbl_qna";
$fields = "thread, right(thread, 1)";
$sql = " where f_idx = '{$f_idx}'";
$sql .= " and length(thread) = length('{$thread}') + 1 and locate('{$thread}', thread) = 1";
$sql .= " order by thread desc limit 1";
$data = $db->get_record($table, $fields, $sql);
if ($data != "") {
$thread_head = substr($data[0], 0, -1);
$thread_foot = ++$data[1];
$new_thread = $thread_head . $thread_foot;
} else {
$new_thread = $thread . "a";
}
$userip = $_SERVER['REMOTE_ADDR'];
$sql = "select ifnull(max(idx), 0) + 1 from tbl_qna";
$result = $db->query($sql);
$rows = mysqli_fetch_row($result);
$max_idx = $rows[0];
$idx_field = "idx";
$db['mb_uniqid'] = $admin_uniqid;
$db['f_idx'] = $f_idx;
$ssyear = $stryear;
$ssmonth = $strmonth;
$ssday = $strday;
$seyear = $stryear;
$semonth = $strmonth;
$seday = $strday;
}
}
$pagename = $_REQUEST["pagename"];
$syear = $_REQUEST["syear"];
$smonth = $_REQUEST["smonth"];
$sday = $_REQUEST["sday"];
$sweekday = $_REQUEST["sweekday"];
$shour = $_REQUEST["shour"];
$sstatis_view = $_REQUEST["sstatis_view"];
$where_sql = " where 1";
if ($pagename != "") {
$where_sql .= " and pagename = '{$pagename}'";
}
//총 페이지뷰 수
$data = $db->get_record("tbl_pageview_cnt", "sum(hit) as hit", $where_sql);
$tot_cnt = $data['hit'];
if ($tot_cnt == "") {
$tot_cnt = 0;
}
//총 오늘 페이지뷰 수
$data = $db->get_record("tbl_pageview_cnt", "sum(hit) as hit", $where_sql . " and date_format(regdate, '%Y-%m-%d') = curdate()");
$today_cnt = $data['hit'];
if ($today_cnt == "") {
$today_cnt = 0;
}
<?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_postscript set hit = hit + 1\nwhere idx = '{$idx}'\n";
$db->exec_sql($sql);
$fields = "*";
$where_sql = " where idx = '{$idx}'";
$data = $db->get_record("tbl_postscript", $fields, $where_sql);
if ($data == "") {
alert_error("not_data");
}
$title = stripslashes($data['title']);
$name = stripslashes($data['name']);
$regdate = $data['regdate'];
$hit = $data['hit'];
$content = nl2br(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{
