| Server IP : 172.67.187.206 / Your IP : 172.71.28.155 Web Server : Apache/2.4.25 (Win32) OpenSSL/1.0.2j PHP/5.6.30 System : Windows NT WIN-ECQAAA40806 6.2 build 9200 (Windows Server 2012 Standard Edition) i586 User : SYSTEM ( 0) PHP Version : 5.6.30 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /Inetpub/www/myschool/nongtakya/modules/tkk3/ |
Upload File : |
<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<TABLE width="1005" align=center cellSpacing=0 cellPadding=0 border=0>
<TR>
<TD align=center valign="top">
<?
// CheckUser($_SESSION['user_user']);
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE username='".$_SESSION['user_user']."' ");
$arr[user] = $db->fetch($res[user]);
?>
<form name="form3" method="post" action="?name=tkk3&file=tabainuser&op=tkk3_read">
<table width=1005 border="0" align="right" cellpadding="0" cellspacing="0">
<tr class="unnamed1">
<td width="600" class="unnamed2"><A HREF="?name=tkk3&file=rab"> <img src="images/back.png" align="absmiddle" ></A> <B>กลับหน้าทะเบียนรับหนังสือเวียนภายในของ<? echo $arr[user][category_name];?></B></td>
<td width="230" align="right"><div align="right"><strong>ระบุชื่อหนังสือที่ต้องการคันหา </strong></div></td>
<td width="100" align="right" ><input name="search" type="text" id="search" value="<?=$_GET["search"];?>"></td>
<td width="70"><div align="left"> <input type="submit" name="Submit2" value="ค้นหา"></div></td>
</tr>
</table>
</form>
</TD>
</TR>
<TR>
<TD>
<TABLE width="1005" height=500 align=center cellSpacing=0 cellPadding=0 border=0>
<TR>
<TD valign="top">
<TABLE width="100%" align=center cellspacing="1" cellpadding="1" >
<tr bgcolor="#6fd1dc" height=25>
<td width="470" align="center"><font color="#FFFFFF"><B>เรื่อง</B></font></td>
<td width="130" align="center"><font color="#FFFFFF"><B>วันที่ส่ง</B></font></td>
<td width="200" align="center"><font color="#FFFFFF"><B>เจ้าของเรื่อง</B></font></td>
<td width="80" align="center"><font color="#FFFFFF"><B>ดูเอกสาร</B></font></td>
<td width="80" align="center"><font color="#FFFFFF"><B>สถานะ</B></font></td>
</tr>
<?
// CheckUser($_SESSION['user_user']);
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE username='".$_SESSION['user_user']."' ");
$arr[user] = $db->fetch($res[user]);
//แสดงบทความ
$limit = 10 ;
$SUMPAGE = $db->num_rows(TB_TKK3,"id","$SQLwhere topic like '%$search%' and category like '%,".$arr[user][id].",%' ");
$page=$_GET[page];
if (empty($page)){
$page=1;
}
$rt = $SUMPAGE%$limit ;
$totalpage = ($rt!=0) ? floor($SUMPAGE/$limit)+1 : floor($SUMPAGE/$limit);
$goto = ($page-1)*$limit ;
$res[tkk3] = $db->select_query("SELECT * FROM ".TB_TKK3." WHERE topic like '%$search%' and category like '%,".$arr[user][id].",%' ORDER BY id DESC LIMIT $goto, $limit ");
while($arr[tkk3] = $db->fetch($res[tkk3])){
//Check Comment
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[comment] = $db->select_query("SELECT * FROM ".TB_TKK3_COMMENT." WHERE tkk3_id='".$arr[tkk3][id]."' and name='".$arr[user][category_name]."' ORDER BY id LIMIT 1");
$arr[comment] = $db->fetch($res[comment]);
?>
<?
if(($arr[tkk3][id]==$arr[comment][tkk3_id])){
?>
<tr bgcolor="#FFFFFF">
<td valign="top"><img src="images/krut.png" width=15 align="absmiddle"> <?echo $arr[tkk3][topic];?></td>
<td valign="top" align="center" ><?echo ThaiTimeConvert($arr[tkk3][post_date],'','');?></td>
<td valign="top"> <? echo $arr[tkk3][posted];?></td>
<td valign="top" align="center" ><A HREF="popup.php?name=tkk3&file=readtkk3_1&id=<?echo $arr[tkk3][id];?> " onclick="return hs.htmlExpand(this, { contentId: 'highslide-html', objectType: 'iframe', objectWidth: 800, objectHeight: 600} )" class="highslide"><img src="images/read.png" width=20></A></td>
<td valign="top" align="center" ><font color="#339900"> รับแล้ว</font></td>
</tr>
<tr>
<td colspan="5" height="1" class="dotline" color=FFFF00></td>
</tr>
<? }?>
<?
}
?>
</table>
<?
SplitPage($page,$totalpage,"?name=tkk3&file=tabainuser&search=$search");
echo $ShowSumPages ;
echo $ShowPages ;
?>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>