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 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70
| <?php
$nomCl=$_POST['nomCl'];
$prenomCl=$_POST['prenomCl'];
$adresse=$_POST['adresse'];
$codePostal=$_POST['codePostal'];
$tel=$_POST['tel'];
$email=$_POST['email'];
$dateDeNaissance=$_POST['dateDeNaissance'];
$departementDeNaissance=$_POST['departementDeNaissance'];
$villeDeNaissance=$_POST['villeDeNaissance'];
$nationalite=$_POST['nationalite'];
$csp=$_POST['csp'];
$situationDeFamille=$_POST['situationDeFamille'];
$situationDuLogement=$_POST['situationDuLogement'];
$cg= (isset($_POST['cg']));
echo $cg;
$source='mysql:host=localhost;dbname=bank';
$user='root';
$password='';
$numCl='';
$bd= new PDO($source, $user, $password);
try {
$reponse = $bd->query('SELECT * FROM client');
echo"OK";
$req = $bd->prepare('INSERT INTO client(numCl, nomCl, prenomCl,
adresse, codePostal, tel, email, dateDeNaissance,
departementDeNaissance, villeDeNaissance, nationalite,
csp, situationDeFamille, situationDuLogement, cg)
VALUES(:id, :nomCl, :prenomCl, :adresse, :codePostal,
:tel, :email, :dateDeNaissance,:departementDeNaissance,
:villeDeNaissance, :nationalite, :csp, :situationDeFamille,
:situationDuLogement, :cg)');
$req->execute(array('numCl' => $numCl,
'nomCl' => $nomCl,'prenomCl'=> $prenomCl,
'adresse'=> $adresse,'codePostal'=> $codePostal,
'tel'=> $tel,'email'=> $email,'dateDeNaissance'=> $dateDeNaissance,
'departementDeNaissance'=> $departementDeNaissance,
'villeDeNaissance'=> $villeDeNaissance,'nationalite'=> $nationalite,
'csp'=> $csp,'situationDeFamille'=> $situationDeFamille,
'situationDuLogement'=> $situationDuLogement,
'cg'=> $cg,));
echo 'client ajouté';
}
catch (PDOException $e) {
echo"Fail";
$e.getMessage();
}
while ($donnees = $reponse->fetch()){
echo "<br>";
echo $donnees['numCl'];
echo $donnees['nomCl'];
echo $donnees['prenomCl'];
echo $donnees['adresse'];
echo $donnees['codePostal'];
echo $donnees['tel'];
echo $donnees['email'];
echo $donnees['dateDeNaissance'];
echo $donnees['departementDeNaissance'];
echo $donnees['villeDeNaissance'];
echo $donnees['nationalite'];
echo $donnees['csp'];
echo $donnees['situationDeFamille'];
echo $donnees['situationDuLogement'];
echo $donnees['cg'];
}
$reponse->closeCursor();
?> |
Partager