MySQL Database Login/Registration

What I have done

http://beta.gahim.com/start/login.php
<title>Login</title>
<FONT FACE="Arial">
<?
session_name("Login");
session_start();
session_destroy();

if($_GET == "failed") {
print $_GET;
}
?>
<form name="login_form" method="post" action="log.php?action=login">
Login: <input type="text" name="username"><BR>
Password: <input type="password" name="password"><BR>
<input type="submit" value="Start Building">
</form>
</font>

http://beta.gahim.com/start/log.php
<?
session_name("Login");
session_start();

if($_GET == "login") {
$conn = mysql_connect("localhost","gahimcom","aransean11"); // your MySQL connection data
$db = mysql_select_db("gahimcom_members"); //put your database name in here
$name = $_POST;
$q_user = mysql_query("SELECT * FROM gahimcom_users WHERE login='$name'");

if(mysql_num_rows($q_user) == 1) {

$query = mysql_query("SELECT * FROM gahimcom_users WHERE login='$name'");
$data = mysql_fetch_array($query);
if($_POST == $data) {
session_register("name");
header("Location: http://beta.gahim.com/start"); // success page. put the URL you want
exit;
} else {
header("Location: login.php?login=failed&cause=".urlencode('Wrong Password'));
exit;
}
} else {
header("Location: login.php?login=failed&cause=".urlencode('Invalid User'));
exit;
}
}

// if the session is not registered
if(session_is_registered("name") == false) {
header("Location: login.php");
}
?>

http://beta.gahim.com/start/process.php
<?
$name=$_POST;
$email=$_POST;
$email=$_POST;
$email=$_POST;
$email=$_POST;

$location=$_POST;
mysql_connect("localhost", "gahimcom", "aransean11") or die(mysql_error());
mysql_select_db("gahimcom_members") or die(mysql_error());
mysql_query("INSERT INTO `data` VALUES ('$name', '$email', '$password', '$username', '$title')");
Print "You are now signed up, you may now login!";
?>

http://beta.gahim.com/start
Code for the registration form

If you signup then try login at http://beta.gahim.com/start/login.php it doesn't work...

Gahim is my account and my project partner doesn't have a boards.ie account, someone from spiralhosting recommended boards.ie. My partner is finalizing a few things with the website builder which isn't oioon the net and I am doing the SQL.

I gave you all the codes and I was wondering if you were able to see whats wrong with it...

Thanks

log.php is for the login form

process.php is for the signup form

As you can see the first thing we do is assign variables to the data from the previous page. We then just query the database to add this new information.
Of course before we try it we need to make sure the table actually exists. Executing this code should create a table that can be used with our sample files:

Hi,
I want to insert into table called gahimcom_users in the gahimcom_members database

May I ask what you mean by read from?

Hi,
I have put that into the process.php file

now the code is
<?
$name=$_POST;
$email=$_POST;
$email=$_POST;
$email=$_POST;
$email=$_POST;

$location=$_POST;
mysql_connect("localhost", "gahimcom", "aransean11") or die(mysql_error());
mysql_select_db("gahimcom_members") or die(mysql_error());
mysql_query("INSERT INTO *gahimcom_users* VALUES ('$name', '$email', '$password', '$username', '$title')");
Print "You are now signed up, you may now login!";
?>

When I try to login (http://beta.gahim.com/start/login.php) it says invalid user, do you think there is something wrong with the login then?

I have done this, still when I login it doesn't work

Is there anything maybe in the signup form http://beta.gahim.com/start/index.php that doesn't work?
:D

ronkmonster wrote: »

does it work with any users details?
if you enter details directly into the database and then try login with those details, does it work?

How do I put in user details, I have to put in a code into the MySQLAdmin...

I click on SQL and what code do I enter?

Hi,
I know that I gave out a fake password, I don't understand what I did wrong with the login?

The fields are
username, password, name, email, title

I hope to get this done by today (since it's 12)

Could you explain on which page I need to change the code?

Thanks :D