if and esle if help

webnewone

Hi,

I run a small website that requires members to log into their account. Its a very basic mysql database that presents the user with their account details by entering a username and password.

The part of my php code that checks the username and password (stored in the mysql db) is a little messy. If it is incorrect it prints a messy message I would much rather it go to a seperate html page if the username and/or password is incorrect.

Here is what I have at the moment:

.............

$num = mysql_numrows($result);

if ($num == 1) {
$row = mysql_fetch_array($result);

}
else if ($num == 0)

{

echo "<h1 align=center>Your Password and/or Username Are Incorrect! Hit Your Back Button and TRY AGAIN</h1><br><p align=center>If the problem persists report it to Admin</p>\n";

}

see all it does is echo a messy "password incorrect" statement. How do I modify that so it goes to an html page if the password is incorrect? What should I add to the above code?

Sorry if this is elementary - i'm really new at this - bought a book and stooopidly thought I could take on the world! :-)

Best wishes

Gavin!

planetsim

use header();
You may wanna use a switch statement as well.

chads2k2

Here is a simple and yet effective PHP/MySQL happy medium login. I wrote it back in the day so its been updated and goes through a TON more checks and stuff now.

<?php
if(isset($login)){
include("connection.inc");
$sql = "select * from member_info where username='$username'";
$result = mysql_query($sql);
if (mysql_num_rows($result) < 1) {

// Checks to see if their Username is all good. If not then it goes to the sorry.inc page.

include("sorry.inc");
exit;

}ELSE{
while ($row = mysql_fetch_array($result)) {
$realpassword = $row['password'];
$member_id = $row['member_id'];
}
}
if ($password != $realpassword){

// Sorry.inc is a html page.

include("sorry.inc");
exit;
}ELSE{

// If everything worked out fine.

session_register("member_id");
$date = date("F j, Y, g:i a");
$sql1 = "Update member_info SET last_login='$date' where member_id='$member_id'";
mysql_query($sql1);
include("membermain.inc");
exit;
}
}

// FORM BELOW!

include("login.inc");
?>

So from that you should be able to mix and match a few things so that you can make your own login. Please just give some credit back to Broken Formula LLC somewhere. 😃 Also check out www.brokenformula.com