Home arrow PHP arrow Page 9 - Building A Quick-And-Dirty PHP/MySQL Publishing System

Game Over - PHP

Looking to quickly add a dynamic news page to your corporate orpersonal Web site? This article shows you how, combining PHP's rapidapplication development capabilities with a MySQL database to create aprimitive news publishing system and administration module in just underfour hours.

  1. Building A Quick-And-Dirty PHP/MySQL Publishing System
  2. A Little Slug-gish
  3. A Maniac Is Born
  4. Bedtime Stories
  5. Admin Ahoy!
  6. Splitting Up
  7. Erasing The Past
  8. Changing Things Around
  9. Game Over
By: icarus, (c) Melonfire
Rating: starstarstarstarstar / 44
March 12, 2002

print this article


And that just about concludes this case study. I now have an application that meets all the requirements defined by the customer. All that's left is to upload it to their Web site, run a few tests on it, and give them a call to let them know where to send the cheque.

As you can see, it's extremely easy to build a simple publishing system with PHP and MySQL. The two technologies, combined together, are so powerful that putting together dynamic, robust Web applications, like the one just described, is a snap. It's also fast - I estimate that I spent a total development time just under four hours on this project - which can come in very handy when working against aggressive deadlines.

If you'd like to learn more about some of the issues, techniques and functions described throughout the course of this article, here are a few links:

The Fundamentals of Relational Database Design: http://www.microsoft.com/TechNet/Access/technote/ac101.asp?a=printable

Date functions available in PHP: http://www.php.net/manual/en/ref.datetime.php

mySQL functions available in PHP: http://www.php.net/manual/en/ref.mysql.php

Protecting Web pages with HTTP authentication: http://www.apacheweek.com/issues/96-10-18#userauth

If you'd like to read other case studies like this, do consider visiting the following links:

Miles To Go Before I Sleep: http://www.devshed.com/c/a/PHP/Miles-To-Go-Before-I-Sleep/

Cracking The Vault: http://www.devshed.com/c/a/PHP/Cracking-The-Vault-part-1/

Till next time...stay healthy!

Note: All examples in this article have been tested on Linux/i686 with Apache 1.3.12 and PHP 4.1.0. Examples are illustrative only, and are not meant for a production environment. A fictitious company name has been used in this case study to protect the identity and reputation of the original subject. Melonfire provides no warranties or support for the source code described in this article. YMMV!

>>> More PHP Articles          >>> More By icarus, (c) Melonfire

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Hackers Compromise PHP Sites to Launch Attac...
- Red Hat, Zend Form OpenShift PaaS Alliance
- PHP IDE News
- BCD, Zend Extend PHP Partnership
- PHP FAQ Highlight
- PHP Creator Didn't Set Out to Create a Langu...
- PHP Trends Revealed in Zend Study
- PHP: Best Methods for Running Scheduled Jobs
- PHP Array Functions: array_change_key_case
- PHP array_combine Function
- PHP array_chunk Function
- PHP Closures as View Helpers: Lazy-Loading F...
- Using PHP Closures as View Helpers
- PHP File and Operating System Program Execut...
- PHP: Effects of Wrapping Code in Class Const...

Developer Shed Affiliates


Dev Shed Tutorial Topics: