PHP Classes
elePHPant
Icontem

PersistClass: DB access wrapper & storing objects in DB tables

Recommend this page to a friend!
  Info   View files View files (21)   DownloadInstall with Composer Download .zip   Reputation   Support forum (2)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2009-08-17 (7 years ago) RSS 2.0 feedNot enough user ratingsTotal: 523 This week: 1All time: 5,411 This week: 1,047Up
Version License PHP version Categories
persistclass 1.0Freely Distributable5.0PHP 5, Databases, Design Patterns
Description Author

This package provides access relational databases. Attempts to focus on simplicity and convenience by eliminating the need of boiler-plate, unmeaningful code.

Features:

- establish database connections (MySQL, Oracle, more to come)
- execute SQL queries
- parse query results
- convenience methods (read single row or value, etc..)
- data escaping (against SQL injection, HTML escaping for outputs)
- transaction handling
- strict error handling - no more undetected errors
- object persistence - storing and retrieving PHP objects in db tables
- possibility to implement support for not yet supported DBs

Check the included demos to see some working examples of its features.

Picture of Bob Gombocki
Name: Bob Gombocki <contact>
Classes: 2 packages by
Country: Norway Norway

  Files folder image Files  
File Role Description
Files folder imagepersistclass (1 file, 1 directory)
Accessible without login HTML file manual.html Doc. Manual
Accessible without login Plain text file demo1-connection.php Example Creating a DB connection
Accessible without login Plain text file demo2-simpledboperations.php Example Executing DB queries
Accessible without login Plain text file demo3-classpersistence.php Example Object mapping
Accessible without login Plain text file demo4-errorhandling.php Example Error handling
Accessible without login Plain text file demo5-advancedpersistence.php Example Multiple connections, advanced mapping
Accessible without login Plain text file demo6-transactionhandling.php Example Transaction handling
Accessible without login Plain text file demo7-optimizingscalability.php Example Optimizing for high-scale
Accessible without login Plain text file demo8-orm.php Example Custom column mapping
Accessible without login Plain text file demotable.sql.txt Example Test data table
Accessible without login Plain text file newdbsupportimplementationguide.html Doc. Support for other DBs implementation guide

  Files folder image Files  /  persistclass  
File Role Description
Files folder imagedbconnection (4 files, 1 directory)
  Plain text file PersistClass.php Class Main ORM class

  Files folder image Files  /  persistclass  /  dbconnection  
File Role Description
Files folder imageexception (5 files)
  Plain text file DbConnection.php Class DB connection layer
  Plain text file DbConnectionMysql.php Class MySQL implementation
  Plain text file DbConnectionOracle.php Class Oracle implementation
  Plain text file DbConnectionPool.php Class Connection pool

  Files folder image Files  /  persistclass  /  dbconnection  /  exception  
File Role Description
  Plain text file ConnectionException.php Class Exception for connection problems
  Plain text file DbException.php Class Exception for any problem
  Plain text file NoDataException.php Class Exception for wrong data field
  Plain text file NoResultException.php Class Exception for no result retrieved
  Plain text file QueryException.php Class Exception for query errors

 Version Control Unique User Downloads Download Rankings  
 0%
Total:523
This week:1
All time:5,411
This week:1,047Up
User Comments (2)