Untitled

<!DOCTYPE HTML>
<html>
<head>
<link rel="stylesheet" type="text/css" href="stylesheetRegister.css">
<style>
.error {color: #FF0000;}
</style>
</head>
<body>

<?php

	$servername = "localhost";
	$user = "root";
	$password = "asakura12";
	$db = "users2";


	$conn = new mysqli($servername, $user, $password, $db);


	if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Create database
//$sql = "CREATE DATABASE users2";
//if ($conn->query($sql) === TRUE) {
   // echo "Database created successfully";
//} else {
   /// echo "Error creating database: " . $conn->error;
//}


// define variables and set to empty values
$nameErr = $emailErr =  $passwordErr = "";
$username = $email = $name = $password = "";

if ($_SERVER["REQUEST_METHOD"] == "POST") {
   if (empty($_POST["username"])) {
     $nameErr = "username is required";
   } else {
     $username = test_input($_POST["name"]);
     // check if name only contains letters and whitespace
     if (!preg_match("/^[a-zA-Z ]*$/",$username)) {
       $nameErr = "Only letters and white space allowed";
     }
   }

   if (empty($_POST["email"])) {
     $emailErr = "Email is required";
   } else {
     $email = test_input($_POST["email"]);
     // check if e-mail address is well-formed
     if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
       $emailErr = "Invalid email format";
     }
   }

   if (empty($_POST["password"])) {
     $passwordErr = "Password is required";
	 $password = "";
   } else {
     $password = test_input($_POST["password"]);
   }

   if (empty($_POST["name"])) {
     $name = "";
   } else {
     $name = test_input($_POST["name"]);
   }

}

function test_input($data) {
   $data = trim($data);
   $data = stripslashes($data);
   $data = htmlspecialchars($data);
   return $data;
}
?>

<h2>Please enter your details</h2>
<p><span class="error">* required field.</span></p>
<form method="send" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>">
   Username: <input type="text" name="name" value="<?php echo $username;?>">
   <span class="error">* <?php echo $nameErr;?></span>
   <br><br>
   E-mail: <input type="text" name="email" value="<?php echo $email;?>">
   <span class="error">* <?php echo $emailErr;?></span>
   <br><br>
   Password: <input type="text" name="password" value="<?php echo $password;?>">
   <span class="error">*<?php echo $passwordErr;?></span>
   <br><br>
   Name: <input type="text" name="name" value="<?php echo $name;?>"</input>
   <br><br>
   <input type="submit" name="submit" value="Submit">

   <?php

// prepare and bind
//$stmt = $conn->prepare("INSERT INTO user (Username, Password, Email, Name) VALUES (?, ?, ?, ?)");

$query = mysql_query("INSERT INTO 'user' (Username, Password, Email, Name) VALUES ($username, $password, $email, $name)");
//$stmt->bind_param($username, $password, $email, $name);

//$stmt->execute();


//$stmt->close();
$conn->close();

?>
</form>

<br/>
<br>
<br>
<a href="startPage.php"><strong>Go back to main page</strong></a>


</body>
</html>