par
Slaygamz3 » 20 mars 2019, 20:53
<?php
try {
$bdd = new PDO("mysql:host=localhost;dbname=magasin_pro", "root", "root");
$bdd->query("SET NAMES 'utf8'");
echo "<h1>Etape I - Exercice 2.php</h1>";
echo "<h2>Liste des clients qui n'ont rien commandé</h2>";
$reponse= $bdd->query("SELECT clients.idClients, NomClients FROM clients JOIN commandes on
commandes.Clients_idClients = clients.idClients WHERE clients.idClients NOT IN (SELECT DISTINCT
commandes.Clients_idClients FROM commandes ");
$reponse->setFetchMode(PDO::FETCH_BOTH);
while ( $donnees = $reponse->fetch() ) {
echo"</br>";
echo $donnees['idClients'];
echo"</br>";
echo $donnees['NomClients'];
echo"</br>";
echo $donnees['NomClients'];
echo"</br>";
}
$bdd = null;
}
catch (PDOException $e) {
echo "Erreur !: " . $e->getMessage() . "<br />";
die();
}
?>
<?php
try {
$bdd = new PDO("mysql:host=localhost;dbname=magasin_pro", "root", "root");
$bdd->query("SET NAMES 'utf8'");
echo "<h1>Etape I - Exercice 2.php</h1>";
echo "<h2>Liste des clients qui n'ont rien commandé</h2>";
$reponse= $bdd->query("SELECT clients.idClients, NomClients FROM clients JOIN commandes on
commandes.Clients_idClients = clients.idClients WHERE clients.idClients NOT IN (SELECT DISTINCT
commandes.Clients_idClients FROM commandes ");
$reponse->setFetchMode(PDO::FETCH_BOTH);
while ( $donnees = $reponse->fetch() ) {
echo"</br>";
echo $donnees['idClients'];
echo"</br>";
echo $donnees['NomClients'];
echo"</br>";
echo $donnees['NomClients'];
echo"</br>";
}
$bdd = null;
}
catch (PDOException $e) {
echo "Erreur !: " . $e->getMessage() . "<br />";
die();
}
?>