12-11-2008, 05:43 PM
|
#3 (permalink)
|
|
The Contributor
Join Date: Oct 2008
Location: UK
Posts: 30
Thanks: 0
|
Thanks that does make sense, however even when I take out the sessions it still doesn't work! It just says says "Username or Password was wrong" although I can't figure out why?! :S
PHP Code:
if(isset($_REQUEST['username'])){
session_start();
$con = mysql_connect("localhost","","") or die('Could not connect: ' . mysql_error());
mysql_select_db("normo_mydb") or die(mysql_error());
$_SESSION['username'] = $_POST['username'];
$username = $_POST['username'];
$password = md5($_POST['password']);
$result = mysql_query("SELECT Password FROM Users WHERE Username = '$username'");
$row = mysql_fetch_array($result);
$num = mysql_num_rows($result);
if($num != "0" && $password == $row['Password']) {
header('location:new.php');
}
else {
session_unset();
session_destroy();
}
mysql_close($con);
}
if(isset($_REQUEST['userReg'])){
session_start();
$con = mysql_connect("localhost","","") or die('Could not connect: ' . mysql_error());
mysql_select_db("normo_mydb") or die(mysql_error());
$userReg = $_POST['userReg'];
$passReg = md5($_POST['passReg']);
$sql = mysql_query("INSERT INTO Users
(Username, Password) VALUES('$userReg','$passReg')") or die(mysql_error());
echo "You are now registered!";
mysql_close($con);
}
|
|
|
|