PhpMyCodeGenerator and PhpMyCellScript

Installation

Requirements

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 - http://www.autoitscript.com/site/autoit/

    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.json
or
controlpanel.bat run_script
or
controlpanel.sh run_script

Web interface

If PHP 5.4 is used, you can start the PHP built-in web server by:
controlpanel.sh web
and then access the PhpMyCodeGenerator web interface by:
http://localhost:8000

How to update PhpMyCodeGenerator?

You can update PhpMyCodeGenerator to the latest version via the control panel by:
controlpanel.bat update
or
controlpanel.sh update
You can also update PhpMyCodeGenerator via the web interface of the control panel.