| 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 : dl,eval,exec,mail,passthru,popen,posix_getpwuid,posix_kill,posix_mkfifo,posix_setegid,posix_seteuid,posix_setgid,posix_setpgid,posix_setsid,posix_setuid,posix_uname,proc_close,proc_open,putenv,shell_exec,show_source,system MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/moungngam/domains/moungngam.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 -->
<title>ͧúǹӺǧ Ӻǧ ѧѴк 18160 : www.moungngam.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 -->
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
//-->
</script>
<script type="text/javascript" language="JavaScript1.2" src="../Templates/stm31.js"></script>
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
background-color: #00CCFF;
}
.style2 {color: #CC6633}
-->
</style></head>
<body background="../images/tem_b1.jpg" style="background-repeat:no-repeat; background-position:top">
<div align="center" >
<table width="980" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top"><div align="center">
<table width="980" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top"><div align="center">
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="980" height="650">
<param name="movie" value="../images/head.swf">
<param name="quality" value="high">
<embed src="../images/head.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="980" height="650"></embed>
</object>
</div></td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td>
<tr>
<td valign="top"><div align="center">
<table width="980" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="200" valign="top"> </td>
</tr>
<tr>
<td height="2500" valign="top"><div align="center"><!-- 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/17.png" width="264" height="42"></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 --></div></td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td height="423" valign="top"><table width="980" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="300" valign="top" background="../images/foot.jpg"><div align="center" class="footer">
<p> </p>
<p> </p>
</div></td>
</tr>
</table></td>
</tr>
</table>
</div>
</body>
<!-- InstanceEnd --></html>
<?php
mysql_free_result($rsNews);
if($conndb)
{
mysql_close($conndb);
unset($conndb);
}
?>