/**
* Fonction de connection à la bdd.
*
* @return $pdo
*/
public function bdd()
{
include_once '../config/bdd-config.php';
$donneesDB = connexionPDO();
try {
$pdo = new PDO($donneesDB['DSN'], $donneesDB['user'], $donneesDB['mdp'], $donneesDB['options']);
} catch (PDOException $e) {
echo 'Connexion échouée : ' . $e->getMessage();
}
return $pdo;
}
function DansBase($pseudo, $email)
{
$sql = "SELECT Pseudo, Email FROM individu WHERE Pseudo='{$pseudo}' OR Email='{$email}'";
$resultat = connexionPDO("localhost", "root", "", "bddevolution")->query($sql);
$info = $resultat->fetchAll(PDO::FETCH_ASSOC);
if ($info != null) {
return true;
} else {
return false;
}
}
//suppresion d'un frais Hf
$keyFrais = $_REQUEST["keyFrais"];
try {
$cnx = connexionPDO();
$RequeteHfsupp = "DELETE FROM fraishf where id='" . $keyFrais . "' ;";
echo $RequeteHfsupp;
$req4 = $cnx->prepare($RequeteHfsupp);
$req4->execute();
} catch (PDOException $e) {
print "Erreur !: " . $e->getMessage();
die;
}
} elseif ($_REQUEST["op"] == "login") {
//connection login
$login = $_REQUEST["login"];
$mdp = $_REQUEST["mdp"];
try {
$cnx = connexionPDO();
//connection
$RequeteVerifSaisie = "SELECT * FROM visiteur where login='******' and mdp='" . $mdp . "' ";
$req1 = $cnx->prepare($RequeteVerifSaisie);
$req1->execute();
$resultat = $req1->fetch();
echo $resultat["login"];
} catch (PDOException $e) {
print "Erreur !: " . $e->getMessage();
//en cas d'erreur
die;
}
}
}
<?php
$connexion = connexionPDO("localhost", "root", "", "bddevolution");
function connexionPDO($hote, $username, $mdp, $bd)
{
try {
$connex = new PDO('mysql:host=' . $hote . ';dbname=' . $bd, $username, $mdp);
$connex->exec("SET CHARACTER SET utf8");
//Gestion des accents
return $connex;
} catch (Exception $e) {
echo 'Erreur : ' . $e->getMessage() . '<br />';
echo 'N° : ' . $e->getCode();
return null;
}
}
