Handling Contents with MySQL for a Content Management System Built with Prototype

Introduction

If you're an AJAX enthusiast and read the preceding article of the series, then you'll recall that I defined all the JavaScript functions required to complete the behavioral layer of the application. In layman's terms, the functionality provided by this CMS is based upon its capacity for adding new publishable articles to the system, in addition to editing and deleting these articles with extreme ease.

As you can see, even when this content management application has been tuned to handle article-related data, it's fair to say that in can be quickly adapted to work with contents of a different nature, which illustrates the flexibility offered by the system.

Now, paying attention specifically to the development of this CMS application, it's necessary to complete the system by creating at least a basic server-side module. This module must be capable of processing all the commands sent by an user to connect to MySQL and insert, update or delete the contents of a specific article.

This time I'm going to use PHP 5 to perform the aforementioned tasks, but logically you can use the server-side scripting language of your choice to interact with the web server and eventually work with a different database system.

All right, having generally outlined the subject of this last installment of the series, let's learn together how to build the server-side component of this Prototype-based content management system. Let's get started now!