<?php if (!empty($ancien_utilisateur)) { @$db = new mysqli('localhost', 'julien', 'admin', 'web'); if(mysqli_connect_errno()) { echo "Impossible de se connecter à la base de données."; exit; } if (isset($_POST['supprimer'])) // test si on a cliquer sur un bouton { $idbouton = $_POST['supprimer']; $sup= " DELETE FROM occasion WHERE id_occas='$idbouton'"; $supp = $db->query($sup); } $ma_requete = " SELECT * from occasion "; $resultat = $db->query($ma_requete); $nb_lig_resultat = $resultat->num_rows; ?> <form name="form1" method="post" action=""> <?php $j = 0; for($i =0; $i < $nb_lig_resultat; $i++) { $ligne = $resultat->fetch_assoc(); ?> <tr <?php if($j % 2 == 0) { echo 'bgcolor="#DCDCDC"'; echo 'onmouseover="bgColor=\'lightyellow\';"'; echo 'onmouseout="bgColor=\'#DCDCDC\'" >'; } else { echo 'bgcolor="#F0F0F0"'; echo 'onmouseover="bgColor=\'lightyellow\';"'; echo 'onmouseout="bgColor=\'#F0F0F0\'" >'; } ?> <td></td> <td class="cellpty"> <?php echo stripslashes($ligne['marque_occas']) . '</td>'; ?> <td class="cellpty"> <?php echo stripslashes($ligne['modele_occas']) . '</td>';?> <td class="cellpty"> <?php echo stripslashes($ligne['version_occas']) . '</td>';?> <td class="cellpty"> <?php echo stripslashes($ligne['annee_occas']) . '</td>';?> <td class="cellpty"> <?php echo stripslashes($ligne['color_ext_occas']) . '</td>';?> <td class="cellpty"> <?php echo stripslashes($ligne['km_occas']) . '</td>';?> <td class="cellpty"> <?php echo stripslashes($ligne['energie_occas']) . '</td>';?> <td class="cellpty"> <?php echo stripslashes($ligne['puissance_occas']) . '</td>';?> <td class="cellpty"> <?php echo stripslashes($ligne['prix_occas']) . '</td>';?> <td> ]" type="checkbox" id="supprimer[]" value="<?php echo $ligne['id_occas']; ?>"></td> </td> </tr> <?php $j++ ?> <?php } ?> </table> </form> <?php foreach($_POST['supprimer'] as $k=>$i){ if($i == "on"){ echo "mon champs checké est : ".$k; } } if (!empty($_POST['supprimer'])) { foreach ($_POST['supprimer'] as $cle) { $Requete = "DELETE FROM `occasion` WHERE `id_occas`='$cle'"; $resRequete = mysql_query($Requete, 'localhost', 'julien', 'admin', 'web') or die(mysql_error()); } } $resultat->free(); $db->close(); ?> <?php } else { ?>
<?php if (!empty($ancien_utilisateur)) { @$db = new mysqli('localhost', 'julien', 'admin', 'web'); if(mysqli_connect_errno()) { echo "Impossible de se connecter à la base de données."; exit; } if (isset($_POST['supprimer'])) // test si on a cliquer sur un bouton { $ids = implode(",",$_POST["supprimer"]); $sup= "DELETE FROM `web`.`occasion` WHERE `occasion`.`id_occas` IN ($ids)"; $supp = $db->query($sup); } $ma_requete = " SELECT * from occasion "; $resultat = $db->query($ma_requete); $nb_lig_resultat = $resultat->num_rows; ?> <form name="form1" method="post" action="afficher.php"> <?php $j = 0; for($i =0; $i < $nb_lig_resultat; $i++) { $ligne = $resultat->fetch_assoc(); ?> <tr<?php if($j % 2 == 0) { echo ' bgcolor="#DCDCDC"'; echo ' onmouseover="bgColor=\'lightyellow\';"'; echo ' onmouseout="bgColor=\'#DCDCDC\'"'; } else { echo ' bgcolor="#F0F0F0"'; echo ' onmouseover="bgColor=\'lightyellow\';"'; echo ' onmouseout="bgColor=\'#F0F0F0\'"'; } ?>> <td>" alt="<?php echo stripslashes($ligne['modele_occas'] . $ligne['version_occas']);?>"/></td> <td class="cellpty"><?php echo stripslashes($ligne['marque_occas']); ?> </td> <td class="cellpty"><?php echo stripslashes($ligne['modele_occas']);?></td> <td class="cellpty">" /><?php echo stripslashes($ligne['version_occas']);?></td> <td class="cellpty"><?php echo stripslashes($ligne['annee_occas']);?></td> <td class="cellpty"><?php echo stripslashes($ligne['color_ext_occas']);?></td> <td class="cellpty"><?php echo stripslashes($ligne['km_occas']);?></td> <td class="cellpty"><?php echo stripslashes($ligne['energie_occas']);?></td> <td class="cellpty"><?php echo stripslashes($ligne['puissance_occas']);?></td> <td class="cellpty"><?php echo stripslashes($ligne['prix_occas']);?></td> <td> "></td> </tr> <?php $j++ ?> <?php } ?> </table> </form> <?php $resultat->free(); $db->close(); ?>