<input id="stock" name="stock" type="text"></br> <label for="image" class="white">Image : </label> <input id="image" name="image" type="text"></br> </br> <input class="form__button" value="Ajouter" type="submit"> </form> </div> <div class="col-xs-12 col-md-6"> <form method="POST"> <label for="name" class="white">Nom : </label> <select name="name" class="form-control"> <?php echo liste_selection($bdd, guitare, id_guitare, nom_guitare); echo '</select></br>'; if (!empty($_POST['name'])) { $req = $bdd->prepare('DELETE FROM `e_boutique`.`guitare` WHERE `guitare`.`id_guitare` = :guitar_name'); $req->execute(array('guitar_name' => htmlspecialchars($_POST['name']))); } ?> </br> <input type="submit" value="Supprimer"> </form> </div> </body> <?php require_once $_SERVER['DOCUMENT_ROOT'] . "/lavrey/affichage/php/footer.php";
</br> <input class="form__button" value="Ajouter" type="submit"> <?php require_once $_SERVER['DOCUMENT_ROOT'] . "/lavrey/echange/ajout/ajout_batterie.php"; ?> </form> </div> <div class="col-xs-12 col-md-6"> <form method="POST"> <label for="name" class="white">Nom : </label> <select name="name" class="form-control"> <?php echo liste_selection($bdd, batterie, id_batterie, nom_batterie); echo '</select></br>'; if (!empty($_POST['name'])) { $req = $bdd->prepare('DELETE FROM `e_boutique`.`batterie` WHERE `batterie`.`id_batterie` = :drum_name'); $req->execute(array('drum_name' => htmlspecialchars($_POST['name']))); } ?> </br> <input type="submit" value="Supprimer"> </form> </div> </body> <?php require_once $_SERVER['DOCUMENT_ROOT'] . "/lavrey/affichage/php/footer.php";
<?php if (!empty($_POST['new_toms'])) { $req = $bdd->prepare('UPDATE `e_boutique`.`nombre_toms` SET `nbr_toms` = :new_toms WHERE `nombre_toms`.`id_nombre_toms` = :id_toms'); $req->execute(array('new_toms' => htmlspecialchars($_POST['new_toms']), 'id_toms' => htmlspecialchars($_POST['toms']))); } ?> <input type="submit" value="valider"> </form> </br> <form method="POST"> <label for="fab_name" class="white">Fabricant</label> <select id="fab_name" name="fab_name" type="text"> <?php liste_selection($bdd, fabricant_batterie, id_fabricant, nom_fab); ?> </select> <input name="new_fab" type="text"> <?php if (!empty($_POST['new_fab'])) { $req = $bdd->prepare('UPDATE `e_boutique`.`fabricant_batterie` SET `nom_fab` = :new_fab WHERE `fabricant_batterie`.`id_fabricant` = :fab_name'); $req->execute(array('new_fab' => htmlspecialchars($_POST['new_fab']), 'fab_name' => htmlspecialchars($_POST['fab_name']))); } ?> <input type="submit" value="valider" > </form>
<?php if (!empty($_POST['new_micro'])) { $req = $bdd->prepare('UPDATE `e_boutique`.`micro_g` SET `nom_micro` = :new_micro WHERE `micro_g`.`id_micro` = :id_micro'); $req->execute(array('new_micro' => htmlspecialchars($_POST['new_micro']), 'id_micro' => htmlspecialchars($_POST['micro']))); } ?> <input type="submit" value="valider"> </form> </br> <form method="POST"> <label for="fab_name" class="white">Fabricant</label> <select id="fab_name" name="fab_name" type="text"> <?php liste_selection($bdd, fabricant_g, id_fabricant, nom_fab); ?> </select> <input name="new_fab" type="text"> <?php if (!empty($_POST['new_fab'])) { $req = $bdd->prepare('UPDATE `e_boutique`.`fabricant_g` SET `nom_fab` = :new_fab WHERE `fabricant_g`.`id_fabricant` = :fab_name'); $req->execute(array('new_fab' => htmlspecialchars($_POST['new_fab']), 'fab_name' => htmlspecialchars($_POST['fab_name']))); } ?> <input type="submit" value="valider" > </form>
</br> <input class="form_button" value="ajouter" type="submit"> </form> <!-- PARTIE SUPPRESSION--> </div> <div class="col-xs-12 col-md-6"> <form method="POST"> <label for="name" class="white">Nom : </label> <select name="name" class="form-control"> <?php echo liste_selection($bdd, basse, id_basse, nom_basse); echo '</select></br>'; if (!empty($_POST['name'])) { $req = $bdd->prepare('DELETE FROM `e_boutique`.`basse` WHERE `basse`.`id_basse` = :bass_name'); $req->execute(array('bass_name' => htmlspecialchars($_POST['name']))); } ?> </br> <input type="submit" value="Supprimer"> </form> </div> </body>