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

executive chauffeured services Westchester Cadillac Deville rentals Deerfield Cadillac Deville rentals Oakbrook limousine airport Highland Park Addison shuttle .. Drug testing

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.

limousine chicago service

In The News:

The creator of the Bredolab malware received a four-year prison sentence in Armenia on Monday for using his botnet to launch DDoS (distributed denial-of-service) attacks that damaged multiple computer systems owned by private individuals and organizations.

An Ohio startup company has raised US$200 million to fund gigabit-per-second broadband projects in six university communities across the U.S., the company announced Wednesday.

Taking a step into the social media marketing industry, Oracle is purchasing Vitrue, the two companies announced Wednesday.

Seagate today announced plans to acquire LaCie, a French maker of external consumer hard drive products, in an all-cash deal worth about $186 million.

This probably seems obvious, but it's worth stating: These days, it's crucial to have a website for your business. From brochure-based sites that provide your contact details and store hours to full-fledged ecommerce carts and customer self-service, your website is important--it tells customers what to expect from you. This article offers several tips for building a better business website that will engage existing customers and help you find new ones.

Google yesterday revealed that the two researchers who cracked Chrome in March at the company's inaugural "Pwnium" hacking contest used a total of 16 zero-day vulnerabilities to win $60,000 each.

Energy/utilities sector ranks last on four of the best practices for cybersecurity, report exposes

Listed on AppExchange, Cloud SSO has been tightly integrated with Salesforce.com applications

FujiFilm said Wednesday it will begin sales of a digital camera in June that is waterproof, shockproof, sealed against dust and sand, and works at temperatures below freezing.

VMware has acquired Wanova, a developer of software used to centralize and simplify image management on physical and virtual desktops, the company said Tuesday.

Google on Tuesday hauled out a tool it last used nearly a year ago to warn users infected with the "DNSChanger" malware.

Microsoft has taken its Google Street View-like service Bing Streetside offline in Germany after German citizens expressed their worries about how Microsoft handles requests for blurring of images, the company said on Tuesday.

Physicians who use social networks to share clinical experiences risk violating patient privacy. A niche industry of private social network providers has cropped up to address the desire to communicate.

The U.S. Department of Justice said Tuesday it was looking into the unauthorized access of a website server in its statistics wing, after hacker group Anonymous claimed to have collected and released 1.7GB of data from it.

Lenovo's net profit for its fiscal fourth quarter grew by 59 percent, as the world's second largest PC maker saw continued growth in sales across both mature and emerging markets.

An often-repeated concern that the U.S. Patriot Act gives the U.S. government unequaled access to personal data stored on cloud services is incorrect, with several other nations enjoying similar access to cloud data, according to a study released Wednesday.

Facebook is to settle a class-action lawsuit in California that accused it of appropriating its users' likenesses for its Sponsored Stories advertising feature, according to a court document filed Tuesday.

Touchscreen laptops and tablets with the upcoming Windows 8 OS will be priced higher than their non-touchscreen counterparts, Dell's CEO said on Tuesday.

Businesses can now remotely control enterprise mobile applications developed for Apple's mobile platform with the latest version of Soti's MobiControl Software Developer Kit for iOS, announced Tuesday.

SAP is buying cloud-based e-commerce vendor Ariba for US$4.3 billion, the companies announced Tuesday.

Verizon Communications on Tuesday became the first service provider to say it will use Alcatel-Lucent's upcoming 7950 XRS core routing system, which will bring the French-American equipment vendor into the carrier core routing business for the first time in about a decade.

Having managed and rescued dozens of projects, and helped others do so, I've noted that there is always one critical success factor (CSF) that has either been effectively addressed or missed/messed up.

Dell on Wednesday reported a drop in profits for the first quarter, weighed down by a revenue decrease and slower sales of consumer products.

In its third day of trading, Facebook's stock is still in a slump, taking the shine off the frenzy that led up to the company's initial public offering (IPO) last week.

CIOs face a common set of thorny challenges these days, namely the pressure to deliver innovations even as they seek to cut or hold down spending, according to an array of senior IT executives who spoke on Tuesday at the MIT Sloan CIO Symposium in Cambridge, Massachusetts.

Besting a record set by Yahoo in 2009, the research arm of Microsoft have deployed a new technique for quickly sorting large amounts of data, called Flat Datacenter Storage (FDS).

A Florida VoIP carrier has filed a net neutrality complaint against a Georgia utility and broadband provider, after the utility accused the VoIP firm of theft of service for using its network to deliver voice service without paying for it.

Brocade this week said it added hardware-based support for the OpenFlow software-defined networking (SDN) API and protocol to its NetIron and MLX series 100Gbps routers as part of a broader SDN strategy.

Hackers claim to be just days away from jailbreaking Apple devices running iOS 5.1.1, the latest firmware release for iPhones and iPads, letting users load applications from outside of Apple's iTunes App Store.

Microsoft said that a skew toward more exploits on Windows Vista can be attributed to the demise of support for the operating system's first service pack.

