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.

TABLE OF CONTENTS:

By: icarus, (c) Melonfire

Poor Best

Rating:

/ 44

March 12, 2002

print this article

SEARCH DEV SHED

TOOLS YOU CAN USE

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!