Dim Conn,strSQL,objRec
Set Conn = Server.Createobject("ADODB.Connection")
Conn.Open "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("mydatabase.mdb"),"" , ""
'*** Check Username & Password ***'
strSQL = "SELECT * FROM admin WHERE username = '"&strusername&"' and password = '"&strpassword&"' "
Set objRec = Conn.Execute(strSQL)
If Not objRec.EOF Then
response.redirect("http://localhost/myweb/user.asp") 'จะให้ไปหน้าไหนก้อใส่ลงไป'
'*** Session ***'
Session("username") = strusername
Else
Response.Write("<font color=red>**</font> username & password ???")
End IF
objRec.Close()
Conn.Close()
Set objRec = Nothing
Set Conn = Nothing
%>
Dim Conn,strSQL,objRec
Set Conn = Server.Createobject("ADODB.Connection")
Conn.Open "DRIVER={MySQL ODBC 5.1 Driver}; SERVER=localhost;port=3307;UID=root;pwd=usbw;database=shop;option=16384;"
'*** Check Username & Password ***'
strSQL = "SELECT * FROM admin WHERE UserName = '"&strusername&"' and Password = '"&strpassword&"' "
Set objRec = Conn.Execute(strSQL)
If Not objRec.EOF Then
response.redirect("หมวดหมู่สินค้า.asp") 'จะให้ไปหน้าไหนก้อใส่ลงไป'
'*** Session ***'
Session("username") = strusername
Else
Response.Write("<font color=red>**</font> username & password ???")
End IF
objRec.Close()
Conn.Close()
Set objRec = Nothing
Set Conn = Nothing
Dim Conn,strSQL,objRec
Set Conn = Server.Createobject("ADODB.Connection")
Conn.Open "DRIVER={MySQL ODBC 5.1 Driver}; SERVER=localhost;port=3307;UID=root;pwd=usbw;database=shop;option=16384;"
'*** Check Username & Password ***'
strSQL = "SELECT * FROM admin WHERE UserName = '"&Request.Form("strUsername")&"' and Password = '"&Request.Form("strPassword")&"' "
Set objRec = Conn.Execute(strSQL)
If Not objRec.EOF Then
response.redirect("หมวดหมู่สินค้า.asp") 'จะให้ไปหน้าไหนก้อใส่ลงไป'
'*** Session ***'
Session("username") = strusername
Else
Response.Write("<font color=red>**</font> username & password ???")
End IF
objRec.Close()
Conn.Close()
Set objRec = Nothing
Set Conn = Nothing