navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

 

User Login

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> General Web Development >> User Login
Page: [1]
 
zablo

 

Posts: 6
From: texarkana, texas, usa
Status: offline

 
User Login - 6/11/2001 17:48:00   
I have a web site that lets users login to an account. The database is ms access, and we are using SQnL code also.

We want the form to check the database's users so the person posting their information can login.

We are using this code for a '.inc' file:

<%
IF Session("Password") = "" THEN

Session("ORI_URL") = Request.ServerVariables("Path_Info")

Response.Redirect("main.asp?e=01")
Else


End IF
%>

We want, when a user logins in with invalid information, it will redirect them to 'main.asp' with an error (e) of '01'.(Which means an invalid login.)

What are we doing wrong, and how can we have that code (above) let our users login, and check for bad information.

Thanks,

Spooky

 

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

 
RE: User Login - 6/11/2001 18:43:00   
What is the purpose of :
Session("ORI_URL") = Request.ServerVariables("Path_Info") ?

If an incorrect login, I would just do :

Response.Redirect("/main.asp?e=01")

What part is actually failing?

------------------
§þððk¥
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!


(in reply to zablo)
zablo

 

Posts: 6
From: texarkana, texas, usa
Status: offline

 
RE: User Login - 6/11/2001 19:03:00   
Goto http://www.zablo.com/login/main.asp.


From there when somebody enters in the wrong information it goes to http://www.zablo.com/login/main.asp?e=01, and when they enter in the right it goes to .../login/login.asp.

When a username and password in entered it just goes to ...login/main.asp, even if it is the right information.


(in reply to zablo)
Spooky

 

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

 
RE: User Login - 6/11/2001 20:17:00   
What supposed to happen?
Im getting a few page errors going to that page.

Login here? > http://www.zablo.com/login/main.asp

On error > http://www.zablo.com/login/main.asp?e=01

On success > http://www.zablo.com/login/login.asp ?


(in reply to zablo)
zablo

 

Posts: 6
From: texarkana, texas, usa
Status: offline

 
RE: User Login - 6/11/2001 21:03:00   
Yes, those pages are correct, when somebody enters in incorrect info it goes to the main.asp?e=01.

If you enter in the correct info it is supposed to go to login.asp. So what coding are we doing wrong?

Thanks,


(in reply to zablo)
Spooky

 

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

 
RE: User Login - 6/11/2001 22:27:00   
You form is being processed on login.asp, what does that page do and how?

If you enter login.asp directly, you get directed back to main.asp?e=01

The fault must lay with the processing and redirection on login.asp?


(in reply to zablo)
zablo

 

Posts: 6
From: texarkana, texas, usa
Status: offline

 
RE: User Login - 6/11/2001 23:14:00   
If somebody directly types in login.asp, they have not entered in a username or password, so we want them to be redirected to main.asp?e=01.

But, if a user enters in right infoamtion ON main.asp when want them directed to login.asp with out being redirected back to main.asp?e=01.

Please help us fix this problem.


(in reply to zablo)
zablo

 

Posts: 6
From: texarkana, texas, usa
Status: offline

 
RE: User Login - 6/11/2001 23:20:00   
Look at main.asp?e=01 now, that is the error/page that we want people redirected to when bad information is provided


if they get it right we want them forwared to their account page located at login/login.asp


(in reply to zablo)
Spooky

 

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

 
RE: User Login - 6/12/2001 20:12:00   
What I mean, is that, something occurs on login.asp to either accept the user or decline the user.

When someone enters information on main.asp, the form sends them to login.asp where their user/password is processed.
Then if the user is declined, they are redirected from there to main.asp somehow, and if they are OK'd then I guess login.asp shows.

Is this code :

code:

<%
IF Session("Password") = "" THEN

Session("ORI_URL") = Request.ServerVariables("Path_Info")

Response.Redirect("main.asp?e=01")
Else


End IF
%>


the only check on login.asp??
If it is, where does Session("Password") come from? Where do you check the username etc?


------------------
§þððk¥
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!


(in reply to zablo)
zablo

 

Posts: 6
From: texarkana, texas, usa
Status: offline

 
RE: User Login - 6/12/2001 20:24:00   
ok, the login form posts to login.asp...and we have alredy determined that if bad information is supplied thye are forwared to main.asp?e=01

on main.asp '<!--#INCLUDE File="passprotect.inc"-->' is at the very top of the page...

the rest of the HTML is as follows:

