In this post I’ll attempt to explain how to build a extremely straightforward Material Management System (CMS). I’ve chosen PHP as the server-aspect scripting language and MySQL as the database management system purely due to the fact I feel they are fairly straightforward to use and they do the task very well.

I won’t devote any time describing CMSs, what they are, or why you really should or really should not use them as there are a lot of superb articles or blog posts around that describe them flawlessly effectively. I’ll just reveal one particular way of establishing a CMS.

This CMS is made up of a single web page (index.php) that can have its contents up to date by use of a kind (editPage.php). The contents entered through the kind are stored in a database, and are accessed and displayed by the net page. Though this CMS is as well straightforward to be of any true use, it could be utilised as the starting stage for a true existence CMS resolution.

There are four files in this undertaking:

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

cms.sql
This file results in a database named cms, and creates a table in that database known as page. It also loads some intial data into the table. You only want to use this file when.

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

updatePage.php
This is the type handler – the script that processes the information (entered in editPage.php) and inserts it into the database table (page).

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

cms.sql

one. Produce DATABASE cms
2. USE cms
3. Create table page (
four. pageID integer car_increment,
5. contents text,
six. main important (pageID)
7. )
eight. insert into page (pageID, contents) values (’1′, ‘dummy text’)

Line one produces a database named cms in the MySQL database management method.

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

Line 3 creates a table in the database.

Line four creates a column named pageID, which will incorporate integers, and which will be automatically incremented as new data are additional to the table. As we only have one particular world wide web page (index.php) in our imaginary website, we will only have 1 document and therefore a single integer: 1. If we extra additional pages to the table, they would be instantly numbered (2, 3, four, and so on).

Line 5 generates a 2nd column known as contents, which will include text. This is exactly where the editable contents displayed by index.php will be stored.

Line six sets pageID as the major crucial, which you can believe of as a reference for the table. As we only have 1 table, which will have only one document, we won’t make any use of the key. I’ve included it even though since it really is excellent practice to do so.

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

Line eight inserts some intial info into the table: 1 as the initial (and only) pageID, and ‘dummy text’ as the contents of the 1st report.

editPage.php

(Be aware that for display criteria, I’ve used square brackets ‘[' as an alternative of angle brackets for tag names.)

1. [html]
2. [head]
three. [title]Really Basic CMS[/title]
four. [/head]
5. [physique]
6. [h1]Truly Basic CMS[/h1]
seven. [?php
eight. mysql_connect("localhost", "root", "password")
9. $ outcome = @mysql_query("Pick contents from cms.page")
10. although ($ row = mysql_fetch_assoc($ consequence))
eleven. $ contents = $ row['contents'] // Do not alter these to angle brackets
twelve.
13. ?]
14. [kind title="form1" method="post" action="updatePage.php"]
15. Enter page subject material:[br][textarea rows="10" cols="60" title="contents"][?php echo "$ contents" ?][/textarea]
16. [input variety="submit" title="Submit" value="Update Page"]
17. [/type]
eighteen. [/system]
19. [/html]

Most of this file is fairly straightforward HTML that doesn’t want explaining. However, the following bits of code are possibly value discussing.

Lines 7 through to thirteen have PHP code to connect to the database and extract the contents of the world wide web page.

Line 15 contains a tiny bit of PHP code to exhibit the contents in the form’s textarea. This line demonstrates how straightforward it is to integrate bits of PHP code into lines of HTML code.

Don’t forget however 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 internet server.

updatePage.php

1. [?php
2. $ contents=$ _REQUEST['contents'] // Do not transform to angle brackets
three. mysql_connect(“localhost”, “root”, “password”)
four. $ outcome = @mysql_query(“UPDATE cms.page SET contents=’$ contents’”)
5. mysql_close()
six. ?]

This is the type handler, that is to say, the script that processes the information entered into the type (in editPage.php).

Line 1 signifies the start off of a PHP script.

Line two requests the contents that had been posted from the form. We could have created
$ contents=$ _Post['contents'] as an alternative if we had needed to.

Line 3 connects to the MySQL database server, setting up the host identify, which I’ve assumed to be localhost, the database person, which I’ve assumed to be root, and the password necessary to connect to the database. By natural means, I have no concept what this would be for your technique so I’ve just written the word password.

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

Line 5 closes the database connection.

Line six closes the PHP script.

index.php

one. [html]
two. [head]
three. [title]House Page[/title]
four. [system]
five. [h1]Residence Page[/h1]
6. [?php
7. mysql_connect("localhost", "root", "password")
8. $ consequence = mysql_query("select contents from cms.page")
9. even though ($ row = mysql_fetch_assoc($ consequence))
10. $ contents = $ row['contents'] // Do not change to angle brackets
eleven.
twelve. echo $ contents
13. ?]
14. [/physique]
15. [/html]

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

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

Putting in/Working the CMS

To use the CMS you need to copy the files onto your world wide web server into the region allotted for world wide web pages. Your world wide web server needs to support PHP and MySQL if it does not, the CMS won’t function.

You also will need to use the right database connection names and passwords (these utilised in the mysql_connect lines in the PHP scripts).

Just how you run the cms.sql file to set up the database and database table will fluctuate from internet server to net server so it’s difficult to give exact guidelines right here. If you have a phpMyAdmin icon or one thing equivalent in your web servers manage/administration panel you ought to be ready to use that.

The moment you’ve set up the database and table, you can merely browse to the editPage.php world wide web page and update the database contents. You can then browse to the index.php page to view the updates.

^ Jump to Top ^