install.php

<?php // Création d'une base de données

include "configuration.php";

function query($link,$requete)
  { 
    $resultat=mysqli_query($link,$requete) or die("$requete : ".mysqli_error($link));
	return($resultat);
  }

function loadDB(){
	include("Donnees.inc.php");
	$mysqli= install_bd();

	// Récupération des tableaux pour les insérer dans une base de données
	if (isset($Recettes)) {
		$tabRecettes = $Recettes;
	}

	if (isset($Hierarchie)){
		$tabHierarchie = $Hierarchie;
	}

	$cmpt = 0;
	$str ="";


	// Parcours de tous les aliments pour les ajouter à la base de donnée
	while (current($tabHierarchie)){
		//echo key($categorie);
		$prep = mysqli_real_escape_string($mysqli, key($tabHierarchie));
		$str .= "INSERT INTO aliments(alim_nom) VALUES ('".$prep."');  ";
		next($tabHierarchie);
	}

	reset($tabHierarchie);
	// Parcours des aliments pour les reliés aux sous-catégories
	while ($categorie = current($tabHierarchie)){
		$souscat = $categorie['sous-categorie'];
		while ($alim = current($souscat)){
			$prep = mysqli_real_escape_string($mysqli, key($tabHierarchie));
			$fils = mysqli_real_escape_string($mysqli, $alim);
			$str .= "INSERT INTO hierarchie(super_nom, sous_nom) VALUES ('".$prep."', '".$fils."');  ";
			next($souscat);
		}
		next($tabHierarchie);
	}

	$valeur = 1;

	// Parcours des recettes et génération des éléments correspondants dans leurs tables
	foreach($tabRecettes as $colonne){
		$titre = mysqli_real_escape_string($mysqli, $colonne['titre']);
		$ingred = mysqli_real_escape_string($mysqli, $colonne['ingredients']);
		$prep = mysqli_real_escape_string($mysqli, $colonne['preparation']);
		if (count($tabRecettes)-1 === $cmpt){
			$str .= "INSERT INTO recettes(titre, ingredients, preparation) VALUES ('{$titre}', '{$ingred}', '{$prep}')";
		}else{
			$str .= "INSERT INTO recettes(titre, ingredients, preparation) VALUES ('{$titre}', '{$ingred}', '{$prep}');  ";
		}

		while ($ingred = current($colonne['index'])){
			$prep = mysqli_real_escape_string($mysqli, $ingred);
			$str .= "INSERT INTO ingredientsderecettes VALUES (".$cmpt.", '".$valeur."', '".$prep."');  ";
			next($colonne['index']);
		}
		$valeur++;
	}

		// Ajout des images à la table des recettes
		$tab[] = array ("image" => "Photos/Black_velvet.jpg", "nom" => "Black velvet");
		$tab[] = array ("image" => "Photos/Bloody_mary.jpg", "nom" => "Bloody Mary");
		$tab[] = array ("image" => "Photos/Bora_bora.jpg", "nom" => "Bora bora");
		$tab[] = array ("image" => "Photos/Builder.jpg", "nom" => "Builder");
		$tab[] = array ("image" => "Photos/Caipirinha.jpg", "nom" => "Caïpirinha");
		$tab[] = array ("image" => "Photos/Coconut_kiss.jpg", "nom" => "Coconut kiss");
		$tab[] = array ("image" => "Photos/Cuba_libre.jpg", "nom" => "Cuba libre");
		$tab[] = array ("image" => "Photos/Frosty_lime.jpg", "nom" => "Frosty lime");
		$tab[] = array ("image" => "Photos/Le_vandetta.jpg", "nom" => "Le vandetta");
		$tab[] = array ("image" => "Photos/Margarita.jpg", "nom" => "Margarita");
		$tab[] = array ("image" => "Photos/Mojito.jpg", "nom" => "Mojito");
		$tab[] = array ("image" => "Photos/Pina_colada.jpg", "nom" => "Piña Colada");
		$tab[] = array ("image" => "Photos/Raifortissimo.jpg", "nom" => "Raifortissimo");
		$tab[] = array ("image" => "Photos/Screwdriver.jpg", "nom" => "Screwdriver");
		$tab[] = array ("image" => "Photos/Shoot_up.jpg", "nom" => "Shoot up");
		$tab[] = array ("image" => "Photos/Tequila_sunrise.jpg", "nom" => "Tequila sunrise");
		$tab[] = array ("image" => "Photos/Tipunch.jpg", "nom" => "Ti'punch");
			
		for ($cmpt = 0; $cmpt< count($tab); $cmpt++){
			$img = mysqli_real_escape_string($mysqli, $tab[$cmpt]['image']);
			$nom = mysqli_real_escape_string($mysqli, $tab[$cmpt]['nom']);
			//echo $img.' '.$nom;
			$str .= "UPDATE recettes SET photo='{$img}' WHERE titre LIKE '{$nom}';  ";
		}


	$base="Boissons";
	$Sql="
			DROP DATABASE IF EXISTS $base;  
			CREATE DATABASE $base;  
			USE $base;  

			CREATE TABLE IF NOT EXISTS recettes (
				id INT AUTO_INCREMENT PRIMARY KEY, 
				titre VARCHAR(255) NOT NULL, 
				ingredients VARCHAR(1024) NOT NULL, 
				preparation VARCHAR(4096) NOT NULL,
				photo VARCHAR(255) NULL
			);  
			
			CREATE TABLE IF NOT EXISTS utilisateurs (
				user_id INT AUTO_INCREMENT PRIMARY KEY, 
				nom VARCHAR(255) NULL, 
				prenom VARCHAR(255) NULL, 
				sexe VARCHAR(1) NULL, 
				email VARCHAR(150) NULL, 
				pseudo VARCHAR(150) NOT NULL UNIQUE, 
				password VARCHAR(32) NOT NULL
			);  

			CREATE TABLE IF NOT EXISTS aliments (
				alim_nom VARCHAR(255) PRIMARY KEY
			);  

			CREATE TABLE IF NOT EXISTS hierarchie (
				super_nom VARCHAR(225) NOT NULL,
				sous_nom VARCHAR(255) NOT NULL,
				PRIMARY KEY (super_nom, sous_nom),
				FOREIGN KEY (super_nom) REFERENCES aliments(alim_nom), 
				FOREIGN KEY (sous_nom) REFERENCES aliments(alim_nom)
			);  

			CREATE TABLE IF NOT EXISTS ingredientsderecettes (
				id INT AUTO_INCREMENT PRIMARY KEY, 
				idBoisson INT NOT NULL,
				nomIngredient VARCHAR(255) NOT NULL,
				FOREIGN KEY (idBoisson) REFERENCES recettes(id),
				FOREIGN KEY (nomIngredient) REFERENCES aliments(alim_nom)
			);  

			CREATE TABLE IF NOT EXISTS panier (
				commande_id INT AUTO_INCREMENT PRIMARY KEY,
				user_id INT NOT NULL,
				recette_id INT NOT NULL,
				FOREIGN KEY (user_id) REFERENCES utilisateurs(user_id), 
				FOREIGN KEY (recette_id) REFERENCES recettes(id),
				UNIQUE (user_id, recette_id)
			);  
			".$str;


	foreach(explode(';  ',$Sql) as $Requete) query($mysqli,$Requete);
	mysqli_close($mysqli);
}
loadDB();

?>