<!--#INCLUDE File="passprotect.inc"-->
<html>
<head>
<meta name="Copyright"
content="All designs located on the Zablo website are copyright, (c) Zablo Web Technologies, Inc. Please send e-mail to support@zablo.pldesigns.com for more information about this site.">
<meta name="DC.description"
content="Zablo Domain Hosting: E-commerce solutions for you! Dedicated Access, Domain Name Registration. We'll help you get your own URL! We'll host your Web site on the Internet! Zablo. Get your own domain name.">
<meta name="DC.subject"
content="Zablo Domain Hosting: E-commerce solutions for you! Dedicated Access, Domain Name Registration. We'll help you get your own URL! We'll host your Web site on the Internet! Zablo. Get your own domain name.">
<meta name="DC.title"
content="Zablo Domain Hosting: E-commerce solutions for you! Dedicated Access.">
<meta name="description"
content="Zablo Domain Hosting: E-commerce solutions for you! Dedicated Access, Domain Name Registration. We'll help you get your own URL! We'll host your Web site on the Internet! Zablo. Get your own domain name.">
<meta name="Designer" content="1101">
<meta name="keywords"
content="Zablo Domain Hosting E-commerce Dedicated Access Zablo Domain Hosting E-commerce Dedicated Access Zablo's Domains Hostings E-commerces Dedicated Access Zablo's Domains Hostings E-commerces Dedicated Access Verioed Domained Hostinged E-commerced Dedicated Access Verioed Domained Hostinged E-commerced Dedicated Accessed Verioing Domaining Host E-commerceing Dedicated Accessing Verioing Domaining Host E-commerceing Dedicated Accessing Verioer Domainer Hostinger E-commercer Dedicated Access Verioer Domainer Hostinger E-commercer Dedicated Access Verior Domainor Hostingor E-commerceor Dedicated Access Verior Domainor Hostingor E-commerceor Dedicated Access Name Names Registration URL URLs Hosts Names Registration Name URL Internet Address Internet Addresses Web Address Web URLs Hosts Addresses">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta name="rating" content="General">
<meta name="revisit-after" content="30 days">
<meta name="ROBOTS" content="ALL">
<meta name="VW96.objecttype"
content="Zablo Domain Hosting: E-commerce solutions for you! Dedicated Access.">
<meta name="webmaster" content="1101">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<title>Zablo:  User Login</title>
<link rel="stylesheet" type="text/css" href="../style-main.css">
<style type="text/css">span.mono { font-family: monospace }
</style>
</head>
<body bgcolor="#000000" topmargin="0" leftmargin="0">

<center>

<table border="0" width="300" cellspacing="0" cellpadding="0" height="148">
<tr>
<td valign="top" bgcolor="#000000" height="44">
<!--webbot bot="Include" u-include="../zablo2.html" tag="BODY" -->

</td>
</tr>
<tr>
<td valign="top" bgcolor="#FFFFFF" height="104">
<!--webbot bot="DatabaseRegionStart" startspan
s-columnnames="fn,ln,address1,address2,city,state,zip,area,phone,areafax,phonefax,email,country,company,username,password,url,allorder"
s-columntypes="202,202,202,202,202,202,202,3,3,3,3,202,202,202,202,202,202,202"
s-dataconnection="zablo" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice="fn"
s-menuvalue="fn" b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE"
b-listlabels="FALSE" b-listseparator="FALSE" i-ListFormat="0" b-makeform="FALSE"
s-recordsource="login"
s-displaycolumns="fn,ln,address1,address2,city,state,zip,area,phone,areafax,phonefax,email,country,company,username,password,url,allorder"
s-criteria="[username] EQ {username} + [password] EQ {password} |" s-order s-sql="SELECT * FROM login WHERE (username = '::username::' AND password = ': assword::')" b-procedure="FALSE" clientside
SuggestedExt="asp" s-DefaultFields="username=&password="
s-NoRecordsFound="Invalid username and/or password, please try again."
i-MaxRecords="1" i-GroupSize="0" BOTID="1" u-dblib="../_fpclass/fpdblib.inc"
u-dbrgn1="../_fpclass/fpdbrgn1.inc" u-dbrgn2="../_fpclass/fpdbrgn2.inc"
tag="BODY"
local_preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">Database Results regions will not preview unless this page is fetched from a Web server using a web browser. The section of the page from here to the end of the Database Results region will repeat once for each record returned by the query.</font></td></tr></table>"
preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.</font></td></tr></table>" b-WasTableFormat="FALSE" --><!--#include file="../_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT * FROM login WHERE (username = '::username::' AND password = ': assword::')"
fp_sDefault="username=&password="
fp_sNoRecords="Invalid username and/or password, please try again."
fp_sDataConn="zablo"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="fn"
fp_sMenuValue="fn"
fp_iDisplayCols=18
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--#include file="../.inc"-->
<!--webbot bot="DatabaseRegionStart" i-CheckSum="20132" endspan -->

