1PLa3MwJ

1<?php
2include("functions.php");
3
4$qDb = "CREATE DATABASE IF NOT EXISTS `posts`;";
5
6$qSelDb = "USE `posts`;";
7
8$qTbPosts = "CREATE TABLE IF NOT EXISTS `posts` (
9  `id` int(11) NOT NULL AUTO_INCREMENT,
10  `categorie` int(11) NOT NULL,
11  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
12  `titre` varchar(255) NOT NULL,
13  `contenu` longtext NOT NULL,
14  PRIMARY KEY (`id`),
15  FOREIGN KEY (`categorie`) REFERENCES `categories`(`id`)
16) ENGINE=InnoDB;";
17
18$qTbCats = "CREATE TABLE IF NOT EXISTS `categories` (
19  `id` int(11) NOT NULL AUTO_INCREMENT,
20  `nom` varchar(255) NOT NULL,
21  PRIMARY KEY(`id`)
22) ENGINE=InnoDB;";
23
24$qInitTbCats = "INSERT INTO categories (nom) VALUES ('Défaut');";
25
26echo "Connexion au serveur MySQL.";
27
28$con = con();
29
30echo "Création de la table categories.";
31mysqli_query($con, $qTbCats);
32echo mysqli_info($con);
33echo mysqli_error($con);
34
35echo "Création de categorie defaut.";
36mysqli_query($con, $qInitTbCats);
37echo mysqli_info($con);
38echo mysqli_error($con);
39
40echo "Création de la table posts.";
41mysqli_query($con, $qTbPosts);
42echo mysqli_info($con);
43echo mysqli_error($con);
44
45mysqli_close($con);
46?>