SQLite DB Handler
| Recommend this page to a friend! |  Stumble It! |
 Bookmark in del.icio.us |
| Classes of José Augusto Ferreira Franco | > | SQLite DB Handler | > | Download .tar.gz .zip | > |  Support forum (1) |
> |  Blog |
> |   Latest changes |
||
|
|||||||||||||||||||||||||
| Author | ||
 |
|
Innovation award Nominee: 1x | |||||||||||||||||||
Browse all classes by 
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.
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 |  User ratings |
Applications |  Files |
|||||
| Groups | ||
 |
Databases | Database management, accessing and searching | View top rated classes |
| Innovation Award | ||
 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.
If you know an application of this package, send a message to the author to add a link here.| Files |
||
| File | Role | Description |
|---|---|---|
| sqlite_class.php |
Class | The main class |
| changes_example.php |
Example | This file generalizes class last changes, with some short pratical examples |
| example1.php |
Example | This short example shows the process required to build a table with class db from package SQLITE DB HANDLER |
 example1.jpg |
Screen | Sreenshot from result to example1.php |
| Download all files: sqlite_db.tar.gz sqlite_db.zip |
For more information send a message to info at phpclasses dot org.
Copyright (c) Icontem 1999-2012