Building a Content Management System (CMS) with the PHP scripting language and the MySQL structured query language is one of the major steps required to build your own social network. Besides being the basic building block of a social network, it also is a central piece of many business software applications like e-commerce systems. Building a CMS quickly with PHP and MSL requires that you use several PHP and MySQL modules. These modules, which can be obtained prebuilt or built from scratch, can be tied together to deliver custom tailored, high performance PHP MySQL-based CMS systems.
- Skill level:
- Moderately Challenging
Create a mockup (a non-working visual implementation) of the PHP MySQL system you will implement, using a word processing program, business presentation office automation program or a website creation program. Use a program that will allow you to create links or bookmarks to other pages in the document so that you will be able to navigate in the document as you would the actual Web pages in a CMS system.
Create one mockup page for each Web page that will be a part of the CMS system. Create one mockup page for the landing page, which includes text field boxes that the user will use to log into the system. Include on this page a text field for the username and the user password. Also include a link on the page that, when clicked, will direct the user to another page that lets the user create an account. On that page include text boxes with labels that will be needed to create an account.
Create another mockup page, the user menu page, that will appear after the user logs in and presses the submit button on the landing page. Include in the menu page a list of all the other application pages that the user can access. Include in the menu the links to personal pages that only the specific user can access and CMS community pages that everybody in the CMS community can access.
Create the personal pages so that they let the user store and access specific types of personal information. Include three different personal pages: a page that will let the user add personal information, one to retrieve personal information and another to change or update personal information.
Create the community pages to allow all users to store and access information that everybody in the community can access. Include three different pages: a page that will let the user add information to the community database, a search-and-retrieve information database and a page to change or update information that the user has posted to the community database.
Making a CMS Mockup
Create the MySQL personal database to store the personal information submitted in the forms. Include in the personal database, a database table that includes a field to store the password needed to access the user's personal database. Include another personal database table that includes fields for the user profile, such as name and e-mail address, and personal database tables for each specific personal application such as address books, calenders or photo albums.
Create the MySQL community database to store the community information submitted by community members in the forms. Include in the community database, a database table for each application that can be accessed. Create separate database tables for blogs about different subjects that require different fields. Define the fields in the tables to match the form text boxes that you have created.
Create the PHP code so it automatically will access the personal and community MySQL databases and display the correct HTML page forms. Structure the PHP and HTML code modules so that one file will display the add records form and add records to the MySQL database, another file will display the search records form and search records in the MySQL database and another file (module) will display the update records form and update the records in the MySQL databases. Use different modules for the personal and community forms and databases. Add new PHP/HTML code modules for new functions, such as a delete records form, as required by your CMS system specifications.
HTML, PHP and MySQL Modules
Tips and warnings
- A CMS MySQL PHP system requires considerable planning. Not only must the general structure of the Web pages and forms be decided, but also the number of MySQL databases, tables and fields for each table.
- The performance of your CMS MySQL PHP system will be determined by the structure of your tables and the code to implement them.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for