PHP 5.3 or higher is needed as PhpMyCodeGenerator makes use of new PHP features, like anonymous functions, namespaces, etc. PHP 5.4 or higher allows you to use the PHP built-in web server.
As PhpMyCodeGenerator was developed on Microsoft Windows with Microsoft Excel initially, so it works best on Microsoft Windows with Microsoft Excel. But as PhpMyCodeGenerator supports Calc later (if PHPExcel is installed), so most functions work on non-Windows platform now.
Some PhpMyCodeGenerator features depend on the following external libraries or programs:
PEAR - http://pear.php.net/
PEAR is used by Selenium as mentioned below.
Selenium - http://seleniumhq.org/
Selenium can be used to automate the browser. Selenium is integrated into PhpMyCellScript via the instructions SELENIUM_START, SELENIUM_DO and SELENIUM_STOP.You can install the Selenium PHP client driver and the Selenium Server via the web interface of the control panel.
AutoIt allows you to write Windows related scripts, like to get clipboard data. AutoIt is integrated into PhpMyCellScript via the instruction AUTOIT.You can install AutoIt via the web interface of the control panel.
jQuery.sheet - http://visop-dev.com/Project+jQuery.sheet
jQuery.sheet allows you to view spreadsheets via the browser.You can install jQuery.sheet via the web interface of the control panel.
PHPExcel - https://github.com/PHPOffice/PHPExcel
PHPExcel allows you to open spreadsheets in different formats on various platforms.You can install PHPExcel via the web interface of the control panel.
WinMerge - http://winmerge.org/
WinMerge is used by the PhpMyCellScript instruction MERGE to merge changes to files.
You need to include the WinMerge installation directory to the system path.
How to start PhpMyCodeGenerator?You can start PhpMyCodeGenerator by:
php example.php example.jsonor
Web interfaceIf PHP 5.4 is used, you can start the PHP built-in web server by:
controlpanel.sh weband then access the PhpMyCodeGenerator web interface by:
How to update PhpMyCodeGenerator?You can update PhpMyCodeGenerator to the latest version via the control panel by:
controlpanel.sh updateYou can also update PhpMyCodeGenerator via the web interface of the control panel.