Yaapi and PHP build a simple content management system_PHP tutorial

If you are a developer building a content-rich web site, you may want to consider the following solutions, which include (a) a database for the content, (b) a templating system that separates the GUI from the content, ( c) a user-friendly interface for maintaining data in the database, and (d) control over the final appearance of the generated pages.
A very interesting solution that offers all of the above is Yaapi, which stands for Your Article Application Programming Interface. It is a PHP class that provides built-in methods to access content stored in the database. The management module is equipped with classes that assist in managing data, and the API itself is powerful enough to handle most common tasks required by a content management system (CMS).
Installation To install and use Yaapi, you need a web server that supports PHP, such as Apache, and of course PHP, as well as a MySQL database server. You can download a copy of Yaapi and unzip it to a location in the root directory of the server.
You also need to create a MySQL database to accommodate Yaapi's data structure. Create this database using the yaapi.sql file in the source archive, then open the Yaapi configuration in the class constructor (article.class.php file) and update it with the name and access parameters used for the database.
Adding content To add content to the database, you must use the Yaapi admin module at http://your-server/yaapi-root/admin/ (replace "your-server" with the name of the server where Yaapi is installed " and replace "yaapi-root" with the directory after Yaapi is decompressed). You'll use this admin module to create (and delete) content categories, and then place articles into those categories. The following is a brief list of the fields you will encounter in this process:
Category: The category of the article Section ID: If your article has two levels, you need to use this parameter to Define the second level. Title: The title of the article Author: The author of the article Email: The email address of the author of the article Approved: A sign used to indicate whether the article has been "permitted" for display Image: An optional image URL related to the article Content: The content of the article A little note on the last item above: Yaapi can break up large sections of your article by inserting separators into the article text. Displayed in several small pages. See the example below: