01.
<?php
02.
session_start();
03.
mysql_connect(
"localhost"
,
"root"
,
"root"
); << ไม่ใช่รหัสจริงนะครับ
04.
mysql_select_db(
"trafficweight"
);
05.
$strSQL
=
"SELECT * FROM user WHERE username = '"
.mysql_real_escape_string(
$_POST
['username
'])."'
06.
and
Password =
'".mysql_real_escape_string($_POST['
password
'])."'
";
07.
$objQuery
= mysql_query(
$strSQL
);
08.
$objResult
= mysql_fetch_array(
$objQuery
);
09.
if
(!
$objResult
)
10.
{
11.
echo
"<script>"
;
12.
echo
"alert('รหัสผ่านผิด กรุณาล็อกอินใหม่ !!!');"
;
13.
echo
"window.location='Login.html';"
;
14.
echo
"</script>"
;
15.
}
16.
else
17.
{
18.
$_SESSION
[
"username"
] =
$objResult
[
"username"
];
19.
$_SESSION
[
"status"
] =
$objResult
[
"status"
];
20.
$_SESSION
[
"name"
] =
$objResult
[
"name"
];
21.
22.
23.
echo
"<script>"
;
24.
echo
"window.location='Home.php';"
;
25.
echo
"</script>"
;
26.
}
27.
28.
29.
mysql_close();
30.
?>