PHP, Symfony and MySQL Integration Template This example shows how to use AnyChart library with the PHP programming language, Symfony framework and MySQL database.

View on GitHub

Running

To use this sample you must have PHP installed, if not, please, install it as described here; MySQL installed and running, if not, please, check out MySQL download page and follow these instructions; and Composer, if not, please, check out Composer installation guide.

To check your installations, run the following command in the command line:


$ php -v
PHP 5.6.27-1+deb.sury.org~trusty+1 (cli)  # sample output
Copyright (c) 1997-2016 The PHP Group
Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies
    with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2016, by Zend Technologies

$ mysql --version
mysql  Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6. # sample output

$ composer -V
Composer version 1.2.1 2016-09-12 11:27:19 # sample output
                

To start this example run commands listed below.

Clone the repository from github.com:


$ git clone git@github.com:anychart-integrations/php-symfony-mysql-template.git
                

Navigate to the repository folder:


$ cd php-symfony-mysql-template
                

Install dependencies:


$ composer install
                

First time you run it, it will ask you for application parameters:


...
Some parameters are missing. Please provide them.
database_host (127.0.0.1):
                

Just press Enter several times to confirm default parameters.

Ensure you have php-mysql installed, run:


$ php -m
                

If there isn't 'mysql', install it:


$ sudo apt-get install php{your_php_version}-mysql # e.g. sudo apt-get install php5.6-mysql
                

Set up MySQL database, use -u -p flags to provide username and password:


$  mysql < database_backup.sql
                

Run example:


$ php bin/console server:run
                

Open browser at http://127.0.0.1:8000


Workspace

Your workspace should look like:


php-symfony-mysql-template/
    app/
        config/
            ...
            parameters.yml      # MySQL database settings
        Resources
            views/
                ...
                chart.html.twig     # html chart template
    bin/
    src/
        AppBundle/
            Controller/
                DefaultController.php   # main controller
            Entity/
                Fruit.php       # base data model
            ...
        ...
    tests/
    web/
        bundles/
        css/
            style.css       # style
        ...
    .gitignore
    composer.json           # composer project settings
    composer.lock
    database_backup.sql     # MySQL database dump
    LICENSE
    phpunit.xml.dist
    README.md
                    

More about Symfony project directory structure you can read here.


Technologies


Further Learning


License

AnyChart PHP/Symfony/MySQL integration sample includes two parts:

  • Code of the integration sample that allows to use Javascript library (in this case, AnyChart) with PHP language, Symfony framework and MySQL database. You can use, edit, modify it, use it with other Javascript libraries without any restrictions. It is released under Apache 2.0 License.
  • AnyChart JavaScript library. It is released under Commercial license. You can test this plugin with the trial version of AnyChart. Our trial version is not limited by time and doesn't contain any feature limitations. Check details here.

If you have any questions regarding licensing - please contact us. sales@anychart.com