Creating Dynamic Website Content with PHP - MySQL

Home
>
Web Development
>
Creating Dynamic Website Content with PHP - MySQL

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.

In The News:

Top Stories - Google News
Updated : Mon, 22 Mar 2010 00:18:20 GMT+00:00

Netanyahu says 'no concession' on Jewish settlements - BBC News

The Hindu

Netanyahu says 'no concession' on Jewish settlements
BBC News
Israeli PM Benjamin Netanyahu has ruled out any concession on the building of settlements in occupied East Jerusalem, despite international pressure. Mr Netanyahu said he had written to US Secretary of State Hillary Clinton to remove any doubt about ...
Critical week for Israeli, Palestinian, American diplomacyXinhua
Obama, Netanyahu to Meet in Washington TuesdayWall Street Journal
Netanyahu Accepts Broad Talks While Standing Firm on JerusalemBusinessWeek
Voice of America -Ha'aretz -Christian Science Monitor
all 1,886 news articles »

Publ.Date : Sun, 21 Mar 2010 22:40:13 GMT+00:00

Volcano erupts in Iceland, hundreds flee - CNBC

Zimbio

Volcano erupts in Iceland, hundreds flee
CNBC
REYKJAVIK - A volcano erupted in the south of Iceland overnight, forcing hundreds of people to evacuate the area and diverting flights after authorities declared a state of emergency, officials said on Sunday. Shortly before midnight ...
Iceland prepares for second, more devastating volcanic eruptionTimes Online
Iceland fears 2nd, even larger volcanic eruptionChina Daily
Volcano erupts near Eyjafjallajoekull in south IcelandBBC News
Telegraph.co.uk -Belfast Telegraph -Aljazeera.net
all 930 news articles »

Publ.Date : Mon, 22 Mar 2010 00:04:57 GMT+00:00

Iraq's Premier, Trailing His Main Rival, Endorses a Recount of the Vote - New York Times

Reuters

Iraq's Premier, Trailing His Main Rival, Endorses a Recount of the Vote
New York Times
BAGHDAD — Prime Minister Nuri Kamal al-Maliki endorsed the mounting calls for a recount of Iraq's parliamentary election, as the latest results on Sunday showed his main competitor with a slight lead. ...
Maliki seeks recount in Iraq electionsLos Angeles Times
Prime minister warns of violence, but election board rejects call for recountWashington Post
Iraqi Panel Says Recount Isn't NeededWall Street Journal
Xinhua -The Guardian -Reuters
all 435 news articles »

Publ.Date : Sun, 21 Mar 2010 23:41:48 GMT+00:00

Rift in EU Widens Over Importance of Greek Aid - New York Times

MiamiHerald.com

Rift in EU Widens Over Importance of Greek Aid
New York Times
ATHENS — The rift over how to solve the Greek debt crisis widened Sunday between Berlin and the rest of Europe after Chancellor Angela Merkel of Germany said there was no need to make aid to Athens the main topic of a ...
Germany's Merkel Says Greece Doesn't Need Financial SupportWall Street Journal
Papandreou tells Merkel Greece doesn't need helpReuters
Angela Merkel: EU summit should not discuss bailout for GreeceThe Guardian
Market News International -ABC News -Financial Times
all 390 news articles »

Publ.Date : Sun, 21 Mar 2010 20:25:39 GMT+00:00

Woods 'nervous' about reception - BBC Sport

BBC Sport

Woods 'nervous' about reception
BBC Sport
Tiger Woods says he is wary of the reception he will receive when he returns to action at the Masters after four months away from the game. Woods has not played since admitting multiple extra-marital affairs but will resume playing on 8 April at ...
Tiger Woods interview transcriptESPN
Woods: 'I've had a lot of low points'Seattle Post Intelligencer
Tiger Woods: Wife, Mom Were "Brutal" on Him as Women Claimed AffairsUs Magazine
ABC News -FOXNews -Entertainment Weekly
all 977 news articles »

Publ.Date : Sun, 21 Mar 2010 23:29:01 GMT+00:00

2 Baltimore Officers Shot During Traffic Stop - New York Times

KXLY Spokane

2 Baltimore Officers Shot During Traffic Stop
New York Times
By AP BALTIMORE (AP) -- Two police officers who had pulled over a suspicious vehicle were shot and wounded by the driver, and the suspect was killed when the officers returned fire, Baltimore police said Sunday. Police Commissioner Frederick H. ...
2 Baltimore officers shot, woundedUPI.com
Two officers injured, suspect killed in overnight shootingBaltimore Sun (blog)
2 Baltimore Officers Shot During Traffic StopWJZ
Examiner.com
all 322 news articles »

Publ.Date : Sun, 21 Mar 2010 05:53:35 GMT+00:00

Tens of thousands call for immigration reform at Washington rally - Los Angeles Times

Reuters

Tens of thousands call for immigration reform at Washington rally
Los Angeles Times
Protesters carrying banners and US flags mass on the National Mall. Organizers are trying to cast the issue as an element of economic recovery. Juana Castizo, 59, of Mulberry, Florida, raises her hands in prayer as immigration reform demonstrators ...
US immigration activists rally for changeReuters
Tens of thousands rally for immigration reform in DCWashington Post
Immigration reform rally takes over National MallABC7Chicago.com
NECN -BusinessWeek -OCRegister
all 746 news articles »

Publ.Date : Sun, 21 Mar 2010 22:51:09 GMT+00:00

Make Money With Blogs
RSS For Web Pages

Creating Dynamic Website Content with PHP - MySQL

Web Development