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
|
<div >
<input form="modify_table" type="submit" name="Ok" value="Valider"/>
</div>
<table class="superb">
<form id="modify_table" method="post" action="#">
<tr>
<th>ID</th>
<th>Emplacement</th>
<th>Quantité</th>
</tr>
<?php
// TRAITEMENT
$emplacementX_array = $_POST['emplacementX'];
$emplacementY_array = $_POST['emplacementY'];
$emplacementZ_array = $_POST['emplacementZ'];
// Préparation de la requete UPDATE
$query = $mysqli->prepare("UPDATE outils SET EmplacementX = (?), EmplacementY = (?), EmplacementZ = (?) WHERE ID = (?)");
// Pour chaque ligne du formulaire
foreach( $emplacementX_array as $id => $emplacementX )
{
$emplacementX = $emplacementX_array[$id];
$emplacementY = $emplacementY_array[$id];
$emplacementZ = $emplacementZ_array[$id];
// ici GESTION d'ERREUR (éventuellement)
// .......
// ici : la requete UPDATE pour la ligne
$query->bind_param("ssss", $emplacementX, $emplacementY, $emplacementZ, $id);
$query->execute() or die ("MySQL query error for id=".$id." (".$mysqli->connect_errno.")".$mysqli->connect_error);
}
$reponse = $mysqli->query("SELECT * FROM outils");
while($donnees = $reponse->fetch_assoc())
{
$id = $donnees['ID'];
$emplacementX = $donnees['EmplacementX'];
$emplacementY = $donnees['EmplacementY'];
$emplacementZ = $donnees['EmplacementZ'];
?>
<tr>
<td><!-- Emplacement case -->
<select name=emplacementY[<?php echo $id; ?>]">
<option value=""></option>
<?php $emplacementY_options = array(
'1U' => '1U', // couples value / name (ils peuvent être différents)
'1D' => '1D',
'II' => 'II',
'III' => 'III',
'IV' => 'IV',
'V' => 'V',
'VI' => 'VI'
);
foreach( $emplacementY_options as $optY_val => $optY_name )
{
$selected = ( $emplacementY == $optY_val )? ' selected="selected"' : '';
?>
<option value="<?php echo $optY_val; ?>"<?php echo $selected; ?>><?php echo $optY_name; ?></option>
<?php
}
?>
</select>
<select name=emplacementX[<?php echo $id; ?>]">
<option value=""></option>
<?php // emplacementX
for($optX='A'; $optX<='F'; $optX++)
{
$selected = ( $emplacementX == $optX )? ' selected="selected"' : '';
?>
<option value="<?php echo $optX; ?>"<?php echo $selected; ?>><?php echo $optX; ?></option>
<?php
}
?>
</select>
<select name="emplacementZ[<?php echo $id; ?>]">
<option value=""></option>
<?php for($optZ=9; $optZ>0; $optZ--)
{
$selected = ( $emplacementZ == $optZ )? ' selected="selected"' : '';
?>
<option value="<?php echo $optZ; ?>"<?php echo $selected; ?>><?php echo $optZ; ?></option>
<?php
}
?>
</select>
</td>
<td><!-- Quantite case -->
<?php //echo $donnees['Quantite'];
echo '<input type="number" name="Quantite" value="'.$donnees['Quantite'].'" /> ';
?>
</td>
</tr>
</form>
<?php //fin de la boucle
}
$query->close();
$reponse->free();
$mysqli->close();
?>
</table> |
Partager