Build a CMS for Your E-Commerce Site, Part Three
In this series we've been working through the construction of a Content Management System, for use with an e-commerce Web site.
The foundation has been laid in the form of a PHP class for accessing the database ('dbConnector'), and to kick off this month we'll set up the database itself, and create the first working part of the system.
Creating the Database
The first table we're going to add to our database will store content chucks -- product information or other data -- for display on the Web site. The ability to share information is the most important function of an Web site, and the job of the Content Management System is to make doing this as easy as possible.
Consider your own data requirements, a few important ones spring to mind for most tables:
|ID||A unique number given to each item, and the primary key of the table.||Integer|
|Title||The title of the item||Varchar(300)|
|Tagline||A very short summary of the item||Varchar(600)|
|Section||The category to which the item belongs||Integer|
|TheArticle||The item itself||Text|
Before we can create the system itself, we need to create the database to store our information. The code below will set this up if you're using the MySQL database system - users of other systems should modify the commands appropriately.
Copy and paste the following into the MySQL admin tool, or use one of the many free 'client' programs available:
CREATE TABLE`databasename`.`cmsarticles` (
`ID` int(6) unsigned NOT NULL auto_increment COMMENT 'The unique ID of the item',
`title` varchar(200) NULL COMMENT 'The item title',
`tagline` varchar(255) NULL COMMENT 'Short summary of the item',
`section` int(4) NULL DEFAULT 0 COMMENT 'The section of the item',
`thearticle` text NULL COMMENT 'The item itself',
PRIMARY KEY (`ID`)
If all has gone according to plan, you should now have a working table in the database. We're now going to create a page to allow you or your staff to enter items into the system.
Creating the editor
First, design a form using the HTML editor of your choice. Create text fields for each database field (excluding ID). An example is below:
Set the action of the form to be newArticle.php (with the method 'post'), and save this page in a folder called cmsadmin (described in the previous portion of this series). If any of this is unclear, just browse through the attached file at the end of this article. Note that the 'section' field is currently a text box, by the time we've finished it'll be a drop-down list, allowing you to choose a section of the site in which to place the item. Next, we'll create the PHP code to deal with whatever is typed into this form, and save it to the database for later retrieval. The code is on the following page, with explanation beneath.
Continued on Page Two.
B2B and B2C Convergence: A Call to Action This Aberdeen report explores and examines the growing challenge that companies face in the convergence of B2B and B2C requirements, which...
Avoid Microsoft Lync Deployment Pitfalls with A10 Thunder ADC Organizations around the world depend on Microsoft Lync to connect, collaborate, and share information in real time. Microsoft Lync combines...
Criminals and Vulnerabilities: Understanding the Threats to Your Online Business Live Event Date: August 12, 2015 @ 2:00 p.m. ET / 11:00 a.m. PT The threats to website security can be divided into two main groups: those...
Gartner's 2015 IDaaS Magic Quadrant Gartner has named Okta as the only leader in its 2015 Identity & Access Management as a Service (IDaaS) Magic Quadrant. Access your...