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.

---

Top Stories - Google News Updated : Sat, 04 Jul 2009 02:56:03 GMT UN secretary-general defends his approach to the job - Los Angeles Times Voice of America UN secretary-general defends his approach to the job Los Angeles Times United Nations Secretary-General Ban Ki-moon rejects the notions that the world body has been shunted aside on security matters and that his moral voice has been lacking. By Bruce Wallace Reporting from The United Nations -- UN Secretary-General Ban ... UN chief gambles on Burma breakthroughBBC News UN Chief Asks Burmese Junta for Meeting with Aung San Suu KyiVoice of America UN chief faces steep challenge in BurmaChristian Science Monitor Aljazeera.net -CNN International -Reuters all 1,005 news articles » Publ.Date : Sat, 04 Jul 2009 01:59:09 GMT Iran Cleric Says British Embassy Staff to Stand Trial - New York Times Times Online Iran Cleric Says British Embassy Staff to Stand Trial New York Times Worshipers at Friday Prayer in Tehran. Ayatollah Ahmad Jannati said that embassy employees would be tried for their role in inciting protests after the election. By JOHN F. BURNS and STEPHEN CASTLE LONDON — A high-ranking Iranian cleric said Friday ... Hardline sermons in Iran stiffen EU resolveTimes Online Miliband defends Iran embassy staffThe Press Association Iranian cleric: British Embassy staff to be triedThe Associated Press Los Angeles Times -Christian Science Monitor -AFP all 6,984 news articles » Publ.Date : Sat, 04 Jul 2009 01:43:30 GMT Sanford heads for Florida for tense reunion with wife - New York Daily News ABC News Sanford heads for Florida for tense reunion with wife New York Daily News Love-sick Gov. Mark Sanford ditched his security detail before jetting to an Argentine rendezvous with his mistress last month. But he took the guards with him Friday for a Florida groveling session with his wife and in-laws. ... Sanford spending holiday weekend with family in FloridaCNN International SC residents mixed over fate of cheating govThe Associated Press South Carolina governor mixed business, pleasure in '08 Argentina tripTheNewsTribune.com New York Times -Wall Street Journal -Reuters all 6,678 news articles » Publ.Date : Fri, 03 Jul 2009 22:40:50 GMT Germany: Demjanjuk Cleared for Trial - New York Times Washington Post Germany: Demjanjuk Cleared for Trial New York Times Doctors have determined that John Demjanjuk, who is accused of complicity in atrocities as a guard at a Nazi death camp, is fit to stand trial, prosecutors said Friday in Munich. Mr. Demjanjuk, 89, a retired autoworker, was deported ... Accused war criminal Demjanjuk 'fit to stand trial'CNN International Plain DealerJohn DemjanjukThe Plain Dealer - cleveland.com Prosecutors: Demjanjuk fit to stand trialThe Associated Press Reuters -AFP -Washington Post all 356 news articles » Publ.Date : Sat, 04 Jul 2009 01:39:31 GMT Palin Resigning Governor's Job; Future Unclear - New York Times Telegraph.co.uk Palin Resigning Governor's Job; Future Unclear New York Times Robert DeBerry/The Mat-Su Valley Frontiersman, via AP Alaska Gov. Sarah Palin announced that she is stepping down from her position as Governor in Wasilla, Alaska on Friday. By ADAM NAGOURNEY and JIM RUTENBERG Gov. Sarah Palin of Alaska abruptly ... Alaska Gov. Sarah Palin quits; plans to resign July 26, keeps mum ...New York Daily News Palin resigns as governor; leaves plans secretThe Associated Press Tired of the Full-Court PressWashington Post Los Angeles Times -CBS News -San Francisco Chronicle all 1,887 news articles » Publ.Date : Sat, 04 Jul 2009 01:44:54 GMT US Marine commander out shopping in Afghanistan - AFP Los Angeles Times US Marine commander out shopping in Afghanistan AFP GARMSIR, Afghanistan (AFP) — Brigadier General Larry Nicholson demonstrated the more open approach he wants to see among the new US troops sent to southern Afghanistan by going shopping for melons. Nicholson, commander of the 4000 Marines deployed on ... Insurgents Step Up Attacks on MarinesWashington Post Failed strategy in Afghanistanguardian.co.uk Gen. Petraeus says Taliban is a resilient enemyThe Associated Press CNN -Bloomberg -Times Online all 4,796 news articles » Publ.Date : Sat, 04 Jul 2009 02:01:56 GMT Honduran court defiant on Zelaya - BBC News FOXNews Honduran court defiant on Zelaya BBC News The Supreme Court of Honduras has rejected a demand by the Organization of American States to reinstate the ousted President, Manuel Zelaya. OAS chief Miguel Insulza was told that the court's position was "irreversible" when he met its president for ... Honduran post-coup gov't claims no negotiations with OASXinhua Ousted Honduran president riled old guard, businessReuters Video shows Honduran troops shooting protesters' bus tiresCNN Aljazeera.net -Voice of America -AFP all 11,913 news articles » Publ.Date : Sat, 04 Jul 2009 01:05:44 GMT Create Blog RSS to HTML

