% If request("Submit") <> "" then username = request.form("username") password = request.form("password") SQL = "Select count(username) as pass from tblusers where username = '" & username SQL = SQL & "' and [password] = '" & password & "'" Open_db() Set RS = objconn.execute(SQL) If rs("pass") > 0 then Session("SignedIn") = true Session("User") = username Session("Password") = password response.Redirect("course.asp") else Set rs = nothing Close_db() wrongpass = true end if end if %>
|
|||
|
|
|||
|