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.

Related Tutorials

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.

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.

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

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.

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.

Add, View, Edit & Delete from to MySQL database, Live Example (News System)
This tutorial will teach you how to deal with MySQL database using php, you will add, view, edit & delete data.

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.

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.

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.

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.

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.

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.

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.

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.

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 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. The tutorial is available in PDF format.

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 MySQL for beginners
Very Simple tutorial to get you start using PHP with the most popular MySQL database.

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.

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.

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.

Design an Online Chat Room with PHP and MySQL
In this article, you will learn how to design and develop a simple online chat room with PHP and MySQL. This tutorial explains every steps of the development, including both database design and PHP programming. Basic computer skills and knowledge of HTML and PHP are required.

How to connect to your MySQL database in PHP
In this tutorial I'll show you how to connect to your MySQL database in PHP. Very useful for beginners.

PHP Script Tips - Working with MySQL Database
A collection of 21 tips on working with MySQL database. Clear explanations and tutorial exercises are provided on connecting and selecting MySQL database, creating and dropping tables, inserting, updating, and deleting rows, selecting and looping through data rows, searching by key words, setting auto-increment IDs.

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.

Connecting to a MySQL Database with PHP
How to connect to a MySQL Database using PHP.

Get the Size of a MySQL Database with PHP
This simple tutorial will show you how to get the size of a MySQL database using PHP in just a few simple steps.

Saving Movie Clip Positions with PHP and MySQL
Good understanding of Flash Actionscript is required to complete this tutorial. What this tutorial basically does is to show you how to set up a table in a mySQL database, then using PHP (or asp with a few minor changes) manipulate that table and interact with Flash.

Basic HTML newsletter in PHP/MYSQL
This tutorial will teach you how to make a simple newsletter in PHP/MYSQL with account activation. This will require PHP that is not running in SAFE_MODE or PHP that at least allows the sendmail function(duh, you can't send mail without this enabled).

Using MySQL with PHP
This tutorial describes: How to configure PHP with a MySQL server, What are the basic functions to use a MySQL server, A test script with a MySQL server.

Dynamic URLS using php and mysql
To create dynamic URL with php and mysql is quite simple and this small tutorial will teach you how very easily. If you look at Chipmunk directory, board, or CMScore, you will find that they all use Dynamic URLs with PHP/Mysql.

Database Normalization And Design Techniques
One of the most important factors in dynamic web page development is database definition. If your tables are not set up properly, it can cause you a lot of headaches down the road when you have to perform miraculous SQL calls in your PHP code in order to extract the data you want. By understanding data relationships and the normalization of data, you will be better prepared to begin developing your application in PHP. Whether you work with mySQL or Oracle, you should know the methods of normalizing the table schema in your relational database system. They can help make your PHP code easier to understand, easier to expand upon, and in some cases, actually speed up your application.

MySQL in PHP - Running Some Queries
Continuing the process of adding access to a MySQL Database to our HTML pages, we now need to interact with the database we previously selected from the server to which we also previously connected.

Editing MySQL Data Using PHP
We have had a few tutorial that show how to display and add data to a MySQL database. Now I am going to show you how to edit a row in your database.

The Universal Web Form Processor
This article describes how to create a generic form processor in PHP. Discussion involves form elements, hidden fields, and more. Also covers the installation process of NuSphere MySQL, an integrated multi-platform distribution of Apache, Perl, PHP, and MySQL.

Web Database Tutorial (PHP & MySQL)

View Tutorial