|
|
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.
17 Tips to Plan a Website
Everyone wants one.
Building eCommerce Websites that Work - Part 3
An interesting eCommerce success factor that isn't precisely overlooked, but which is often thought about more in terms of being a way of feeding the search engine spiders has to do with providing content. In a very real sense the customer's job is to consume. That's why you're in business.
5 Tips To Supercharge Your Website Sales Copy
The art of turning website visitors into paying customers depends almost entirely on good sales copy. What is that?
How to Build a Database Driven Web Site
If you ever want to create a state directory, article directory, dating site or link directory, you need to know about creating database driven web sites. This may seem like a daunting task at first, if you have never done it, however I was in the same boat as you. It is not as difficult as you think.
Why Should Your Business Go O.N.L.I.N.E.
Optimize your time. How much time each day must you devote to paperwork, scheduling and accounting? You strive to meet the needs of your clients, but when chained to the obligations of business management, it's just as important to make sure the doors stay open as it is to satisfy customers. By integrating your daily tasks and taking advantage of the amazing Web-based software solutions out there, you can make more time for clients and spend less time behind your desk. Do you work from home? When your business is online, you can manage your business any place you have a connection to the Internet
Be Creative Before You Purchase Or Create A Website
Before you jump into spending coutnless hours on designing and publishing your website, or spending hundreds on having it done by anyone else you should plan out your full design (or structure). This is very important so that when it comes time to do this long-lasting project you will be well prepared.
If Its Done Its Done for: Make Your Website Part of Your Business before You Build
Web sites are an Ongoing Part of Business.
Build a Web Site that Works...Even for a Safari Hobby!
My life's greatest passion is a safari hobby. And what would that be, you ask. ...Simply the conservation of wildlife and the environment. I do this after hours from my 7 to 5 job. And that's how this story started. Read this story to learn how to build not just a web site...but a web site that works...
7 Ways to Gain a Professional Online Reputation
A professional online reputation is essential to the flourishing of any business big or small. Many business owners spend countless hours on the core operations of their business forgetting the importance their website has. Having an up-to-date website with a professional appearance and easy navigation can make or break a lot of potential business deals. Below are 7 ways you can gain a professional online reputation.
Marketing Your Business Online
As a business you can't afford to ignore the Internet Age; in 2002 there was an estimated 605 million people online around the entire globe, today this is estimated at over a billion users worldwide.
Websites for Writers ? Why You Need One and How to Get Started Today
It may seem like the publishing industry's equivalent of Beanie Baby madness- everyone is talking about writer's websites. Freelancers and authors everywhere are jumping on the bandwagon, publishing sites to promote themselves and their work. This craze leaves many writers wondering if it's just a fad or if it's really worth the expense and effort. While it may seem like an overwhelming or frivolous endeavor, there are some solid business reasons why you should consider setting up your own website.
What and How to choose the Right Keywords for Mega Traffic
Keywords in Search Engine Optimizing and Search Engine Marketing are the building blocks and foundation of your website on the search engines. If your foundation is weak or poorly put together your webpages won't have much to be based upon for the engines to rank with.
Using Psychology Easily on Your Website to Make More Sales!
Psychology is a long word which everyone thinks, "no, that's not for me, it'll be too difficult". Apart from being lazy, anyone who thinks this is wrong. Applying psychology on your website is easy and extremely effective. Also, the fact that most webmasters take the lazy view of applying psychology gives you the edge over your competition.
Ever Wondered What Challenges Other People With Their Web Site?
Have you ever wondered what challenges are faced by other webmasters and owners in the design and promotion of their websites, well I certainly have and so I decided to try and find out.
HTML Editors 101 - Smaller Is Better
SiteSpinner
Search Engines and Customers Want Focused Web Site Content
How do you decide on the content, products and or services you will promote on your Web site.
Get Your Business on the Web
I can't think of any business alive today that couldn't benefit from at least a minor presence on the web. Now that I've made that statement, I'm sure someone will point out one. My point is, however, that having a web presence today is about as cheap as anything going and if you ever get one client or sale from the web you are way ahead.
Do You Really Need A Website To Succeed
Rosalind wants to share her inspirational poetry with a wider community. Alas, poor Rosalind lives in a remote town.
Making the Most of Your Website: Start with the Basics
One of my most salient memories from when I sold real estate in Oregon for my Dad's company was listing a property where the owners had initially tried to sell it For-Sale-By-Owner with no success. After the listing contract was signed my Dad told them, "Next time put your phone number on your sign."
For Newer Sites, Web Marketing Depends On Titles & Links!
We all start out the same. Some have budgets, some don't. The one true factor out there is that we all want to expose our business. For 99% of us, starting out in the world of web marketing means a few things: