PHP Classes

class mysql: MySQL database access wrapper

Recommend this page to a friend!
  Info   View files View files (5)   DownloadInstall with Composer Download .zip   Reputation   Support forum (2)   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 60%Total: 6,636 All time: 311 This week: 204Up
Version License Categories
mysqldb 1.0.0GNU General Publi...Databases
Description Author

This class is a wrapper to access MySQL databases.

It provides functions for opening and closing connections to a MySQL server, list databases, tables and table fields, execute SQL insert, update delete and select queries and retrieve the result set data into arrays, dump database data to a file.

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

###---###---###---###--- 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.

  Files folder image Files  
File Role Description
Accessible without login Plain text file class-mysqldb.php Class file to include in your script
Plain text file class-mysqlidb.php Class same as class mysql but using mysqli driver
HTML file mysqldb_doc-2005-04-24.html Doc. doc
Plain text file README Doc. readme file
Plain text file sample.php Example example usage 17KB
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  
This week:0
All time:311
This week:204Up
User Ratings User Comments (2)
 All time
13 years ago (kishore kumar)
I have been using daily this class for more than a year now.
14 years ago (gaspard)
For more information send a message to info at phpclasses dot org.