PHP Classes

class sqlite: SQLite database access wrapper

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 60%Total: 2,886 All time: 1,302 This week: 89Up
Version License Categories
sqlitedb 1.0.0GNU Lesser Genera...Databases
Description 

Author

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.

Picture of Jonathan Gotti
Name: Jonathan Gotti is available for providing paid consulting. Contact Jonathan Gotti .
Classes: 13 packages by
Country: France France
Age: 48
All time rank: 724 in France France
Week rank: 216 Down8 in France France Down
Innovation award
Innovation award
Nominee: 4x

Details

###---###---###---###--- 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 http://opensource.org/licenses/lgpl-license.php 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 http://trac.jgotti.net/class-db/wiki #- 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 http://trac.jgotti.net/class-db/newticket but please first check for any previous report at http://trac.jgotti.net/class-db/report/6 Contribution to the wiki is appreciated too.

  Files folder image Files (5)  
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

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadsqlitedb-2009-12-24.zip 12KB
Downloadsqlitedb-2009-12-24.tar.gz 9KB
Install with ComposerInstall with Composer
Needed packages  
Class DownloadWhy it is needed Dependency
Base DB Download .zip .tar.gz base abstraction class Required
 Version Control Reuses Unique User Downloads Download Rankings  
 0%1
Total:2,886
This week:0
All time:1,302
This week:89Up
User Ratings User Comments (2)
 All time
Utility:75%StarStarStarStar
Consistency:75%StarStarStarStar
Documentation:75%StarStarStarStar
Examples:75%StarStarStarStar
Tests:-
Videos:-
Overall:60%StarStarStarStar
Rank:1218
 
this is just the wrapper I'm looking for!
12 years ago (Leon)
80%StarStarStarStarStar
Excellent
15 years ago (kishore kumar)
80%StarStarStarStarStar