Package of classes that provide DBMS independent access and management of databases.
Currently it features:
o BSD style license.
o Dual API call forms:
* Direct driver class object calls
* Global function calls
o Set of functions that call the selected DBMS driver objects functions supporting when possible:
* Database connection setup with support for connection strings
* Operation error handling
* Query constant data conversion
* Direct queries
* Prepared queries
* Query result rows random access
* Retrieve a limit range of rows of a SELECT query.
* Nested transactions
* Large object fields (BLOBs - storing files in the database)
* Database object creation (tables, indexes, sequences)
* DBMS driver supported feature query
o DBMS Drivers classes that support the most important databases being used on the Web.
o Driver conformance test suite to verify if the driver classes are working and features are properly implemented.
o A parser class that is able to interpret DBMS independent database schemas file defined in a custom XML format supporting the following types of objects:
* Tables with fields of the types: text, integer, boolean, date, time, timestamp, decimal, float, character large objects (CLOBs) and binary large objects (BLOBs), auto-increment.
* Primary keys
* Indexes
* Auto incremented sequences
o A manager class that is able to:
* Install a new database from a schema description interpreted by the parser class.
* Ability to compare a previously installed schema with a new schema and only install the changes without affecting data stored after the previous installation or update.
* Dump database structure and contents in the same XML format handled by the parser allowing for moving data between databases of different DBMS vendors.
* Reverse engineer schemas of already installed databases
This class implements a model of the Percetron (Artificial Neural Networks - ANN) that can be trained to recognize patterns in its inputs.
This is similar to the algorithm used on palmtops to recognize words written on its pen pad.
The example that comes with this class demonstrates how it can be used to find people that match the profile an inquiring user that fills a form with questions about personal preferences.
First the perceptron is trained with answers of several people. Then the answers of an inquiring user are converted into values that are fed to the perceptron in order to find profile matches.
This class allows for easy display of a FAQ that is stored in a MySQL database.
This class allows for easy display of a FAQ that is stored in a MySQL database. You can also perform a rudementary search on the questions and answers.
BabelKit is an interface to a universal multilingual database code table.
BabelKit takes all of the programming work out of maintaining multiple database code definition sets in multiple languages.
The code administration and translation page lets you define new virtual code tables, new languages, enter all codes and their descriptions and then translate them into all languages of interest.
Perl and PHP classes retrieve the code descriptions and automatically generate HTML code selection elements in the user's language. This makes internationalization and localization of web sites and database interfaces
much easier.
Image gallery generation class based on templates.
Template based Image gallery generation class.
Example shows how it:- Creates the thumbnails into a folder, and then generates HTML file listing all the thumbnails and links to the original images.
Each class can be used seperately!
Stumble It!
Bookmark in del.icio.us
1. 
