Ta bort inlägg..

TroOmbMedlem sedan dec. 200215 inlägg

Frågan27 jan. 2003 19:35#1

Kan nån förklara för mej hur jag gör när jag först connectar till en tabell, sen listas inlägget och ett IDnummer. Sedan kommer en ruta upp under som man skriver in ett ID i och klickar på Ta bort så försvinner den från tabellen.. Koden:

<?
$dellink = mysql_connect("localhost","anv","losen");
$query = "DELETE FROM sb ID = $id ";
mysql_db_query("clanrrf","$query");
mysql_close($dellink);

$data = mysql_connect("localhost","anv","losen");
$sql="select * from sb2 ORDER BY id DESC";
$result = mysql_db_query("clanrrf","$sql");
while($row = mysql_fetch_array($result)){
?>
<B>ID:</B> <?=$row['id']?><BR>
<B>Inlägg:</B> <?=$row['inlagg']?><BR><BR>
<?
}
mysql_close($data);
?><BR><BR>
<FORM ACTION="deleeeeeee.php">
<INPUT TYPE="text" NAME="id"><BR>
<INPUT TYPE="submit" VALUE="Ta bort">
</FORM>

FuelMedlem sedan okt. 20001 285 inlägg

27 jan. 2003 20:35#2

<?php
// Connect here..

if ($action == "delete") {
    mysql_query("DELETE FROM sb WHERE id = $id ");
}
echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
	   "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="sv" lang="sv">
<head>
<title>Robert</title>
<head>
<body>
<?php
$result = mysql_query("SELECT * FROM sb2 ORDER BY id DESC");
while($row = mysql_fetch_array($result)){
?>
<b>ID:</b> <?=$row['id']?><br />
<b>Inlägg:</b> <?=$row['inlagg']?><br /><br />
<?
}
?>

<br /><br />
<form action="<?=$PHP_SELF;?>">
ID: <input type="text" name="id" /> <input type="submit" value="Delete" />
<input type="hidden" name="action" value="delete" />
</form>
</body>
</html>

eller..

<?php
// Connect here..

if ($action == "delete") {
    mysql_query("DELETE FROM sb WHERE id = $id ");
}
echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
	   "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="sv" lang="sv">
<head>
<title>Robert</title>
<head>
<body>
<?php
$result = mysql_query("SELECT * FROM sb2 ORDER BY id DESC");
while($row = mysql_fetch_array($result)){
?>
<b>ID:</b> <?=$row['id']?><br />
<b>Inlägg:</b> <?=$row['inlagg']?>
<form action="<?=$PHP_SELF;?>">
<input type="submit" value="Delete this" />
<input type="hidden" name="action" value="delete" />
<input type="hidden" name="id" value="<?=$row['id']?>" />
</form>
</body>
</html>
<?
}
?>