Een rij deleten uit de db
ZO haal ik de gegevens uit de database en steek deze in een drop-down menu,
als je dan op eentje selecteerd, en op verwijdert duwt, dan wordt de rij uit de database verwijdert
Hoe doe ik dit met onderstaande code?
<form id="form1" method="post" action="">
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
<?php
// Make a MySQL Connection
require_once("connect.php");
// Get all the data from the "example" table
$result = mysql_query("SELECT * FROM koen")
or die(mysql_error());
echo "<select name=\"select\">\n";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result ))
{
// Print out the contents of each row into a table
echo "<option value=\"".$row['titel']."\">";
echo $row['titel'];
echo "</option>\n";
}
echo "</select>";
?>
// Make a MySQL Connection
require_once("connect.php");
// Get all the data from the "example" table
$result = mysql_query("SELECT * FROM koen")
or die(mysql_error());
echo "<select name=\"select\">\n";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result ))
{
// Print out the contents of each row into a table
echo "<option value=\"".$row['titel']."\">";
echo $row['titel'];
echo "</option>\n";
}
echo "</select>";
?>
<input type="submit" name="knop" value="Versturen" />
</form>
bedankt
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
2
3
4
5
6
7
8
9
10
11
12
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$sql = "
DELETE FROM koen
WHERE titel = '" . $_POST['select'] . "'
LIMIT 1
";
if (!mysql_query ($sql)) {
trigger_error (mysql_error ());
}
}
?>
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$sql = "
DELETE FROM koen
WHERE titel = '" . $_POST['select'] . "'
LIMIT 1
";
if (!mysql_query ($sql)) {
trigger_error (mysql_error ());
}
}
?>