01.
<form action=
"show_core.php"
method=
"post"
>
02.
<table align=
"center"
width=
"65%"
><div align=
"center"
><tr>
03.
<td height=
"34"
align=
"right"
border=
"1"
>ZONE :</td>
04.
<td>
05.
<label
for
=
"zone_core"
></label>
06.
<select name=
"zone_core"
id=
"zone_core"
>
07.
<option selected=
"selected"
>กรุณาเลือก</option>
08.
<option value=
"1"
>1</option>
09.
<option value=
"2"
>2</option>
10.
<option value=
"3"
>3</option>
11.
<option value=
"4"
>4</option>
12.
<option value=
"5"
>5</option>
13.
<option value=
"6"
>6</option>
14.
<option value=
"7"
>7</option>
15.
<option value=
"8"
>8</option>
16.
<option value=
"9"
>9</option>
17.
<option value=
"10"
>10</option>
18.
</select>
19.
</td>
20.
<td>ค้นหารายละเอียดเอกสาร :
21.
<input type=
"text"
name=
"search"
id=
"search"
value=
"<? echo $core_description; ?>"
; />
22.
<input type=
"submit"
value=
"ค้นหา"
/></center></td></tr></div></table>
23.
<table width=
"80%"
align=
"center"
>
24.
<tr>
25.
<td width=
"40%"
><div align=
"right"
>[ <a href=
"show_asbuit.php"
> เอกสารแบบ Asbuit</a> ][</div></td>
26.
<td width=
"15%"
><div align=
"left"
><a href=
"core.php"
> เพิ่มเอกสาร Core Assignment</a> ]</div></td>
27.
</tr></table>
28.
<table border=
"2"
cellspacing=
"0"
cellpadding=
"2"
align=
"center"
width=
"65%"
>
29.
<tr>
30.
<th bgcolor=
"#FFFF33"
width=
"5%"
>ZONE</th>
31.
<th bgcolor=
"#FFFF33"
width=
"18%"
>ชื่อเอกสาร Core Assignment </th>
32.
<th bgcolor=
"#FFFF33"
width=
"18%"
>ไฟล์เอกสาร Core Assignment </th>
33.
<th bgcolor=
"#FFFF33"
width=
"8%"
>วันที่</th>
34.
<th bgcolor=
"#FFFF33"
width=
"15%"
>รายละเอียด</th>
35.
<th bgcolor=
"#FFFF33"
width=
"8%"
>แก้ไข l ลบ</th>
36.
37.
</tr>
38.
<?php
39.
$strQuery
=
"SELECT * FROM core_assignment"
;
40.
if
(isset(
$_POST
[
'search'
]) )
41.
{
42.
$strQuery
=
$strQuery
.
" WHERE core_description LIKE '%"
.
$_POST
['search
']. "%'
";
43.
$strQuery
=
$strQuery
.
" OR zone_core LIKE '%"
.
$_POST
['search
']. "%'
";
44.
}
45.
$strQuery
=
$strQuery
.
";"
;
46.
47.
$check_log
= mysql_query(
$strQuery
)
or
die
(mysql_error());
48.
49.
$num
= mysql_num_rows(
$check_log
);
50.
if
(
$num
<=0) {
51.
52.
}
53.
$n
=0;
54.
while
(
$objResult
= mysql_fetch_array(
$check_log
)){
55.
?>
56.
<tr>
57.
<td align=
"center"
><?=
$objResult
[
"zone_core"
]; ?></td>
58.
<td align=
"center"
><?=
$objResult
[
"core_name"
]; ?></td>
59.
<td align=
"center"
><?=
$objResult
[
"file_core"
]; ?></td>
60.
<td align=
"center"
><?=
$objResult
[
"date_core_up"
]; ?></td>
61.
<td align=
"center"
><?=
$objResult
[
"core_description"
]; ?></td>
62.
<td align=
"center"
>
63.
<a href=
"add_core.php?do=edit&sid=<?php echo $objResult["
core_id
"]; ?>"
>แก้ไข</a>
64.
|
65.
<a href=
"show_core.php?do=delete&sid=<?php echo $objResult["
core_id
"]; ?>"
>ลบ</a></td>
66.
</tr>
67.
<?php } ?>
68.
69.
</table></form>