Building A Quick-And-Dirty PHP/MySQL Publishing System - Game Over

(Page 9 of 9 )

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!

DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.

Comments On: Building A Quick-And-Dirty PHP/MySQL Publishing System

>>> Be the FIRST to comment on this article!