Ad:

ASP Discussion Thread
Marked Solved
Views: 5479

Permalink

Feb 5th, 2007

Creating a Login Page

Expand Post »

Hi Guys

I'm new in ASP and Access and I 'm trying to create a login page.

Please Help!!

Thanks in Advance

Similar Threads

Login Page Database connection to MSAccess in VB.NET
How to create one login page in ASP.NET using C# in C#
Creating Login Page in ASP.NET
Creating a login page in ASP
Simple ASP.Net Login Page (Using VB.Net) in ASP.NET

Goitse

Reputation Points: 12

Solved Threads: 0

Newbie Poster

Offline

13 posts
since Oct 2006

Permalink

Feb 22nd, 2007

Re: Creating a Login Page

Hi there,

this will help you understand how to create login page using ASP & ACCESS,

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>

<%

'This is first condition which will check user clicked on submit or not 

If Request("Submit") = "Submit" Then 



'Creating variables

dim fuser, fpass, duser, dpass



'Assigning Value to the variables which is entered by user

	fuser = Trim(Request.Form("userID"))

	fpass =  Trim(Request.Form("userPassword"))

	

'Assigning the database location into a variable, 

'Using ASP MapPath Method, The MapPath method maps a specified path to a physical path.

	database = Server.MapPath("/database/users.mdb") 



'ADO Connection Object

'The ADO Connection Object is used to create an open connection to a data source.

	set conn=Server.CreateObject("ADODB.Connection")

	conn.Provider="Microsoft.Jet.OLEDB.4.0"

	conn.Open database



'ADO Recordset Object

'The ADO Recordset object is used to hold a set of records from a database table.

'A Recordset object consist of records and columns (fields).

	set rs=Server.CreateObject("ADODB.recordset")

	rs.Open "Select * from loginInfo", conn 'Here ioginInfo is Table Name





'Assigning Value to the variables which already stored in database

		duser = Rs.Fields.Item("userName").Value

		dpass = Rs.Fields.Item("password").Value



'Now comparing both information (entered by user) with database information 

if fuser = duser And fpass = dpass Then



'If info Matched so user will redirect to the login Success page 

	Response.Redirect("Success.asp")

	

else



'else user will redirect to the same page with Message "Invalid username or password"

Response.Redirect "login.asp?msg=" & Server.URLENcode("Invalid username or password")



end if



end if 

%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Login Page</title>

</head>

<body>

<form id="form1" name="form1" method="post" action="login.asp">

  <table width="34%" border="0" align="center" cellpadding="3" cellspacing="03" bordercolor="#FFE5CA" bgcolor="#FFEFDF" style="border:#cccccc solid 1px;">

    <tr>

      <td colspan="2">

	  		<%

				if len(trim(request("msg"))) <> 0 then

				Response.write "<center><div><strong>"

				Response.write Request("msg")

				Response.write "</strong></div></center>"

				end if 

			%>

      </td>

    </tr>

    <tr>

      <td width="31%"><strong>User Name</strong> </td>

      <td width="69%"><input name="userID" type="text" id="userID" /></td>

    </tr>

    <tr>

      <td width="31%"><strong>Password</strong></td>

      <td width="69%"><input name="userPassword" type="password" id="userPassword" /></td>

    </tr>

    <tr>

      <td colspan="2"><div align="center">

          <input type="submit" name="Submit" value="Submit" style="text-align:center;" />

          <input type="reset" name="reset" value="Reset" style="text-align:center;" />

        </div></td>

    </tr>

  </table>

</form>

</body>

</html>

katarey

Reputation Points: 39

Solved Threads: 23

Junior Poster

Offline

167 posts
since Jul 2005

Permalink

Feb 23rd, 2007

Re: Creating a Login Page

Make sure you store your .mdb file outside your www (root) folder. As anyone can download a access.mdb file if you leaving it open to the internet.

www.domain.com/database/users.mdb is open to the internet and anyone can download it.

Mechanix

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

2 posts
since Feb 2007

Permalink

Feb 23rd, 2007

Re: Creating a Login Page

Yes! agree with Mechanix,
but for download .mdb file the name and location should know, and you can use password protection as well,

but the core thing is that you should store the mdb (database) out side of wwwroot folder

and if you store the (database) out side of wwwroot folder so you have to use the physical path. "C:\web_projects\My project\database\users.mdb"

just replace this line

ASP Syntax (Toggle Plain Text)
database = Server.MapPath("../database/users.mdb")
database = Server.MapPath("../database/users.mdb")

with

ASP Syntax (Toggle Plain Text)
database = "C:\web_projects\My project\database\users.mdb"
database = "C:\web_projects\My project\database\users.mdb"

Note this path for example only

if you are working on web server (hosting company) not the local system so you can fine the physical path. using Server.MapPath() function

ASP Syntax (Toggle Plain Text)
<% response.Write Server.MapPath("/") %>
<% response.Write Server.MapPath("/") %>

create a asp file with this code, which will write the physical path of your root folder

hope this will useful for you
regards,
Rahul

Last edited by katarey; Feb 23rd, 2007 at 2:41 pm.

katarey

Reputation Points: 39

Solved Threads: 23

Junior Poster

Offline

167 posts
since Jul 2005

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP Forum Timeline: Can i make an online questionaire using ASP?

Next Thread in ASP Forum Timeline: Prob with ASP

DaniWeb Message

Cancel Changes

User Name
Password