<table border="0" width="100%" cellspacing="0" cellpadding="0" height="100%">
<tr>
<td bgcolor="#EBEBEB" valign="top" width="249" height="256">
<!--webbot bot="Include" u-include="../safe/files/xtra/flash.shtml" tag="BODY"
-->



<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font face="Arial">
<img border="0" src="../images/trans.gif" width="252" height="1"></font></p>

<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font size="2" face="Arial">
  User Options:</font></p>
<blockquote>

<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font size="1" face="Arial"><img border="0" src="../images/button.gif">
<a href="../order/index.asp?username=<%=FP_FieldLink(fp_rs,"username")%>&password=<%=FP_FieldURL(fp_rs,"password")%>">Place
A New Order</a></font></p>

<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font size="1" face="Arial">
<img border="0" src="../images/button.gif"><a href="change.asp?username=<%=FP_FieldLink(fp_rs,"username")%>&password=<%=FP_FieldLink(fp_rs,"password")%>">
My Account Info</a>
</font></p>
<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font size="1" face="Arial">
<img border="0" src="../images/button.gif"> <a href="login.asp?username=<%=FP_FieldLink(fp_rs,"username")%>&password=<%=FP_FieldLink(fp_rs,"password")%>">Admin
Main</a>
</font></p>

<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font size="1" face="Arial">
<img border="0" src="../images/button.gif"> <a href="logout.asp?&username=<%=FP_FieldLink(fp_rs,"username")%>">Logout</a>
</font></p>

</blockquote>
<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font face="Arial"><font size="1">
  </font><font size="2">
Customer Options:</font></font></p>
<blockquote>

<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font size="1" face="Arial">
<img border="0" src="../images/button.gif"> <a href="<%=FP_FieldLink(fp_rs,"url")%>">View
My Web Site</a>
</font></p>
<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font size="1" face="Arial">
<a href="mailto:webdesignchange@zablo.com?Subject=<%=FP_FieldURL(fp_rs,"fn")%>&ln=<%=FP_FieldURL(fp_rs,"ln")%> (<%=FP_FieldURL(fp_rs,"username")%> ) Needs To Make Changes To Their Web Site.">
<img border="0" src="../images/button.gif">
Make Changes to Web Site</a></font></p>
<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font size="1" face="Arial">
<img border="0" src="../images/button.gif">
Make Changes to Account</font></p>

<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font size="1" face="Arial"><img border="0" src="../images/button.gif">
View All Orders</font></p>

</blockquote>

</td>
<td width="1470" height="456" bgcolor="#FFFFFF" valign="top">
<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font face="Arial">
<a href="../index.asp?3">Home</a>
<font color="#C0C0C0">
> </font><a href="main.asp">User Login</a>
<font color="#C0C0C0">
> </font>Logged In As: </font><span style="text-transform: capitalize"><font size="2" face="Arial"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="fn,ln,address1,address2,city,state,zip,area,phone,areafax,phonefax,email,country,company,username,password,url,allorder"
s-column="username" b-tableformat="FALSE" b-hasHTML="FALSE" clientside
local_preview="<font size="-1">&lt;&lt;</font>username<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>username<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"username")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="19455" endspan -->
</font>
</span></p>
<p style="word-spacing: 0; border-bottom: 1 solid #000000; margin-top: 0; margin-bottom: 0" align="right"><i><span style="text-transform: uppercase"><font face="Arial" size="4">WELCOME
BACK    <!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="fn,ln,address1,address2,city,state,zip,area,phone,areafax,phonefax,email,country,company,username,password,url,allorder"
s-column="fn" b-tableformat="FALSE" b-hasHTML="FALSE" clientside
local_preview="<font size="-1">&lt;&lt;</font>fn<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>fn<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"fn")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="4509" endspan -->  <!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="fn,ln,address1,address2,city,state,zip,area,phone,areafax,phonefax,email,country,company,username,password,url,allorder"
s-column="ln" b-tableformat="FALSE" b-hasHTML="FALSE" clientside
local_preview="<font size="-1">&lt;&lt;</font>ln<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>ln<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"ln")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="4893" endspan -->
</font>
</span></i></p>
<blockquote>
<p align="justify"><font face="Arial">  Welcome back <b><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="fn,ln,address1,address2,city,state,zip,area,phone,areafax,phonefax,email,country,company,username,password,url,allorder"
s-column="fn" b-tableformat="FALSE" b-hasHTML="FALSE" clientside
local_preview="<font size="-1">&lt;&lt;</font>fn<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>fn<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"fn")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="4509" endspan --> </b>, to your
Member Administration. We have completely redesigned the layout and have added
many new options. Please use the links below and to the left to navigate
around your section of Zablo.</font></p>
<div align="left">
<table border="0" width="234" height="1" cellspacing="0" cellpadding="0">
<tr>
<td width="134" height="1" bgcolor="#E6E6E6">
<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0" align="left"><font face="Arial" size="1">Your
Decrypted Username:</font></td>
<td width="84" height="1" bgcolor="#E6E6E6"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="fn,ln,address1,address2,city,state,zip,area,phone,areafax,phonefax,email,country,company,username,password,url,allorder"
s-column="username" b-tableformat="FALSE" b-hasHTML="FALSE" clientside
local_preview="<font size="-1">&lt;&lt;</font>username<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>username<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"username")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="19455" endspan -->
</font></td>
</tr>
<tr>
<td width="134" height="1" bgcolor="#E6E6E6"><font face="Arial" size="1">Your
E-Mail Address:</font></td>
<td width="84" height="1" bgcolor="#E6E6E6"><font face="Arial" size="1"><!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="fn,ln,address1,address2,city,state,zip,area,phone,areafax,phonefax,email,country,company,username,password,url,allorder"
s-column="email" b-tableformat="FALSE" b-hasHTML="FALSE" clientside
local_preview="<font size="-1">&lt;&lt;</font>email<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>email<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"email")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="10376" endspan -->
</font></td>
</tr>
</table>
</div>
<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"> </p>

