Every week I look at the PHP Classes newsletter to see if there are any cool new submissions. This one is perhaps the most exciting and promising that I've seen in a while!
I blogged a while ago about a PHP Datagrid class. Basically, it's an easy way to interact with the data in a table (view, add, modify records), without having to build an interface from scratch. However, the class turned out to be a pain to implement, I never got it to work fully.
So, my next venture will be to implement this new class: DBNavigator.
Like the PHP Datagrid class, it can be used to browse and modify data in a MySQL database. The cool difference is that is uses an AJAX interface to edit, insert, and search the MySQL database tables! I was looking for a demo on the author's site, but couldn't find it (the site's in Italian). But it boasts some cool features:
- Update and delete multiple records at once.
- Prevent editing/deleting records by simultaneous users (locking).
- Records can be data-bound to form inputs.
- Uploading files to specific folders, and ensuring that the uploaded files don't exist already.
- List and search for records to be edited or deleted. Search fields support AJAX based auto-complete suggestions. Search results can be saved to CSV files.
- Pagination (paging) links in tables with different colors or CSS styles for different rows.
Hopefully this one will be easier to implement!