Skip to content

Instantly share code, notes, and snippets.

View yooslim's full-sized avatar

YOo Slim yooslim

  • Beyn
  • Algeria
View GitHub Profile
<?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');
<?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());
}
<?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.");