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,633 All time: 310 This week: 197Up
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: 45
All time rank: 724 in France France
Week rank: 238 Down6 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  
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

Downloadmysqldb-2009-12-24.zip
Downloadmysqldb-2009-12-24.tar.gz
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:6,633
This week:0
All time:310
This week:197Up
User Ratings User Comments (2)
 All time
Utility:75%StarStarStarStar
Consistency:73%StarStarStarStar
Documentation:78%StarStarStarStar
Examples:80%StarStarStarStarStar
Tests:-
Videos:-
Overall:60%StarStarStarStar
Rank:1295
 
Excellent
12 years ago (kishore kumar)
80%StarStarStarStarStar
I have been using daily this class for more than a year now.
13 years ago (gaspard)
72%StarStarStarStar
 
For more information send a message to info at phpclasses dot org.