PHP Classes

MySQL Access Wrapper: MySQL database access wrapper

Recommend this page to a friend!
  Info   View files View files (11)   DownloadInstall with Composer Download .zip   Reputation   Support forum (3)   Blog (2)    
Ratings Unique User Downloads Download Rankings
StarStarStar 47%Total: 979 All time: 3,708 This week: 220Up
Version License PHP version Categories
db101 1.5.0GNU General Publi...4Databases
Description 

Author

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: 33
All time rank: 1555233 in United States United States
Week rank: 312 Up38 in United States United States Up

  Files folder image Files  
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  /  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  /  cache  /  sql  
File Role Description
  Accessible without login Plain text file placeholder Data The placeholder for the SQL cache folder

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

 Version Control Unique User Downloads Download Rankings  
 0%
Total:979
This week:0
All time:3,708
This week:220Up
User Ratings User Comments (2)
 All time
Utility:68%StarStarStarStar
Consistency:68%StarStarStarStar
Documentation:-
Examples:62%StarStarStarStar
Tests:-
Videos:-
Overall:47%StarStarStar
Rank:2993