Login   Register  
PHP Classes
elePHPant
Icontem

File: admin/editNewsForm.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  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: 6 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>