Login   Register  
PHP Classes
elePHPant
Icontem

PersistClass: DB access wrapper & storing objects in DB tables

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  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 (5 years ago) RSS 2.0 feedNot enough user ratingsTotal: 509 All time: 5,255 This week: 1,379Up
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
Age: ???
All time rank: 23088 in Norway Norway
Week rank: 1754 Up6 in Norway Norway Up

  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:509All time:5,255
 This week:0This week:1,379Up
 User Comments (2)