1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
|
<?php
try
{
$bdd = new PDO('mysql:host=localhost;charset=utf8', 'root', '',
array (PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));
}
catch (exception $e)
{
die ('Erreur :'.$e->getMessage ());
}
if(isset($_POST["inscription"])){
$nom_societe = $_POST['nom_societe'];
$email_societe = $_POST['email_societe'];
$nom_societe = $_POST['nom_societe'];
}
$stmt = $bdd->prepare('SELECT COUNT(*) FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = ?');
$stmt->execute(array($_POST['nom_societe']));
if ($stmt->fetchColumn() == 0) {
$creationbase = $bdd -> exec('CREATE DATABASE '.$nom_societe.'');
$creationtable = $bdd ->exec('
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
DROP TABLE IF EXISTS '.$nom_societe.'.`ajoute_article`;
CREATE TABLE IF NOT EXISTS `ajoute_article` (
`id_employe` int(11) NOT NULL,
`id_article` int(11) NOT NULL,
PRIMARY KEY (`id_employe`,`id_article`),
KEY `FK_Ajoute_article_id_article` (`id_article`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
');
} else {
echo "la bdd existe";
}
?> |
Partager