01.$query = "SELECT ID FROM USERS";
02.$result = mysqli_query($dbConnection, $query);
03.
04.if(empty($result)) {
05. $query = "CREATE TABLE USERS (
06. ID int(11) AUTO_INCREMENT,
07. EMAIL varchar(255) NOT NULL,
08. PASSWORD varchar(255) NOT NULL,
09. PERMISSION_LEVEL int,
10. APPLICATION_COMPLETED int,
11. APPLICATION_IN_PROGRESS int,
12. PRIMARY KEY (ID)
13. )";
14. $result = mysqli_query($dbConnection, $query);
15.
16.
17.
18.
19.
20.$Email = $_POST["Email"];
21.$PASSWORD = $_POST["PASSWORD"];
22.$PERMISSION_LEVEL = $_POST["PERMISSION_LEVEL"];
23.$APPLICATION_COMPLETED = $_POST["APPLICATION_COMPLETED"];
24.$APPLICATION_IN_PROGRESS = $_POST["APPLICATION_IN_PROGRESS"];
25.
26.$query2 = "INSERT INTO USERS (EMAIL, PASSWORD, PERMISSION_LEVEL, APPLICATION_COMPLETED, APPLICATION_IN_PROGRESS) VALUES ($Email, $PASSWORD, $PERMISSION_LEVEL, $APPLICATION_COMPLETED, $APPLICATION_IN_PROGRESS)";
27.$result2 = mysqli_query($dbConnection, $query2);
28.
29.}
