Persistclass Php Class | NBhosting.nl

Databases: PersistClass
Zsolt Herpai (contact me)
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.

Click here for detailed information about this class on phpclasses.org

manual.html

Doc.

Manual

demo1-connection.php

Example

Creating a DB connection

demo2-simpledboperations.php

Example

Executing DB queries

demo3-classpersistence.php

Example

Object mapping

demo4-errorhandling.php

Example

Error handling

demo5-advancedpersistence.php

Example

Multiple connections, advanced mapping

demo6-transactionhandling.php

Example

Transaction handling

demo7-optimizingscalability.php

Example

Optimizing for high-scale

demo8-orm.php

Example

Custom column mapping

demotable.sql.txt

Example

Test data table

persistclass/dbconnection/DbConnection.php

Class

DB connection layer

persistclass/dbconnection/DbConnectionMysql.php

Class

MySQL implementation

persistclass/dbconnection/DbConnectionOracle.php

Class

Oracle implementation

persistclass/dbconnection/exception/ConnectionException.php

Class

Exception for connection problems

persistclass/dbconnection/exception/DbException.php

Class

Exception for any problem

persistclass/dbconnection/exception/NoDataException.php

Class

Exception for wrong data field

persistclass/dbconnection/exception/NoResultException.php

Class

Exception for no result retrieved

persistclass.tar.gz

All files

persistclass.zip

All files