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.
The purpose of these examples are to show you various ways to use PHP and MySQL. The examples include displaying all fields in the database, random fields, sorting alphabetically and limiting the results returned.
This sample script produces a result set of random rows from a table. It does so by populating one of the columns with a random number, and then doing a select statement that uses it to sort the results.
OO approach described in this article helps to create data layer abstractions which are easy to port to other databases without altering the application code
PHP4 is packed with good features. One of the most popular is session variables. These are variables that persist throughout a session, as the user moves from page to page. Session variables are great holders of state information and other useful stuff. PHP4's session variables are stored in files by default. However for true scalability, it is better to store this data in a database using a database wrapper library like ADODB. ADODB supports Oracle, MySQL, PostgreSQL, Interbase, MSSQL, VFP, Access, ADO.
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. This 6-page article describes the data relationships and the normalization of data using a simple example.
Learn how to easily create a comment system. Don't know what a comment system is? Well, it's what you see very often in a news system. Basically it allows your users to give feedback on tutorials, news etc. This tutorial is definitley a must-see.
This is a database driven pagination tutorial. Pagination refers to when return results are
broken up into pages. For example when say a search returns 100 results but 10 results per page is desired and links to the other pages with 10 more results are generated. This is used to avoid scrolling nightmares. A classic example is the google search. This tutorial assumes basic knowledge of php scripting and mysql databases.