Connecting PHP 5.3 and Apache Derby / JavaDB

PHP Developers can connect to the Derby database of Floreant POS with the following steps. It has been tested in PHP 5.3 and should be working in PHP 5.2 as well.

PHP has different APIs for different databases and PHP can connect to Apache Derby (formerly known as Cloudscape) with DB2 connectivity. For successful connection we need to go through the following steps.

This opens up interesting possibilities for web developers who want to build web interfaces or reporting dashboards that connect directly to the Floreant POS database. Combined with the upcoming MySQL support, PHP developers will have even more options for building web-based extensions for Floreant POS.