Login and check password from Database

•

•

•

•

What is DaniWeb IT Discussion Community?

You're currently browsing the ASP section within the Web Development category of DaniWeb, a massive community of 373,939 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,623 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our ASP advertiser: Lunarpages ASP Web Hosting

Thread Tools Display Modes

Views: 681 | Replies: 1 | Solved

Reply

•

•

Join Date: Mar 2007

Posts: 13

Reputation: roby4eldiablo is an unknown quantity at this point

roby4eldiablo is an unknown quantity at this point

Rep Power: 2

Solved Threads: 0

roby4eldiablo roby4eldiablo is offline

roby4eldiablo is offline

Offline

Newbie Poster

Login and check password from Database

#1

Apr 30th, 2008

Hi all. I have a login Form where user can insert Nickname & Password.
I have a database where i have listed new registered user and store their information.
The problem is when I control the Form data "pass" and check if it's equal to the rst("pwd")
into the database.
It never match....
The 2 password are equal but it look like if they are different.
Someone can help me please?

 Help with Code Tags 
 asp Syntax (Toggle Plain Text) 
var con;
var conString;
con = Server.CreateObject("ADODB.Connection");
conString = "Provider=Microsoft.Jet.OLEDB.4.0; "+ "Data Source= " + Server.MapPath("/negozio.mdb");
con.Open(conString);
var n, p, q;
n=Request.Form("nick");
p=Request.Form("pass");
var sSQLString;
var rst;
rst = Server.CreateObject("ADODB.Recordset");
sSQLString = "SELECT pwd FROM utenti WHERE nick='"+n+"';";
rst = con.Execute(sSQLString);
q=rst("pwd");
if (p != q)
{Response.write ("Password errata, reinserire la password corretta");
Response.AddHeader ("Refresh", "5;URL=login.asp"); 
con.Close( );
con = null;
}
else {Response.write ("Salve " + n + " benvenuto, tra un attimo potra accedere alle opzioni del sito");
Response.AddHeader ("Refresh", "5;URL=home.asp"); 
con.Close( );
con = null;
}
var con;
var conString;
con = Server.CreateObject("ADODB.Connection");
conString = "Provider=Microsoft.Jet.OLEDB.4.0; "+ "Data Source= " + Server.MapPath("/negozio.mdb");
con.Open(conString);
var n, p, q;
n=Request.Form("nick");
p=Request.Form("pass");
var sSQLString;
var rst;
rst = Server.CreateObject("ADODB.Recordset");
sSQLString = "SELECT pwd FROM utenti WHERE nick='"+n+"';";
rst = con.Execute(sSQLString);
q=rst("pwd");
if (p != q)
{Response.write ("Password errata, reinserire la password corretta");
Response.AddHeader ("Refresh", "5;URL=login.asp"); 
con.Close( );
con = null;
}
else {Response.write ("Salve " + n + " benvenuto, tra un attimo potra accedere alle opzioni del sito");
Response.AddHeader ("Refresh", "5;URL=home.asp"); 
con.Close( );
con = null;
}

Last edited by roby4eldiablo : Apr 30th, 2008 at 9:51 am.

Reply With Quote

•

•

Join Date: Mar 2007

Posts: 13

Reputation: roby4eldiablo is an unknown quantity at this point

roby4eldiablo is an unknown quantity at this point

Rep Power: 2

Solved Threads: 0

roby4eldiablo roby4eldiablo is offline

roby4eldiablo is offline

Offline

Newbie Poster

Re: Login and check password from Database

#2

May 2nd, 2008

I modify the sql string and the condition and all work properly.
I hope that someone can benefit from this article.

 Help with Code Tags 
 asp Syntax (Toggle Plain Text) 
var con;
var conString;
con = Server.CreateObject("ADODB.Connection");
conString = "Provider=Microsoft.Jet.OLEDB.4.0; "+ "Data Source= " + Server.MapPath("/negozio.mdb");
con.Open(conString);
var n, p;
n=Request.Form("nick");
p=Request.Form("pass");
var sSQLString;
Response.write (" "+n+"</br>");
Response.write (" "+p+"</br>");
var rst;
var sSQLString;
rst = Server.CreateObject("ADODB.Recordset");
sSQLString = "SELECT * FROM utenti WHERE nick='"+n+"' AND pwd='"+p+"';";
Response.write (" "+sSQLString+"</br>");
rst = con.Execute(sSQLString);
if(rst.EOF)
{Response.write ("Password errata, reinserire la password corretta");
Response.AddHeader ("Refresh", "5;URL=login.asp"); 
con.Close( );
con = null;
}
else {Response.write ("Salve " + n + " benvenuto, tra un attimo potra accedere alle opzioni del sito");
Response.AddHeader ("Refresh", "5;URL=home.asp"); 
con.Close( );
con = null;
}
var con;
var conString;
con = Server.CreateObject("ADODB.Connection");
conString = "Provider=Microsoft.Jet.OLEDB.4.0; "+ "Data Source= " + Server.MapPath("/negozio.mdb");
con.Open(conString);
var n, p;
n=Request.Form("nick");
p=Request.Form("pass");
var sSQLString;
Response.write (" "+n+"</br>");
Response.write (" "+p+"</br>");
var rst;
var sSQLString;
rst = Server.CreateObject("ADODB.Recordset");
sSQLString = "SELECT * FROM utenti WHERE nick='"+n+"' AND pwd='"+p+"';";
Response.write (" "+sSQLString+"</br>");
rst = con.Execute(sSQLString);
if(rst.EOF)
{Response.write ("Password errata, reinserire la password corretta");
Response.AddHeader ("Refresh", "5;URL=login.asp"); 
con.Close( );
con = null;
}
else {Response.write ("Salve " + n + " benvenuto, tra un attimo potra accedere alle opzioni del sito");
Response.AddHeader ("Refresh", "5;URL=home.asp"); 
con.Close( );
con = null;
}

Reply With Quote

Reply

•

•

•

•

Only community members can participate in forum threads. You must register or log in to contribute.

•

•

•

•

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

•

•

•

•

•

•

•

•

DaniWeb ASP Marketplace

•

•

•

•

Thread Tools	Display Modes
Show Printable Version Email this Page	Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads

Validating a User Imput with SQL Database (Login) (C#)
Create a Login page (asp,c#,sql2k5) (C#)
code for login and password..using vb6 (Visual Basic 4 / 5 / 6)
Please help with login page code behind (ASP.NET)
problems with sessions and login.php (PHP)
Database encryption (ASP.NET)
login check (ASP)
php help needed for login (PHP)

Other Threads in the ASP Forum

Previous Thread: What is client side vbscript?
Next Thread: Getting Started with asp.net

Forum Highlights

ASP Forum
Today's Posts
Unanswered Threads

Related Features

DANIWEB FEATURE INDEX

Advertisement

Statistics

Members: 373,939

Users Online Now: 2,623

Active IRC Users: 18

Forum Threads: 123,550

Forum Posts: 639,420

Code Snippets: 849

Blogs: 141

Blog Entries: 1,958

Directory Links: 564