<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font face="Arial">User Options:</font></p>
<blockquote>

<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font size="2" face="Arial"><img border="0" src="../images/button.gif">
<a href="../order/index.asp?username=<%=FP_FieldLink(fp_rs,"username")%>&password=<%=FP_FieldURL(fp_rs,"password")%>">Place
A New Order</a></font></p>

<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font size="2" face="Arial">
<img border="0" src="../images/button.gif"><a href="change.asp?username=<%=FP_FieldLink(fp_rs,"username")%>&password=<%=FP_FieldLink(fp_rs,"password")%>">
My Account Info</a>
</font></p>
<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font size="2" face="Arial">
<img border="0" src="../images/button.gif"> <a href="login.asp?username=<%=FP_FieldLink(fp_rs,"username")%>&password=<%=FP_FieldLink(fp_rs,"password")%>">Admin
Main</a></font></p>

<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font size="2" face="Arial">
<img border="0" src="../images/button.gif"> <a href="logout.asp?username=<%=FP_FieldLink(fp_rs,"username")%>">Logout</a></font></p>

</blockquote>
<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font face="Arial">Customer Options:</font></p>
<blockquote>

<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font size="2" face="Arial">
<img border="0" src="../images/button.gif"> <a href="<%=FP_FieldLink(fp_rs,"url")%>">View
My Web Site</a></font></p>
<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font size="2" face="Arial">
<a href="mailto:webdesignchange@zablo.com?Subject=<%=FP_FieldURL(fp_rs,"fn")%>&ln=<%=FP_FieldURL(fp_rs,"ln")%> (<%=FP_FieldURL(fp_rs,"username")%> ) Needs To Make Changes To Their Web Site.">
<img border="0" src="../images/button.gif">
Make Changes to Web Site</a></font></p>
<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font size="2" face="Arial">
<img border="0" src="../images/button.gif">
Make Changes to Account</font></p>

<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font size="2" face="Arial"><img border="0" src="../images/button.gif">
View All Orders</font></p>

</blockquote>
</blockquote>

</td>
</tr>
</table>

</td>
</tr>
</center>
</table>

<div align="center">
<center>

<table border="0" width="300" cellspacing="0" cellpadding="0" height="70">
<tr>
<td width="705" height="1" valign="top" bgcolor="#FFFFFF">
<!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="FALSE"
b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside tag="BODY"
local_preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="center"><font color="#000000">End of Database Results region.</font></td></tr></table>"
preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the end of a Database Results region.</font></td></tr></table>" --><!--#include file="../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" i-CheckSum="56926" endspan -->

</td>
</tr>
<tr>
<td width="705" height="76" valign="top" bgcolor="#000000">
<!--webbot bot="Include" u-include="../bottom2.html" tag="BODY" -->

</td>
</tr>
</table>

</center>
</div>

</body>
</html>


On this page is where the username and paswords are check to the database. WHat is wrong with the coding?


(in reply to zablo)
Page:   [1]

All Forums >> Web Development >> General Web Development >> User Login
Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts