01.
<form name=
"frmSearch"
method=
"post"
action=
"<?=$_SERVER['SCRIPT_NAME'];?>"
>
02.
<b>เลือกรายการ</b>
03.
<!-- List Search -->
04.
<select name=
"ddlSelect"
id=
"ddlSelect"
>
05.
<option>- เลือก -</option>
06.
<option value=
"name"
<?
if
(
$_POST
[
"ddlSelect"
]==
"name"
){
echo
"selected"
;}?>>ชื่อ</option>
07.
<option value=
"surname"
<?
if
(
$_POST
[
"ddlSelect"
]==
"surname"
){
echo
"selected"
;}?>>นามสกุล</option>
08.
09.
<!-- Textarea Search -->
10.
<input placeholder=
"search"
name=
"search"
type=
"text"
id=
"search"
value=
"<?=$_POST["
search
"];?>"
>
11.
<input type=
"submit"
value=
"ค้นหา"
>
12.
<!-- Add button -->
13.
<form>
14.
<input type=
"button"
class
=
"button button2"
value=
"เพิ่มข้อมูล"
onclick=
"window.open('createstaff.php')"
/>
15.
</form>
16.
17.
</form>
18.
<?
19.
20.
$objConnect
= mysqli_connect(
"localhost"
,
"root"
,
"root"
,
"database"
)
or
die
(
"Error Connect to Database"
);
21.
22.
23.
24.
$strSQL
=
"SELECT * FROM staff WHERE 1 "
;
25.
if
(
$_POST
[
"ddlSelect"
] !=
""
and
$_POST
[
"search"
] !=
''
)
26.
{
27.
$strSQL
.=
" AND ("
.
$_POST
[
"ddlSelect"
].
" LIKE '%"
.
$_POST
[
"search"
].
"%' ) "
;
28.
}
29.
$objQuery
= mysqli_query(
$objConnect
,
$strSQL
)
or
die
(
"กรุณาเลือกรายการค้นหา"
);
30.
?>