- PHP Version 5.6 or later
- Apache 2 or later, Nginx or any other Servcers support PHP
- Windows 7 or later /Linux 3 or later/Ubuntu or any other platforms support Apache, Nginx etc
- Firefox 52, Chrome 57, IE 8, or any other Browsers support SVG
- 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
- 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"
Create your first Dashboard
- Run the web folder in your browser. e.g. http://localhost/dashboarduiler following welcome screen will appear
Select Database as Data Source:
Click the Database icon
Now, select Database from Data Source Settings. Enter your host name, username, password and the database name as mentioned in the screen.
Click the Database icon
Now, select Upload from Data Source Settings. XLSX, XLS or CSV can also be selected as data source
Publish to the web
Before going to the next step, just make sure that your google sheet is publish to the web:
Step-1: Goto your My Driver folder and right click on the spreadsheet you want to access. Right click "Publish to the web" under the File menu.
Step-2: On the next screen: Select your desire Sheet and "Comma-separated values (csv)" from the drop down you want to retrieve data.
Hit the publish button.
Step-3: Copy the link on the following screen.
Connecting Dashboard Builder with Google Sheet
Step-1: Click the Database icon
Step-2: Now, paste the link of your Google sheet under the File Tab of Data Source Settings.
Select the gear icon for your Chart preference. The following screen will appear
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
Select your Chart Type, Trace and its Properties.
DashboardBuilder currently supports, Line, Bar, Stack, Histogram, Area, Pie, Donut and Bubble Chart
Click Save Changes when you finish
On the Chart Prefernece shcreen, click Save Changes , Charts will be appeared on the screen as shown below.
Adjust size and position:
To adjust the size and the position of the Chart Panel by dragging its corner
Click Save button. The following screen will appear. Give a name to your file and click Save button.
Click New button. The following screen will appear. Now click Yes.
Open an Existing Dashboard
Click Open button. The foloowing screen will appear. Select your file from the given list
Generate a PHP Code
Click Generate button
The following screen will appear with PHP 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.