PHP Classes

File: admin/editNewsForm.php

Recommend this page to a friend!
  Classes of Andrew   News Script   admin/editNewsForm.php   Download  
File: admin/editNewsForm.php
Role: Application script
Content type: text/plain
Description: Edits News Items
Class: News Script
Manage and publish news stored in a MySQL database
Author: By
Last change:
Date: 15 years ago
Size: 2,002 bytes
 

Contents

Class file image Download
<?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>