Gästbok problem
Hej
Har en gästbok i PHP koden är
Jag vill kunna ta bort ett inlägg beroende på vilket id texten har i databasen.
Jag vill ta bor inlägget genom att jag trycker på ta bort knappen bre vid meddelandet. Har gjort en submitknapp på rad 72. Kör mysql_query för att ta bort inlägget på rad 47 (den är inte färdigkodad)
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
"http://www.w3.org/TR/html4/strict.dtd">
<html lang ="sv">
<head>
<link rel="stylesheet" type="text/css" href="style.css"/>
<title>
Gästbok
</title>
</head>
<body>
<?php
include('geshi.php');
if (mysql_connect('localhost','root','') && mysql_select_db('guestbook')){
$time = time();
$errors = array();
if (isset($_POST['guestbook_name'], $_POST['guestbook_message'])){
$name = mysql_real_escape_string($_POST['guestbook_name']);
$message = mysql_real_escape_string($_POST['guestbook_message']);
$kode = mysql_real_escape_string($_POST['kode']);
$value = mysql_real_escape_string($_POST['value']);
if(empty($name) || empty($message)){
$errors[] = 'Fyll i alla fält!';
}
if(empty ($errors)){
$insert ="INSERT INTO `entries` VALUES ('','$time','$name','$message','$kode','$value')";
if(mysql_query($insert)){
header('Location: '. $_SERVER['PHP_SELF']);
}else{
$errors[] = 'Något gick fel.';
}
}else{
foreach($errors as $error){
echo '<div class=error>' . $error . '</div>';
}
}
}
$entries = mysql_query("SELECT `timestamp`,`name`,`message`,`kode`,`value` FROM `entries` ORDER BY `timestamp` DESC");
/*-----------------------------------------------------------------------------------------------------------------------------
$delete_message = mysql_query("DELETE `timestamp`,`name`,`message`,`kode`,`value` FROM `entries` WHERE ");
------------------------------------------------------------------------------------------------------------------------------*/
if (mysql_num_rows($entries)==0){
echo 'Inga medelanden';
}else{
while($entries_row = mysql_fetch_assoc($entries)){
$entries_timestamp = date('Y-m-d H:i',$entries_row['timestamp']);
$entries_name = $entries_row['name'];
$entries_message = $entries_row['message'];
$entries_kode = $entries_row['kode'];
$entries_value = $entries_row['value'];
echo '<p><div id="text"><b><u>'.$entries_name ." ". $entries_timestamp.'</u>
</b><br></div>'.
nl2br(htmlspecialchars ($entries_message)).'<br><p>';
if($entries_value != 'nothing'){
// Make a new GeSHi object, with the source, language and path set
$source = $entries_kode;
$language = $entries_value;
$path = 'geshi/';
$geshi = new GeSHi($source, $language, $path);
//submit knapp.
echo '<i>Kod '.$language.'</i>' ?> <input type="submit" value="tabort"> <?php echo $geshi->enable_line_numbers(GESHI_FANCY_LINE_NUMBERS).$geshi->set_line_style('background: #eeeeee;', 'background: #eeeeee;', false) . $geshi->parse_code();
}
}
}
}else{
echo 'Could not connect';
}
?>
<hr>
<form action="<?php echo htmlspecialchars($_SERVER['PHP_SELF']);?>" method="POST">
Name:<br><input type="text" name="guestbook_name" maxlength="25"><br>
Message:<br><textarea name="guestbook_message" rows="5" cols="50"></textarea><br>
Kod: <select name="value">
<option value="nothing">Inget</option>
<option value="C++">C++</option>
<option value="java5">Java</option>
<option value="php">PHP</option>
<option value="css">CSS</option>
<option value="html4strict">HTML</option>
</select>
<br><textarea name="kode" rows="5" cols="50"></textarea><br>
<input type="submit" value="Ny">
</form>
</body>
</html>
CPU: AMD Phenom2 X4 955 3,2GHz| RAM: Kingston 2x2048MB| HDD: WD Caviar® Black 1TB 3,5| ASUS M4A87TD/USB3| PSU: Corsair 650W| GPU: XFX Radeon HD 5770 1GB| OS: Windows 7| Chassi: Antec Three Hundred
