Web Hosting Forum - A Web Hosting community for Webmasters


Divi WordPress Theme

Author Topic: Using PHP and MySQL to Develop a Simple CMS - Version 2  (Read 2470 times)

0 Members and 1 Guest are viewing this topic.

Offline Tech

  • Junior Guru
  • **
  • Posts: 183
  • iTrader: +2/-0
    • View Profile
Using PHP and MySQL to Develop a Simple CMS - Version 2
« on: August 31, 2007, 01:51:40 AM »
In version 1 of our simple CMS we introduced the following four files:

    * cms.sql
    * updatePage.htm
    * updatePage.php, and
    * index.php

      Together, these files formed a very simple CMS, which you can download from the following address:

      http://www.computernostalgia.net/downloads/cms_v1.zip

      In this article we'll extend the CMS slightly so that the database contents are extracted and presented in the form (UpdatePage.htm). This will make it easier to edit the contents, rather than simply overwriting them.

      In order to make this modification, updatePage.htm needs to become a PHP file. I've called it editPage.php because updatePage.php already exists.

      Here is the contents of editPage.php:

      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'];
      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 containt 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.

All of the files for version 2 of the CMS are available at:

http://www.computernostalgia.net/downloads/cms_v2.zip

Article Source: http://EzineArticles.com/?expert=John_Dixon
« Last Edit: January 01, 1970, 05:30:00 AM by Tech »

Divi WordPress Theme
Tags:
 

Related Topics

  Subject / Started by Replies Last post
0 Replies
2546 Views
Last post August 30, 2007, 02:04:54 AM
by Tech
1 Replies
9636 Views
Last post August 11, 2010, 09:06:51 AM
by evalauren
0 Replies
983 Views
Last post March 09, 2011, 01:53:05 PM
by ludmela5
3 Replies
938 Views
Last post November 13, 2017, 10:21:03 PM
by neckozenica
0 Replies
2851 Views
Last post July 25, 2015, 02:08:35 AM
by SethPenman