RSS Underground Dynamic Content Article
PHP & Dynamic Content
Static content is a plain html file that doesn't change for any user or request. The same content is displayed to everyone, regardless of anything else including variables, sessions and cookies. Dynamic content, on the other hand, is specifically displayed based on a web browser's request. It can change the whole way information is displayed, from listing only 5 articles on a page instead of 10, or listing them alphabetically or by article ID (incremented upon insertion to a database) or by the date last modified. This control makes dynamic web pages very attractive to web designers.
| RSSUnderground Editor's Tip! Hey
you want to have a free
hosted web site that you can use for anything you want?
The only catch is that these guys show an Adsense ad at the
top of the page - but so what! You can still use it to promote
your business or other web sites! I do not make any money
from telling you this - just the satsisfaction of knowing
I am helping my fellow webmasters and marketers find quality
free web hosting! Check it out! It's worth it - it's free!
If your site has information about a product or service, or just anything that isn't likely to change, static pages are great. However, if the content changes frequently, adding a PHP backend to your site to control the content may be the way to go. You might also look into Content Management Systems.
Related: Xml Sitemap File - Google Sitemap Generator
RSS Underground Featured Article Author Box
Professional web site developer at simplyPHP.com
Creating Dynamic Website Content with PHP - MySQL
Fresh web site content for your visitors can be of real benefit when attempting to generate repeat traffic. Most webmasters, however, just don't have enough spare time to frequently update or rebuild their pages manually. If your web site hosting company provides free access to PHP and MySQL, this article will show you how to combine those two open source tools and replace a portion of your web sites' static content with frequently changing dynamic content.
Why do you need dynamic content for your web site?
Static pages on a web site eventually become "stale" and visitor traffic can fall significantly over time. The drop in traffic can be attributed to these primary factors:
1) The reluctance of search engines to include and display your potentially "out of date" pages in their search results,
2) The finite number of other subject related web sites that would be willing to link to your information on a specific topic, and
3) Visitors that learn to view your static web site with a "been there, done that" attitude.
Creating and maintaining a web site requires a significant investment in time and resources. Loosing repeat visitors diminishes the value of your investment. Without repeat traffic it is virtually impossible for a web site to be a continuing success.
How can you add dynamic content without having to purchase expensive software?
One proven (and easy to implement) method of creating dynamic content for your web site is by rotating information on key, higher traffic web pages using PHP with a MySQL database. Rotating content can take the form of a series of rotating articles, a rotating group of product listings, or even a simple "thought for the day". What is important is that your clients and visiting search engines find new and interesting information each time they visit your web site.
As an example of dynamic content creation, we will build a system that rotates information about a group of products on the main page of a hypothetical retail sales web site that markets widgets. Our goal is to present information about a different type or model of widget available for purchase whenever a consumer visits the shopping web site.
Step One: Create a content table to hold your widget data.
There are a couple of options for storing the data to be displayed in your dynamic content rotation. The first option would be to create a new database, or perhaps simply add a table in an existing product database that will hold the information that you wish to display.
Let's take five theoretical widget products and design a table as follows:
+------+-----------------------+ | item | product | +------+-----------------------+ | 1 | Plastic Widgets | | 2 | Metal Widgets | | 3 | Wooden Widgets | | 4 | Rubber Widgets | | 5 | Stone Widgets | +------+-----------------------+
1-a) Create your table with the following SQL statement:
CREATE TABLE `content_table` ( `item` int(4) NOT NULL auto_increment, `product` varchar(10) NOT NULL default '', KEY `item` (`item`) ) TYPE=MyISAM AUTO_INCREMENT=6 ;
This table contains two fields. The first is an item number and the second is a description field that will hold the product name and features. Note: You can add fields to your actual table including: an image URL field, shopping cart direct purchase URL field, product page filed, etc.
1-b) Insert the example data into your new table as follows:
INSERT INTO `content_table ` VALUES (1, ' Plastic Widgets'); INSERT INTO `content_table ` VALUES (2, ' Metal Widgets'); INSERT INTO `content_table ` VALUES (3, ' Wooden Widgets'); INSERT INTO `content_table ` VALUES (4, ' Rubber Widgets'); INSERT INTO `content_table ` VALUES (5, ' Stone Widgets');
Once you have completed these two steps you will have a table compete with data to be shown on your web site.
Another option would be to utilize your existing product table. If there are hundreds of different models and styles of widgets already in one of the tables in your database, you could utilize the same structure we are learning now to connect directly to that table and display the already existing data.
Step two: Working with your new table:
For this tutorial, we will utilize one of the most effective mechanisms and perhaps the easiest to incorporate. This is the use of a random number generator for deciding which item will be shown.
To create a random number generator using PHP you must first calculate the total number of possible items that you want the system to choose from. In this example we had five items so the maximum number of choices will be 5. The reason we need this number is to limit the random numbers being delivered. If we have five items, we want the number generator to only give us a result of between 1 and 5.
We must now create a variable for our PHP code that will hold our new randomly generated item number as follows:
$mynumber = rand(1, 5);
This little snippet of code will act as the mechanism to "select" a widget product item at random from the five provided in the content table that we created.
If we created 100 different items for your dynamic display instead of just five, you would simply change the "rand (1, 5)" part of the code to reflect the different maximum number. In this case we would change it to "rand (1, 100)" so that the random number generator gives us back a number somewhere between one and one hundred.
We are now ready to extract the randomly selected item's information from your table so that it can be displayed on your webpage.
You can now connect to your database and query your table to find the data for the item that matches the random number you created, as follows:
$query_content = "SELECT * FROM content_table WHERE item = $mynumber ";
Step three: Displaying your data:
When displaying your data it is important to maintain consistency in presentation size. It is preferable to create a table of specified dimensions (such as "width=400") and display your results within this table. In this way the page proportions do not have to change with each new item (which can be very confusing for visitors).
Simply display the results just as if these where any other MySQL query using the echo command:
Every time your page is loaded a different widget product will be selected at random for display on that page.
What else can you do with your dynamic content?
The only limits are within your imagination. By adding a title and meta description tags to your content table, you can alternate the title and search engine description for that page. You can also utilize this system to promote affiliate programs or sponsorship opportunities by rotating affiliate links and banners.
The proper use of dynamic content can bring your web site back into favor with search engines and encourage your visitors to return frequently to see what is new.
Don Beavers lives in Bryan, Texas and is an enterprise level PHP-MySQL programmer at the Datavor Web Directory
and at the Shopping Elf directory Shopping Guide
The Advantages of Dynamic Website Content
Think about your own surfing behavior. What types of web sites do you visit the most often; which ones keep drawing you back?
If you are like most internet surfers, you will spend much of your time hanging around web sites with dynamic web site content, or content that is updated constantly or personalized to your preferences. The age of static, archival web sites is long gone, in in its place is a dynamic and powerful internet driven by PHP, ASP, CGI, and Java.
But setting up a web site with full SQL support and advanced features is not an easy task, especially for someone who is still waist deep in HTML coding.
So...what to do?
If you don't have the time or the will to commit to an advanced web site with cutting-edge features and complicated scripts, there are still a good number of options that will make your web site look more professional, with minimal effort.
An excellent resource is Hotscripts - you can find a huge number of complete server side scripts there, many of them free. Another great resource is this Random Text Generator, which is a powerful PHP script to generate random content on your web site. Show a new quote every day!
In the end, the choice to go all-out is up to you, but with the help of a few handy scripts and some rudimentary server-side know-how, you can turn a static page into an impressive multi-faceted datacenter overnight!
David Saharkhiz is a computer science major and National Merit Semifinalist at America's Clemson University. He provides comprehensive web-help and HTML coding tutorials, codes free HTML scripts, and works to help novice webmasters set up new web sites.
Dynamic Website Content
Powerful, Affordable, Effective
This is powerful changing content for your Website, providing entertaining and useful information to everyone who visits your Website or Websites. In addition to added interest and repeat traffic for your Website or Websites, your Power Pointers Page is a powerful prospect-generating tool that's affordable and effective, providing your customers and prospects a valuable service they will thank you for, creating good will, generating increased traffic to your site, doubling or tripling repeat visits...and generating MORE SALES FOR YOU!
BBS Press Service, Inc. is here for our customers and we stand behind our service. We have over 18 years of experience in online publishing -- a feat only accomplished by providing the best service around. We are providing you the dynamic content you need to set your Website apart and increase your new and returning Website traffic. In addition, this service is a proven prospect-generator, allowing you to increase your online revenue by signing up subscribers to the service. We charge a very reasonable annual subscription fee for the service and we pass along a very generous $100.00 commission directly to you for every sale. Then you continue to earn a $100 commission whenever your customers renew their Power Pointers subscriptions. It's a win/win combination like nothing you've ever seen before!
Click Here: http://www.powerpointerspage.com/135220 You don't want to skip this!!!
Independent Represenative Eric D. McClenon email@example.com (206)679-0648
please visit the Internet Marketing web sites:
Free RSS to HTML PHP Script
Recently Added Internet Related Articles:
News Feeds - Looking at News Feeds, you might think they’re some of the most complex things to set up. Nothing could be further from the truth. They’re actually super-easy to create once you have the system set up properly. You can break down the news feed system into a fast, low-cost system that you can do once, or several times over.
Content Sites - Choosing the right Search Engine Optimization (SEO) content writer can be a challenging task, because there are so many different styles and writers from which you can select. However, you don't want to just select any SEO content writer, because you need to make sure that the job is done right.
Web Content Provider - When it comes to finding a high quality web content provider, the task can be frustrating to say the least. Not only do you have to work your way through masses of cheap web content to find what you're looking for, but you will probably end up learning some lessons along the way when it comes to paying less than $5 an article.
Content Copywriting - Since the beginning, you've been told that "Content Is King" but there are so many web site owners - who have been trying to win the search engine battles - ignore the rules and try to be 'smart'.
Blogging Web Site - Choosing which blogging platform to use is one of the most important decisions that you can make as a blogger. The right platform can make blogging a breeze, and the wrong platform can make blogging a chore. Because the program that you use to blog with is such a powerful part of your blogging experience, it is well worth putting in the time to find a platform that provides your ideal balance between a user-friendly interface and a flexible framework that allows you to make your blog look and feel unique.
Estate Blogging - A weblog is really like an online journal. You can write as much or as little as you want, about any topic that strikes your fancy. It's a great way to talk about new listings, open houses, and any special events coming up. Getting a weblog up and running is simple. Check out the various blogging services, such as blogger.com or typepad.com, and decide which one best meets your needs.
Creating Quality Content - In the western side of the world and in developed countries, many business establishments have not only their physical building present in the business area but also their online stores. Everyone who has access to the internet can buy almost everything that he needs. Clothes, gifts items, book, CDs, VCD, DVDs, and even the food that he wants to eat, he can buy it on the internet.
Feeds Blogging - A weblog on the same domain name, (as part of your web site like yourdomainname.com/blog) can help you add fresh content to your web site without having to know html. Fresh daily or even weekly content can keep the search spiders coming back more often. Writing your weblog posts on the topics or search terms you want to be relevant for helps as well. Each weblog post becomes another webpage targeted for your keywords.
Blogging Tips - The more you understand about any subject, the more interesting it becomes. As you read this article you'll find that the subject of Blogging is certainly no exception. If you run a small company, you may find that the world of blogging for business owners is a world that you want to be a part of. Blogging is a great way to get the word out to consumers about your product or service, and it can even be useful for inspiring employee loyalty and helping you keep your workers at peak morale.