//Database Information
$dbhost = "localhost";
$dbname = "users";
$dbuser = "MY USERNAME";
$dbpass = "MY PASSWORD";
//Connect to database
mysql_connect ($localhost, $MY USERNAME, $MY PASSWORD)or die("Could not connect: ".mysql_error());
mysql_select_db($users) or die(mysql_error());
$firstname = $_POST['firstname'];
$username = $_POST[username'];
$password = md5($_POST['password']);
$email = $_POST['email'];
$gamertag = $_POST['gamertag'];
$gender = $_POST['gender'];
// lets check to see if the username already exists
$checkuser = mysql_query("SELECT username FROM users WHERE username='$username'");
$username_exist = mysql_num_rows($checkuser);
if($username_exist > 0){
echo "I'm sorry but the username you specified has already been taken. Please pick another one.";
unset($username);
include 'register.html';
exit();
}
// lf no errors present with the username
// use a query to insert the data into the database.
$query = "INSERT INTO users (firstname, username, password, email, gamertag, gender)
VALUES('$firstname', '$username', '$password', '$email', '$gamertag', '$gender')";
mysql_query($query) or die(mysql_error());
mysql_close();
echo "You have successfully Registered";
// mail user their information
$yoursite = ‘LeThaL Gaming’;
$webmaster = ‘Sal (LeThaL P1STONS)’;
$youremail = ‘[email protected]’;
$subject = "You have successfully registered at $yoursite...";
$message = "Dear $name, you are now registered at our web site.
To login, simply go to our web page and enter in the following details in the login form:
Username: $username
Password: $password
Please print this information out and store it for future reference.
Thanks,
$Sal";
mail($email, $subject, $message, "From: $LeThaL Gaming <$[email protected]>\nX-Mailer:PHP/" . phpversion());
echo "Your information has been mailed to your email address.";
?>Thanks
Edited by Mr. Matt, 15 December 2006 - 01:48 PM.
