Hallo,
ik zit een beetje te prutsen met PHP, en heb nu een code geschreven, die, als je op delete klikt, het bericht weghaalt..
Maar nu zoals ik zie, als ik op edit klikt, haalt hij het ook weg?
Hoe kan dit?
ik zit een beetje te prutsen met PHP, en heb nu een code geschreven, die, als je op delete klikt, het bericht weghaalt..
Maar nu zoals ik zie, als ik op edit klikt, haalt hij het ook weg?
Hoe kan dit?
PHP:
<?php
include('config/data.php');
$index = "index.php";
//Berichten weergeven + tellen
$result = mysql_query("SELECT * FROM messages ORDER BY id DESC LIMIT 0,3");
$count = mysql_num_rows($result);
// als 0 berichten is.
if($count == 0){
echo "<div align='center'>";
echo "<table width='500' border='0' cellspacing='5'>";;
echo "<tr>";
echo "<td align='left' width='75'> </td>";
echo "<td align='left' width='350' class='sender'> </td>";
echo "<td width='75'> </a></td>";
echo "</tr>";
echo "<tr>";
echo "<td align='left' width='75'> </td>";
echo "<td align='left' width='350'> </td>";
echo "<td width='75'> </td>";
echo "</tr>";
echo "<tr>";
echo "<td align='left' width='75'> </td>";
echo "<td align='center' width='350' class='text'>No messages yet!<br><hr color='#222222' width='350px' size='1'></td>";
echo "<td width='75'> </td>";
echo "</tr>";
echo "</table>";
//als 1 berichten >=
} elseif($count >= 1)
{
while($row = mysql_fetch_array($result))
{
echo "<div align='center'>";
echo "<table width='500' border='0' cellspacing='5'>";;
echo "<tr>";
echo "<td align='left' width='75'> </td>";
echo "<td align='left' width='350' class='sender'>" . $row['sender'] . "</td>";
echo "<td width='75'></td>";
echo "</tr>";
echo "<tr>";
echo "<td align='left' width='75'> </td>";
echo "<td align='left' width='350'>" . $row['date'] . "<br>" . $row['time'] . "</td>";
echo "<td width='75'> </td>";
echo "</tr>";
echo "<tr>";
echo "<td align='left' width='75'> </td>";
echo "<td align='left' width='350' class='text'>" . $row['content'] . "<br></td>";
echo "<td width='75'> </td>";
echo "</tr>";
echo "<tr>
<td align='left' width='75'> </td>
<td align='center' width='350'><span class='text'>[</span> <a href='".$_SERVER['PHP_SELF']."?delete&id=".$row['id']."'> Delete</a> <span class='text'>|</span> <a href='".$_SERVER['PHP_SELF']."?edit&id=".$row['id']."'>Edit </a><span class='text'>]</span><br><hr color='#222222' width='350px' size='1'></td>
<td width='75'> </td>
<tr>";
echo "</table>";
}
}
//textarea for message
echo "<center>";
echo "<form action='' method='post'>";
echo "<table width='500' border='0' cellspacing='5'>";
echo "<tr>";
echo "<td align='left' width='75'> </td>";
echo "<td align='center' width='350'><textarea name='text' cols='35' rows='5'></textarea>";
echo "<br><input type='submit' name='submit' value='Submit' />";
echo " <input name='reset' type='button' value='Reset' /></td>";
echo "<td width='75'> </td>";
echo "</tr>";
echo "</table>";
echo "</form>";
echo "</div>";
echo "</center>";
//Als er op submit is gedrukt.
if(isset($_POST['submit']))
{
mysql_query("INSERT INTO messages (content, sender, reciever, date, time) VALUES ('$_POST[text]', 'Admin', 'reciever', NOW(), NOW())");
echo "<meta http-equiv=refresh content=0;URL=".$_SERVER['PHP_SELF'].">";
}
//Delete function
if($_GET['delete'] == $row['id'])
{
if (is_numeric($_GET["id"]))
{
$sql = "DELETE FROM messages WHERE id = " . $_GET['id'];
$res = mysql_query($sql);
echo "<meta http-equiv=refresh content=0;URL=$index>";
}
}
?>
