Viewing file:  admin-dashboard.php (13.08 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
require_once('check_session.php');
?>
<!doctype html>
<html class="fixed">
<head>
<!-- Basic -->
<meta charset="UTF-8">
<title>Administrator | สมาคมนักกฎหมายสาธารณสุข</title>
<meta name="keywords" content="HTML5 Admin Template" />
<meta name="description" content="สมาคมนักกฎหมายสาธารณสุข,กฎหมายกระทรวงสาธารณสุข">
<meta name="author" content="mophlawyer.com">
<!-- Mobile Metas -->
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no" />
<!-- Web Fonts -->
<link href="https://fonts.googleapis.com/css?family=Mitr:300" rel="stylesheet">
<!-- Vendor CSS -->
<link rel="stylesheet" href="assets/vendor/bootstrap/css/bootstrap.css" />
<link rel="stylesheet" href="assets/vendor/font-awesome/css/font-awesome.css" />
<link rel="stylesheet" href="assets/vendor/magnific-popup/magnific-popup.css" />
<link rel="stylesheet" href="assets/vendor/bootstrap-datepicker/css/datepicker3.css" />
<!-- Specific Page Vendor CSS -->
<link rel="stylesheet" href="assets/vendor/bootstrap-fileupload/bootstrap-fileupload.min.css" />
<!-- Theme CSS -->
<link rel="stylesheet" href="assets/stylesheets/theme.css" />
<!-- Skin CSS -->
<link rel="stylesheet" href="assets/stylesheets/skins/default.css" />
<!-- Theme Custom CSS -->
<link rel="stylesheet" href="assets/stylesheets/theme-custom.css">
<!-- Head Libs -->
<script src="assets/vendor/modernizr/modernizr.js"></script><!-- Vendor CSS -->
<link rel="stylesheet" href="assets/vendor/bootstrap/css/bootstrap.css" />
<link rel="stylesheet" href="assets/vendor/font-awesome/css/font-awesome.css" />
<link rel="stylesheet" href="assets/vendor/magnific-popup/magnific-popup.css" />
<link rel="stylesheet" href="assets/vendor/bootstrap-datepicker/css/datepicker3.css" />
<!-- Specific Page Vendor CSS -->
<link rel="stylesheet" href="assets/vendor/select2/select2.css" />
<link rel="stylesheet" href="assets/vendor/jquery-datatables-bs3/assets/css/datatables.css" />
<!-- Theme CSS -->
<link rel="stylesheet" href="assets/stylesheets/theme.css" />
<!-- Skin CSS -->
<link rel="stylesheet" href="assets/stylesheets/skins/default.css" />
<!-- Theme Custom CSS -->
<link rel="stylesheet" href="assets/stylesheets/theme-custom.css">
<!-- Head Libs -->
<script src="assets/vendor/modernizr/modernizr.js"></script>
</head>
<body>
<section class="body">
<?php require_once("topnav.php"); ?>
<div class="inner-wrapper">
<?php require_once("sidebar.php"); ?>
<section role="main" class="content-body">
<header class="page-header">
<h2>Dashboard</h2>
<div class="right-wrapper pull-right">
<ol class="breadcrumbs">
<li>
<a href="index.html">
<i class="fa fa-home"></i>
</a>
</li>
<li><span><?php shownamesite(); ?></span></li>
</ol>
<div class="sidebar-right-toggle"></div>
</div>
</header>
<!-- start: page -->
<div class="row">
<div class="col-md-12 col-lg-6 col-xl-6">
<section class="panel panel-featured-left panel-featured-secondary">
<div class="panel-body">
<div class="widget-summary">
<div class="widget-summary-col widget-summary-col-icon">
<div class="summary-icon bg-secondary">
<i class="fa fa-graduation-cap"></i>
</div>
</div>
<?php
require_once ('db.php');
$result=$conn->prepare("SELECT * FROM tbl_image");
$result->execute();
$num_rows = (int)$result->rowCount();
?>
<div class="widget-summary-col">
<div class="summary">
<h4 class="title">นิติกรทั้งหมด</h4>
<div class="info">
<strong class="amount"><?php echo $num_rows; ?></strong> <span class="text">คน</span>
</div>
</div>
<div class="summary-footer">
</div>
</div>
</div>
</div>
</section>
</div>
<div class="col-md-12 col-lg-6 col-xl-6">
<section class="panel panel-featured-left panel-featured-tertiary">
<div class="panel-body">
<div class="widget-summary">
<div class="widget-summary-col widget-summary-col-icon">
<div class="summary-icon bg-tertiary">
<i class="fa fa-group"></i>
</div>
</div>
<?php
$result1=$conn->prepare("SELECT * FROM tbl_members");
$result1->execute();
$num_rows1 = (int)$result1->rowCount();
?>
<div class="widget-summary-col">
<div class="summary">
<h4 class="title">สมาชิกทั้งหมด</h4>
<div class="info">
<strong class="amount"><?php echo $num_rows1; ?> </strong> <span class="text">คน</span>
</div>
</div>
<div class="summary-footer">
</div>
</div>
</div>
</div>
</section>
</div>
<div class="col-md-12 col-lg-6 col-xl-6">
<section class="panel panel-featured-left panel-featured-tertiary">
<div class="panel-body">
<?php
$result2=$conn->prepare("SELECT * FROM up_files WHERE cattype='1'");
$result2->execute();
$num_rows2 = (int)$result2->rowCount();
?>
<div class="widget-summary">
<div class="widget-summary-col widget-summary-col-icon">
<div class="summary-icon bg-tertiary">
<i class="fa fa-pencil-square"></i>
</div>
</div>
<div class="widget-summary-col">
<div class="summary">
<h4 class="title">รายการข่าวประชาสัมพันธ์</h4>
<div class="info">
<strong class="amount"><?= $num_rows2; ?></strong><span class="text">รายการ</span>
</div>
</div>
<div class="summary-footer">
<a class="text-muted text-uppercase" href="admin-all-page.php?cat=1">(ดูทั้งหมด)</a>
</div>
</div>
</div>
</div>
</section>
</div>
<div class="col-md-12 col-lg-6 col-xl-6">
<section class="panel panel-featured-left panel-featured-quartenary">
<div class="panel-body">
<div class="widget-summary">
<div class="widget-summary-col widget-summary-col-icon">
<div class="summary-icon bg-quartenary">
<i class="fa fa-download"></i>
</div>
</div>
<?php
$result3=$conn->prepare("SELECT * FROM up_files WHERE cattype='3'");
$result3->execute();
$num_rows3 = (int)$result3->rowCount();
?>
<div class="widget-summary-col">
<div class="summary">
<h4 class="title">เอกสารดาวน์โหลด</h4>
<div class="info">
<strong class="amount"><?= $num_rows3; ?></strong><span class="text">รายการ</span>
</div>
</div>
<div class="summary-footer">
<a class="text-muted text-uppercase" href="admin-all-page.php?cat=3">(รายงการทั้งหมด)</a>
</div>
</div>
</div>
</div>
</section>
</div>
<div class="col-md-12 col-lg-6 col-xl-6">
<section class="panel panel-featured-left panel-featured-success">
<div class="panel-body">
<div class="widget-summary">
<div class="widget-summary-col widget-summary-col-icon">
<div class="summary-icon bg-success">
<i class="fa fa-university"></i>
</div>
</div>
<?php
$result4=$conn->prepare("SELECT * FROM up_files WHERE cattype='4'");
$result4->execute();
$num_rows4 = (int)$result4->rowCount();
?>
<div class="widget-summary-col">
<div class="summary">
<h4 class="title">ข้อบังคับ</h4>
<div class="info">
<strong class="amount"><?= $num_rows4; ?></strong><span class="text">รายการ</span>
</div>
</div>
<div class="summary-footer">
<a class="text-muted text-uppercase" href="admin-all-page.php?cat=4">(รายงการทั้งหมด)</a>
</div>
</div>
</div>
</div>
</section>
</div>
<div class="col-md-12 col-lg-6 col-xl-6">
<section class="panel panel-featured-left panel-featured-warning">
<div class="panel-body">
<div class="widget-summary">
<div class="widget-summary-col widget-summary-col-icon">
<div class="summary-icon bg-warning">
<i class="fa fa-gavel"></i>
</div>
</div>
<?php
$result5=$conn->prepare("SELECT * FROM up_files WHERE cattype='5'");
$result5->execute();
$num_rows5 = (int)$result5->rowCount();
?>
<div class="widget-summary-col">
<div class="summary">
<h4 class="title">ระเบียบสมาคม</h4>
<div class="info">
<strong class="amount"><?= $num_rows5; ?></strong><span class="text">รายการ</span>
</div>
</div>
<div class="summary-footer">
<a class="text-muted text-uppercase" href="admin-all-page.php?cat=5">(รายงการทั้งหมด)</a>
</div>
</div>
</div>
</div>
</section>
</div>
</div>
<!-- Vendor -->
<script src="assets/vendor/jquery/jquery.js"></script>
<script src="assets/vendor/jquery-browser-mobile/jquery.browser.mobile.js"></script>
<script src="assets/vendor/bootstrap/js/bootstrap.js"></script>
<script src="assets/vendor/nanoscroller/nanoscroller.js"></script>
<script src="assets/vendor/bootstrap-datepicker/js/bootstrap-datepicker.js"></script>
<script src="assets/vendor/magnific-popup/magnific-popup.js"></script>
<script src="assets/vendor/jquery-placeholder/jquery.placeholder.js"></script>
<!-- Specific Page Vendor -->
<script src="assets/vendor/select2/select2.js"></script>
<script src="assets/vendor/jquery-datatables/media/js/jquery.dataTables.js"></script>
<script src="assets/vendor/jquery-datatables/extras/TableTools/js/dataTables.tableTools.min.js"></script>
<script src="assets/vendor/jquery-datatables-bs3/assets/js/datatables.js"></script>
<!-- Theme Base, Components and Settings -->
<script src="assets/javascripts/theme.js"></script>
<!-- Theme Custom -->
<script src="assets/javascripts/theme.custom.js"></script>
<!-- Theme Initialization Files -->
<script src="assets/javascripts/theme.init.js"></script>
<!-- Examples -->
<script src="assets/javascripts/tables/examples.datatables.default.js"></script>
<script src="assets/javascripts/tables/examples.datatables.row.with.details.js"></script>
<script src="assets/javascripts/tables/examples.datatables.tabletools.js"></script>
</body>
</html>
|