Login help

momal_1

Hi,

I have this login script which keeps saying login failed even though i have put in data which exists in the table.

Here is the code:

<?php
include('C:\adodb\adodb.inc.php');
echo "Open database connection <br>";

$db =& ADONewConnection('access');

// Microsoft Access connection string.
$dsn = "Driver={Microsoft Access Driver (*.mdb)};DBQ=F:\db1a.mdb";
$db->Connect($dsn);

$appUsername = $_POST["username"];
$appPassword = $_POST["password"];
// SQL statement to build recordset.
$recordSet = $db->Execute("SELECT * FROM customer WHERE Member_ID='$appUsername' AND Cust_ID='$appPassword'");
echo "$sql";    

echo "Open database connection 2<br>";
if ($recordSet->RecordCount < 1) {
    echo '<p align="center">Login Failed!</p><br>'.
    '<p>Your login was unsuccessful!! Please try loggin in again!';
    include ('userlogin.htm');            

} else {
    echo "Open database connection 3<br>";
    $_SESSION['login'] = true;
    $_SESSION['username'] = $appUsername;


echo '<p align="center">Success!</p><br>'.
'<p>Your login was successful! Welcome $appUsername!';
}
?>

I am connecting to a MS Access database and the query is being choed fine.

Can anyone see any thing wrong with this?

Many thanks

Kudose

Try chanhing:

if ($recordSet->RecordCount < 1) {

to:

if ($recordSet->RecordCount != "1") {

momal_1

Hi,

I tried that solution, but it still says login failed even if the input is wrong or right.

Can anyone help me?

Thanks

Krillan

Your original if statement would have worked fine. I think it's your SQL connection and/or statement. You should try to qualify those single quotes in that SQL statement.

I.E. instead of:

where Member_ID='$appUsername'

try:

where Member_ID=\'$appUsername\'

And do the same for the Cust_ID.

Just IMHO, Cust_ID is a terrible column name for the password that's associated with Member_ID :-) Make it Member_Pass or something that is relevant.

If the above suggestion doesn't work, let me know.

momal_1

Still saying login failed doing it that way.

I am just tryin to create the basic login, then will sort our the passwords. I am just tryin to get the fuinctionailty of the site working now.

Thanks

Krillan

So whatever the problem is, it has to do with the fact that your SQL execution is not returning any rows. I've never used the Microsoft Access database driver before, so I'm trusting that how you are initializing the driver and connecting to your .mdb file is correct.

Try to remove the WHERE statements all together, and see if a simple SELECT * from customers will return any records. Let me know...

momal_1

Yeah the select all returns 7 customers

Krillan

Ok, and I'm assuming that resulted in a "Success!" connection.

I still believe there's something fishy with those WHERE statements, and how the variable is being placed inside of the single quotes. Try not having the single quotes? I'll have to look this up real quick...

momal_1

Even with that off it still come sup with failed.

As i know there is 7 records i tried

if ($recordSet->RecordCount != "1") {

And this still came us as failed.

All the connection script is fine as this works for other php pages which retrieve all records from the table.

Many thanks for your time

Krillan

Well the reason that the line of code resulted in failed because 7 will certainly never be equal to 1 =) Your original line of code, however, will result in false (7 is not less than 1) and should result in a success.

Anywho, I think ur original single quotes were correct. I'm puzzled...this has become a nice challenge for me ;-)

momal_1

Sorry i posted it wrong - i changed it to:

if ($recordSet->RecordCount != "7") {

While i was using
SELECT * FROM customer;

Thanks!!

momal_1

Hi,

I changed you line to this:

if(!$appUsername || !$appPassword){  

echo "Variables didnt post!"; exit(); 
}  else {
echo "Variables did post!";
}

And this is the outcome from running this script:

Open database connection
Variables did post!Open database connection 2

Login Failed!

Your login was unsuccessful!! Please try loggin in again!

Its a weird problem!!

Thanks

Kudose

Welp, my last comments before running out of ideas....

Switch to MySQL. 🙂

Krillan

AHHH...

Try changing this:

$appUsername = $_POST["username"]; 
$appPassword = $_POST["password"];

to this:

$appUsername = $_POST['username']; 
$appPassword = $_POST['password'];

I dunno if the double quotes qualify correctly. I'm fairly new to PHP myself, so ;-)

momal_1

I have got that from everyone!!

I have to do it in Access for a project!!

Thanks

Kudose

Well, I do have one last idea.

change the $app vaiables to single quotes

echo out the $app variables instead of the if statement.

Maybe they are posting so it reads them, but they are empty or not posting right for some reason.

If that doesnt work, I bid you good luck.

momal_1

I modded your previos code again to this:

if(!$appUsername || !$appPassword){  

echo "Variables didnt post!"; exit(); 
}  else {
echo "Variables did post!$appUsername, $appPassword ";
}

The results from this are as expected so the form is posting fine.

I just changed the quotes and they made no difference

Thanks