This article is intended for PHP programmers interested in learning about the SQLite extension. The article will introduce the reader to the functionality offered by the PHP SQLite extension,and overview the benefits of SQLite in relation to other database systems. A basic understanding of how PHP and SQL work is assumed.

In this tutorial, Timothy shows you how to get started using SQLite starting with how to obtain it and install it and progressing through example usage.

A Brief introduction in how to use MySQL, Great tutorial for beginners.

Want to reduce the load that MySQL has on your web server? Generating Static HTML pages to replace queries is the solution. Read this tutorial to learn how.

This article provides a comparison of three popular table editor libraries and applications. Namely, the TableEditor Library (available form phpguru.org), phpMyEdit and dbPerceptor.

One of the most powerful aspects of the MySQL server is the amazing amount of control the administrator has over each user's intended behavior. This control can restrict user privileges over a general part of the server, such as limited access to an entire database, but can also be as specific as limiting privileges for a specific table or even column. This article will serve to explain the process in which the MySQL server grants/revokes these user privileges, highlighting in particular the newest additions to the MySQL privilege system, the tables_priv and columns_priv tables. Please keep in mind that the GRANT/REVOKE commands detailed later in this article are only relevant to MySQL version 3.22.11 and up.

If you are writing an application that is used in multiple environments and operating systems, you need to plan to support multiple databases. This article is based on my experiences with multiple database systems, stretching from 4th Dimension in my Mac days, to the databases I currently use, which are: Oracle, FoxPro, Access, MS SQL Server and MySQL. Although most of the advice here applies to Perl, Python and other programming languages, we will focus on PHP and how the ADOdb database abstraction library offers some solutions.

This tutorial will explain the basics of core databases in SQL without complicating with mySQL. Will show you the how to create and view databases in the system and how to create and run sql scripts in the monitor and phpMyAdmin further tutorials will go into the basics of tables following with advanced tutorials.

This article is aimed at answering one of the most asked questions on the PHP mailing list and discussion forums alike: How to store binary files in a MySQL database. This article is split into three pages: Setting up the database, Creating the 'upload' scripts, and Creating the 'download' script. Includes the complete source code for all the scripts involved.

The correct usage of PHP strings is essential when dealing with database queries submitted from User Forms, such as User Registration. Find out how to format strings before saving them in a database in this helpful tutorial.