PHP Tutorials — Database Interactions

In this tutorial we look at the issue of SQL injection, how the attackers use it, the problems that can arise and methods of prevention using PHP.

Example of how a simple system for creating a CRUD interface from the information in the model classes.

Adding a jQuery Auto Complete to Your Google Custom Search Engine

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.

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.

Create a Basic Shoutbox with PHP and SQL

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

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.

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.