non verificato, + o -
codice:
<?
mysql_connect($DBhost,$DBuser,$DBpass) or die("Timeout Server connection ");
@mysql_select_db("$DBName") or die("MySQL databse unavailable$DBName.");
$sqlquery = "SELECT id, data, username, username_password, email FROM $table";
$result = mysql_query($sqlquery) or die(mysql_error());
if(mysql_num_rows($result) > 0) {
echo "<form action=\"delete.php\" method=\"post\">";
while(list($id, $data, $username, $password, $email) = mysql_fetch_row($result) {
echo "
#id:$id
Data creazione: $data
User: $username
Pass: $password
Email: $email</p>
<input type=\"checkbox\" name=\"del_id[]\" value=\"$id\">
";
}
echo "<input type=\submit\" name=\"cancella\" value=\"cancella i valori selezionati\">";
</form>";
} else {
echo "Tabella vuota";
}
?>
delete.php
codice:
<?
if(isset($_POST['del_id']) && is_array($_POST['del_id']) && count($_POST['del_id']) > 0) {
$query = "DELETE FROM tabella WHERE id IN (".implode(", ", $_POST['del_id']).")";
// conn
// sel
mysql_query($query);
} else {
echo "NOn sono stati selezionati record";
}
?>