Tags |
|
|
Links |
|
|
Casual Articles - Using PHP and MySQL to Develop a Simple CMS - Version 2
We had a problem with handling materials in a production department. Our process required raw materials to enter the department, be processed, and leave the department. The raw material was placed on pods, delivered for production, removed from the pods, placed on a stagi
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 .
The average American household and business is flooded with mail every day. In fact, recent studies have shown the average C-level executive receives 37 pieces of mail every day. This number can be startling, especially for those who deal with B-to-B audiences.Adva
- 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 .
As a general contractor, you have a big job. You’ve worked hard to achieve the success that you have, so of course you want to make sure you do the job in the best way possible. With resources that cater to your responsibilities, this site can help guide you through the p
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 .
We’ve all heard the saying: If you fail to plan, you plan to fail. But I like to think of it another way. Ask yourself, “am I planning to succeed?”In business, it’s important to follow a plan. It’s important to have a plan for your year, each week, and each day. Ot
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 .
There are a lot of theories and principles that one can follow to be edgy in any business. But putting all these principles into action will only get you half way towards attaining a successful business.What is essential is that you give your heart and dedication
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 .
Would a pressure washing business work in the nation state island of Bermuda? Well one gentleman thinks so and has developed what he believes is a perfect marketing plan to do so. What kinds of things are there to wash in Bermuda? Well the economic development association
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.casualarticles.com/article/86444/casualarticles-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.casualarticles.com/article/86444/casualarticles-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:
Advertising Using Pay-Per-Click
Effective Ways To Drive Laser Targeted Traffic To Your Website: Part 1
Bookmark it:
|