| Server IP : 122.155.177.87 / Your IP : 122.155.177.87 Web Server : Apache/2 System : Linux cat177-87.static.lnwhostname.com 3.10.0-1160.62.1.el7.x86_64 #1 SMP Tue Apr 5 16:57:59 UTC 2022 x86_64 User : apache ( 994) PHP Version : 5.3.29 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname,putenv,eval MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/thungkhana/domains/thungkhanan.go.th/public_html/calendar/ |
Upload File : |
<?php require_once('../admin/Connections/conndb.php'); ?>
<?php
//echo $this_date;
/*$date_i=$_GET[date_i];
$temp=explode("/",$date_i);
$input=$temp[2]."-".$temp[1]."-".$temp[0];
//$sql="select * from table where field_date='$input' "*/
//echo $input;
if(isset($_POST[this_date])){
$date=$_POST[this_date];
}
else{
$date=$_GET[date];
}
$temp=explode("-",$date);
$input=$temp[2]."-".$temp[1]."-".$temp[0];
// echo $input;
$y=$temp[2]+543;
$m=$temp[1];
switch($m)
{
case "1":
$printmonth = "..";
break;
case "2":
$printmonth = "..";
break;
case "3":
$printmonth = "..";
break;
case "4":
$printmonth = "..";
break;
case "5":
$printmonth = "..";
break;
case "6":
$printmonth = "..";
break;
case "7":
$printmonth = "..";
break;
case "8":
$printmonth = "..";
break;
case "9":
$printmonth = "..";
break;
case "10":
$printmonth = "..";
break;
case "11":
$printmonth = "..";
break;
case "12":
$printmonth = "..";
break;
}
$date_review=$temp[0]." ".$printmonth." ".$y;
/*if(isset($_POST[person])){
$person=$_POST[person];
}
else{
$person=$_GET[person];
}*/
//echo " new = ".$person;
if($person == " " || $person == "all" || $persons=="0"){
//echo "empty value".$_POST['person'];
mysql_select_db($database_conndb, $conndb);
$query_rsNews = "SELECT * FROM calendar ORDER BY person ASC, created DESC";
$rsNews = mysql_query($query_rsNews, $conndb) or die(mysql_error());
$row_rsNews = mysql_fetch_assoc($rsNews);
$totalRows_rsNews = mysql_num_rows($rsNews);
}
else {
//echo "not empty value".$_POST['person'];
// $created=$years."-".$month."-".$dated;
mysql_select_db($database_conndb, $conndb);
$query_rsNews = "SELECT * FROM calendar where created = '".$input."' ORDER BY person";
//echo $query_rsNews;
$rsNews = mysql_query($query_rsNews, $conndb) or die(mysql_error());
$row_rsNews = mysql_fetch_assoc($rsNews);
$totalRows_rsNews = mysql_num_rows($rsNews);
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><!-- InstanceBegin template="/Templates/template_a.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<link href='cal/CalendarControl.css' rel='stylesheet' type='text/css'>
<script language='JavaScript' src='cal/CalendarControl.js'></script>
<!-- InstanceEndEditable -->
<?php
require_once('../admin/Connections/conndb.php');
mysql_select_db($database_conndb, $conndb);
?>
<title>ͧúǹӺŷ觢ҹ 99/9 1 Ӻ 觢ҹ ´ ѧѴ ѹ :: www.thungkhanan.go.th</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<link href="../styles.css" rel="stylesheet" type="text/css">
<!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable -->
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
background-color: #3CFFFF;
}
-->
</style>
<!--styles -->
<link href="../styles.css" rel="stylesheet" type="text/css" />
<link href="../css/Hover%20Buttons.css" rel="stylesheet" type="text/css"/>
<link href="../css/Hoverable-Sidenav.css" rel="stylesheet" type="text/css"/>
<!--<script src="https://platform-api.sharethis.com/js/sharethis.js#property=5d255a83d97c100012d80679&product='inline-share-buttons'
async='async" type='text/javascript'> -->
</script>
<!--styles -->
<style type="text/css">
<!--
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: none;
}
a:active {
text-decoration: none;
}
.style6 {color: #FFFFFF}
-->
</style></head>
<body background="../images/0bg1.png" style="background-repeat:no-repeat; background-position:top">
<!-- content -->
<div align="center">
<table width="950" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="top"><tr>
<td height="640" align="center" valign="top"> </td>
</tr>
<tr>
<td align="center" valign="top">
<table width="1000" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="top">
<div class="hover13 column">
<div>
<figure><a href="http://www.thungkhanan.go.th/index.php"><img src="../images/menu-top_01.png" border="0" /></a></figure>
</div> </td>
<td align="center" valign="top">
<div class="hover13 column">
<div>
<figure><a href="http://www.thungkhanan.go.th/news.php?cat_id=31" target="_blank"><img src="../images/menu-top_02.png" border="0" /></a></figure>
</div> </td>
<td align="center" valign="top">
<div class="hover13 column">
<div>
<figure><a href="http://www.thungkhanan.go.th/albums/index.php" target="_blank"><img src="../images/menu-top_03.png" border="0" /></a></figure>
</div> </td>
<td align="center" valign="top">
<div class="hover13 column">
<div>
<figure><a href="http://www.thungkhanan.go.th/office.php"><img src="../images/menu-top_04.png" border="0" /></a></figure>
</div> </td>
<td align="center" valign="top">
<div class="hover13 column">
<div></div> </td>
</tr>
</table>
</td>
</tr>
</td>
</tr>
<tr>
<td align="center" valign="top"><table width="980" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="top"> </td>
</tr>
<tr>
<td align="center" valign="top"> </td>
</tr>
<tr>
<td align="center" valign="top"><!-- InstanceBeginEditable name="EditRegion3" -->
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="0">
<tr>
<td class="title2"><div align="center"><img src="../images/botton/calender.png" width="640" height="78"></div></td>
</tr>
<tr>
<td class="styles1"><form id="form1" name="form1" method="POST" action="index.php">
<div align="right">͡ѹ ::
<style>
input {border:1px solid #0080C0}
.dateinput{background:url(images/date.gif) top left no-repeat; border:solid 1px #0080C0;
padding-left:20px;
}
</style>
<input name='this_date' type='text' id='date' value='<?=date('j-n-Y') ?>' class='dateinput' onfocus='showCalendarControl(this);' size='10' />
<label>
<input name="Submit" type="submit" class="btn-s" value="ŧ">
</label>
</div>
</form></td>
</tr>
<tr>
<td colspan="3" align="left" valign="top" class="title"><div align="center">ԷԹԺѵԧҹ Шѹ
<? echo $date_review; ?>
</div></td>
</tr>
<tr>
<td colspan="3" align="left" valign="top"> </td>
</tr>
<tr>
<td colspan="3" align="left" valign="top"><div align="center">
<?php if ($totalRows_rsNews > 0) { // Show if recordset not empty
do { ?>
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#999999">
<tr>
<td height="25" colspan="4" background="../images/bg4.gif" class="styles"><div align="left">
<?
if($row_rsNews[person]== "1"){
echo "¡ ͺ.";
} else if($row_rsNews[person]== "2"){
echo "ͧ¡ 1";
}else if($row_rsNews[person]== "3"){
echo "ͧ¡ 2";
}else if($row_rsNews[person]== "4"){
echo "ӹѡҹѴ";
}else if($row_rsNews[person]== "5"){
echo "ǹѧ";
}else if($row_rsNews[person]== "6"){
echo "ǹ¸";
}
?>
<a href="edit.php?id=<?php echo $row_rsNews[id]; ?>"></a> <a href="javascript:confirmDelete('delete.php?id=<?php echo $row_rsNews[id]; ?>')"></a></div></td>
</tr>
<tr>
<td width="10%" height="20" bgcolor="#FFD6C4" class="styles1"><div align="center"></div></td>
<td width="60%" height="20" bgcolor="#FFD6C4" class="styles1"><div align="center">Чҹ</div></td>
<td width="15%" height="20" bgcolor="#FFD6C4" class="styles1"><div align="center">ʶҹ</div></td>
<td width="15%" height="20" bgcolor="#FFD6C4" class="styles1"><div align="center">Ҿ</div></td>
</tr>
<?
if($row_rsNews[time_1]!="" || $row_rsNews[detail_1]!="" || $row_rsNews[where_1]!="" || $row_rsNews[by_1]!="") {
?>
<tr>
<td width="10%" height="20" valign="top" bgcolor="#FFFFFF" class="styles1"><div align="center">
<?php echo $row_rsNews[time_1]; ?>
</div></td>
<td width="60%" height="20" valign="top" bgcolor="#FFFFFF" class="styles1"> <?php echo $row_rsNews[detail_1]; ?></td>
<td width="15%" height="20" valign="top" bgcolor="#FFFFFF" class="styles1"><div align="left">
<?php echo $row_rsNews[where_1]; ?>
</div></td>
<td width="15%" height="20" valign="top" bgcolor="#FFFFFF" class="styles1"><div align="left">
<?php echo $row_rsNews[by_1]; ?>
</div></td>
</tr>
<? }
if($row_rsNews[time_2]!="" || $row_rsNews[detail_2]!="" || $row_rsNews[where_2]!="" || $row_rsNews[by_2]!="") { ?>
<tr>
<td width="10%" height="20" valign="top" bgcolor="#FFFFFF" class="styles1"><div align="center">
<?php echo $row_rsNews[time_2]; ?>
</div></td>
<td width="60%" height="20" valign="top" bgcolor="#FFFFFF" class="styles1"> <?php echo $row_rsNews[detail_2]; ?></td>
<td width="15%" height="20" valign="top" bgcolor="#FFFFFF" class="styles1"><div align="left">
<?php echo $row_rsNews[where_2]; ?>
</div></td>
<td width="15%" height="20" valign="top" bgcolor="#FFFFFF" class="styles1"><div align="left">
<?php echo $row_rsNews[by_2]; ?>
</div></td>
</tr>
<? }
if($row_rsNews[time_3]!="" || $row_rsNews[detail_3]!="" || $row_rsNews[where_3]!="" || $row_rsNews[by_3]!="") { ?>
<tr>
<td width="10%" height="20" valign="top" bgcolor="#FFFFFF" class="styles1"><div align="center">
<?php echo $row_rsNews[time_3]; ?>
</div></td>
<td width="60%" height="20" valign="top" bgcolor="#FFFFFF" class="styles1"> <?php echo $row_rsNews[detail_3]; ?></td>
<td width="15%" height="20" valign="top" bgcolor="#FFFFFF" class="styles1"><div align="left">
<?php echo $row_rsNews[where_3]; ?>
</div></td>
<td width="15%" height="20" valign="top" bgcolor="#FFFFFF" class="styles1"><div align="left">
<?php echo $row_rsNews[by_3]; ?>
</div></td>
</tr>
<? }
if($row_rsNews[time_4]!="" || $row_rsNews[detail_4]!="" || $row_rsNews[where_4]!="" || $row_rsNews[by_4]!="") { ?>
<tr>
<td width="10%" height="20" valign="top" bgcolor="#FFFFFF" class="styles1"><div align="center">
<?php echo $row_rsNews[time_4]; ?>
</div></td>
<td width="60%" height="20" valign="top" bgcolor="#FFFFFF" class="styles1"> <?php echo $row_rsNews[detail_4]; ?></td>
<td width="15%" height="20" valign="top" bgcolor="#FFFFFF" class="styles1"><div align="left">
<?php echo $row_rsNews[where_4]; ?>
</div></td>
<td width="15%" height="20" valign="top" bgcolor="#FFFFFF" class="styles1"><div align="left">
<?php echo $row_rsNews[by_4]; ?>
</div></td>
</tr>
<? }
if($row_rsNews[time_5]!="" || $row_rsNews[detail_5]!="" || $row_rsNews[where_5]!="" || $row_rsNews[by_5]!="") { ?>
<tr>
<td width="10%" height="20" valign="top" bgcolor="#FFFFFF" class="styles1"><div align="center">
<?php echo $row_rsNews[time_5]; ?>
</div></td>
<td width="60%" height="20" valign="top" bgcolor="#FFFFFF" class="styles1"> <?php echo $row_rsNews[detail_5]; ?></td>
<td width="15%" height="20" valign="top" bgcolor="#FFFFFF" class="styles1"><div align="left">
<?php echo $row_rsNews[where_5]; ?>
</div></td>
<td width="15%" height="20" valign="top" bgcolor="#FFFFFF" class="styles1"><div align="left">
<?php echo $row_rsNews[by_5]; ?>
</div></td>
</tr>
<? }
if($row_rsNews[time_6]!="" || $row_rsNews[detail_6]!="" || $row_rsNews[where_6]!="" || $row_rsNews[by_6]!="") { ?>
<tr>
<td width="10%" height="20" valign="top" bgcolor="#FFFFFF" class="styles1"><div align="center">
<?php echo $row_rsNews[time_6]; ?>
</div></td>
<td width="60%" height="20" valign="top" bgcolor="#FFFFFF" class="styles1"> <?php echo $row_rsNews[detail_6]; ?></td>
<td width="15%" height="20" valign="top" bgcolor="#FFFFFF" class="styles1"><div align="left">
<?php echo $row_rsNews[where_6]; ?>
</div></td>
<td width="15%" height="20" valign="top" bgcolor="#FFFFFF" class="styles1"><div align="left">
<?php echo $row_rsNews[by_6]; ?>
</div></td>
</tr>
<? } ?>
</table>
<?php } while ($row_rsNews = mysql_fetch_assoc($rsNews));
} // Show if recordset not empty ?>
</div></td>
</tr>
<?if ($totalRows_rsNews == 0) { // Show if recordset empty ?>
<tr>
<td height="100" colspan="4" bgcolor="#FFFFFF" class="red"><div align="center">Чҹ
</div></td>
</tr> <? }
?>
<tr>
<td colspan="3" align="left" valign="top"> </td>
</tr>
</table>
<!-- InstanceEndEditable --></td>
</tr>
</table></td>
</tr>
<tr>
<td align="center" valign="top"> </td>
</tr>
<tr>
<td align="center" valign="top"> </td>
</tr>
<tr>
<td align="center" valign="top"> </td>
</tr>
<tr>
<td align="center" valign="top" style="background-repeat:no-repeat"><img src="../images/foot.png"></td>
</tr>
</table>
</div>
<!-- end_content -->
<tr><td><a style="display:scroll;position:fixed;bottom:5px;right:5px;" class="backtotop" href="#top" rel="nofollow" title="Back to Top"><img src="../images/up.png" border="0" /></a></td>
</tr>
<map name="Map6" id="Map6"><area shape="rect" coords="210,1,302,41" href="http://www.tratlocal.go.th/index.php" target="_blank" />
</map>
</body>
<!-- InstanceEnd --></html>
<?php
mysql_free_result($rsNews);
if($conndb)
{
mysql_close($conndb);
unset($conndb);
}
?>