This software enables accessing MySQL table data similar to accessing arrays using PHP. It allows PHP Database Access Through Arrays.
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.
Version 0.8.0 Alpha: N/A