Hello,

I thought I'd start a new thread since my last one got a bit hectic. I've made a registration form where people sign up with username and password. The code I've used is:



And the code for the form I've used is:



What i want to know is, if they've inputted an incorrect username or password (like too many characters or the username is taken), how can i redirect the user to a different page. I assume i have to use the header() function but I'm not sure how.

Thank you

This post has been edited by Sayid Ahmed: 23 Aug, 2008 - 05:33 AM

You have to write simple if construction to check inputted data and redirect if needed.

Exactly, MitkOK is right.

if ($_POST['username'] != $row['username'] or md5($_POST['password']) != $row['password']) {
header("Location: login.php");
} else {
echo "$_POST[username] you are now logged in.";
}

If the user name doesn't match the username in the database or the password hashes are incorrect, then you can redirect the user. Just use an if-else block like above.

This is a signup page, not a log in. But based on what you said, if the usernames do match, then they get redirected by this code:



Am i correct?

Oops, yeah that will work.

It doesn't seem to work, it will still make a new entry to the database.

BTW, what is the variable $row for?

$row is what you pull from the database...

you need to query the database to pull the persons username... if they username exists, then count($row['username']) will equal 1... IF it equals one, then redirect to unsuccessful.php... if it equals 0, then redirect to successfuly.php...

if you don't understand it, just post here and i'll write up the code... but please TRY it first =)

OK i understand what you mean, but sadly it didn't work when i tried it, i started off with this:



I messed around with it but still no result. The header part does work tho, cos i made $count = 1 and redirected to unsuccessful.php

This post has been edited by Sayid Ahmed: 23 Aug, 2008 - 02:11 PM

you should use $count = count($row)... you want to use the entire array

I'm sorry, you've lost me now

<?php
$sql = mysql_query("SELECT username FROM users WHERE username = '$username'")or die(mysql_error());
$row = mysql_fetch_array($sql);
$count = count($row);

if($count > 1){
header("Location: unsuccessful.php");
}else{
header("Location: successful.php");
}
?>

Wehay, cheers for that, i guess i better go read a mysql tutorial as well as PHP then.

here's the complete code I used:

<?php

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

$match = mysql_query("SELECT username FROM users WHERE username = '$username'")or die(mysql_error());  
$row = mysql_fetch_array($match);  
$count = count($row);  
  
if($count > 1){  
header("Location: unsuccessful.php");  
}else{  
 header("Location: successful.php"); 
 $sql = "INSERT INTO users (username, password) VALUES ('".$username."', '".md5($password)."')";
mysql_query($sql)or die(mysql_error()); 
}  	

 ?>

This post has been edited by Sayid Ahmed: 24 Aug, 2008 - 12:51 PM