|
Server : Apache/2.2.2 (Fedora) System : Linux App1.pathumtani.go.th 2.6.20-1.2320.fc5smp #1 SMP Tue Jun 12 19:40:16 EDT 2007 i686 User : apache ( 48) PHP Version : 5.2.9 Disable Function : NONE Directory : /var/www/html/pathumthani_vc/report/pdir/admin/ |
Upload File : |
<?
$keyword_se = " ";
include ("../../../inc/conndb.inc.php");
if ($keyword != ""){
$keyword_department = str_replace("*", "%", $dep_sc);
$keyword_position = str_replace("*", "%", $position_sc);
$keyword_people = str_replace("*", "%", $people_sc);
$keyword_se = " or office_detail.th_name like '$keyworddep_sc' or officer.position like '$keywordposition_sc' or officer.th_name like '$keywordpeople_sc' ";
}
$sql = " SELECT * FROM office_detail INNER JOIN officer ON (office_detail.office_id = officer.office_id)";
$sql = $sql ." where $keyword_se ORDER BY officer.ID; ";
//echo $sql;
$query_result=mysql_db_query($dbname,$sql);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>ค้นหาแบบพิเศษ</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<link href="../../../common/basiccss.css" rel="stylesheet" type="text/css">
</head>
<body>
<form action="Advance_Searchgo.php" method="post" name="Adv_Search" id="Adv_Search">
<table width="434" border="0" cellspacing="1">
<tr>
<td colspan="3"><div align="center"><strong>Advance_Search</strong></div></td>
</tr>
<tr>
<td width="148"> </td>
<td> </td>
<td> </td>
</tr>
<tr bgcolor="#DDDDDD">
<td> ค้นหาจากชื่อหน่วยงาน : </td>
<td width="144"><input type="text" name="dep_sc" id="dep_sc"></td>
<td width="132"><font size="2" color="#336699"><strong> <input type="submit" name="Submit" value="Go"></strong></font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td> ค้นหาจากตำแหน่ง : </td>
<td><input name="position_sc" type="text" id="position_sc"></td>
<td><font size="2" color="#336699"><strong> <input type="submit" name="Submit2" value="Go"></strong></font></td>
</tr>
<tr bgcolor="#DDDDDD">
<td> ค้นหาจากชื่อบุคคล : </td>
<td bgcolor="#EEEEEE"><input name="people_sc" type="text" id="people_sc"></td>
<td bgcolor="#EEEEEE"><font size="2" color="#336699"><strong> <input type="submit" name="Submit3" value="Go"></strong></font></td>
</tr>
<tr align="center">
<td colspan="3"><br><input type="button" name="Button" value="ปิดหน้าต่างนี้" onClick="window.close();"></td>
</tr>
</table>
</form>
</body>
</html>