Remember Me
forgot your password?

Using Php and Mysql to Develop a Cms

In this article I'll try to describe how to develop a very simple Content Management System (CMS). I've chosen PHP as the server-side scripting language and MySQL as the database management system purely because I think they are fairly easy to use and they do the job very well.

I won't spend any time describing CMSs, what they are, or why you should or should not use them as there are plenty of excellent articles around that describe them perfectly well. I'll just explain one way of developing a CMS.

This CMS consists of a single web page (index.php) that can have its contents updated by use of a form (editPage.php). The contents entered via the form are stored in a database, and are accessed and displayed by the web page. Although this CMS is too simple to be of any real use, it could be used as the starting point for a real life CMS solution.

There are four files in this project:

cms.sql
editPage.php
updatePage.php
index.php

cms.sql
This file creates a database called cms, and creates a table in that database called page. It also loads some intial data into the table. You only need to use this file once.

editPage.php
This web page contains a simple form that can be used to enter (and edit) the contents displayed by index.php.

updatePage.php
This is the form handler - the script that processes the data (entered in editPage.php) and inserts it into the database table (page).

index.php
This is the web page that displays the data held in the database table.

cms.sql

1. CREATE DATABASE cms;
2. USE cms;
3. CREATE table page (
4. pageID integer auto_increment,
5. contents text,
6. primary key (pageID)
7. );
8. insert into page (pageID, contents) values ('1', 'dummy text');

Line 1 creates a database called cms in the MySQL database management system.

Line 2 tells MySQL to use the database for the subsequent commands.

Line 3 creates a table in the database.

Line 4 creates a column called pageID, which will contain integers, and which will be automatically incremented as new records are added to the table. As we only have one web page (index.php) in our imaginary website, we will only have one record and therefore one integer: 1. If we added additional pages to the table, they would be automatically numbered (2, 3, 4, etc).

Line 5 creates a second column called contents, which will contain text. This is where the editable contents displayed by index.php will be stored.

Line 6 sets pageID as the primary key, which you can think of as a reference for the table. As we only have one table, which will contain only one record, we won't make any use of the key. I've included it though because it's good practice to do so.

Line 7 simply closes the bit of code that was started in line 3.

Line 8 inserts some intial data into the table: 1 as the first (and only) pageID, and 'dummy text' as the contents of the first record.

editPage.php

