01.
include
(
"Connect.php"
);
02.
header(
'Content-Type: text/html; charset=utf-8'
);
03.
$conn
=
new
DB;
04.
05.
06.
07.
if
(!isset(
$_POST
[
'term'
])){
08.
09.
$fetchData
=
$conn
->Selectrecordjoin(
"select TOP (5) PERCENT * FROM Mat_keyword order by id asc "
);
10.
}
else
{
11.
12.
13.
$search
=
$conn
->converttoutf8(
$_POST
[
'term'
]);
14.
$fetchData
=
$conn
->Selectrecordjoin(
"select * FROM Mat_keyword where key_word Like '%$search%' "
);
15.
16.
17.
18.
}
19.
$data
=
array
();
20.
21.
while
(
$row
=
$conn
->parseArray(
$fetchData
)) {
22.
23.
$Section
=
$conn
->converttotis620(
$row
[
'Description'
]);
24.
$Material_Select
=
$conn
->converttotis620(
$row
[
'Material'
]);
25.
26.
$data
[] =
array
(
"id"
=>
$row
[
'id'
],
"Material"
=>
$row
[
'Material'
],
"text"
=>
$Section
);
27.
28.
}
29.
echo
json_encode(
$data
);