Проблем с урок за масово премахване
- Автор GameZone
- Начална дата
Код:
while($row = mysql_fetch_assoc($query)) {
$sql2 = mysql_query("SELECT * FROM songs WHERE id='$row[song]'");
$data = mysql_fetch_assoc($sql2);
$song = "$data[artist] - $data[song]";
?>
<table width="100%" align='center'>
<tr><td width="10%" style='background-color: #ffffff; padding: 5px; border: 1px solid #e5e5e5;' align='center'>
<span style='font-size: 11px; font-color: #ffcc00;'>
<?php
if($data[listen] == 0) {
echo "<img src='images/icons/nolisten.jpg' width='16' height='16' title='Неможе да се слуша в сайта'>";
}
else {
echo "<img src='images/icons/listen.jpg' width='16' height='16' title='Може да се слуша в сайта'>";
}
?>
</span></td>
<td width="80%" style='background-color: #ffffff; padding: 5px; border: 1px solid #e5e5e5;'>
<span style='font-size: 11px; font-color: #ffcc00;'>
<a href="index.php?page=play_song&song=<?php echo $data[id]; ?>"><?php echo $song; ?></a>
</span></td>
<td width="10%" style='background-color: #ffffff; padding: 5px; border: 1px solid #e5e5e5;' align='center'>
<span style='font-size: 11px; font-color: #ffcc00;'>
<input name="checkbox[]" type="checkbox" id="checkbox[]" value="<?php echo $row[id]; ?>">
</span></td>
<?php
}
echo "</tr><tr>
<td colspan='3' align='center'>
<form method='POST' action=''>
<input name='delete' type='submit' id='delete' value='Изтрий'>
</form>
</td></tr></table></a></div></div>";
$sql3 = mysql_query("SELECT * FROM favourites WHERE user='$sesuser'");
$count = mysql_num_rows($sql3);
if($_POST['checkbox']) {
$ids = $checkbox[$count];
foreach($_POST['checkbox'] AS $ids){
$sql = "DELETE FROM favourites WHERE id='$ids'";
$res = mysql_query($sql) or die (mysql_error());
}
if($res) {
echo "<meta http-equiv=\"refresh\" content=\"0;URL=index.php?page=options&mode=favourites_songss\">";
}
}
}