PARLOT::Ebooks, Scripts, Websites, and more...

Adsense websites

Why do I Need a Website?

Cost Effective Advertising. Online selling. Increased geopgraphic range. Wider... Read More

7 Golden Rules For Building Mini Sites

First, an eye opener. Making your fortune through affiliate programs... Read More

How To Get Your Customers To Trust Your Website

Research reveals three important facts:1) The Internet is one of... Read More

Get a Website!, Register Your Domain!: To Website or Not to Website?

If you're fairly new to the Internet scene, you may... Read More

Why a CSS Website Layout Will Make You Money

Although CSS layouts have been around for years, they haven't... Read More

Making Your Website Shine! Attract and Keep Visitors at Your Site!

When you consider the billions of individuals and companies on... Read More

Web Success Secret - Keep Your Visitors Interested

Visitors to your site come looking for information or solutions... Read More

7 Reasons YOU Need a Website

1) A marketing necessityI still hear it said from time... Read More

The 5 Biggest Mistakes Almost All Web Designers Make

Huge Mistake #1: Creating a Website with Flash -- Did... Read More

Growing Your Meetings In CyberSpace

As increasing numbers of people search for information on the... Read More

Five Essential Questions to Answer Before Creating Your First (or second...or third) Website

Right after the thought, "I need a website," people usually... Read More

Flash Deadly Sins (That Can Kill Your Web Business)

Looks like every client wants a Flash site these days... Read More

Adding Word Rich Content to Your Website

You have permission to publish this article electronically, in print,... Read More

What and How to choose the Right Keywords for Mega Traffic

Keywords in Search Engine Optimizing and Search Engine Marketing are... Read More

So You Want To Have A Website

So you want to have a website. You have gone... Read More

Effectively Using Robots Meta Tags

The "robots" meta tag, when used properly, will tell the... Read More

Unlocking the Power of Your Website!

Why do some web sites reap huge benefits while others... Read More

3 Rules of Website Designing and Layout

Now that you have got your domain name registered, your... Read More

Dreamweaver 8 Preview

August 8 2005, Macromedia announced a release of Studio 8.... Read More

Traffic for Webmasters

"If you build it, they will come"; is an age... Read More

Server Stats ? Analyzing Traffic To Your Site

Analyzing traffic to a site is a key factor in... Read More

Is Your Website Innovative? Increase Your Business Over Night!

While studying online for IT investment opportunities, I found that... Read More

Creating Websites that Cater to Exam Preparations

One of the things that Internet excels is disseminating information... Read More

Building a Web Site Requires the Right Software to Eliminate Headaches and Keep Money in Your Pocket

When most people build a web site, they think one... Read More

How to Make Your Own Free Website in 8.5 Minutes or Less

Designing and creating your own website does not have to... Read More