% Set objCn = Server.CreateObject ("ADODB.Connection") Set objRs = Server.CreateObject ("ADODB.Recordset") objCn.ConnectionString = "Data Source="& Server.MapPath("./cgi-bin/ercsr02.mdb") objCn.Provider = "Microsoft.JET.OLEDB.4.0" objCn.Open %> <%%> <% session("login_name") function logkontrol() loginpassword = Request("formpassword") loginname = Request("formusername") session("message")="" if trim(loginname) = "" then Session("message") = "Kullanıcı adı?" exit function end if if trim(loginpassword) = "" then Session("message") = "Şifre?" exit function end if sql = "SELECT * FROM CUSTOMERS WHERE USERNAME='"& loginname &"'" objRs.Open sql,objCn,1,3 if objRs.EOF then Session("message") = "Kullanıcı bulunamadı" objRs.close exit function end if if loginpassword <> trim(objRs("PASSWORD") ) then Session("message") = "Hatalı şifre" objRs.close exit function end if Session("logincheck")= "OK" session("login_name")= loginname session("pass_word")= loginpassword objRs.close set user=nothing end function if Request.form("formsubmitted")="yes" then logkontrol else session("message")="" end if %> <% pagename="main" %>
|
||||||||||||||||||||||||||||||||||||||
|
|
Tekrar açılana kadar |
<%
sql=" SELECT * FROM PRESS WHERE ID IN (SELECT MAX(ID) FROM PRESS)"
objRS.open sql,objCN,1,3
%>
,650,450)">
<%=objRS("TITLE")%> <% objRS.close %> |
|
||||||||
|
|
|||||||||||