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
| <?php
$db = mysql_connect('localhost', 'root', 'nejjar')
or die('<font color=red>Désolé mais vous ne pouvez voir les infos de la data-base</font>');
mysql_select_db('a',$db);
echo '<form action="pageformulaire.php" method="post" name="delLinks">';
echo '<table>';
$sql = "SELECT * FROM contact ORDER BY id DESC";
$req = mysql_query($sql) or die($error.'Erreur SQ!'.$sql.''.mysql_error());
while ($data = mysql_fetch_assoc($req)) {
echo '<tr><td>'.$data['noms'].'</td>';
echo '<td>'.$data['phone'].'</td>';
echo '<td><input type="checkbox" name="maListe[]" value="'.$data['id'].'" /></td>';
echo '</tr>';
}
echo '<input type="submit" name="button" id="button" value="Supprimer" /></td></tr></table></form>';?>
<?php
$db = mysql_connect('localhost', 'root', 'nejjar')
or die('<font color=red>Désolé mais vous ne pouvez voir les infos de la data-base</font>');
mysql_select_db('a',$db);
$liste = $_POST['maListe'];
echo '<table border=1>';
for($i=0;$i<sizeof($liste);$i++)
{
$sql = "SELECT noms, phone FROM contact WHERE id=$liste[$i]";
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
while ($data = mysql_fetch_assoc($req)) {
echo '<tr><td>'.$data['noms'].'</td>';
echo '<td>'.$data['phone'].'</td>';
echo '</tr>';
}
}
echo '</table>';
?> |
Partager