| Server IP : 104.21.80.248 / Your IP : 172.71.28.156 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 : E:/Inetpub/www/myschool/khaesai/modules/tkk9/ |
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=tkk9&file=search">
<table width=1005 border="0" align="right" cellpadding="0" cellspacing="0">
<tr class="unnamed1">
<td width="600" class="unnamed2"><A HREF="?name=tkk9&file=tabainuser"> <img src="images/back.png" align="absmiddle" ></A> <B>กลับหน้าทะเบียนรับหนังสือเวียนภายในของ<? echo $arr[user][category_name];?></B></td>
<td width="290" 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="190" 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_TKK9,"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[tkk9] = $db->select_query("SELECT * FROM ".TB_TKK9." WHERE topic like '%$search%' and category like '%,".$arr[user][id].",%' ORDER BY id DESC LIMIT $goto, $limit ");
while($arr[tkk9] = $db->fetch($res[tkk9])){
//Check Comment
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[comment] = $db->select_query("SELECT * FROM ".TB_TKK9_COMMENT." WHERE tkk9_id='".$arr[tkk9][id]."' and catno='".$arr[user][id]."' ORDER BY id LIMIT 1");
$arr[comment] = $db->fetch($res[comment]);
?>
<?
if(($arr[tkk9][id]==$arr[comment][tkk9_id])){
?>
<tr bgcolor="#FFFFFF">
<td valign="top"><img src="images/krut.png" width=15 align="absmiddle"> <?echo $arr[tkk9][topic];?></td>
<td valign="top" align="center" ><?echo ThaiTimeConvert($arr[tkk9][post_date],'','');?></td>
<td valign="top"> <? echo $arr[tkk9][posted];?></td>
<td valign="top" align="center" ><A HREF="popup.php?name=tkk9&file=readtkk9&id=<?echo $arr[tkk9][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="#999900"> รับแล้ว</font></td>
</tr>
<tr>
<td colspan="5" height="1" class="dotline" color=FFFF00></td>
</tr>
<? }?>
<?
}
?>
</table>
<?
SplitPage($page,$totalpage,"?name=tkk9&file=search&search=$search");
echo $ShowSumPages ;
echo $ShowPages ;
?>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>