PHP Classes

class sqlite: SQLite database access wrapper

Recommend this page to a friend!

  Author Author  
Name: Jonathan Gotti is available for providing paid consulting. Contact Jonathan Gotti .
Classes: 13 packages by
Country: France France
Age: 41
All time rank: 714 in France France
Week rank: 515 Down16 in France France Down
Innovation award
Innovation award
Nominee: 4x

  Detailed description   Download Download .zip .tar.gz   Install with Composer Install with Composer  
This class is a wrapper around the PHP extension to access SQLite databases.

It provides functions for opening and closing SQLite database files, list database tables and their fields, execute SQL insert, update delete and select queries and retrieve the result set data into arrays.

###---###---###---###--- Welcome to Class-db ---###---###---###---###

#- What is class-db:
Class-db is a php5 base class to create database access wrapper
and to ease programmer work when it's time to work with database.
Class-db comes with some extended class for mysql and sqlite so
you can check thoose out to see how to create your own extended
database wrapper.

#- Author
Jonathan Gotti < jgotti at jgotti dot org >

#- Licence GNU Lesser General Public License

#- History
I've created first version of class-db in 2003 (in fact it was only
class-mysqldb at this time) to assist me dealing with mysql database
common operation. after some change and i finally split it in a two
class: class-db and class-mysqldb in 2006 (there was already a sqlite
wrapper too at this time)
Over the time i added it some stuff as some methods to paginate results
and one of my favourite the smart question marks in conditions strings.
(still in 2006). I also added the possibility to have a single
instance of the same database connection (since 2007) and a new
decorator dbProfiler class to help profiling your application in 2008
and there we are.

#- How to use
you can find some sample of usage in the example file provided with the
library. you may additionnaly find some documentation at

#- contribution, bug report and feedback
Contribution, feedback and bug report are ALWAYS apreciated so don't
hesitate to send me a mail i'll always reply to you.
Also you can leave you bug reports at the online at
but please first check for any previous report at
Contribution to the wiki is appreciated too.

  Classes of Jonathan Gotti  >  class sqlite  >  Download Download .zip .tar.gz  >  Support forum Support forum (3)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: class sqlite
Base name: sqlitedb
Description: SQLite database access wrapper
Version: 1.0.0
PHP version: -
License: GNU Lesser General Public License (LGPL)
All time users: 2764 users
All time rank: 1330
Week users: 1 user
Week rank: 631 Up
  Groups   Rate classes User ratings   Dependencies  
  Dependents   Applications   Related pages   Files Files  

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

  User ratings  
Not enough user ratings

  Packages needed by this class  
Class DownloadWhy it is needed Dependency
Base DB Download .zip .tar.gz base abstraction class Required

  Other classes that need this package  
Class Why it is needed Dependency
HTML dbtree use instead of class mysql to work on a sqlite database Conditional

  Applications that use this package  
my personal code repository

Add link image If you know an application of this package, send a message to the author to add a link here.

  Related pages  
base DB TRAC site
wiki + svn repository for class-db

  Files folder image Files  
File Role Description
Plain text file class-sqlite.php Class file to include in your script
Accessible without login Plain text file class-sqlite3db.php Class this one use the sqlite3 extension for php5 instead of the native embedded sqlite2
Plain text file README Doc. important notice
Plain text file sample.php Example example usage
HTML file sqlitedb_doc-2006-05-08.html Doc. doc

Install with Composer Install with Composer - Download Download all files: sqlitedb.tar.gz
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.