Tutorial search
PHP Tutorials
Tutorials
Stuff
Affiliates
Photoshop Templates
Featured Photoshop templates - professional ready to use designs for your next project.
View all templates
PHP Database Tutorials
We hope that you will enjoy our PHP Database tutorials. Feel free to contact us if you would like to be a tutorial hero and contribute your own PHP Database tutorials to our site. Thank you !
Example of how a simple system for creating a CRUD interface from the information in the model classes.

Writing external scripts to perform complex data handling is a tedious affair. The best way to automate tasks straightaway into the server is by using Stored Procedures. It is very useful to make them as flexible as possible, as it facilitates easy identification of any errors and can be used for executing a variety of tasks as well.

This is a simple example of photo-gallery script, which uses MySQL table (BLOB field) to store images. Trivial password-protection, uploading and deleting images are supported. For Apache-version of PHP ddthere is advanced browser-caching support (using If-Modified-Since header).

Hi folks! In this tutorial We will learn how to create a database for a complete and professional forums system. I want to present you an awasome utility for designing and creating databases: MySQL Workbench.

Adding a jQuery Auto Complete to Your Google Custom Search Engine

Creating a CodeIgniter application is easier than you might think. Take a guided tour through your first project: a simple Web page with a contact form. In under an hour, you will learn how to install CodeIgniter, configure it, and create a Web site consisting of a home page, a form that adds information to a database, and a thank-you page.

This tutorial covers the basics of using MySQL's aggregate functions (SUM(), MIN(), MAX() etc) to generate report-style data and to summarise complex sets of information

Sometimes when working with a MySQL powered website in PHP, we’ll come across situations where we have multiple records that we wish to display to the visitor. If there are many tens, hundreds or more of these results, we might not want them all shown on the one page as this would increase the loading time, and make the list harder to navigate.
To solve this problem, we introduce the concept of pagination in MySQL, which makes use of the handy LIMIT keyword and information passed by GET fro

This tutorial contains a step-by-step guide to building an IP Address and Visitor tracking log tool using PHP and MySQL.
When running a website, whether it’s a small personal homepage, or a large site for a company, it’s useful to be able to know who is visiting your site, and what they’re up to while they’re there.

PhpMyAdmin is a popular open-source application used to remotely manage and modify MySQL databases and is particularly useful for use on websites as it can be placed within a secure directory on a remote web server and accessed via a specific URL. This allows you to easily and quickly access your data to make changes, to download backups or perform a range of other useful operations.

In this tutorial we’re going to look at an example where it becomes useful to use more than one table at a time while still using the powerful features of MySQL to query this data in a simple, straightforward manner
Multiple tables can be queried using one statement via the JOIN command, to join together multiple tables at a time

In this tutorial we will work on building ourselves a very simple PHP application to accept user data and save it into a MySQL database. This information will then be displayed to anyone visiting the site. We’ll also take a quick look at how we can generate a script to authenticate administrative users based on a username and password combination and allow those admin users to delete unwanted comments from the database.

This tutorial covers the basics of using MySQL to update existing records and insert new records into a table using PHP
There is also a section on auto-incrementing values and table indexes to improve performance
Total Tutorials in Category: 193





