Tutorial search

PHP Tutorials
Tutorials
Stuff
Affiliates

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 !

Sort by:
Basic CRUD scaffolding with PHP Doctrine + Smarty
Basic CRUD scaffolding with PHP Doctrine + Smarty
Example of how a simple system for creating a CRUD interface from the information in the model classes.
Category: PHP tutorials > Database - Difficulty:
Using Stored procedure with mySQL and PHP
Using Stored procedure with mySQL and PHP
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.
Category: PHP tutorials > Database - Difficulty:
PHP MySQL example: image gallery (blob-storage)
PHP MySQL example: image gallery (blob-storage)
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).
Category: PHP tutorials > Database - Difficulty:
Create a Basic Shoutbox with PHP and SQL
Create a Basic Shoutbox with PHP and SQL
Create a Basic Shoutbox with PHP and SQL
Category: PHP tutorials > Database - Difficulty:
How to make a brilliant mysql forum database from scratch
How to make a brilliant mysql forum database from scratch
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.
Category: PHP tutorials > Database - Difficulty:
Adding a jQuery Auto Complete to Your Google Custom Search Engine
Adding a jQuery Auto Complete to Your Google Custom Search Engine
Adding a jQuery Auto Complete to Your Google Custom Search Engine
Category: PHP tutorials > Database - Difficulty:
Connect to a MySQL Database
Connect to a MySQL Database
A basic tutorial on how to connect to a MySQL Database,
Category: PHP tutorials > Database - Difficulty:
Getting started with CodeIgniter
Getting started with CodeIgniter
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.
Category: PHP tutorials > Database - Difficulty:
Generating Reports using MySQL’s Aggregate Functions - Sum(), Max(), Min() and more
Generating Reports using MySQL’s Aggregate Functions - Sum(), Max(), Min() and more
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
Category: PHP tutorials > Database - Difficulty:
Pagination : Splitting data across multiple pages with MySQL and PHP
Pagination : Splitting data across multiple pages with MySQL and PHP
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
Category: PHP tutorials > Database - Difficulty:
A simple IP Address and Visitor Tracking tool with PHP & MySQL
A simple IP Address and Visitor Tracking tool with PHP & MySQL
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.
Category: PHP tutorials > Database - Difficulty:
Using PHPMyAdmin to manage your MySQL data
Using PHPMyAdmin to manage your MySQL data
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.
Category: PHP tutorials > Database - Difficulty:
Using Multiple MySQL Tables with Unique IDs, Joins and Normalization
Using Multiple MySQL Tables with Unique IDs, Joins and Normalization
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
Category: PHP tutorials > Database - Difficulty:
Creating a Simple Comments and Login System using MySQL and PHP
Creating a Simple Comments and Login System using MySQL and PHP
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.
Category: PHP tutorials > Database - Difficulty:
Updating, Inserting and Deleting data with MySQL
Updating, Inserting and Deleting data with MySQL
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
Category: PHP tutorials > Database - Difficulty:
Total Tutorials in Category: 193