php logging in - Dev Articles

Dev Articles Community Forums Sponsor:

January 11th, 2005, 04:40 PM

bituthomas

Registered User

Join Date: Jan 2005

Posts: 5

Time spent in forums: < 1 sec
Reputation Power: 0

php logging in

Hi I have a problem. I am starting my PHP website and I have a login page and email. I also have a database in mySql.I am able to insert records through a form, but now I want to type in an email on the front page and I want the same e-mail to be retrieved from my database.

So I don't know how to match the email address on the page to the one in the database. please help.
This is the code and the page to which I have directed the home page on which email and password fields are present.

<html>

<head> This is a new page</head>
<body>
<?php
$db = mysql_connect("studb.cms.gre.ac.uk","****","****");
$rec = mysql_select_db("mdb_tb405");

$password=$HTTP_POST_VARS["frmpassword"];
$query="select * from jobseeker where password='$password'";
$result=mysql_query($query,$db);
$nmb=mysql_num_rows($result);// number of rows..in this case 1
if($nmb==1)
alert("This is valid");
$data=mysql_fetch_array($result);


?>
</body>
</html>

January 13th, 2005, 09:35 AM

ramz

Contributing User

Join Date: Jan 2003

Location: Juiz de Fora - MG- Brazil

Posts: 93

Time spent in forums: < 1 sec
Reputation Power: 6

Try this

I saw your post, but need more info to help you out. I need to know if you're using the PASSWORD() function of MySQL to store the passwords at your database. If yes, try the code below.

<html>

<head> This is a new page</head>
<body>
<?php
$db = mysql_connect("studb.cms.gre.ac.uk","****","****");
$rec = mysql_select_db("mdb_tb405");

$password = $_POST['frmpassword'];
$query = "select * from jobseeker where password = PASSWORD('$password')";
$result = mysql_query($query,$db);
$nmb = mysql_num_rows($result);
if($nmb) {
alert("This is valid");
$data = mysql_fetch_array($result);


}
?>
</body>
</html>

Regards,
Ramiro

__________________
Regards,
Ramiro Varandas Jr.

January 14th, 2005, 06:56 AM

bituthomas

Registered User

Join Date: Jan 2005

Posts: 5

Time spent in forums: < 1 sec
Reputation Power: 0

thanx

Thanks so much i have been waiting for a reply for three days but I finally figured out a way to do it. Thanks Ramiro.

January 14th, 2005, 07:29 AM

MadCowDzz

I'm Internet Famous

Dev Articles Frequenter (2500 - 2999 posts)

Join Date: Jan 2003

Location: Toronto, Canada

Posts: 2,890

Time spent in forums: 1 Week 16 h 14 m 9 sec
Reputation Power: 8

bituthomas,

How did you end up solving the problem?

January 14th, 2005, 08:09 AM

bituthomas

Registered User

Join Date: Jan 2005

Posts: 5

Time spent in forums: < 1 sec
Reputation Power: 0

solution

I used this code

<html>
<head>
<title>
Employement for You
</title>
</head>
<body>
<?php

$db = mysql_connect("studb.cms.gre.ac.uk","****","****");
$rec = mysql_select_db("mdb_tb405",$db);

$post_vars = $HTTP_POST_VARS;
$pwd = $HTTP_POST_VARS['pass'];
$email = $HTTP_POST_VARS['email'];

$result = mysql_query("SELECT email FROM userslist2 WHERE password ='$pwd' and email='$email'",$db);
$pno=mysql_numrows($result);

if ($pno >0)
{
header("Location

ptions.php?email=$email");
}
else
{
$msg="incorrect email or password";
header("Location:login.php?msg=$msg");
}
?>

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: