LS_Proiect/create_tables.php at main · just4appl3/LS_Proiect · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
<?php

$server   = "localhost";
$user     = "root";
$password = "";
$database = "LSProject";

$conn = mysqli_connect($server, $user, $password) or die(mysqli_error());

$sql_create = "CREATE DATABASE IF NOT EXISTS `$database`";
$result = mysqli_query($conn, $sql_create);
if(!$result) {
   echo "Error creating database: " . $conn->error;
}

mysqli_select_db($conn, $database);

$sql_create = "CREATE TABLE IF NOT EXISTS users(
                  ID int NOT NULL AUTO_INCREMENT,
                  PRIMARY KEY(ID),
                  username varchar(30) UNIQUE,
                  password varchar(20),
				  role varchar(20)
    		 )";

$retval = mysqli_query($conn, $sql_create);
if(!$retval) {
  die('Could not create table users : ' . mysqli_error());
}

$sql_create = "CREATE TABLE IF NOT EXISTS markers(
                  ID int NOT NULL AUTO_INCREMENT,
                  PRIMARY KEY(ID),
                  name varchar(20),
                  latitude double,
            	  longitude double,
	              color varchar(10),
	              dimensions varchar(20)
			)";

$retval = mysqli_query($conn, $sql_create);
if(!$retval) {
  die('Could not create table markers : ' . mysqli_error());
}

?>

<html>
 <body>
  <form action="registration.php" id="form" name="form"></form>
  <script type="text/javascript">
   document.forms["form"].submit();
  </script>
 </body>
</html>