How do you keep visitors returning to your website? By updating content regularly. Maintaining this gets out of hand unless you have a content management system. Harish Kamath explains how to put a barebones CMS together using three APIs. To see the VIDEO TUTORIAL click HERE.
Free companion video tutorial for this article! Click Here!
Before I get started, here is a check list of the prerequisites required for the successful installation and implementation of the packages that I intend to use for my development:
a web server, preferably Apache
PHP, installed and configured on the server
a MySQL database
Fortunately, most Linux-based hosting packages bundle the above software as a part of their standard hosting plan. But, if you have a dedicated box that you manage on your own, you can always download (and install) them from the following websites:
The next step is to download a copy of yaapi. Point your browser to the following URL: http://xhawk.net/projects/yaapi/. Next, I uncompress the archive file, i.e. yaapi-1.2.1.tar.gz, to a convenient location under my web server root as shown below.
$ tar -xzvf yaapi-1.2.1.tar.gz
$ mv yaapi-1.2.1 yappi
Next, I proceed to create a MySQL database that will be used by yaapi. Start up the MySQL client and fire the following commands, one by one. Create a new database using the following SQL command (I've called mine "bb_cms").
mysql> CREATE DATABASE bb_cms;
Next, I create a MySQL user with the appropriate rights on the database that Iíve created above.
mysql> GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , DROP , INDEX , ALTER ON `bb_cms`.* TO " bb_cms_user "@"localhost" IDENTIFIED BY "password_comes_here"; Query OK, 0 rows affected (0.03 sec)
After the database and MySQL user have been created, it is time to set up the required database tables. And fortunately, the yaapi distribution contains a SQL file -- titled "yaapi.sql" -- with the required SQL instructions. Execute the following command:
$ mysql -D yaapi -u bb_cmsuser -p < /usr/local/apache/htdocs/yaapi/yaapi.sql