Location: PHPKode > scripts > News Script > news-script/admin/editNewsForm.php
<?php
require('../config.php');
require('../NewsScript.php');

/**
 * Here we have clicked the button to update our edited article
 * We need to update it in the database
 */
if(isset($_POST['Submit']))
{
	$news = new NewsScript();
	if($news->updateNews($_GET['id'], $_POST['txtAuthor'], $_POST['txtContent']))
	{
		echo "Update complete!";
	}
	else echo "Update Error!";
	
	exit();
	
}
else // page loads but form not submitted
{
	if(is_numeric($_GET['id']))
	{
		$connection = mysql_connect($db_host, $db_user, $db_password) 
						or die("Unable to connect to MySQL");
							
		mysql_select_db($db_name, $connection) or die("Unable to select DB!");
		$id = $_GET['id'];
	
		$result = mysql_query("SELECT * FROM newstbl WHERE id = '$id'");
		$row = mysql_fetch_assoc($result);
			
		$author =  $row['author'];
		$content = $row['content'];
	
		mysql_close($connection);
	}
	else echo "None numeric Value!";
}

/**
 * output our content
 *
 */
function showContent()
{
	global $content;
	echo $content;
}

/**
 * output the author
 *
 */
function showAuthor()
{
	global $author;
	echo 'value="'. $author . '"';
}
	
?>
<!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">
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
	<title>Edit News</title>
</head>

<body>
<h1>Edit News</h1>
<form method="post" action="<?php $_SERVER['PHP_SELF']?>">
<table width="100%" border="0" cellspacing="2" cellpadding="2">
  <tr>
    <td>Name</td>
    <td><input type="text" name="txtAuthor" <? showAuthor();?> /></td>
  </tr>
  <tr>
    <td>News</td>
    <td><textarea name="txtContent" cols="60" rows="5"><? showContent();?></textarea></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td><input type="submit" name="Submit" value="Update" /></td>
  </tr>
</table>
</form>
</body>
</html>
Return current item: News Script