PHP liste_selection Examples

Example #1

File: ajout_guitare.php Project: Edrenn/boutique

			<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";

Example #2

File: ajout_batterie.php Project: Edrenn/boutique

			</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";

Example #3

File: ref_batterie.php Project: Edrenn/boutique

		    <?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>

Example #4

File: ref_guitare.php Project: Edrenn/boutique

			<?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>

Example #5

File: ajout_basse.php Project: Edrenn/boutique

				
			</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>