PHP Classes

MySQL Access Wrapper: MySQL 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
StarStarStar 47%Total: 980 All time: 3,711 This week: 488Up
Version License PHP version Categories
db101 1.5.0GNU General Publi...4Databases
Description 

Author

Bogdan Lupandin

This class implements a MySQL database access wrapper. A lot of examples. Well commented code. It can:

- Establish database connections
- Validate SQL queries
- Execute SQL queries and fetch result rows into arrays or objects
- Build SQL queries from lists of parameters
- Manage transactions
- Display query results in HTML tables made of DIV tags
- Caches results
- Added layer of security
- Advanced Debug Capabilities
- Error Logging

Picture of Bogdan Lupandin
Name: Bogdan Lupandin <contact>
Classes: 3 packages by
Country: United States United States
Age: 34
All time rank: 1555235 in United States United States
Week rank: 195 Up19 in United States United States Up

  Files folder image Files (11)  
File Role Description
Files folder imagecache (1 file, 1 directory)
Files folder imagelogs (1 file)
Accessible without login Plain text file db.php Appl. The main Database class
Accessible without login Plain text file example_1.php Example Example of generating the INSERT/UPDATE statement
Accessible without login Plain text file example_2.php Example Example of a tabular view of a database
Accessible without login Plain text file example_3.php Example Example of generating an SQL statement
Accessible without login Plain text file example_4.php Example Example showing the fetch_rowset and fetch_row
Accessible without login Plain text file example_5.php Example Example showing how to undo a previous action
Accessible without login Plain text file example_6.php Example An example which uses the cache
Accessible without login Plain text file vars.xml Conf. The variable page

  Files folder image Files (11)  /  cache  
File Role Description
Files folder imagesql (1 file)
  Accessible without login Plain text file placeholder Data The placeholder for the cache folder

  Files folder image Files (11)  /  cache  /  sql  
File Role Description
  Accessible without login Plain text file placeholder Data The placeholder for the SQL cache folder

  Files folder image Files (11)  /  logs  
File Role Description
  Accessible without login Plain text file sql.txt Data The writeable log file

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
Downloaddb101-2012-05-21.zip 16KB
Downloaddb101-2012-05-21.tar.gz 14KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:980
This week:0
All time:3,711
This week:488Up
User Ratings User Comments (2)
 All time
Utility:68%StarStarStarStar
Consistency:68%StarStarStarStar
Documentation:-
Examples:62%StarStarStarStar
Tests:-
Videos:-
Overall:47%StarStarStar
Rank:3075
  

  Applications that use this package  
No pages of applications that use this class were specified.

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