CMS Tutorial

[RazoRmedia]

okay, heres the first part

part 2 - The paragraphs section

The zip file attached contains the following files:

• createPara.htm - This is a simple form which lets the user input a paragraph title and the paragraph content.
• addParatoDB.php - This is immediately called after createPara.htm, it adds the information in the form to the database. As the paraId is autoincrement, this is never passed and instead is incremented in the DB when a new record is added.
• editPara.php - retrieves all the current paragraphs and displays them together on a page with the option of choosing one to edit. This simply displays a list of all the paragraph titles and a button for the user to edit or delete the respective paragraph. The 'edit' button points at changePara.php?id=xx where 'xx' is the id of the paragraph to be edited and the delete button points at deletePara.php?id=xx where 'xx' is the id of the paragraph to be deleted.
• changePara.php - this page returns the information held in the database and returns it in a form (just a couple of textboxes really. it lets you update a paragraph using a form similar to the createPara.htm page but with the chosen paragraph already in the form.
• updatePara.php - this updates the changed paragraph as amended by the user in changePara.php
• deletePara.php - this delete the chosen paragraph as chosen in editPara.php

The only thing missing here is the file with all the connection strings in to the database, this is needed to be added if youu wish these files to work.

Any questions, please feel free to post.