[MySQL] suppression data en utilisant checkbox

<?php require("conn.php"); define('TABLE', 'level'); if (!mysql_connect($db_host, $db_user, $db_pwd)) die("Can't connect to database"); if (!mysql_select_db($database)) die("Can't select database"); if (!$result = mysql_query('SELECT ID_level, level_name FROM '.TABLE)) die('Query to show fields from table failed'); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" lang="fr" xml:lang="fr"> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> </head> <body> <form action="delete_level.php" method="POST"> <?php while($ligne = mysql_fetch_assoc($result)){ echo '<div style="clear:both;">'; echo '<input type="checkbox" name="del[]" value="'.$ligne['ID_level'].'" />'; echo $ligne['level_name']; echo '</div>'; } ?> <input type="submit" value="delete" /> </form> </body> </html>

<?php require("conn.php"); define('TABLE', 'level'); if (!mysql_connect($db_host, $db_user, $db_pwd)) die("Can't connect to database"); if (!mysql_select_db($database)) die("Can't select database"); if(!empty($_POST['del'])){ $in = ''; foreach($_POST['del'] as $cle=>$valeur) $in .= $valeur.','; $in = substr($in, 0, -1); mysql_query('DELETE FROM '.TABLE.' WHERE ID_level IN ('.$in.')'); } ?>

Et ba voila, c'est la correction Merci :D.

Citation:

Envoyé par Madfrix

Voilà une correction vite faite et fonctionnelle, à toi de faire l'enrobage ;)

Fichier add_level.php

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
43
44
45
46
47
48
49
 
<?php
 
require("conn.php");
define('TABLE', 'level');
 
if (!mysql_connect($db_host, $db_user, $db_pwd))
    die("Can't connect to database");
 
if (!mysql_select_db($database))
    die("Can't select database");
 
if (!$result = mysql_query('SELECT ID_level, level_name FROM '.TABLE))
    die('Query to show fields from table failed');
 
?>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
 
<html xmlns="http://www.w3.org/1999/xhtml" lang="fr" xml:lang="fr">
 
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
 
</head>
 
<body>
 
 
<form action="delete_level.php" method="POST">
 
<?php
 
while($ligne = mysql_fetch_assoc($result)){
	echo '<div style="clear:both;">';
		echo '<input type="checkbox" name="del[]" value="'.$ligne['ID_level'].'" />';
		echo $ligne['level_name'];
	echo '</div>';
}
 
?>
 
<input type="submit" value="delete" />
 
</form>
 
</body>
 
</html>

Fichier delete_level.php

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
 
<?php 
 
	require("conn.php");
	define('TABLE', 'level');
 
	if (!mysql_connect($db_host, $db_user, $db_pwd))
	    die("Can't connect to database");
 
	if (!mysql_select_db($database))
	    die("Can't select database");
 
	if(!empty($_POST['del'])){
		$in = '';
 
		foreach($_POST['del'] as $cle=>$valeur)
			$in .= $valeur.',';
 
		$in = substr($in, 0, -1);
 
		mysql_query('DELETE FROM '.TABLE.' WHERE ID_level IN ('.$in.')');
 
	}
 
 
?>

Je n'ai pas fait non de vérification des valeurs saisies (sécurité etc...) à toi de le faire