Home
>
Web Development
>
How to Build a Database Driven Web Site

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.

Benefits of building database driven web sites

-Store vast amounts of information about your products or services.

-Efficient data sorting and retrieval

-Complex queries and statistical analysis performed relatively easily

-Separate site design from site's content

-Create new pages on the fly without manually creating or editing new web pages

-Makes it easy for client to post content, update records without the need to know html or rely on a web developer.

-Advanced search capabilities

-Attract repeat visitors with fresh and constantly updated content.

-Update site information online without the need to upload web pages.

-Site maintenance greatly reduced.

-Enhance web interactivity

Requirements

MySQL - to retrieve information from a database, you first need to have a database. That's where MySQL comes in. MySQL is a relational database management system, or RDBMS. It's a software package that is very good at organizing and managing large amounts of information. MySQL also makes that information readily accessible by using a server-side scripting language like PHP.

PHP - this is a server-side scripting language. With PHP installed, your Web server will be able to read a new file (called a "PHP script") that can retrieve information instantly from a database and insert it into a web page before sending it to the browser that requested it. PHP is completely free to download and use.

Check with your current Web host. Make sure they have already installed MySQL and PHP on your Web server. Most web hosting companies already have it installed. If not find a web host that provides this service.

Steps to building a database driven web site:

You will be building a link directory site using a mySQL database and the WSN Links Script (a PHP script). Here's an example of the "Colorado Business Directory Site" that was built, based on following the 7 steps below:

http://www.hereiscolorado.com

1. Check that your web host has PHP 4.10+ (or PHP 5) and MySQL 3+ installed on the server.

2. To create the mySQL database on the web server:

-login to the cpanel of your server ie domainname/cpanel with your user name and password.
-click on 'MySQL Databases' icon.
-enter database name
-click 'add db'
-click on 'go back'
-under 'Users' enter user name and password for database
-click 'add user'
-click on 'go back'
-click on 'add user to database'

You should now get the reply that your database installation was successful.

3. Download the PHP script files to your desktop at: WSN links - http://www.isitebuild.com/cgi-bin/a/t.cgi?wsnlinks

4. Extract files from the ZIP folder and save them to a folder on your computer.

5. Upload all the extracted files to your hosting space

6. Set the correct permissions for your files.

7. To complete the installation and to customize the script, read the manual at:

http://www.isitebuild.com/cgi-bin/a/t.cgi?wsnlinks

You can continue to customize or edit your site online by accessing the admin panel within your web site.

Adding, sorting, retrieving, searching data, creating new pages, links etc can now easily be accomplished.

Congratulations!... you successfully have built yourself a database driven web site.

Herman Drost is the Certified Internet Webmaster (CIW) owner and author of http://www.isitebuild.com Affordable Web Site Design and Web Hosting. Subscribe to his "Marketing Tips" newsletter for more original articles. http://www.isitebuild.com. You can read more of his in-depth articles at: http://www.isitebuild.com

family-safe home cleaners Lincolnshire ..

In The News:

Tired of AI customer service loops? These insider tricks help you escape "frustration AI" and get real human help when you need it most for urgent issues.

Unlock richer audio from your streaming apps with simple tweaks to volume normalization, equalizer settings, and quality preferences for cleaner sound.

Scammers are sending fake Facebook settlement payout emails that mimic legitimate notices from the privacy settlement administrator to deceive users.

Holiday shopping scams surge as fake refund emails target distracted consumers during Black Friday and holiday seasons, costing Americans billions annually.

The AI-powered IRMO M1 exoskeleton features four modes, including turbo, eco, training and rest for hiking, running, cycling and sports with eight-hour battery life.

OpenAI announced upgrades for its ChatGPT Images platform on Tuesday, saying the program can now make more precise edits and produce images more quickly.

Chrome for Android now turns web articles into AI-powered podcast conversations. Get hands-free browsing with Google Gemini's natural audio summaries.

LastPass faces $1.6 million fine from U.K. regulators after 2022 data breach exposed 1.6 million users. Password manager failed proper security controls.

Petco disclosed a data breach exposing customer Social Security numbers, financial account details, and driver's license information due to a software error.

Baseball teams can now analyze complete swing mechanics in normal training environments using Theia's markerless AI system that processes standard high-speed footage.

Smart home hacking fears overblown? Expert reveals real cybersecurity risks and simple protection tips to keep your connected devices safe from hackers.

MIT develops needle-free glucose monitor using light technology. Revolutionary device could replace painful finger pricks for diabetes management.

The ClickFix campaign disguises malware as legitimate Windows updates, using steganography to hide shellcode in PNG files and bypass security detection systems.

Researchers from Osaka Metropolitan University designed a 21-foot dome that combines aquaculture and hydroponics to create a self-sustaining urban food system.

The Fox News AI Newsletter gives readers the latest AI technology advancements, covering the challenges and opportunities AI presents.

ChatGPT data breach exposes personal info of users through partner Mixpanel. OpenAI confirms names, emails compromised in security incident.

Android rolls out Emergency Live Video for 911 calls, letting dispatchers see real-time scenes during emergencies. Great for holiday travel safety.

Malicious Chrome and Edge extensions collected browsing history, keystrokes and personal data from millions of users before Google and Microsoft removed them.

Google's new Call Reason feature lets Android users mark calls as urgent before dialing, displaying an urgent label to recipients using Phone by Google app.

Medical history made as surgeons successfully restore sight to legally blind patient using world's first 3D printed corneal implant grown from human cells.

Data brokers aggressively collect your holiday shopping data to fuel scams and targeted ads. Learn how to delete your digital profile before 2025 starts.

Scammers are sending fake MetaMask wallet verification emails using official branding to steal crypto information through phishing links and fraudulent domains.

Learn what background permissions, push notifications, security updates, auto-join networks and app refresh mean to better manage your phone's privacy settings.

Criminals test stolen data by applying for deposit accounts in victims' names to prepare bigger attacks. Learn why banks won't share fraud details.

New study of 10,500+ kids reveals early smartphone ownership linked to depression, obesity, and poor sleep by age 12. Earlier phones mean higher risks.

How to Build a Database Driven Web Site

Web Development