This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
//Inclusion de la base de données | |
require_once 'bd.php'; //Lien => https://gist.github.com/YOoSlim/5303274 | |
//Selections de la liste des pays | |
$req = $bd->query('SELECT * FROM PAYS'); | |
$paysList = $req->fetchAll(PDO::FETCH_OBJ); | |
//Selections de la liste des departements | |
$req = $bd->query('SELECT codeDepartement FROM DEPARTEMENT'); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
try { | |
$pdo_options[PDO::ATTR_ERRMODE] = PDO::ERRMODE_EXCEPTION; | |
$pdo_options[PDO::MYSQL_ATTR_INIT_COMMAND] = "SET NAMES utf8"; | |
$bdd = new PDO('mysql:host=localhost;dbname=databaseName', 'root', '', $pdo_options); | |
} | |
catch (Exception $e) { | |
die('Erreur : ' . $e->getMessage()); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
//Tableau contenant la liste des tables | |
$mesTables = array('Livres', 'Auteurs', 'Exemplaires', 'AuteursDe'); | |
//Definition de la table choisis, si elle existe bien évidement | |
if(isset($_POST['maTable']) AND array_key_exists($_POST['maTable'], $mesTables)) $tableChoisi = $_POST['maTable']; | |
else $tableChoisi = null; | |
//Connexion a la base de données | |
$link = mysql_connect("", "", "") or die("Impossible de se connecter."); |