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.
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.54, for debian-linux-gnu (x86_64) using readline 6.3 # sample output
To start this example run commands listed below.
Clone the repository from github.com:
$ git clone git@github.com:anychart-integrations/php-mysql-template.git
Navigate to the repository folder:
$ cd php-mysql-template
Ensure you have php-mysql being installed, run:
$ php -m
If there isn't mysql in the list 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
Drop index.php, data.php and css folder to a folder where you serve your .php files and your server (e.g. Apache or Nginx) could get them. Open browser at an appropriate url.
Now you can update MySQL database data, run (don't forget to use -u -p flags if you need):
$ mysql < database_backup.sql
The chart on web page will be updated automatically.
Workspace
Your workspace should look like:
php-mysql-template/
static/
css/
style.css # css style
index.php # main PHP file including HTML template
data.php # PHP file which loads data from MySQL
save-data.php # PHP file which save data to MySQL
database_backup.sql # MySQL script to update database data
LICENSE
README.md
Technologies
Further Learning
License
AnyChart PHP/MySQL integration sample includes two parts:
- Code of the integration sample that allows to use Javascript library (in this case, AnyChart) with 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. sales@anychart.com