registrationmysqlphp

<?php
$value1 = $_POST['FirstName'];
$value2 = $_POST['LastName'];
$value3 = $_POST['EmailAddress'];
$value4 = $_POST['NewUsername'];
$value5 = $_POST['NewPassword'];
$value6 = $_POST['NewReenterPassword'];

if(empty($value1)){
die("The First Name field is empty.<br>
<a href='HTML Registration page.php'>Please Click Here To Continue</a>");
}
else
{
if (!preg_match("/^[a-zA-Z ]*$/",$value1)) {
 die("Only letters and white space allowed.<br>
<a href='HTML Registration page.php'>Please Click Here To Continue</a>");
}
else
{
if($value1 > 15) {
die("The First Name has gone past the limit of 15 characters.<br>
<a href='HTML Registration page.php'>Please Click Here To Continue</a>");
}
}
}

if(empty($value2)){
die("The Last Name field is empty.<br>
<a href='HTML Registration page.php'>Please Click Here To Continue</a>");
}
else
{
if (!preg_match("/^[a-zA-Z ]*$/",$value2)) {
 die("Only letters and white space allowed.<br>
<a href='HTML Registration page.php'>Please Click Here To Continue</a>");
}
else
{
if($value2 > 15) {
die("The Last Name has gone past the limit of 15 characters.<br>
<a href='HTML Registration page.php'>Please Click Here To Continue</a>");
}
}
}

if(empty($value3)){
die("The email address field is empty.<br>
<a href='HTML Registration page.php'>Please Click Here To Continue</a>");
}
else
{
if(!filter_var($value3, FILTER_VALIDATE_EMAIL)){
die("The email format is incorrect.<br>
<a href='HTML Registration page.php'>Please Click Here To Continue</a>");
}
}

if(empty($value4)){
die("The Username field is empty.<br>
<a href='HTML Registration page.php'>Please Click Here To Continue</a>");
}
else
{
if($value4 > 15) {
die("The Username has gone past the limit of 15 characters.<br>
<a href='HTML Registration page.php'>Please Click Here To Continue</a>");
}
}

if(empty($value5)){
die("The Password field is empty.<br>
<a href='HTML Registration page.php'>Please Click Here To Continue</a>");
}
else
{
if($value5 > 20) {
die("The Password has gone past the limit of 20 characters.<br>
<a href='HTML Registration page.php'>Please Click Here To Continue</a>");
}
}

if(empty($value6)){
die("The Re-enter Password field is empty.<br>
<a href='HTML Registration page.php'>Please Click Here To Continue</a>");
}

if($value5 !== $value6) {
die("Passwords don't match. <a href='HTML Registration page.php'>Please Click Here To Continue</a>");
}

define('DB_NAME', 'my_sr1203');
define('DB_USER', 'sr1203');
define('DB_PASSWORD', 'devpusevge29');
define('DB_HOST', 'sr1203.altervista.org');

$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);

if (!$link) {
	die('Could not connect' . mysql_error());
	}

$db_selected = mysql_select_db(DB_NAME, $link);

if (!$db_selected) {
	die('Can\'t use ' . DB_NAME . ':  ' . mysql_error());
}

$sql = "INSERT INTO phplogin (FirstName, LastName,
EmailAddress, NewUsername, NewPassword, NewReenterPassword)
VALUES ('$value1','$value2','$value3',
'$value4','$value5','$value6')";

if (!mysql_query($sql)) {
	die('Error: ' . mysql_error());
	}
	else{
	echo "The data has been stored<br>
	<a href='HTML User page.php'>Please Click Here To Login</a>";
	}




mysql_close();

?>