Member You
#1 in Business Subscribe Email Print

You are here: Home > Internet and Businesses Online > Web Development > Using PHP and MySQL to Develop a Simple CMS - Version 2

Tags

  • result
  • incorporation
  • which
  • contents rather
  • editpagephp because
  • database contents

  • Links

  • How Many Affiliate Checks Do You Want To Receive?
  • 5 Easy Steps to Closing the Sale: Step V
  • Low APR Credit Card: Know How It Works!
  • Member You - Using PHP and MySQL to Develop a Simple CMS - Version 2

    Entrepreneurs Need to Know Themselves
    the second in a series taken from How to Evaluate and Profit from a Business OpportunityGoing into business for yourself is a big decision, one that requires careful thought and a great deal of planning. Whether you decide to buy a business, or start one from an i
    = 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
    Seven Tips for Developing a Solid Networking Strategy; From the Book - Cracking the Networking CODE
    Let's start with a quick reminder:Networking is NOT forcing yourself or your products on someone.Networking IS getting to know people, their lives, and their needs.Networking is NOT selling your products and services at every moment.Networking
    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"

      How To Work From Home And Achieve Success
      HOW TO WORK FROM HOME AND ACHIEVE SUCCESS Working from home to achieve success can be simple and is straightforward. Many people do not strive for success because they believe it is complicated but it is NOT complicated at all! People are simply unaware.
      ollowing 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

      Taking A Look At The Business Incorporation Benefits
      Any one who has seen the abbreviations "inc" or "llc" will realize that most businesses are incorporated. However, what most people are in the dark about is the reasons why so many businesses seek incorporation or why incorporation is so valuable. There are numerous reaso
      er 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

      Minor Sponsorships for Major Returns
      Sponsorship certainly conjures up an image of enormous market reach but at a mighty high price. Some of the biggest events in the world reach a market of many, many millions of people. But that's at a level where only major players are able to participate.If you ar
      . < 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
      A Practical Guide to Meta Tags - Name or HTTP-Equiv?
      META tags are a way for you to define your web page and web site to the outside world. You can declare the keywords and description, which help your placement in search engines. In addition, you can specify who owns the copyright, how often the page is to be visited by se
      = 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

    HTTP = HTML link (for blogs, profiles,phorums):
    <a href="http://www.memberyou.net/article/86444/memberyou-Using-PHP-and-MySQL-to-Develop-a-Simple-CMS--Version-2.html">Using PHP and MySQL to Develop a Simple CMS - Version 2</a>

    BB link (for phorums):
    [url=http://www.memberyou.net/article/86444/memberyou-Using-PHP-and-MySQL-to-Develop-a-Simple-CMS--Version-2.html]Using PHP and MySQL to Develop a Simple CMS - Version 2[/url]

    Related Articles:

    Your Customers Are Your Best Asset

    Back to the Basics of Affiliate Programs

    The Rise And Rise Of China MP3 Wholesale Distributors

    Bookmark it: del.icio.us digg.com reddit.com netvouz.com google.com yahoo.com technorati.com furl.net bloglines.com socialdust.com ma.gnolia.com newsvine.com slashdot.org simpy.com shadows.com blinklist.com