Building a Database-Driven Web Site Using PHP and MySQL

This ten part series of articles will teach you everything you'll need to build a database-driven Web site from the ground up. Main topics include: Installation, Getting Started with MySQL, Getting Started with PHP, Using PHP to access a MySQL database, Relational Database Design, A Content Management System, Content Formatting and Submission, MySQL Administration, Advanced SQL, and Advanced PHP.

Related Tutorials

PHP/MySQL RSS Feed
Setup your own RSS feed that pulls data from your PHP/MySQL-driven web site. Use PHP to create the XML/RSS document RSS Readers require to inform visitors of your web site database's content updates.

Web Database Tutorial (PHP & MySQL)
This is a tutorial on how to create a web database application using PHP and MySQL on a Unix platform (Linux or Mac OS X). The example used is a database to manage web site links. The same ideas used in this tutorial can be expanded to most web applications like phone directories, personalization, survey polls, etc... All are based on inserting, displaying and managing data in a database.

Apache Server PHP MySQL phpMyAdmin Setup using AppServ
Our goal is to be able to run PHP scripts on our own computers for the purpose of dynamic web testing and development. What exactly should you do to get the scripts run properly? Unlike running general HTML scripts in IE or any other browser, running PHP requires some components for the script compilation. The answer to this question is by installing a web server (Apache), PHP Core, and MySQL (for database-driven websites) on your PC.

Using PHP to search a MySQL database and return paged results
PHP, MySQL and a Web Server capable of parsing PHP pages, like Apache or IIS. This search script does not spider all your pages by crawling the links, so the content you want to be searchable must be within the database. Knowledge of PHP and MySQL is also necessary because this script is just the bones of a working solution.

Making A Cool Login System With MySQL and jQuery
We are making a cool and simple login / registration system. It will give you the ability to easily create a member-only area on your site and provide an easy registration process. It is going to be PHP driven and store all the registrations into a MySQL database.

Querying Web Databases
We introduce the following techniques in this tutorial: * Using the five-step web database querying approach to develop database-driven queries * Coding a simple solution to produce HTML <pre> preformatted text * Using the MySQL library functions for querying databases * Handling MySQL DBMS errors * Producing formatted output with the HTML <table> environment * Using include files to modularize database code * Adding multiple queries to a script and consolidating the results into one HTML presentation environment * Performing simple calculations on database data * Developing basic database-driven scripts incrementally and producing modular code encapsulated in functions.

How to Access a MySQL Database Using PHP
Display data from a MySQL database on a web page using PHP.

How to connect to MySQL database using PHP
Before you can get content out of your MySQL database, you must know how to establish a connection to MySQL from inside a PHP script. To perform basic queries from within MySQL is very easy. This article will show you how to get up and running.

Generating Advanced Web Page Statistics using PHP
This tutorial is intended for the PHP programmer interested in gathering and analyzing Website statistics in a presentable format using mySQL and PHP.You will need a moderate understanding of PHP and a limited knowledge of mySQL, including how to create a mySQL table using the mySQL client.

Building Dynamic Pages With Search Engines in Mind
Almost any developer knows that search engine placement is critical to the success of a web site. What many people don't know is that a lot of search engines cannot index many database-driven pages (basically any page with a '?' or '&' in the URL).

Revisited: Logging With PHP
This article, "Logging With PHP," the author explains how to build a PHP/MySQL-driven Web traffic logging and analysis system that can be continually updated, which provides information on what content was being viewed, browser and platforms stats, and trends over time.

Create dynamic sites with PHP & MySQL
This tutorial shows you how to use two open source, cross-platform tools for creating a dynamic Web site: PHP and MySQL. When we are finished, you will know how dynamic sites work and how they serve the content, and you will be ready to serve your own dynamic content from your site.

Random Links and images with PHP & MySQL
This script allows any number of images to be referenced and have an associated hyperlink attached, which makes it great for 88x31 buttons which are commonplace throughout the web. The script requires a web server with PHP and a MySQL database to store the data.

Acquiring PHP MySQL
PHP and MySQL are already packaged in Linux and Mac OS X OSs. However, most PHP developer are actually using Windows when developing PHP applications. This is also true to myself. I have Mandrake Linux 10 but I'll just use it for testing purposes of my finished scripts. One reason is that Windows render an amazing web presence unlike any other OS's browsers. So this page will only cover the WAMP ( Windows, Apache, MySQL, PHP ). You will learn how to install Apache, PHP, and MySQL under Windows platform.

Basic mySQL Queries And PHP
This tutorial will help you get started in working with mySQL and PHP. It will assume that you have no prior experience in using mySQL with PHP before. After reading this tutorial, you should get an idea on what a database is, how to use it, and how to access it. You can then go ahead and start reading on the many more advanced topics regarding database systems.

PHP and Mysql: Part 1
Alot of people have written in saying that the Using MySQL with PHP tutorials they've found in the internet are difficult to follow. This tutorial is our attempt at solving the confusion and providing a straight-forward explanation of how you use PHP to interact with a MySQL database.

Interacting with Web Forms
HTML forms are one of the key ingredients of any dynamic website because they can enable the users of a site to interact with it. Otherwise, websites are more or less static: They may be driven by a database and, therefore, regularly changing, but they look the same for each and every visitor. HTML forms can change that; therefore, using data from forms from within PHP is very important.

