<?

// Include data base connection
include("dbconnect.php");

// Check for form submission
if(isset($_REQUEST['submit'])) {
// Check for empty fields
if(empty($_REQUEST['username'])||empty($_REQUEST['password'])||empty($_REQUEST['cpassword'])||empty($_REQUEST['email'])) {
// Cancel the register process and display error
echo "Some fields are not filled out.";
}
else {
// If fields are not empty
// Set varibles for submitted data
$username = $_REQUEST['username'];
$password = $_REQUEST['password'];
$cpassword = $_REQUEST['cpassword'];
$email = $_REQUEST['email'];
$ip = $_SERVER['REMOTE_ADDR'];
}

// Check if username already exists
$sql1 = "SELECT * FROM `user` WHERE `username`='$username'";
$result1 = mysql_num_rows($result);
if($result1 == 1) {
//If username exists
echo "Username already exists.";
}

// Check if submitted passwords are the same
if($password != $cpassword) {
//Passwords do not match, display error
echo "Passwords do not match.";
}

// If username does not exist and passwords match
// Encrypt password for database storage
$spw = md5($password);

// Insert data into database
$sql2 = "INSERT INTO `users` (`username`,`password`,`email`,`ip`) VALUES ('$username','$spw','$email','$ip')";
$query1 = mysql_query($sql2);

// Redirect if query runs correctly
header("location: http://requiemofdestiny.awardspace.com/confirmed.php"); // Change to whatever you want the redirected apge to be
}
?>

$query1 = mysql_query($sql2);

$query1 = mysql_query($sql2) or die(mysql_error());

<?php

// Start Sessions
session_start();

// Include dbconnect.php
include("dbconnect.php");

// Check if form was submitted
if(!$_POST['create']) {// Form wasn't submitted
// Echo the Form
echo "
<form method=\"post\">
<table width=\"300px\" border=\"0\" align=\"center\" cellpadding=\"1\" cellspacing=\"1\">
<tr>
<td colspan=\"4\"><div align=\"center\">Register</div></td>
</tr>
<tr>
<td colspan=\"2\"><div align=\"right\">Username:</div></td>
<td colspan=\"2\"><input type=\"text\" name=\"username\" id=\"username\"></td>
</tr>
<tr>
<td colspan=\"2\"><div align=\"right\">Password:</div></td>
<td colspan=\"2\"><input type=\"text\" name=\"password\" id=\"password\"></td>
</tr>
<tr>
<td colspan=\"2\"><div align=\"right\">Confirm Password:</div></td>
<td colspan=\"2\"><input type=\"text\" name=\"cpassword\" id=\"cpassword\"></td>
</tr>
<tr>
<td colspan=\"2\"><div align=\"right\">E-mail:</div></td>
<td colspan=\"2\"><input type=\"text\" name=\"email\" id=\"email\"></td>
</tr>

<tr>
<td width=\"100\"><input name=\"ip\" type=\"hidden\" id=\"ip\" value=\"<?php echo $_SERVER[REMOTE_ADDR]; ?>\"></td>
<td colspan=\"2\"><div align=\"center\">
<input type=\"submit\" name=\"create\" id=\"create\" value=\"Create\">
</div></td>
<td width=\"100\">&nbsp;</td>
</tr>
</table>
</form>
";
}
else { // Form Was Submitted
// Check if form is empty
if(empty($_POST['username'])||empty($_POST['password'])||empty($_POST['cpassword'])||empty($_POST['email'])) {
echo "Please fill in all form data.";
}
else {
// Collect Form Data
$username = $_POST['username'];
$password = $_POST['password'];
$cpassword = $_POST['cpassword'];
$email = $_POST['email'];
$ip = $_POST['ip'];

// Check if submitted data is already in Database
$checkuiuser = mysql_query("SELECT * FROM `users` WHERE `username='$username'") or die(mysql_error());
$checkuiuserc = mysql_num_rows($checkuiuser);
$checkuiemail = mysql_query("SELECT * FROM `users` WHERE `email`='$email'") or die(mysql_error());
$checkuiemailc = mysql_num_rows($checkuiemail);
}

// Run if statement for checking
if($checkuiuserc > 0 || $checkuiemail > 0) {
// Username or Email exists in DB
echo " Username or Email already in use.";
}
if ($cpassword != $password) {
// Check if pass word match
echo "Password do not match";
}

$uiencryptpass = md5($password);

$uiinsert = mysql_query("INSERT INTO `users` (`username`,`password`,`email`,`ip`,`userlvl`) VALUES ('$username','$uiencryptpass','$email','$ip','1'");
echo "You have been Registered.";
}
?>