rendered paste bodyfunction editnews()
{
$id = $_GET['id'];
$query = "SELECT id,title,text FROM news WHERE id=$id";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
$pageGotChanged = false;
$id = $row['id'];
$title = $row['title'];
$text = $row['text'];
if( isset($_POST["submit"]) /*$_SERVER["REQUEST_METHOD"] == "POST"*/ ){
$id = $_GET['id'];
$title = $_POST['title'];
$text = $_POST['text'];
$query = "UPDATE news SET text='$text', title='$title' WHERE id=$id";
if( mysql_query($query) )
{
$pageGotChanged = true;
}
else
{
echo "Could not update!!";
}
}
elseif (isset($_POST["delete"])) {
$query = "DELETE * FROM tables WHERE id = " . $this->id;
if(mysql_query($query)) {
echo "News deleted!";
}
}
?>
<div class="box">
<h2>Edit news</h2>
<div class="form">
<?php if ($pageGotChanged) { ?>
<p style="border: 1px solid #99CC99; background: #CCFFCC; padding: 10px; margin-bottom: 1em;">
Updated successfully!
</p>
<?php } ?>
<form name="edit" action="<?=$_SERVER['REQUEST_URI']?>" method="post">
<div class="field">
<div class="label">Title</div>
<input type="text" class="text title" name="title" value="<?=$title?>">
</div>
<div class="field">
<div class="label">Text</div>
<div class="wysiwyg"><textarea id="text" name="text"><?=$text?></textarea></div>
</div>
<div class="field">
<div class="submit"><input type="submit" name="submit" value="Save updates"> or <input type="submit" name="delete" value="Delete"> </div>
</div>
</form>
</div>
<?
}