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 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159
| <?php
get_header();
?>
<div class="row pb_3per page">
<div class="small-12 large-8 columns">
<div id="primary" class="content-area">
<main id="main" class="site-main" role="main">
<?php
if (have_posts()) {
while (have_posts()) : the_post(); ?>
<?php get_template_part('template-parts/content', 'page'); ?>
<?php include get_template_directory() . '/custom-part-content-supp.php' ?>
<div>
<fieldset class="fieldset">
<legend>Commande de kits génomique</legend>
<!-- mise en place de la Bdd -->
<?php
$servname = "";
$dbname = "";
$user = "";
$pass = "";
$identifiant = $_POST['identitficateur'];
$nom = $_POST['nom'];
$prenom = $_POST['prenom'];
$adresse = $_POST['street'];
$ville = $_POST['city'];
$cp = $_POST['postal'];
$complementAdresse = $_POST['street2'];
$mail = $_POST['email'];
$fixe = $_POST['tel'];
$portable = $_POST['phone'];
$kit = $_POST['number-kits'];
$tube = $_POST['number-tubes'];
$aiguille = $_POST['number-aiguilles'];
$adaptateur = $_POST['number-adaptateur'];
$cartonSmall = $_POST['number-small'];
$cartonBig = $_POST['number-big'];
$etiquetteChronopost = $_POST['number-chronospost'];
$enveloppeBulle = $_POST['number-enveloppe'];
$commentaire = $_POST['message'];
try {
//on se connecte à la base de données
$dbco = new PDO("mysql:host=$servname;dbname=$dbname", $user, $pass);
$dbco->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
//$sth appartient à la classe PDOStatement
$sth = $dbco->prepare("
INSERT INTO formulaire_ifce(identifiant,nom,prenom,adresse,ville,codePostal,complementAdresse,mail,fixe,portable,kit,tube,aiguille,adaptateur,cartonSmall,cartonBig,etiquetteChronopost,enveloppeBulle,commentaire)
VALUES (:identifiant,:nom, :prenom, :adresse, :ville, :cp, :complement, :mail,:fixe,:portable,:kit,:tube,:aiguille,:adaptateur,:cartonSmall,:cartonBig,:etiquetteChronopost,:enveloppeBulle,:commentaire)
");
//La constante de type par défaut est STR
$sth->bindValue(':identifiant', $identifiant);
$sth->bindValue(':nom', $nom, PDO::PARAM_STR);
$sth->bindValue(':prenom', $prenom, PDO::PARAM_STR);
$sth->bindValue(':adresse', $adresse, PDO::PARAM_STR);
$sth->bindValue(':ville', $ville, PDO::PARAM_STR);
$sth->bindValue(':cp', $cp, PDO::PARAM_INT);
$sth->bindValue(':complement', $complementAdresse, PDO::PARAM_STR);
$sth->bindValue(':mail', $mail, PDO::PARAM_STR);
$sth->bindValue(':fixe', $fixe);
$sth->bindValue(':portable', $portable);
$sth->bindValue(':kit', $kit, PDO::PARAM_INT);
$sth->bindValue(':tube', $tube, PDO::PARAM_INT);
$sth->bindValue(':aiguille', $aiguille, PDO::PARAM_INT);
$sth->bindValue(':adaptateur', $adaptateur, PDO::PARAM_INT);
$sth->bindValue(':cartonSmall', $cartonSmall, PDO::PARAM_INT);
$sth->bindValue(':cartonBig', $cartonBig, PDO::PARAM_INT);
$sth->bindValue(':etiquetteChronopost', $etiquetteChronopost, PDO::PARAM_INT);
$sth->bindValue(':enveloppeBulle', $enveloppeBulle, PDO::PARAM_INT);
$sth->bindValue(':commentaire', $commentaire, PDO::PARAM_STR);
$sth->execute();
} catch (PDOException $e) {
echo "Erreur : " . $e->getMessage();
}
?>
<form method="post" action="" enctype="multipart/form-data" class="ifce">
<div class="ifce">
<div class="small-12 large-12 columns ifce-first">
<div class="small-12 large-6 columns">
<label for="identity-number">N° Identificateur</label>
<input type="text" class="sg-input" id="identitficateur" name="identitficateur" required />
<div class="invalid-feedback">
Numéro inconnu
</div>
<div class="valid-feedback">
Numéro reconnu
</div>
</div>
<div class="small-12 large-6 columns">
<label for="email">Email</label>
<input readonly type="email" disabled="disabled" id="email" name="email" required />
</div>
</div>
<div class="small-6 large-6 columns">
<label for="nom">Nom</label>
<input readonly type="text" disabled="disabled" id="nom" name="nom" required>
</div>
<div class="small-6 large-6 columns">
<label for="prenom">Prénom</label>
<input readonly type="text" disabled="disabled" id="prenom" name="prenom" required>
</div>
<fieldset class="fieldset">
<legend>Adresse de livraison</legend>
<div class="small-12 large-12 columns">
<label for="street">Adresse</label>
<input type="text" disabled="disabled" id="street" name="street" required />
</div>
<div class="small-12 large-12 columns">
<label for="street2">Complement adresse </label>
<input type="text" disabled="disabled" id="street2" name="street2" />
</div>
<div class="small-4 large-4 columns">
<label for="postal">Code Postal</label>
<input type="text" disabled="disabled" id="postal" name="postal" maxlength="5" pattern="[0-9]{5}" title="5 chiffres" required />
</div>
<div class="small-8 large-8 columns">
<label for="city">Ville</label>
<input type="text" disabled="disabled" id="city" name="city" required />
</div>
</fieldset>
<div class="small-6 large-6 columns">
<label for="phone">Teléphone Portable</label>
<input readonly type="text" disabled="disabled" id="phone" name="phone" />
</div>
<div class="small-6 large-6 columns">
<label for="tel">Téléphone Fixe</label>
<input readonly type="text" disabled="disabled" id="tel" name="tel" />
</div>
<div class="small-12 large-12 columns">
<label for="kit">Kits </label><em>1 kit contient 1 sachet étanche,1 planche de 5 étiquettes,1 buvard</em>
<!-- <input type="number" disabled="disabled" class="form-control" id="kit" name="kit" required/> -->
<select class="sg-input either-required" name="number-kits" id="number-kits" disabled="disabled">
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option> |
Partager