[SQL] Passer plusieurs variables à l'aide des checkbox
Bonjour,
j'essaie de passer plusieurs variables que je sélectionne via un formulaire:
Code:
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
| //selection de la table dans la base
$query="Select * from interventions" ;
//controle des resultats
$result = mysql_query( $query )or exit ('Erreur SQL !'.$query.'<br>'.mysql_error());
while($data = mysql_fetch_array($result))
{
//affichage des resultats
echo"<tr><td><input type='text' name='tech' size='15' value='".$data['tech']."' maxlength='25'></td>";
echo"<td><input type='text' name='client' size='15' value='".$data['client']."' maxlength='25'></td>";
echo"<td><input type='text' name='doss' size='15' value='".$data['doss']."' maxlength='25'></td>";
echo"<td><input type='text' name='tech' size='15' value='".$data['ville']."' maxlength='25'></td>";
echo"<td><input type='text' name='tech' size='15' value='".$data['jour']."' maxlength='25'></td>";
echo"<td><input type='text' name='tech' size='15' value='".$data['inter']."' maxlength='25'></td>";
echo"<td><input type='text' name='tech' size='15' value='".$data['dateDdC']."' maxlength='25'></td>";
echo"<td><input type='text' name='tech' size='15' value='".$data['dateFdC']."' maxlength='25'></td>";
echo"<td><input type='checkbox' name='delete[]' value='".$data['id']."'></td>";
echo"</tr>";
}
mysql_close();
?>
<td width="" align="right" colspan="3">
<input class="bouton" type="submit" name="exple3" value="Archiver">
</td>
</table>
</form> |
le fichier qui récupère les variables:
Code:
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
| <?php
//recup de la variable de suppression
if(isset($_POST['delete'])) $delete=$_POST['delete'];
else $delete="";
if(isset($_POST['client'])) $client=$_POST['client'];
else $client="";
if(isset($_POST['doss'])) $doss=$_POST['doss'];
else $doss="";
if (sizeof($delete)==0)
{
exit;}
else{
foreach ($delete as $id)
{
echo $delete;
echo $client;
echo $doss;
if (sizeof($delete)==0){
header('Location:pageformulaire.php');
exit;}
else{
$db = mysql_connect('localhost', 'root', '')
or die('<font color=red>Désolé mais vous ne pouvez voir les infos de la data-base</font>');
mysql_select_db('gestion',$db);
foreach ($delete as $valeur){
//je creer ma requete
$sql="INSERT INTO arch_inter (client, doss) VALUES ('$client','$doss')";
}
//on envoie la requete
$req = mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
}
// on ferme la connexion à mysql
mysql_close();
}} |
En faite, mon script laisse bien passer le nombre de checkbox coché mais pas la valeur des differents champs coché ....
merci de votre aide.