Login   Register  
PHP Classes
elePHPant
Icontem

SQLite DB Handler

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of José Augusto Ferreira Franco  >  SQLite DB Handler  >  Download .tar.gz .zip  >  Support forum Support forum (1)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: SQLite DB Handler
Base name: sqlite_db
Description: Create and manage SQLite database files
Related classes: ,
Version: -
PHP version: -
License: Artistic License
All time users: 1191 users
All time rank: 2639
Week users: 1 user
Week rank: 2417
 

  Author  
Picture of José Augusto Ferreira Franco
Name: José Augusto Ferreira Franco <e-mail contact>
Packages: 15 Browse all classes by José Augusto Ferreira Franco Browse all classes by
Country: Portugal Portugal - PHP jobs in Portugal
Age: 34
All time rank: 1023 in Portugal Portugal
Week rank: 154 Down2 in Portugal Portugal Up
Innovation award
Innovation award
Nominee: 1x


  Detailed description  
This class can be used to create and manage SQLite database files.

It can create databases tables from a list of field declarations passed as an array.

SQLite does not implement many types table alterations. This class can emulate table alterations by recreating a table with the altered fields and inserting the old table field values.

The class also supports a turbo mode by executing special pragma statements that can enhance the database access performance.

The class error messages can be generated in Portuguese (of Portugal) or English.

  Groups   Rate classes User ratings   Applications   Files Files  

  Groups  
Group folder image Databases Database management, accessing and searching View top rated classes


  Innovation Award  
PHP Programming Innovation award nominee
December 2005
Number 4

Prize: One book of choice by SAMS
SQLite is an interesting flat file database management system. It does not require a database backend server, but it provides an SQL interface to access the database table data.

SQLite SQL dialect provides means to execute the most common SQL operations. However, the support for database schema management in the current SQLite versions is still deficient.

This class provides an alternative solution to perform many types of table schema alterations, equivalent to the use of the SQL ALTER TABLE statement.

Manuel Lemos

  User ratings  
There are not enough user ratings to display for this class.

  Applications that use this class  
No application links were specified for this class.
Add link image If you know an application of this package, send a message to the author to add a link here.
  Files folder image Files  
File Role Description
Plain text file sqlite_class.php Class The main class
Plain text file changes_example.php Example This file generalizes class last changes, with some short pratical examples
Plain text file example1.php Example This short example shows the process required to build a table with class db from package SQLITE DB HANDLER
Image file example1.jpg Screen Sreenshot from result to example1.php

Download all files: sqlite_db.tar.gz sqlite_db.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.