All pastes #63945 Raw Edit

Something

public text v1 · immutable
#63945 ·published 2006-06-10 22:34 UTC
rendered paste body
function 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>

<?


}