Creating Dynamic Website Content with PHP - MySQL


Fresh website 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 websites' static content with frequently changing dynamic content.

Why do you need dynamic content for your website?

Static pages on a website 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 websites that would be willing to link to your information on a specific topic, and

3) Visitors that learn to view your static website 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 website 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 website 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 website.

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 field, 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 website.

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 dynamic content displays to function there must be a mechanism in place that instructs your web page as to which item should be shown to the visitor. These mechanisms vary in complexity from extremely simple commands to the more complicated use of cookies or IP tracking to determine which item should be displayed.

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:

echo $query_content [' product '];

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 website back into favor with search engines and encourage your visitors to return frequently to see what is new.

Don Beavers lives in Bryan/College Station, Texas and is an enterprise level PHP-MySQL programmer at both the Shopping Elf Shopping Guide, and the Datavor Web Directory.


MORE RESOURCES:
RELATED ARTICLES
What Your Customers Say About YOUR Site! Part 1
The following is a list of patterns that many visitors follow, and you can use these suggestions to better your site.1.
Launch Your Own Website Today - Its Easier Than You Think!
Thousands of people are now making a living online and the opportunities are abundant as the Internet continues its growth. An added benefit of running an Internet business is that you can usually start one part-time while you maintain your job and steady income.
Easy Steps To Website Development and Promotion
One of the most important parts of establishing a new website is website development and promotion. For people to visit your new site, you have to attract them.
Ten Major Tips to Develop a Multilingual Web Site to Work
If you are living in a country that its native language is something rather than English language, then you may like to develop your website to offer content in the language of your own country.There are millions of websites on the Internet that are all in English language but there are billions of people on the earth that speak in a different language and are not familiar with English language.
Study Your Sites Performance Via Hit Tracking
Knowledge is power.And undoubtedly, it is the key to making a substantial fortune online.
A Web Site for Your Small Business: How to Set Up a Website
Your web site will be your window to the world. Even if you are not selling any product online still you need your customers to access you 24 hours a day 365 days in a year and you can pass important information to them by hosting frequently asked pages, product descriptions, product improvements etc.
Art, Artists, and the Web:Part: 2--First Steps in Building an Artist's Website
What you should do and know if you are an artist and you have decided to have a website.1) Look at "Web Sites That Suck.
Why Local Service Companies Should Have a Website
The Internet is being used by local service business to improve sales today. Sales are improved because a website gives a company more credibility and in some cases generates leads.
3 Essential Tools Every Website Designer and Marketer Needs
Appealing to others is really important when you have a web page. This is because you will not have any personal contact with visitors and cannot persuade them to buy from you or come into your store, not personally that is.
Maximizing ROI via Web Site Traffic Analysis
We are clearly well past the innocent "golden age" of the Internet - Darwinian economics have become the order of the day today. Any company worth their salt must maintain a web site as an information resource and/or to generate incremental ecommerce revenue.
The Power Of CPanel
cPanel is a control panel for your website and allows you to set up and manage your web account through a graphical interface instead of having to use command line. This means that you can make changes to your website without having to learn to use a command line environment.
You Dont Know Which One
I still remember it very clear ..
My Yahoo Search - Beyond Bookmarks
Yahoo has long offered email, an online calendar, notes, bookmarks, and more through their free My Yahoo service. Now Yahoo has expanded this service even more by adding My Yahoo Personal Search to the mix.
Five Essential Questions to Answer Before Creating Your First (or second...or third) Website
Right after the thought, "I need a website," people usually say, "I need a web designer!" Actually, before even whispering "web design," you need to answer these five questions in as much detail as possible. Once you're clear on your strategy, you can provide better information to your web designer.
Develop a Solid Website Presence
Starting an internet business can be confusing to non-veterans. The internet is the new world of business and research.
7 Profit Producing Reasons Why Every Successful Service Professional Needs A Web Presence
Your business website is a critical aspect of being able to start and continue conversations with potential clients. It's the ultimate self-service window for potential and current clients who come to you interested in your services and/or products.
Frequent Business Question: How Do You Start a Web Business?
Today it seems everyone is jumping on the entrepreneur bandwagon, and who could blame them? Setting your own schedule, working from the comfort of your own home, and never having to deal with a horrible commute or office politics again, this option is quite popular among all ages. With the advent of the technology age, it seems more individuals are looking to the internet to provide them with goods or services.
High Quality Website at Low Cost
Although designing a great web site is an important part of developing a successful online business, it is often becomes a problem for newcomers to the internet business.The vulgar problem is the lack of money.
Web Design for the Professional Magician Part I - Selecting the Perfect Domain Name
Selecting the Perfect Domain NameThe first issue I have with magician web sites is the improper use of domain names. Examine the following list of URLs and select the most professional one: www.
Unlocking the Power of Your Website!
Why do some web sites reap huge benefits while others just get lost in the shuffle? Do some web masters have a secret that most of us have overlooked? Actually, there is a secret to unlocking the power of your web site and it has to do with words. When communicating via the web, words truly make all the difference.