· 6 years ago · Oct 22, 2019, 12:14 AM
1<!DOCTYPE html>
2<script language="javascript">
3function sucesso(){
4 setTimeout("window.location='index.php'", 3000);
5}
6</script>
7
8<?php
9
10$servername = "localhost";
11$username = "root";
12$password = "";
13
14// Create connection
15$conn = mysqli_connect($servername, $username, $password);
16// Check connection
17if (!$conn) {
18 echo "deu ruim<br>";
19 die("Connection failed: " . mysqli_connect_error());
20}
21mysqli_select_db($conn, "myDB");
22
23// Create database
24$sql = "CREATE DATABASE IF NOT EXISTS myDB";
25if (mysqli_query($conn, $sql)) {
26 // echo "Database created successfully<br>";
27} else {
28 // echo "Error creating database: " . mysqli_error($conn);
29}
30mysqli_query($conn, "USE myDB");
31mysqli_query($conn, "DROP TABLE IF EXISTS usuarios");
32if (mysqli_query($conn, "CREATE TABLE IF NOT EXISTS usuarios(
33id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
34 nome VARCHAR(100) NOT NULL,
35 idade VARCHAR(100) NOT NULL,
36 senha VARCHAR(100) NOT NULL,
37 email VARCHAR(100) NOT NULL,
38 telefone VARCHAR(100) NOT NULL,
39 p01 VARCHAR(100) NOT NULL,
40 p02 VARCHAR(100) NOT NULL,
41 p03 VARCHAR(100) NOT NULL,
42 p04 VARCHAR(100) NOT NULL,
43 p05 VARCHAR(100) NOT NULL,
44 p06 VARCHAR(100) NOT NULL,
45 p07 VARCHAR(100) NOT NULL,
46 p08 VARCHAR(100) NOT NULL,
47 p09 VARCHAR(100) NOT NULL,
48 p10 VARCHAR(100) NOT NULL,
49 p11 VARCHAR(100) NOT NULL,
50 p12 VARCHAR(100) NOT NULL,
51 p13 VARCHAR(100) NOT NULL
52 )")) {
53 // echo "Criou tabela usuario<br>";
54 } else {
55 // echo "Nao criou tabela: " . mysqli_error($conn);
56 }
57
58if (mysqli_query($conn, "CREATE TABLE IF NOT EXISTS grupos(
59id INT NOT NULL PRIMARY KEY AUTO_INCREMENT
60)")) {
61// echo "Criou tabela grupos<br>";
62} else {
63 // echo "Nao criou tabela: " . mysqli_error($conn);
64}
65
66mysqli_query($conn, "DROP TABLE IF EXISTS usuario_grupo");
67if (mysqli_query($conn, "CREATE TABLE IF NOT EXISTS usuario_grupo(
68id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
69 usuario VARCHAR(100) NOT NULL,
70 grupo VARCHAR(100) NOT NULL
71 )")) {
72 // echo "Criou tabela usuario - grupos<br>";
73 } else {
74 // echo "Nao criou tabela: " . mysqli_error($conn);
75 }
76
77mysqli_query($conn, "INSERT INTO usuarios (id, nome, idade, senha, email, telefone,
78 p01,
79 p02,
80 p03,
81 p04,
82 p05,
83 p06,
84 p07,
85 p08,
86 p09,
87 p10,
88 p11,
89 p12,
90 p13
91 ) VALUES (NULL, 'thais', '42', 'senha123', 'email123', '123',
92 '3',
93 '2',
94 '3',
95 '2',
96 '5',
97 '1',
98 '1',
99 '1',
100 '1',
101 '7',
102 '3',
103 '2',
104 '1')
105");
106
107mysqli_query($conn, "INSERT INTO usuarios (id, nome, idade, senha, email, telefone,
108 p01,
109 p02,
110 p03,
111 p04,
112 p05,
113 p06,
114 p07,
115 p08,
116 p09,
117 p10,
118 p11,
119 p12,
120 p13
121 ) VALUES (NULL, 'brunonog', '47', 'senha123', 'nubro', '987654868',
122 '1',
123 '3',
124 '1',
125 '5',
126 '3',
127 '3',
128 '2',
129 '2',
130 '1',
131 '4',
132 '1',
133 '1',
134 '2')
135");
136
137mysqli_query($conn, "INSERT INTO usuarios (id, nome, idade, senha, email, telefone,
138 p01,
139 p02,
140 p03,
141 p04,
142 p05,
143 p06,
144 p07,
145 p08,
146 p09,
147 p10,
148 p11,
149 p12,
150 p13
151 ) VALUES (NULL, 'breno', '64', 'senha123', 'brenosocial', '5465113',
152 '2',
153 '2',
154 '3',
155 '2',
156 '1',
157 '1',
158 '1',
159 '1',
160 '2',
161 '4',
162 '3',
163 '1',
164 '1')
165");
166
167mysqli_query($conn, "INSERT INTO usuarios (id, nome, idade, senha, email, telefone,
168 p01,
169 p02,
170 p03,
171 p04,
172 p05,
173 p06,
174 p07,
175 p08,
176 p09,
177 p10,
178 p11,
179 p12,
180 p13
181 ) VALUES (NULL, 'brunomont', '18', 'senha123', 'cabrinha', '666',
182 '4',
183 '5',
184 '5',
185 '5',
186 '3',
187 '2',
188 '2',
189 '2',
190 '1',
191 '3',
192 '3',
193 '2',
194 '2')
195");
196
197mysqli_query($conn, "INSERT INTO usuarios (id, nome, idade, senha, email, telefone,
198 p01,
199 p02,
200 p03,
201 p04,
202 p05,
203 p06,
204 p07,
205 p08,
206 p09,
207 p10,
208 p11,
209 p12,
210 p13
211 ) VALUES (NULL, 'fifi', '25', 'senha123', 'fifififi', '6563115',
212 '1',
213 '5',
214 '5',
215 '3',
216 '4',
217 '2',
218 '2',
219 '4',
220 '1',
221 '3',
222 '3',
223 '2',
224 '3')
225");
226
227mysqli_query($conn, "INSERT INTO usuarios (id, nome, idade, senha, email, telefone,
228 p01,
229 p02,
230 p03,
231 p04,
232 p05,
233 p06,
234 p07,
235 p08,
236 p09,
237 p10,
238 p11,
239 p12,
240 p13
241 ) VALUES (NULL, 'chico', '52', 'senha123', 'froma', '6969',
242 '2',
243 '1',
244 '1',
245 '3',
246 '2',
247 '2',
248 '1',
249 '1',
250 '2',
251 '3',
252 '1',
253 '1',
254 '5')
255");
256
257mysqli_query($conn, "INSERT INTO usuarios (id, nome, idade, senha, email, telefone,
258 p01,
259 p02,
260 p03,
261 p04,
262 p05,
263 p06,
264 p07,
265 p08,
266 p09,
267 p10,
268 p11,
269 p12,
270 p13
271 ) VALUES (NULL, 'rennan', '19', 'senha123', 'renao', '6545651',
272 '2',
273 '1',
274 '2',
275 '3',
276 '2',
277 '3',
278 '1',
279 '1',
280 '1',
281 '2',
282 '2',
283 '1',
284 '3')
285");
286
287mysqli_query($conn, "INSERT INTO usuarios (id, nome, idade, senha, email, telefone,
288 p01,
289 p02,
290 p03,
291 p04,
292 p05,
293 p06,
294 p07,
295 p08,
296 p09,
297 p10,
298 p11,
299 p12,
300 p13
301 ) VALUES (NULL, 'isadora', '30', 'senha123', 'izabella', '5645955',
302 '1',
303 '1',
304 '2',
305 '5',
306 '5',
307 '3',
308 '2',
309 '1',
310 '1',
311 '4',
312 '2',
313 '1',
314 '4')
315");
316
317mysqli_query($conn, "INSERT INTO usuarios (id, nome, idade, senha, email, telefone,
318 p01,
319 p02,
320 p03,
321 p04,
322 p05,
323 p06,
324 p07,
325 p08,
326 p09,
327 p10,
328 p11,
329 p12,
330 p13
331 ) VALUES (NULL, 'anaflavia', '25', 'senha123', 'ana', '84865555',
332 '1',
333 '2',
334 '4',
335 '1',
336 '3',
337 '4',
338 '1',
339 '1',
340 '2',
341 '2',
342 '1',
343 '1',
344 '1')
345");
346
347mysqli_query($conn, "INSERT INTO usuarios (id, nome, idade, senha, email, telefone,
348 p01,
349 p02,
350 p03,
351 p04,
352 p05,
353 p06,
354 p07,
355 p08,
356 p09,
357 p10,
358 p11,
359 p12,
360 p13
361 ) VALUES (NULL, 'laura', '37', 'senha123', 'lauritadoida', '1564654',
362 '3',
363 '3',
364 '4',
365 '4',
366 '1',
367 '1',
368 '2',
369 '1',
370 '1',
371 '3',
372 '3',
373 '3',
374 '3')
375");
376
377mysqli_query($conn, "INSERT INTO usuarios (id, nome, idade, senha, email, telefone,
378 p01,
379 p02,
380 p03,
381 p04,
382 p05,
383 p06,
384 p07,
385 p08,
386 p09,
387 p10,
388 p11,
389 p12,
390 p13
391 ) VALUES (NULL, 'juliana', '24', 'senha123', 'jujubinha', '5163142',
392 '4',
393 '5',
394 '1',
395 '5',
396 '5',
397 '3',
398 '3',
399 '1',
400 '1',
401 '6',
402 '4',
403 '2',
404 '5')
405");
406
407
408echo "Colocou<br>";
409echo"<script language='javascript'>sucesso()</script";
410
411mysqli_close($conn);
412
413?>