PHP Database Access Through Arrays

The PHP Database Access Through Arrays project is a database access tool designed for easy data extraction from MySQL tables using array-style access. It makes use of SPL and several classes and iterator interfaces to facilitate the retrieval of data from MySQL databases.

This project offers a convenient way to access MySQL data as if it were an array. For example, users can easily add a new row to a table using the following code:

$DB['test_table'][] = array(
'name' => 'first',
'value' => 'the first row'
);

Additionally, the tool provides a for-each loop to iterate over each row in the table. An example of its use can be seen in the following code:

foreach ($DB['test_table'] as $i => $row) { ... }

Users can also update or delete specific rows from a table effortlessly. For instance, users can change the value of the first row's 'value' column to '1st' by writing:

$DB['test_table']['first']['value'] = '1st';

And similarly, to delete the first row:

unset($DB['test_table']['first']);

Requirements for this project include PHP 5.1.

Recent updates to this project include changes in how array offsets are mapped to conditions for selecting a row, improved security through unique field usage, and careful handling of SQL data types with constraints checking. Additionally, users can disable inboxing of SQL data types through a specific property. A new hierarchy of exceptions also permits more fine-grained catching of exceptions.