qqQAsZUg

1<?php
2  $servername = "localhost";
3  $username = "root";
4  $password = "";
5  $dbname = "courseworkv2";
6
7  $first_name= $_POST["first_name"];
8  $last_name= $_POST["last_name"];
9  $email=$_POST["email"];
10  $registeredname=$_POST["username"];
11  $registeredpassword=$_POST["password"];
12  $hashed_password=password_hash("$password", PASSWORD_BCRYPT);
13 
14
15
16  // Create connection
17  $conn = new mysqli($servername, $username, $password, $dbname);
18
19  // Check connection
20  if ($conn->connect_error) {
21	  die("Connection failed: " . $conn->connect_error);
22  }
23
24$sql="CREATE TABLE IF NOT EXISTS `userdetails` ( 
25`firstName` TEXT(50) NOT NULL , 
26`lastName` TEXT(50) NOT NULL , 
27`email` VARCHAR(50) NOT NULL UNIQUE , 
28`userName` varchar(20) NOT NULL  UNIQUE, 
29`password` VARCHAR(15) NOT NULL UNIQUE, 
30`hash` VARCHAR(200) NOT NULL,
31PRIMARY KEY (`userName`)
32) ENGINE = InnoDB";
33
34 $sql2 = "Insert Into userdetails (firstName, lastName, email, userName, password, hash) Values('$first_name', '$last_name', '$email', '$registeredname', 'registered$password', '$hashed_password')";
35 
36
37
38  if ($conn->query($sql2) === TRUE) {
39    echo "Inserted values successfully!";
40} else {
41    echo "Error: you have entered not entered a unique value! Remember, username, password and email must all be unique." .  "<br>" . $conn->error;
42}
43
44
45  
46$conn->close();
47
48?>