Data Workings

This class can be used to access records of an SQL database table as objects.

It can access a SQL database table and retrieve its list columns so it can determine which fields need to be retrieved and stored to map record information to object variables and vice-versa.

It can insert new table records from values set to the respective object variables.

It can also retrieve or delete table records given the primary key value, assuming that the table only has one primary key field.

A changed object may also be saved back to the respective table record.

The class can also execute queries that retrieve multiple records. The queries may be sorted by given field. The range of records returned by the query may also be limited to a given range.

The class supports multiple databases relying on PEAR DB package.