The nation's space efforts entered a new chapter today with the launch of the first commercial vehicle to the International Space Station.

The price bar for PCs keeps dropping, with chip maker Via on Tuesday announcing a US$49 APC computer with a customized version of Google's Android operating system.

Preparing for the eventual widespread conversion to IPv6, the Nmap Project has updated its namesake security scanning tool so it can scan IPv6 networks using a variety of novel techniques.

Alcatel-Lucent is set to give Cisco and Juniper another run for the money in core routing 10 years after its initial attempt failed.

A new variant of SpyEye malware allows cybercriminals to monitor potential bank fraud victims by hijacking their webcams and microphones, according to security researchers from antivirus vendor Kaspersky Lab.

Sony on Tuesday showed a digital media hub that uses Wi-Fi to connect its PCs, tablets, smartphones and PlayStation game consoles, a product that it hopes will be part of its comeback.

Advanced technologies such as HAMR could mean disk drive capacities from 30TB to 60TB by 2016, according to a new report by IHS iSuppli.

Google said Tuesday morning that it has closed the deal to acquire Motorola Mobility for $12.5 billion

YouTube and German music royalty collecting society GEMA have appealed the outcome of a lawsuit filed by GEMA against YouTube, in which a German court ordered YouTube to inspect the titles of uploaded videos to filter out potentially copyright-infringing content.

Google has finally closed its acquisition of Motorola Mobility, and will now start working on new devices while keeping Android open, it said on Tuesday.

With the world's largest social networking website, Facebook, going public it is quite obvious that comparisons with Google will crop up. We have collated some figures and here is a list of numbers comparing the two giants.

Trusteer expects malware used to attack several German bank sites to be reconfigured for banks in other countries

Former OMB intelligence chief Michael Daniel will take over as the debate over CISPA, for example, heats up

Sidecar, a born-again startup whose founders hail from Internet media services company RealNetworks, Tuesday is launching an eponymous app for iPhones and Android smartphones that's designed to make it easier for people to share videos, photos and more while talking on those devices.

A pair of Microsoft-backed industry groups applauded the ultimatum European Union antitrust regulators issued to rival Google over alleged anti-competitive practices.

Internet Corporation for Assigned Names and Numbers (ICANN) said Monday that its application system for new generic top-level domains (gTLDs) has reopened, more than a month after it was brought down because of a software glitch.

EMC has acquired Syncplicity, an enterprise file-management service provider, for an undisclosed sum.

A judge at the U.S. International Trade Commission has determined that a Kodak patent asserted in a complaint against Apple and Research In Motion is invalid, Kodak said on Monday.

The security vendor Trusteer is warning banks to look out for a sophisticated Trojan capable of emptying the account of an online customer.

Named late last week to replace Howard Schmidt as the top White House cybersecurity adviser, Michael Daniel is a 17-year veteran of the Office of Management and Budget (OMB) and has been its intelligence branch chief for the past 11 years. But he has stayed largely under the radar, even in the cybersecurity community.

Traditional mobile phone plans are now on the wane in the U.S., but the country's biggest carriers are still bringing in more money and leading the world in revenue, according to a report based on first-quarter results.

Schools in the U.S. will need broadband speeds of 100 Mbps per 1,000 students and staff members by the 2014-15 school year in order to meet a growing demand for Web-based instruction and a skyrocketing number of student-owned Web devices, according to a new report by a trade group representing state education agencies.

Voyager Mobile, the startup that had planned to launch last Tuesday but said it was delayed by an attack on its website, went live on Sunday with an unlimited voice, text and data plan for US$39 per month.

The Supreme Court on Monday declined to consider the petition of Joel Tenenbaum, a former doctoral student at Boston University who faces a fine of US$675,000 for illegally downloading 30 songs.

As Avaya continues its transition from a hardware company into a communications and collaboration software provider, it is going through some growing pains, including a shakeup of executives and uncertainty around a potential initial public offering that's been rumored for months.

The U.S. Federal Trade Commission has hired Paul Ohm, a privacy advocate and critic of current online privacy practices, as a senior privacy adviser for consumer protection and competition issues affecting the Internet and mobile services.

Salesforce.com, which has placed ample emphasis on its Chatter social networking application, will actually begin providing real-time chat functionality as part of an imminent upgrade to its family of cloud-based software, according to a company document.

The Nasdaq computer system that delayed trade notices of the Facebook IPO on Friday was plagued by race conditions, the stock exchange announced Monday. As a result of this technical glitch in its Nasdaq OMX system, the market expects to pay out US$13 million or even more to traders.

There are many ways you can use Twitter to help build your business. For example, you can track trending topics, leverage Web analytics, and tap some 50 million daily users.

International medical vendor Mediq was expanding in a big way by acquisition and needed a standard email platform across its business, but the project's cost and the complexity of doing it alone was so daunting that the company called on outside help that costs it less in the long run.

