Untitled

<!DOCTYPE html>
<html>
<head>

</head>
<body>
	<h2>Welcome to MyPeople</h2>
	<p style="text-align: right;">USERNAME&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbspPASSWORD&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp<br>
		<input type="text" name="reg_username">
		<input type="password" name="reg_password">
		<input type="submit" name="submit" value="Log In"><br>
	</p>


<?php
//checking if mandatory fields are empty and if valid data is entered
// define variables and set to empty values
$nameErr = $emailErr = $genderErr = $usernameErr = $passwordErr = "";
$name = $email = $gender = $username = $password = "";

if ($_SERVER["REQUEST_METHOD"] == "POST") {

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

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

    $username = trim($username);
    $username = htmlspecialchars($username);

    $gender = test_input($_POST["gender"]);
}

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

// Create database
$db = "CREATE DATABASE userDatabase";

$servername = "127.0.0.1";
$Username = "root";
$password = "";
$databaseName = "userDatabase";

// Create connection
$conn = new mysqli($servername, $Username, $password, $databaseName);

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

//Create table
$table = "CREATE TABLE users (
	SerialNo  INT(7)  NOT NULL AUTO_INCREMENT,
	Name      VARCHAR(30)  NOT NULL,
	EmailId   VARCHAR(60)  NOT NULL,
	PhoneNo	  INT(10),
	Dob       INT(5),
	Username  VARCHAR(25)  NOT NULL,
	Password  VARCHAR(25)  NOT NULL,
	Gender    CHAR(1),
	PRIMARY KEY(SerialNo, Password, Username)
	)";

if ($conn->query($table) === TRUE) {
    echo "Table MyGuests created successfully";
} else {
    echo "Error creating table: " . $conn->error;
}

//escaping strings
$NAME  = mysqli_real_escape_string($conn, $_POST['name']);
$EMAIL  = mysqli_real_escape_string($conn, $_POST['email']);
$PHONENO = mysqli_real_escape_string($conn, $_POST['phnumber']);
$DOB  = mysqli_real_escape_string($conn, $_POST['dob']);
$USERNAME  = mysqli_real_escape_string($conn, $_POST['username']);
$PASSWORD  = mysqli_real_escape_string($conn, $_POST['password']);
$GENDER  = mysqli_real_escape_string($conn, $_POST['gender']);

$enter_info = "INSERT INTO users (NAME, EMAIL, PHONENO, DOB, USERNAME, PASSWORD, GENDER) VALUES ('$NAME', '$EMAIL', '$PHONENO', '$DOB', '$USERNAME', '$PASSWORD', '$GENDER')";

if(mysqli_query($conn, $enter_info)){
    echo "Records added successfully.";
} else{
    echo "ERROR: Could not able to execute $enter_info. " . mysqli_error($conn);
}


?>


	<form method="post" action="<?php echo htmlspecialchars($_SERVER['PHP_SELF']);?>">
		<p><b> New User? Register now!</b><br><br>
		Name: <input type="text" name="name" value="<?php echo $name;?>" required> *<br><br>
		Email ID: <input type="text" name="email" value="<?php echo $email;?>" required> *<br><br>
		Phone no: <input type="number" name="phnumber"><br><br>
		Date of Birth: <input type="date" name="dob"><br><br>
		Username: <input type="text" name="username" value="<?php echo $username;?>" required> *<br><br>
		New Password: <input type="password" name="password" value="<?php echo $password;?>" required> *<br><br>
		Gender: <input type="radio" name="gender" value="female" <?php if (isset($gender) && $gender=="female") echo "checked";?>>Female <input type="radio" name="gender" value="male" <?php if (isset($gender) && $gender=="male") echo "checked";?>> Male  *<br><br>
		<input type="submit" name="register" value="Register"><br>
		<p>* marked fields are mandatory</p>
	</form>


</body>
</html>