AllSyntax.com: » Tutorials » PHP » 35 » Building A News Management System


	I find that the harder I work, the more luck I seem to have. - Thomas Jefferson

[login] | [Register]

Building a News Management System

by: sm0ke

Page: 3 of 5
(View All)

Admin Features

If we want to edit or delete any of the posts we have submitted, were going to need an admin list of all the posts entered with links to either edit or delete that post.

The below code is the complete code for the admin list page (/admin/list.php):

Its not very pretty, but it displays all the latest posts in descending order, and presents two links next to each title to either edit or delete the post.

the code: <a href='ed.php?id=$send->id'></a> basically calls the edit script into play, while sending the "id" variable with the link. This allows us to edit or delete the post where id=xx.

Edit

The next bit of code is quite like the initial add script that we wrote earlier in the tutorial It connects to the databse and selects the record requested. So if you press edit on id 1, we see a form filled with all the information saved in the first news post.

The edit script - save as (/admin/ed.php):

<?
     include("../site/site.inc.php");

// form not yet submitted
// display initial form with values pre-filled
if (!$submit)
{
	db_login();

// generate and execute query
	$query = "SELECT * FROM news WHERE id = '$id'";
	$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
	
	// if a result is returned
	if (mysql_num_rows($result) > 0)
	{
		// turn it into an object
		$send = mysql_fetch_object($result);

// print form with values pre-filled
?>

Edit News Post
<form action="<? echo $PHP_SELF; ?>" method="POST">
<input type="hidden" name="id"  value="<? echo $send->id; ?>">
Title:<br />
<input size="50" maxlength="250" type="text" name="title" value="<? echo $send->title; ?>"><br />
Content:<br />
<textarea name="content" cols="40" rows="10"><? echo $send->content; ?></textarea><br />
Author:<br />
<input size="50" maxlength="250" type="text" name="author" value="<? echo $send->author; ?>"><br />

<?
	}
	// no result returned
	
	else {
		echo "<font size=-1>That post does not exist.</font>";
	}
}
// form submitted
// start processing it
else
{

There we logged into the database and collected all information on id number xx, then displayed the information in a form ready for editing. Next, we need to check if the form has been submitted, and were there any errors? If not, update the record in the db with the new values or halt if any error encountered.

That updated the databse for id number xx with the new values entered into the form.

Delete

And finally, the admin needs to delete posts. this page is only a few lines of code:

With the code sample shown above, we have connected to the database and asked it to delete the article with id number xx.

« Prev.

1 | 2 | 3 | 4 | 5 |

Next »

Comments:

s141797

Subject: "Problem help" Date: Nov 16 2008 at 10:31 am

I am having a problem at the del.php page.

This sentence does not work: $query = "DELETE FROM news WHERE id = '$id'"; .... Its like my script does not recieve the id or something, I get no error message but the row does not get deleted from my table.

If i use this: $query = "DELETE FROM news WHERE id = '1'"; the row gets deleted from the table but then the entire of the script is gone.

Im having the same problem at the r.php file.... This site just returns nothing.

I have simply copy pasted all the code in the tutorial and changed the db login variables.

Any ideas?

You Must be logged in or a member to comment.

	Tutorial Stats
547,614	Views
6	Total Comments
0	Rating of 5 ( Votes)

	Tutorial Options
· Login to Rate This Article
· Login to Post a Comment
· Read more by this author

	Related
· Simple PHP Tutorial
· One File Website
· Pagination with PHP
· Building a Comments Script
· Complete Members System
· Variable Scope

Building a News Management System

Admin Features

Edit

Delete

Comments:

Tutorial Stats

Tutorial Options

Related