Registration.html:

CODE-

<form name="login" method="post" action="registration.php">
<title>Register</title>
<body bgcolor="#999999">
<center>
  <p>Username:
    <input name="username" type="text">
  <br>
  <br>
  Password: <input type="password" name="password">
  <br>
  <br>
  Email: <input type="text" name="email" maxlength="100">
</p>
<p align="center">
  <input type="submit" name="submit" value="Join">
</center>

Registration.php:

Code-

<title>Register</title>
<?PHP

//Database Information

$dbhost = "host";
$dbname = "name";
$dbuser = "user";
$dbpass = "pass";

//Connect to database

mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());


$name = $_POST['name'];
$email = $_POST['email'];
$username = $_POST['username'];
$password = ($_POST['password']);

// 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 "";
    unset($username);
    include 'registration.html';
    exit();
}

// lf no errors present with the username
// use a query to insert the data into the database.

$query = "INSERT INTO users (name, email, username, password)
VALUES('$name', '$email', '$username', '$password')";
mysql_query($query) or die(mysql_error());
mysql_close();

echo "You are now registered!!!";

// mail user their information

$yoursite = 'www.Blackopsplayer.com';
$webmaster = 'Admin';
$youremail = '[email protected]';

$subject = "Thanks for registering at our website :)";
$message = "$username, you are now registered at Blackopsplayer.com.
    To login, simply go to our web page and enter in the following details in the login form:
    Username: $username
    Password: $password

 $webmaster";

mail($email, $subject, $message, "From: $yoursite <$youremail>\nX-Mailer:PHP/" . phpversion());

echo "You are ready to log in! We have sent your info to your email.";

?>

Login.html:

CODE-

<title>Login Page</title>
<body bgcolor="#999999">
<form name="login" method="post" action="login.php">
<center>
Username: <input type="text" name="username">
<br>
<br>
Password: <input type="password" name="password">
<br>
<br>
<input type="submit" name="submit" value="Sign-in">
</center>

login.php:

CODE-

<?php

//Database Information

$dbhost = "host";
$dbname = "name";
$dbuser = "user";
$dbpass = "pass";

//Connect to database

mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());

session_start();
$username = $_POST['username'];
$password = ($_POST['password']);

$query = "select * from users where username='$username' and password='$password'";

$result = mysql_query($query);

if (mysql_num_rows($result) != 1) {
$error = "Bad Login";
    include "login.html";

} else {
    $_SESSION['username'] = "$username";
    include "memberspage.php";
}

?>