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: 312 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: 287 Down10 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 17KB
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,636
This week:0
All time:312
This week:204Up
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:1299
 
Excellent
13 years ago (kishore kumar)
80%StarStarStarStarStar
I have been using daily this class for more than a year now.
14 years ago (gaspard)
72%StarStarStarStar