Samsung is blocking a hack of its S Voice digital assistant software that allowed any Android phone running Ice Cream Sandwich to use the app.

Advanced Micro Devices aims to improve the quality of high-definition video and 3D graphics on equipment in casinos and hospitals with its new R-series processors, which the company announced on Monday.

Mobile operators that want help keeping their subscribers happy can get it through a new managed service from Alcatel-Lucent, the company said on Monday.

Malware writers have used Crossrider, a cross-browser extension development framework, to build a click-fraud worm that spreads on Facebook, security researchers from antivirus firm Kaspersky Lab said on Monday.

Now that Google has gotten permission from China's Anti-Monopoly Bureau to acquire Motorola Mobility, the companies are expected to complete their merger by the middle of this week.

IT management executives from large corporations worry most about how to manage employee-owned devices safely and securely, according to clients of the Directions on Microsoft analyst firm.

Silver Peak today upgraded the software for its WAN appliance to handle automated optimization for TCP and non-TCP traffic, 512,000 simultaneous connections for 10 gigabit-per-second (Gbps) infrastructures and support for a bunch of common hypervisors.

IT managers grappling with bring-your-own-device policies can expect to see an explosion in the number of smartphones and tablets used by employees.

The big cable companies know that if they want to stay relevant in the wireless market, they can't do it on their own.

Version 3.4 of the Linux kernel was officially rolled out Sunday, in what maintainer Linus Torvalds called a "calm" release cycle.

Google has "a matter of weeks" to address four antitrust issues identified by European Union antitrust regulators. If Google addresses these issues the case can be solved by a so-called "commitment decision" instead of formal antitrust proceedings resulting in a fine, said JoaquAn Almunia, Vice President of the European Commission responsible for Competition Policy.

Yahoo has agreed to sell off about half of its stake in Alibaba Group back to the Chinese e-commerce giant as part of a US$7.1 billion deal, the two companies jointly announced on Monday.

If the numbers at StatCounter are accurate then the world has a new Web browser champion: Google Chrome.

The chief of AT&T Mobility can't wait for Windows 8 tablets to hit the market because they'll fuel demand for Windows phones.

IBM is offering employees who are nearing retirement a one-time opportunity to take advantage of a program that would guarantee their employment through Dec. 31, 2013.

Europe's top court has ruled that the functionality of a computer program and the programming language it is written in cannot be protected by copyright.

Your boss wants it yesterday, but it better be good when judged by the standards of tomorrow. Your customers want every feature they can imagine, but don't you dare confuse them by giving them all the buttons they want. Your fellow programmers want your code documented, but they just respond "tl;dr" to anything you write.

After all the attention, clamor, and expectations Facebook is now a publicly traded company worth $104 billion. With shares trading at a hundred times earnings, Facebook is under a lot of pressure to increase the profit that it brings in. In other words, now the fun begins.

Microsoft is abandoning the 'Aero' user interface with Windows 8, calling the UI that debuted in Vista and continued in Windows 7, 'cheesy' and 'dated.'

Company claims system requirements will be the same as those of Visual Studio 2010 despite performance increases

The NFL has big stadiums, big players and big games, but when it comes to computer systems, the league's vice president of IT doesn't use the word big.

Despite interoperability trials and demonstrations involving alternative data center fabric standards, a non-standard fabric technology is said by proponents to be at the front of the pack.

Taiwanese smartphone vendor High Tech Computer said on Sunday certain models of its newest smartphones have passed U.S. Customs and are being released to its carrier customers, after the company previously warned of a delay in product shipments because of an International Trade Commission (ITC) order.

So.cl, an experimental research project from Microsoft, that combines social networking and search to promote learning, is now accepting all users interested in joining the site.

Email managers have a lot at stake. After all, the volume of global electronic messages sent via email dwarfs all other forms of electronic communication, including social networking. Since the inception of electronic mail, which, according to some Internet historians, can be traced to a small mainframe app called 'MAILBOX' from the mid-1960s, human-to-human messages have been created, transmitted and stored in electronic format. But early email administrators could hardly have envisioned the complexity of current email infrastructure and the concomitant maze of technical, security, business and regulatory challenges.

Pakistan late Sunday reversed a block on Twitter in the country over material it considered anti-Islam, the country's interior minister said.

Technical problems at the Nasdaq exchange affected the trading of Facebook shares on Friday, the much-anticipated day of its IPO (initial public offering), Robert Greifeld, chief executive of Nasdaq OMX Group Inc., told reporters on Sunday, according to published reports.

Chinese regulatory authorities have approved Google's acquisition of Motorola Mobility, paving the way for the deal to close within the week, company officials confirmed Saturday.

In the latest move in a complex series of patent-related cases, Apple filed a motion in a U.S. district court late Friday to ban Samsung Electronics' Galaxy Tab 10.1 in the U.S.

Apple's plans for a Bluetooth 4.0-based iWallet could be the beginning of the end for the venerable cash register.

Creating Dynamic Website Content with PHP - MySQL

Web Development Web Development