Slet fra database
Hej med jer.Jeg vil gerne masseslette fra min database, men kræver lige jeg kan se indlægget først. Har lavet et script hvor den skriver ud fra database og jeg kan slette, dog kun et indlæg ad gangen.
Nogen der kan hjælpe med at ændrer det til et "afkrydsningsfelt" så jeg kan krydse alle dem af der skal slettes og så trykke på en "delete" knap?
Har følgende kode:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<title>View Records</title>
</head>
<body>
<?php
// connect to the database
include('connect-db-pic.php');
// number of results to show per page
$per_page = 20;
// figure out the total pages in the database
$result = mysql_query("SELECT * From comment WHERE visnyhed = 3 AND billedekategori <> '' ORDER BY tid DESC LIMIT 30");
$total_results = mysql_num_rows($result);
$total_pages = ceil($total_results / $per_page);
// check if the 'page' variable is set in the URL (ex: view-paginated.php?page=1)
if (isset($_GET['page']) && is_numeric($_GET['page']))
{
$show_page = $_GET['page'];
// make sure the $show_page value is valid
if ($show_page > 0 && $show_page <= $total_pages)
{
$start = ($show_page -1) * $per_page;
$end = $start + $per_page;
}
else
{
// error - show first set of results
$start = 0;
$end = $per_page;
}
}
else
{
// if page isn't set, show first set of results
$start = 0;
$end = $per_page;
}
// display pagination
echo "<p><a href='view.php'>View All</a> | <b>View Page:</b> ";
for ($i = 1; $i <= $total_pages; $i++)
{
echo "<a href='view.php?page=$i'>$i</a> ";
}
echo "</p>";
// display data in table
echo "<table border='1' cellpadding='10'>";
echo "<tr> <th>ID</th> <th>Overskrift</th> <th>Beskrivelse</th> <th></th> <th></th></tr>";
// loop through results of database query, displaying them in the table
for ($i = $start; $i < $end; $i++)
{
// make sure that PHP doesn't try to show results that don't exist
if ($i == $total_results) { break; }
// echo out the contents of each row into a table
echo "<tr>";
echo '<td>' . mysql_result($result, $i, 'id') . '</td>';
echo '<td>' . mysql_result($result, $i, 'beskrivelse') . '</td>';
echo '<td><a href="editpic.php?id=' . mysql_result($result, $i, 'id') . '">Edit</a></td>';
echo '<td><a href="deletepic.php?id=' . mysql_result($result, $i, 'id') . '">Delete</a></td>';
echo "</tr>";
}
// close table>
echo "</table>";
// pagination
?>
<p><a href="new.php">Add a new record</a></p>
</body>
</html>
