Contents

Answer

Requirements

  • PHP Version 5.6 or later
  • Apache 2 or later
  • Windows 7 or later /Linux 3 or later
  • Firefox 52, Chrome 57, IE 8
  • Additional
  • allow_url_fopen is enabled
  • PDO drivers such as mysql, sqlite are installed
  • Read-Write permission to folders and sub-folders of dashboardbuilder i.e chmod -R 777 dashbboardbuilder-v3-FREE
Answer

Installation

  • Download from https://dashboardbuilder.net
  • Place the files in a directory on the web server. e.g. “…/www/dashboardbuilder/”
  • Unzip the file using Extract Here option to the root folder of "dashboardbuilder"
Answer

Create your first Dashboard

Getting Started

Answer

Select Database as Data Source:

Click the Database icon

PHP Dashboard welcome screen

Now, select Database from Data Source Settings. Enter your host name, username, password and the database name as mentioned in the screen.
Select Database as Data Source

Answer

Click the Database icon

Select Database as Data Source

Now, select Upload from Data Source Settings. XLSX, XLS or CSV can also be selected as data source


Select Database as Data Source

Answer

Select the gear icon for your Chart preference. The following screen will appear
Chart Setting

SQL statement format

Enter your SQL statement in SQL filed as following manner
SELECT sum(salary) as xaxis, DATE_FORMAT(from_date, '%Y/%m') as yaxis FROM salaries GROUP BY DATE_FORMAT(from_date, '%Y/%m') LIMIT 10
You must define your Trace data for X as 'xaxis' and data for Y as 'yaxis' as mentioned above.
Click on the SQL   sign if you want to add more SQL statement

Select the desired table and click  Run Query   button
SQL statement

Select your Chart Type, Trace and its Properties.
DashboardBuilder currently supports, Line, Bar, Stack, Histogram, Area, Pie, Donut and Bubble Chart
SQL statement
Chart Setting

Click  Save Changes   when you finish

Answer

Preview:

On the Chart Prefernece shcreen, click  Save Changes  , Charts will be appeared on the screen as shown below.
Chart Setting

Answer

Adjust size and position:

To adjust the size and the position of the Chart Panel by dragging its corner
Chart Preference

Answer

Save Data:

Click Save   button. The following screen will appear. Give a name to your file and click Save button.
Chart Preference

Answer

New Dashboard

Click New  button. The following screen will appear. Now click Yes.
Chart Preference

Answer

Open an Existing Dashboard

Click Open   button. The foloowing screen will appear. Select your file from the given list
Open an Existing Datashboard

Answer

Generate a PHP Code

Click Generate  button
The following screen will appear with PHP code
Generate PHP source code

Click the Copy+Past button to copy the code and paste into your PHP application
You also need to copy the required API file/folder i.e 'inc/dashboard_dist.php' and 'assets/js/dashboard.min.js' to the folder where your application is running.