K6cYQTRB

1<?php
2//get values from form
3if(isset($_POST['first_name']) && isset($_POST['last_name']) && isset($_POST['address']) && isset($_POST['number']) && isset($_POST['email']) && isset($_POST['username']) && isset($_POST['password'])){
4$username = $_POST['username'];
5$password = $_POST['password'];
6$firstname = $_POST['first_name'];
7$lastname = $_POST['last_name'];
8$address = $_POST['address'];
9$number = $_POST['number'];
10$email = $_POST['email'];}
11$server = "localhost";
12$user = "root";
13$pass = "";
14$conn = mysqli_connect($server,$user,$pass);	//connect to the server
15if(!$conn){
16	die("</br>Could Not Connect</br>". mysqli_error($conn));}
17echo "Connected Successfully</br>";
18$username = stripcslashes($username);	//to prevent mysql injection
19$password = stripcslashes($password);
20$firstname = stripcslashes($firstname);
21$lastname = stripcslashes($lastname);
22$address = stripcslashes($address);
23$number = stripcslashes($number);
24$email = stripcslashes($email);
25$username = mysqli_real_escape_string($conn,$username);
26$password = mysqli_real_escape_string($conn,$password);
27$firstname = mysqli_real_escape_string($conn,$firstname);
28$lastname = mysqli_real_escape_string($conn,$lastname);
29$address = mysqli_real_escape_string($conn,$address);
30$number = mysqli_real_escape_string($conn,$number);
31$email = mysqli_real_escape_string($conn,$email);
32$sql = 'CREATE DATABASE IF NOT EXISTS DevelopersInc';	//Create Database
33$retval = mysqli_query($conn,$sql);
34if(!$retval){
35	die("</br>Could Not Create Database</br>" . mysqli_error($conn));}
36echo "Database Created Successfully</br>";
37$retval = mysqli_select_db($conn,'DevelopersInc');//select database
38if(!$retval){
39	die("</br>Could Not Select Database</br>" . mysqli_error($conn));
40}echo "Database Selected Successfully</br>";
41//Create Table Details
42$sql = 'CREATE TABLE IF NOT EXISTS details(ID INT NOT NULL AUTO_INCREMENT, TOKEN VARCHAR(20) NOT NULL, FIRSTNAME VARCHAR(20) NOT NULL, LASTNAME VARCHAR(20) NOT NULL, ADDRESS VARCHAR(20) NOT NULL, EMAIL VARCHAR(20) NOT NULL, PHONENUMBER VARCHAR(10) NOT NULL, USERNAME VARCHAR(20) NOT NULL, PASSWORD VARCHAR(20) NOT NULL, primary key (TOKEN), key (ID))';
43$retval = mysqli_query($conn,$sql);
44if(!$retval){
45	die("</br>Could Not Create Table" . mysqli_error($conn));} 
46echo "Table Created Successfully</br>";
47$token = mt_rand();
48$token = stripcslashes($token);
49$token = mysqli_real_escape_string($conn,$token);
50$sql = "insert into details (TOKEN, FIRSTNAME, LASTNAME, ADDRESS, EMAIL, PHONENUMBER, USERNAME, PASSWORD) VALUES ('$token','$firstname','$lastname','$address','$email','$number','$username','$password')";
51$retval = mysqli_query($conn,$sql);
52if(!$retval){
53	die("</br>Could Not Insert Values</br>" . mysqli_error($conn));} 
54	echo "Data Inserted Successfully</br>";
55//close conection
56mysqli_close($conn);
57?>