Specifications

This will mark a story as published and authorize it for public viewing.
Similarly, unpublish_story.php uses the following query to mark a story as unpublished and
stop it from being displayed to the public:
update stories set published = null
where id = $story
The edit link appears regardless of whether a story is published, so the editor can always make
changes. This is different to the writers’ level of access, where they can only modify a story
before it has been published.
Extending the Project
There are several ways this project could be extended to make a more comprehensive content
management system:
• You could allow groups of users to work on stories together (collaboration).
• You could implement a more flexible page layout so that editors can position text and
images on the page.
• An image library could be built so that frequently used pictures are not duplicated, and
search keywords are assigned to images as well as story text.
• You could also add spell-checking functionality to the content editor. A check could be
implemented using, for example, the aspell library.
Next
In the next project, we will build a Web-based interface that will allow you to check and send
email from the Web using IMAP.
Building Practical PHP and MySQL Projects
P
ART V
616
32 7842 ch26 3/6/01 3:36 PM Page 616