· 6 years ago · May 05, 2019, 04:34 PM
1<?php
2$servername = "localhost";
3$username = "root";
4$password = "";
5
6// Create connection
7$conn = new mysqli($servername, $username, $password);
8// Check connection
9if ($conn->connect_error) {
10 die("Connection failed: " . $conn->connect_error);
11}
12
13// Create database
14$sql = "CREATE DATABASE IF NOT EXISTS myDB";
15if ($conn->query($sql) === TRUE) {
16 echo "Database created or updated successfully";
17} else {
18 echo "Error creating database: " . $conn->error;
19}
20echo "<br>\n";
21
22
23$sql_set_database = "USE myDB";
24if ($conn->query($sql_set_database) === TRUE) {
25 echo "Set database successfully";
26} else {
27 echo "Error setting database: " . $conn->error;
28}
29echo "<br>\n";
30
31$sql_Events = "DROP TABLE going_to_trainings, going_to_events, contacting";
32
33if ($conn->query($sql_Events) == TRUE)
34 echo "Table going_to_trainings, going_to_events, contacting deleted";
35else
36 echo "Error to delete table: " . $conn->error;
37
38echo "<br>\n";
39
40$sql_Events = "CREATE OR REPLACE TABLE events(
41 id INTEGER,
42 title VARCHAR(100),
43 type VARCHAR(100),
44 location VARCHAR(100),
45 description VARCHAR(100),
46 price INTEGER,
47 organizedBy VARCHAR(100),
48 beginDate DATE ,
49 endDate DATE ,
50 isValid BOOLEAN,
51 difficulty INTEGER,
52 PRIMARY KEY(id)
53)";
54if ($conn->query($sql_Events) === TRUE) {
55 echo "Table events created successfully";
56} else {
57 echo "Error creating table: " . $conn->error;
58}
59echo "<br>\n";
60
61
62$sql_User = "CREATE OR REPLACE TABLE users(
63 id INTEGER,
64 username VARCHAR(100),
65 e_mail VARCHAR(100),
66 password VARCHAR(100),
67 first_name VARCHAR(100),
68 last_name VARCHAR(100),
69 github_token VARCHAR(100),
70 linkedin_token VARCHAR(100),
71 PRIMARY KEY (ID)
72)";
73
74
75if ($conn->query($sql_User) === TRUE) {
76 echo "Table user created successfully";
77} else {
78 echo "Error creating table : " . $conn->error;
79}
80echo "<br>\n";
81
82
83$sql_Trainings = "CREATE OR REPLACE TABLE trainings(
84 id INTEGER,
85 title VARCHAR(100),
86 date_training DATE,
87 domain VARCHAR(100),
88 specifications VARCHAR(100),
89 stars INTEGER,
90 difficulty INTEGER,
91 price INTEGER,
92 image VARCHAR(100),
93 PRIMARY KEY(id)
94
95)";
96if ($conn->query($sql_Trainings) === TRUE) {
97 echo "Table trainings created successfully";
98} else {
99 echo "Error creating table : " . $conn->error;
100}
101echo "<br>\n";
102
103
104$sql_Going_To_Events = "CREATE OR REPLACE TABLE going_to_events(
105 id INTEGER ,
106 id_user INTEGER ,
107 id_events INTEGER ,
108 PRIMARY KEY (id) ,
109 CONSTRAINT FK3 FOREIGN KEY (id_events) REFERENCES events(id),
110 CONSTRAINT FK4 FOREIGN KEY (id_user) REFERENCES users(id)
111)";
112if ($conn->query($sql_Going_To_Events) === TRUE) {
113 echo "Table going_to_events created successfully";
114} else {
115 echo "Error creating table : " . $conn->error;
116}
117echo "<br>\n";
118
119
120$sql_contacting = "CREATE OR REPLACE TABLE contacting(
121 id INTEGER,
122 id_user INTEGER,
123 id_contact_message INTEGER,
124 PRIMARY KEY(id) ,
125 CONSTRAINT FK5 FOREIGN KEY(id_user) REFERENCES users(id),
126 CONSTRAINT FK6 FOREIGN KEY(id_contact_message) REFERENCES contact_messages(id)
127)";
128if ($conn->query($sql_contacting) === TRUE) {
129 echo "Table sql_contacting created successfully";
130} else {
131 echo "Error creating table : " . $conn->error;
132}
133echo "<br>\n";
134
135
136$sql_contact_messages = "CREATE OR REPLACE TABLE contact_messages(
137 id INTEGER ,
138 name VARCHAR(40),
139 title VARCHAR(50),
140 description VARCHAR(200),
141 PRIMARY KEY(id)
142)";
143if ($conn->query($sql_contact_messages) === TRUE) {
144 echo "Table sql_contact_messages created successfully";
145} else {
146 echo "Error creating table : " . $conn->error;
147}
148echo "<br>\n";
149
150$sql_Going_To_Trainings = "CREATE OR REPLACE TABLE going_to_trainings(
151 id INTEGER,
152 id_user INTEGER,
153 id_training INTEGER,
154 PRIMARY KEY(id),
155 CONSTRAINT fk_id_user_going_to_trainings FOREIGN KEY(id_user) REFERENCES users(id),
156 CONSTRAINT fk_id_training_going_to_trainings FOREIGN KEY(id_training) REFERENCES trainings(id)
157)";
158if ($conn->query($sql_Going_To_Trainings) === TRUE) {
159 echo "Table sql_Going_To_Trainings created successfully";
160} else {
161 echo "Error creating table : " . $conn->error;
162}
163echo "<br>\n";
164
165$sql_invo = "show ENGINE INNODB STATUS";
166
167if ($conn->query($sql_invo) == TRUE) {
168 echo "ok";
169}
170$conn->close();
171?>