UxVS7Qtd

1<?php
2
3/*
4 * SETTINGS!
5 */
6$databaseName = 'oo_battle';
7$databaseUser = 'root';
8$databasePassword = '';
9
10/*
11 * CREATE THE DATABASE
12 */
13$pdoDatabase = new PDO('mysql:host=localhost', $databaseUser, $databasePassword);
14$pdoDatabase->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
15$pdoDatabase->exec('CREATE DATABASE IF NOT EXISTS oo_battle');
16
17/*
18 * CREATE THE TABLE
19 */
20$pdo = new PDO('mysql:host=localhost;dbname='.$databaseName, $databaseUser, $databasePassword);
21$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
22
23// initialize the table
24$pdo->exec('DROP TABLE IF EXISTS ship;');
25
26$pdo->exec('CREATE TABLE `ship` (
27 `id` int(11) NOT NULL AUTO_INCREMENT,
28 `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
29 `weapon_power` int(4) NOT NULL,
30 `jedi_factor` int(4) NOT NULL,
31 `strength` int(4) NOT NULL,
32 `is_under_repair` tinyint(1) NOT NULL,
33 PRIMARY KEY (`id`)
34) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci');
35
36/*
37 * INSERT SOME DATA!
38 */
39$pdo->exec('INSERT INTO ship
40    (name, weapon_power, jedi_factor, strength, is_under_repair) VALUES
41    ("Jedi Starfighter", 5, 15, 30, 0)'
42);
43$pdo->exec('INSERT INTO ship
44    (name, weapon_power, jedi_factor, strength, is_under_repair) VALUES
45    ("CloakShape Fighter", 2, 2, 70, 0)'
46);
47$pdo->exec('INSERT INTO ship
48    (name, weapon_power, jedi_factor, strength, is_under_repair) VALUES
49    ("Super Star Destroyer", 70, 0, 500, 0)'
50);
51$pdo->exec('INSERT INTO ship
52    (name, weapon_power, jedi_factor, strength, is_under_repair) VALUES
53    ("RZ-1 A-wing interceptor", 4, 4, 50, 0)'
54);
55
56echo 'Ding!';