(Note that for display considerations, I've used square brackets '[' instead of angle brackets for tag names.)

1. [html]
2. [head]
3. [title]Really Simple CMS[/title]
4. [/head]
5. [body]
6. [h1]Really Simple CMS[/h1]
7. [?php
8. mysql_connect("localhost", "root", "password");
9. $result = @mysql_query("SELECT contents from cms.page");
10. while ($row = mysql_fetch_assoc($result)){
11. $contents = $row['contents']; // Do not change these to angle brackets
12. }
13. ?]
14. [form name="form1" method="post" action="updatePage.php"]
15. Enter page content:[br][textarea rows="10" cols="60" name="contents"][?php echo "$contents" ?][/textarea]
16. [input type="submit" name="Submit" value="Update Page"]
17. [/form]
18. [/body]
19. [/html]

Most of this file is fairly simple HTML that doesn't need explaining. However, the following bits of code are probably worth discussing.

Lines 7 through to 13 contain PHP code to connect to the database and extract the contents of the web page.

Line 15 contains a tiny bit of PHP code to display the contents in the form's textarea. This line shows how easy it is to integrate bits of PHP code into lines of HTML code.

Remember though that in order to use PHP code in an HTML page, the file has to have an extension of .php. If it does not, the PHP code will not be processed by the web server.

updatePage.php

1. [?php
2. $contents=$_REQUEST['contents']; // Do not change to angle brackets
3. mysql_connect("localhost", "root", "password");
4. $result = @mysql_query("UPDATE cms.page SET contents='$contents'");
5. mysql_close();
6. ?]

This is the form handler, that's to say, the script that processes the data entered into the form (in editPage.php).

Line 1 signifies the start of a PHP script.

Line 2 requests the contents that were posted from the form. We could have written
$contents=$_POST['contents']; instead if we had wanted to.

Line 3 connects to the MySQL database server, setting up the host name, which I've assumed to be localhost, the database user, which I've assumed to be root, and the password needed to connect to the database. Naturally, I have no idea what this would be for your system so I've just written the word password.

Line 4 updates the page table in the cms database with the new contents.

Line 5 closes the database connection.

Line 6 closes the PHP script.

index.php

1. [html]
2. [head]
3. [title]Home Page[/title]
4. [body]
5. [h1]Home Page[/h1]
6. [?php
7. mysql_connect("localhost", "root", "password");
8. $result = mysql_query("select contents from cms.page");
9. while ($row = mysql_fetch_assoc($result)){
10. $contents = $row['contents']; // Do not change to angle brackets
11. }
12. echo $contents;
13. ?]
14. [/body]
15. [/html]

This is the web page that displays the contents from the database.

Most of the lines in this web page are pretty straight forward and don't need explaining. Lines 6 to 13 contain the PHP script that extracts the contents from the database and displays (echos) it in the browser.

Installing/Running the CMS

To use the CMS you need to copy the files onto your web server into the area allocated for web pages. Your web server needs to support PHP and MySQL; if it doesn't, the CMS won't work.

You also need to use the correct database connection names and passwords (those used in the mysql_connect lines in the PHP scripts).

Exactly how you run the cms.sql file to set up the database and database table will vary from web server to web server so it's difficult to give precise instructions here. If you have a phpMyAdmin icon or something similar in your web servers control/administration panel you should be able to use that.

Once you've set up the database and table, you can simply browse to the editPage.php web page and update the database contents. You can then browse to the index.php page to view the updates.

John Dixon

John Dixon is a web developer working through his own company John Dixon Technology. As well as providing web development services, John's company also provides free open source accounting software written in PHP and MySQL.

Rate this Article: 2.7 / 5 stars - 3 vote(s)
Print Email Re-Publish

Add new Comment



Captcha

  • Latest Web Design Articles
  • More from John Dixon

5 Most Noteworthy Rules in Designing Website

By: Irfan Ardiansah | 29/11/2009
When it relates to website, spare attention had better be paid to every little detail to make certain it performs optimally to serve its intention. Here are five most noteworthy rules discovered to make certain that your website performs well.

Disadvantages of Choosing Pre Built Templates

By: Alejandro Anillo | 28/11/2009
This article focuses on disadvantages of pre built templates available on the internet.

Getting Your Website Re-Designed

By: Mark Walters | 28/11/2009
Useful information and advice on re-designing your website. Learn why it is important to have a fresh and up to date website and how to start the re-design process.

texas-web-design

By: Derick Hartmanom | 28/11/2009
McAllen Web Design extends custom-built web design and development for your business organization by providing an streamlined website that does more than just have bits of information and a a couple of pages here and there. There requires to be research done, as with any professional service you are participating in - such as writing a research paper. A great website will stresses on the order, visual aspect and code just as much as the special message itself. Your web site should ...

Design of website with respect to search engine optimization

By: Stella | 28/11/2009
Here are some essential web design tips that every web site should follow. Listed below are some useful and rather important tips for designing a professional and high quality web site:

Corporate identity and Corporate Logos: The need for constant innovation

By: John Tweak | 28/11/2009
Corporate identity is an essential element of the successful operation of a business. It is all about creating a positive impression of the company in the minds of the population, so that business becomes sustainable and yields better results. Corporate identity sends a strong message about the principles and purpose of the company to the target audience, so that the target audience reacts optimistically in line with its requirements and needs.

Finding Help for Homestead Website Beginner

By: Homestead User | 28/11/2009
So you've built your website, published your pages onto the Internet and now your going to have thousands of visitors coming your way, right? That's not the way it works because there are things that keep your Homestead website from being a success.

Starter Websites: Affordable Web Solutions for Small Business

By: Amalendu Hajraa | 28/11/2009
The article informs readers about starter website and what they should keep in mind concerning starter websites. In this connection the article also speaks about starter website packages by offshore development centers in India.

Using Php to Populate a Drop Down List Box From a Mysql Database Table

By: John Dixon | 05/09/2008 | Web Design
Drop down list boxes provide a great way to enable visitors to your web site to select an item on a form. Normally, you hard code the items on the drop down list box - but what about if you want to get the items from a database table.

Finding Hidden Characters in a File

By: John Dixon | 27/06/2008 | Programming
It is sometimes necessary to find hidden characters within one or more files.

Web Site Promotion Tips

By: John Dixon | 20/06/2008 | SEO
When trying to get to the top of the search engine rankings there are certain things you should do, and other things you should not, in order to increase your chances of getting a top ten placement.

Exploiting Google Adsense

By: John Dixon | 08/04/2008 | Internet Marketing
Google Adsense provides a great way to generate revenue from a web site.

Using Perl and Regular Expressions to Process Html Files - Part 2

By: John Dixon | 17/03/2008 | Programming
In Part 1 we looked at what Perl and regular expressions are, and discussed how to use them to process ASCII files such as HTML files. In this part we'll develop a Perl script to process an HTML file.

Using Perl and Regular Expressions to Process Html Files - Part 1

By: John Dixon | 17/03/2008 | Programming
Like many web content authors, over the past few years I've had many occasions when I've needed to clean up a bunch of HTML files that have been generated by a word processor or publishing package. Initially, I used to clean up the files manually, opening each one in turn, and making the same set of updates to each one. This works fine when you only have a few files to fix, but when you have hundreds or even thousands to do, you can very quickly be looking at weeks or even months of work.

Size Really Does Matter

By: John Dixon | 14/03/2008 | SEO
I believe that by following three basic rules, it is relatively easy to achieve a high ranking with the major search engines: 1. Add lots of relevant content; 2. Build up plenty of good quality inbound links; 3. Be patient.

Submit Your Articles Free: Signup
Article Categories




Use of this web site constitutes acceptance of the Terms Of Use and Privacy Policy | User published content is licensed under a Creative Commons License.
Copyright © 2005-2008 Free Articles by ArticlesBase.com, All rights reserved. (0.06, 1, w1)