PHP by example, Part I
As a language for building dynamic Web pages, PHP offers a simplified method for constructing complex and powerful Web-related programs.Step by step, Erik demonstrates the fundamental principles of PHP in an original, real-world Web site example. Part 1 of this two-part series offers the basics of PHP and features a Webzine that includes an author's page where content providers can enter the text of articles, as well as a front end for presenting this content to the world.

PHP/MySQL News with Comments
In this tutorial, you will learn the concepts behind building a news system with PHP and MySQL.

Are PHP and MySQL the Perfect Couple?
This is ore of an introductory article on PHP and MySQL covering such topics as features of PHP and MySQL, and how to use PHP to interact with MySQL.

Building a Comments Script
This tutorial will guide you through the process of building a comments script with PHP. The comments script will use a mySQL database to store and retrieve information. Its not too advanced, but additional features can easily be added, such as a delete feature and implementing usernames.

Databases in PHP - MySQL in PHP
Having studied database basics and taken a look at the Structured Query Language, it's time to dig in. Now we take a look at the use of MySQL in PHP.

PHP/MYSQL Snippets
This tutorial explains the following: Opening and closing PHP tags; Connecting to a MYSQL Database; Selecting a mysql database; usage of ucfirst, ucwords, strtolower and strtoupper function, Using the date function to print different aspects of the date and time, Printing Browser Info, IP Address and hostname of the ip.

Adding PHP to Apache on Linux
This article provides extensive instructions on installing PHP on Apache/Linux. Main topics include: How to Get PHP, PHP Extensions, Building PHP for CGI Use, Building PHP as an Apache Module, Building mod_php as a Dynamically Loaded Object, Testing Your Installation, Going Further/In Conclusion, Building Apache at Lightspeed, Apache Source Components Provided by Linux Distributions, and Fixing Red Hat 6.1's apxs Script.

PHP For Beginners - Free Courses from www.iTechCollege.com
What is PHP? PHP is a computer scripting language, which is originally designed for creating dynamic web pages. PHP is an open-source language, used primarily for dynamic web content and server-side applications. In this course, you will learn how to: How to write to screen; Generate and Retrieve a query string; Use functions; Redirect a page; Show environment variables; How to use cookies in PHP; Include a page; How to connect to MySql database; PHP`s most advantage: create an image directly.

PHP and Javascript: Dynamic update with MySQL
In this tutorial we will create a web page that extracts data from a MySQL database without having to refresh the page.

Installing Apache 2.0, PHP 4.2, MySQL 3.23, and PHPMyAdmin
This article shows you how to setup, configure, install, and use the Apache 2.0 web server, PHP 4.2.0 scripting langauge, PHPMyAdmin, and that latest MYSQL DBMS Database MySQL 3.23 on a Windows machine so you can easily test your dynamic Macromedia Flash content in a server environment. Making it easy to test on your local laptop/desktop. A Flash application using these tools is also detailed.

Building dynamic WML sites
Cellular phones supporting WAP are slowly, but constantly spreading. Therefore, it could be time for you to start building your WML pages to access internet databases. As such, we will show you how to build PHP/WML pages to access a MySQL database which contains professors' receiving hours and exams timetables for a University.

Is it possible to repair MySql Databases using PHP?
Why yes, yes it is. Here, we attempt to devise a method of storing the structure of a MySql database and it’s individual tables in PHP.

PHP and Accessing MySQL Databases
PHP can be used for many things, including grabbing your MySQL database entries.

MySQL & PHP Basics
A breif description of each way of using a mysql database with php coding.

PHP and MySQL for beginners
Very Simple tutorial to get you start using PHP with the most popular MySQL database.

Authentication and Security
In this tutorial we discuss the techniques used to build web database applications that authenticate, authorize, and protect the data that is transmitted over the Web. The topics covered in this tutorial include: * How HTTP authentication works and how it can be used with Apache and PHP * Writing PHP scripts to manage user authentication and authorization * Writing PHP scripts that authenticate users against a table in a database * The practical aspects of building session-based web database applications to authenticate users, including techniques that don't use HTTP authentication * A case study example that develops an authentication framework, demonstrating many of the techniques presented in this tutorial * The features of the encryption services provided by the Secure Sockets Layer.

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.

A MySQL Driven Chat Script
In this article, Tim will show you how to create a quick-n-easy chat script using PHP and a very simple MySQL database. The script will allow visitors to choose a nickname, enter text to send to the chatting window, and view messages from other people... all in real-time! For a bit of fun, the chat application also has buttons to send several emote-icons including smiling and frowning faces.One of the most popular uses for the Internet is person-to-person communication.

How to add A Rating System in your site
Sit back, relax, and imagine this. You run a huge international movie database site. And, your database software is MySQL. You want visitors of your site to be able to rate movies, so that you can rank the movies.

Pagination with PHP
This tutorial is designed to guide you through the logic and code behind the process of paginating data in PHP. In this tutorial, the data is retrieved from mySQL database. I feel you will be able to grasp this tutorial better if you have a decent knowledge of PHP and mySQL.

Accessing a Database Using PHP/MySQL
How to make a mysql connection, select a database, query the database, count the rows and use the information within the rows.

Building a Database-Driven Web Site Using PHP and MySQL

View Tutorial