This example shows how to use Anychart library with the PHP programming language, Laravel framework and MySQL database.
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 [email protected]:anychart-integrations/php-laravel-mysql-template.git
Navigate to the repository folder:
$ cd php-laravel-mysql-template
Install dependencies:
$ composer install
Ensure you have php-mysql, php-mbstring, php-xml being installed, run:
$ php -m
If there isn't 'mysql', 'xml' or 'mbstring' in the list, install it:
# to install php-mysql, run:
$ sudo apt-get install php{your_php_version}-mysql # e.g. sudo apt-get install php5.6-mysql
# to install php-mbstring, run:
$ sudo apt-get install php{your_php_version}-mbstring # e.g. sudo apt-get install php5.6-mbstring
# to install php-xml, run:
$ sudo apt-get install php{your_php_version}-xml # e.g. sudo apt-get install php5.6-xml
Set up MySQL database, use -u -p flags to provide username and password:
$ mysql < database_backup.sql
Run example:
$ php artisan serve
Open browser at http://localhost:8000/
Your workspace should look like:
php-laravel-mysql-template/
app/
...
Http/
...
Controllers/
...
ChartController.php # Main controller to render chart
bootstrap/
config/
database/
public/
...
css/
...
style.css # css style
resources/
...
views
...
chart.blade.php # html template
routes/
...
web.php # routes
storage/
tests/
...
.env # main project settings, MySQL settings here
.env.example
.gitattributes
.gitignore
artisan
composer.json # composer project settings
composer.lock
database_backup.sql # MySQL database dump
gulpfile.js
LICENSE
package.json
phpunit.xml
README.md
server.php
yarn.lock
More about Laravel directory structure you can read here: https://laravel.com/docs/5.3/structure
Language - PHP
Database - MySQL
Web framework - Laravel
AnyChart PHP/Laravel/MySQL integration sample includes two parts:
- Code of the integration sample that allows to use Javascript library (in this case, AnyChart) with Laravel framework, PHP language 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. [email protected]