1P1Z0FhY

1<?php
2
3    $servername = "mysql";
4    $username = "root";
5    $password = "tiger";
6    $dbname = "IntAlk2";
7
8    try {
9        $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
10        // set the PDO error mode to exception
11        $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
12        echo "Connected successfully";
13
14        $create_table_tag = "CREATE TABLE IF NOT EXISTS `IntAlk2`.`tag` ( `tazon` INT(5) NOT NULL AUTO_INCREMENT , `tnev` VARCHAR(30) NOT NULL , PRIMARY KEY (`tazon`)) ENGINE = InnoDB";
15        $create_table_verseny = "CREATE TABLE IF NOT EXISTS `IntAlk2`.`verseny` ( `vazon` INT(3) NOT NULL AUTO_INCREMENT , `velnev` VARCHAR(45) NULL , `idopont` DATE NOT NULL , PRIMARY KEY (`vazon`)) ENGINE = InnoDB;";
16        $create_table_pivot = "CREATE TABLE IF NOT EXISTS `IntAlk2`.`nevez` (
17            `tag` INT(5) NOT NULL ,
18            `verseny` INT(3) NOT NULL ,
19            `pont` TINYINT(3) NOT NULL,
20        PRIMARY KEY(tag,verseny),
21        FOREIGN KEY(tag) REFERENCES tag(tazon),
22        FOREIGN KEY(verseny) REFERENCES verseny(vazon)
23        ) ENGINE = InnoDB";
24
25        $stmt = $conn->prepare($create_table_tag);
26        $stmt->execute();
27
28        $stmt = $conn->prepare($create_table_verseny);
29        $stmt->execute();
30
31        $stmt = $conn->prepare($create_table_pivot);
32        $stmt->execute();
33
34        $conn = null;
35    } catch (PDOException $e) {
36        echo "Connection failed: " . $e->getMessage();
37    }