01.
if
(
$_SESSION
[
'levelid'
] ==
"01"
){
02.
include_once
'_menufloating.php'
;
03.
echo
'<div id="mws-navigation">'
;
04.
echo
'<ul>'
;
05.
echo
'<li class="active"><a href="#" class="mws-i-24 i-home">'
;
06.
echo
'HOME'
;
07.
echo
'</li>'
;
08.
echo
'<li><a href="_main.php?page=salemanager" class="mws-i-24 i-chart">'
;
09.
echo
'งานขาย'
;
10.
echo
'</li>'
;
11.
echo
'<li><a href="#" class="mws-i-24 i-day-calendar">'
;
12.
echo
'จัดซื้อ/จัดจ้าง'
;
13.
echo
'</li>'
;
14.
exit
();
15.
}
if
(
$_SESSION
[
'levelid'
] ==
"02"
){
16.
include_once
'_menufloating.php'
;
17.
echo
'<div id="mws-navigation">'
;
18.
echo
'<ul>'
;
19.
echo
'<li class="active"><a href="#" class="mws-i-24 i-home">'
;
20.
echo
'HOME'
;
21.
echo
'<li><a href="#" class="mws-i-24 i-chart">'
;
22.
echo
'งานขาย'
;
23.
exit
();
24.
$connection_string
=
"DRIVER={SQL Server};SERVER=$servername;DATABASE=$databasename;AutoTranslate=no"
;
25.
$cid
= odbc_connect(
$connection_string
,
$user
,
$pass
);
26.
$query
= "SELECT * FROM [192.168.0.20].UFDATA_009_2012.dbo.Inventory a
27.
$result
= odbc_exec(
$cid
,
$query
);
28.
while
(odbc_fetch_row(
$result
)){
29.
echo
'<input type="text" class="mws-textinput" value="'
;
30.
echo
'$result["cInvCode"]'
;
31.
echo
'">'
;
32.
}