| Server IP : 10.254.12.21 / Your IP : 10.254.12.21 Web Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/5.6.40 System : Linux arit.skru.ac.th 3.10.0-1160.76.1.el7.x86_64 #1 SMP Wed Aug 10 16:21:17 UTC 2022 x86_64 User : apache ( 48) PHP Version : 5.6.40 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/arit/ |
Upload File : |
<!DOCTYPE HTML>
<html>
<head>
<meta charset="utf-8">
<link rel="shortcut icon" href="images/logotab.ico"></head>
<link href="structer.css" rel="stylesheet" type="text/css">
<title>กระดานข่าว</title>
<style type="text/css">
<!--
.style1 {color: #0000FF}
-->
</style>
</head>
<style type="text/css">
.news_content
{
width:750px;
float:right;
}
.news_menu
{
width:200px;
float:left;
height:500px;
}
.sidebar_menu {
list-style: none;
margin: 0 0 30px;
padding: 0;
}
.sidebar_menu li {
margin: 0;
padding: 2px 0 3px 16px;
background: url(./images/templatemo_list_01.png) no-repeat scroll 0 8px;
border-bottom: 1px dotted #ccc
}
.sidebar_menu li a {
font-size: 14px;
}
#sidebar h3 {
font-size: 16px;
padding: 0 0 15px 0;
margin: 0 0 15px 0;
background: url(./images/sidebar_header_bg.png) left bottom no-repeat
}
h1 {
margin: 0 0 5px 0;
padding: 10px 0 10px 10px;
font-size: 24px;
font-weight: normal;
color: #ffffff;
background: #26405b;
}
h2 {
margin: 0 0 10px 0;
padding: 5px 0 5px 10px;
font-size: 16px;
}
h4 {
margin: 0;
padding: 3px 0 3px 10px;
font-size: 18px;
font-weight: bold;
color: #03F;
background: #EEE;
}
.section_02_box {
float: left;
width: 350px;
border: 1px solid #CCCCCC;
margin: 0 20px 0 0px;
}
.section_02_box .section_02_box_content{
float: left;
padding: 15px;
}
.section_02_box_content .section_02_box_content_title {
font-weight: bold;
}
.section_02_box_content ul{
clear: both;
list-style: none;
margin: 0;
padding: 0;
}
.section_02_box_content ul li{
padding: 0 0 5px 15px;
margin: 0;
background: url(images/templatemo_listicon.gif) top left no-repeat;
}
.section_02_box img {
float: left;
margin: 3px 15px 0 0;
}
.cleaner_with_height {
clear: both;
width: 100%;
height: 20px;
}
</style>
</style>
<body>
<!--start logo -->
<div id="logo">
<?php include "logo.php";?>
</div>
<!--end logo -->
<!-- start nav -->
<nav>
<div id="nav">
<div id="content-nav">
<?php include "navigator.php";?>
</div>
</div>
</nav>
<!-- start article -->
<article>
<div id="content"> <!-- start content -->
<div class="content-title">
ฐานข้อมูลออนไลน์แยกตามสาขา <img src="images/dot21.jpg" width="12px;">
<div class="content-line"></div>
</div>
<div class="content-text">
<div class="news_menu">
<ul class="sidebar_menu">
<li><a href='StatMonth.php' >สถิติรายเดือน</a></li>
<li><a href='StatYear.php' >สถิติรายปี</a></li>
</ul>
</div>
<div class="news_content">
<p align="center">
<form action="StatYear.php" method="post" name="regis">
<?php if (isset($_POST[year]))
{
$yearselected=$_POST[year];
}
else
{
include "connect.php";
$sql="select * from stat_detail order by year,month desc limit 0,1";
$query=mysql_query($sql);
$result=mysql_fetch_array($query);
$yearselected=$result[year];
//echo "--$yearselected --$monthselected";
}
include "connect.php";
echo " ปี <select name='year'>";
$sql="select * from year order by year desc";
$query=mysql_query($sql);
$row=mysql_num_rows($query);
$i=0;
while($i<$row)
{
$result=mysql_fetch_array($query);
$year=$result[year];
$yearthai=$year+543;
if ($yearselected==$year)
echo "<option value ='$year' selected> $yearthai </option>";
else
echo "<option value ='$year'> $yearthai </option>";
$i++;
}
echo "</select>";
echo " <input type='submit' value ='ดูรายการสถิติ'>";
?>
</form></p>
<br />
<br />
<TABLE
style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; BORDER-TOP: medium none; BORDER-RIGHT: medium none"
border=0 cellSpacing=0 borderColor=#35a0ff cellPadding=0 width=515>
<TBODY>
<TR>
<TD>
<TABLE border=0 cellSpacing=0 cellPadding=2 width="100%">
<TBODY>
<TR bgcolor="#6666FF">
<TD width=500 height="30" style="font-size:16px; color:#FFFFFF; width:500px; height:30px; ">
รายการ
<!-- icon_profile -->
</TD>
<TD width="100" vAlign="center" style="font-size:16px; color:#FFFFFF; width:100px; text-align:right;">
จำนวน
</TD>
<TD width="78" vAlign="top">
</TD>
</TR>
<tr bgcolor="#FFFFFF"><td colspan="2"></tr>
<?php include "connect.php";
$sql="SELECT *,sum(a.amount) as amount2 FROM stat_detail a join stat_list b on(a.id_list=b.id_list) join month d on (a.month=d.id_month) where a.year=$yearselected group by a.id_list ";
$query=mysql_query($sql);
$row=mysql_num_rows($query);
$i=0;
while ($i<$row)
{
$result=mysql_fetch_array($query);
$id_detail=$result[id_detail];
$amount=$result[amount2];
$name_list=$result[name_list];
$noun=$result[noun];
$year=$result[year];
$id_month=$result[id_month];
?> <TR>
<TD Height="20" bgColor=#eeeeee vAlign=top align="left"><p align="left" style="width:500px; font-size:14px;"><img src="images/templatemo_title.png" width="13" height="13" /> <?php echo"$name_list";?></p></TD>
<TD bgColor=#eeeeee vAlign=top align="right"><p align="right" style="width:100px; font-size:14px;"><?php echo number_format($amount);?></p></TD>
<td bgColor=#eeeeee vAlign=top align="center"><p align="left" style="width:78px; font-size:12px;"><?php echo"($noun)";?></p></td></TR>
<tr bgcolor="#FFFFFF"><td colspan="2"></tr>
<?php $i++;
}
?>
</TBODY></TABLE></TD></TR></TBODY></TABLE>
<div class="cleaner_with_height"> </div>
</div>
</div> <!-- end content-text -->
</div> <!-- end content -->
</article>
<footer>
<?php include "footer.php";?>
</footer>
</body>
</html>