JTuim1aC

1<?php
2$host = "localhost";
3$db_user = "root";
4$db_password = "pass";
5$db_name = "zaklad_pogrzebowy_db";
6$link = mysqli_connect($host, $db_user, $db_password);
7if (!$link) {
8    die('Could not connect: ' . mysqli_error());
9}
10$db_selected = mysqli_select_db($link, $db_name);
11if (!$db_selected) {
12    $sqlCreateDatabase = 'CREATE DATABASE ' . $db_name;
13    if (mysqli_query($link, $sqlCreateDatabase)) {
14        echo "Database created successfully.<br>";
15    } else {
16        echo 'Error creating database: ' . mysqli_error() . "\n";
17    }
18}
19$polaczenie = @new mysqli($host, $db_user, $db_password, $db_name);
20if ($polaczenie->connect_errno!=0)
21{
22    echo "Error: ".$polaczenie->connect_errno;
23}
24else
25{
26    $queryCreateUsersTable = "CREATE TABLE IF NOT EXISTS `USERS` (
27        `ID` int(5) unsigned NOT NULL auto_increment,
28        `EMAIL` varchar(55) UNIQUE NOT NULL default '',
29        `FIRSTNAME` varchar(20) NOT NULL default '',
30        `LASTNAME` varchar(30) NOT NULL default '',
31        `PASSWORD` varchar(50) NOT NULL default '',
32        PRIMARY KEY  (`ID`))";
33    $polaczenie->query($queryCreateUsersTable);
34    $sqlInsUsers = "INSERT INTO USERS (EMAIL, FIRSTNAME, LASTNAME, PASSWORD)
35        VALUES 
36        ('john@example.com', 'John', 'Mouse', 'john123'),
37        ('kamils@gmail.com', 'Kamil', 'Sieradzki', 'haslo123'),
38        ('adudek@gmail.com', 'Adam', 'Dudek', 'pwr123')";
39    if ($polaczenie->query($sqlInsUsers) === TRUE) {
40        echo "New records created successfully <br>";
41        $allUser= "SELECT * FROM USERS";
42        $result = $polaczenie->query($allUser);
43        while($row = $result->fetch_assoc()) {
44            echo "id: " . $row["ID"]. " - Name: " . $row["FIRSTNAME"]. " " . $row["LASTNAME"]. " | EMAIL: " . $row["EMAIL"] . " | PASSWORD: " . $row["PASSWORD"] ."<br>";
45        }
46    } else {
47        echo "Error: " . $sqlInsUsers . "<br>" . $polaczenie->error;
48    }
49    $queryCreateCarsTable = "CREATE TABLE IF NOT EXISTS `CARS` (
50        `ID_CAR` int(5) unsigned NOT NULL auto_increment,
51        `NAME` varchar(50) NOT NULL UNIQUE default '',
52        `PRICE` int(5) NOT NULL,
53        PRIMARY KEY  (`ID_CAR`))";
54    $polaczenie->query($queryCreateCarsTable);
55    $sqlInsCars = "INSERT INTO CARS (NAME, PRICE)
56        VALUES 
57        ('VW VOLKSWAGEN T5', '150'),
58        ('Mercedes W212 E-klasa', '250'),
59        ('Cadillac Fleetwood', '300')";
60    if ($polaczenie->query($sqlInsCars) === TRUE) {
61        echo "New cars created successfully <br>";
62        $allUser= "SELECT * FROM CARS";
63        $result = $polaczenie->query($allUser);
64        while($row = $result->fetch_assoc()) {
65            echo "id: " . $row["ID_CAR"]. " - Name: " . $row["NAME"]. " | PRICE: " . $row["PRICE"] . "<br>";
66        }
67    } else {
68        echo "Error: " . $sqlInsCars . "<br>" . $polaczenie->error;
69    }
70    $queryCreateServiesTable = "CREATE TABLE IF NOT EXISTS `SERVICES` (
71        `ID_SERVICE` int(5) unsigned NOT NULL auto_increment,
72        `NAME` varchar(50) NOT NULL UNIQUE default '',
73        `PRICE` float (5) NOT NULL,
74        PRIMARY KEY  (`ID_SERVICE`))";
75    $polaczenie->query($queryCreateServiesTable);
76    $sqlInsServices = "INSERT INTO SERVICES (NAME, PRICE)
77        VALUES 
78        ('Oprawa muzyczna', '199.99'),
79        ('Fotograf', '149.99'),
80        ('Profesjonalny mowca pogrzebowy', '180.00')";
81    if ($polaczenie->query($sqlInsServices) === TRUE) {
82        echo "New services created successfully <br>";
83        $allUser= "SELECT * FROM SERVICES";
84        $result = $polaczenie->query($allUser);
85        while($row = $result->fetch_assoc()) {
86            echo "id: " . $row["ID_SERVICE"]. " - Name: " . $row["NAME"]. " | PRICE: " . $row["PRICE"] . "<br>";
87        }
88    } else {
89        echo "Error: " . $sqlInsServices . "<br>" . $polaczenie->error;
90    }
91    $queryCreateOrdersTable = "CREATE TABLE IF NOT EXISTS `ORDERS` (
92        `ID_ORDER` int(7) unsigned NOT NULL auto_increment,
93        `ID_USER` int(5) unsigned NOT NULL,
94        `ID_CAR` int(5) unsigned NOT NULL,
95        `COLOUR` varchar(7) NOT NULL,
96        `EMAIL` varchar(55) NOT NULL,
97        `FIRSTNAME` varchar(20) NOT NULL,
98        `LASTNAME` varchar(30) NOT NULL,
99        `PHONE` varchar(12) NOT NULL,
100        PRIMARY KEY  (`ID_ORDER`),
101        FOREIGN KEY (ID_USER) REFERENCES USERS(ID),
102        FOREIGN KEY (ID_CAR) REFERENCES CARS(ID_CAR))";
103    $polaczenie->query($queryCreateOrdersTable);
104    echo "Info create orders: " . $queryCreateOrdersTable . "<br>" . $polaczenie->error;
105    $polaczenie->close();
106}
107?>