· 6 years ago · May 05, 2019, 04:38 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$sql_contact_messages = "CREATE OR REPLACE TABLE contact_messages(
104 id INTEGER ,
105 name VARCHAR(40),
106 title VARCHAR(50),
107 description VARCHAR(200),
108 PRIMARY KEY(id)
109)";
110if ($conn->query($sql_contact_messages) === TRUE) {
111 echo "Table sql_contact_messages created successfully";
112} else {
113 echo "Error creating table : " . $conn->error;
114}
115echo "<br>\n";
116
117
118$sql_contacting = "CREATE OR REPLACE TABLE contacting(
119 id INTEGER,
120 id_user INTEGER,
121 id_contact_message INTEGER,
122 PRIMARY KEY(id) ,
123 CONSTRAINT fk_id_user_contacting FOREIGN KEY(id_user) REFERENCES users(id),
124 CONSTRAINT fk_id_contact_message_contacting FOREIGN KEY(id_contact_message) REFERENCES contact_messages(id)
125)";
126if ($conn->query($sql_contacting) === TRUE) {
127 echo "Table sql_contacting created successfully";
128} else {
129 echo "Error creating table : " . $conn->error;
130}
131echo "<br>\n";
132
133$sql_Going_To_Trainings = "CREATE OR REPLACE TABLE going_to_trainings(
134 id INTEGER,
135 id_user INTEGER,
136 id_training INTEGER,
137 PRIMARY KEY(id),
138 CONSTRAINT fk_id_user_going_to_trainings FOREIGN KEY(id_user) REFERENCES users(id),
139 CONSTRAINT fk_id_training_going_to_trainings FOREIGN KEY(id_training) REFERENCES trainings(id)
140)";
141if ($conn->query($sql_Going_To_Trainings) === TRUE) {
142 echo "Table sql_Going_To_Trainings created successfully";
143} else {
144 echo "Error creating table : " . $conn->error;
145}
146echo "<br>\n";
147
148$sql_Going_To_Events = "CREATE OR REPLACE TABLE going_to_events(
149 id INTEGER ,
150 id_user INTEGER ,
151 id_events INTEGER ,
152 PRIMARY KEY (id) ,
153 CONSTRAINT fk_id_user_going_to_events FOREIGN KEY (id_events) REFERENCES events(id),
154 CONSTRAINT fk_id_events_going_to_events FOREIGN KEY (id_user) REFERENCES users(id)
155)";
156if ($conn->query($sql_Going_To_Events) === TRUE) {
157 echo "Table going_to_events created successfully";
158} else {
159 echo "Error creating table : " . $conn->error;
160}
161echo "<br>\n";
162
163$sql_invo = "show ENGINE INNODB STATUS";
164
165if ($conn->query($sql_invo) == TRUE) {
166 echo "ok";
167}
168$conn->close();
169?>