Open Source Dashboard overview:

Open source dashboard is the most comprehensive competitive drag-drop tool for the dashboard in which source code is released under a license and the users are granted the rights to use, change, and distribute the open source dashboard to anyone and for any purpose. This Open Source tool is written in the most widely used Open Source platform such as PHP, Apache, MySQL, HTML5 and JavaScript.


What is an Open Source Dashboard?

Open-source dashboard is a type of data visualization tool in which source code is released under a license in which users are granted the rights to study, read and modify changes, and distribute the tool to anyone and for any purpose. Unlike traditional data visualization software distributed in an unchangeable compiled format, Our enterprize edition of open-source dashboard is delivered with both full source code and non-compiled formats, allowing open code modification.


Create interactive dashboards with the best open source dashboard tool

This SQL dashboard open source empowers the non-technical user with the ability to connect the database using PDO, the most commonly and widely using database connection to fetch data from open source platform such as MySQL, MS SQL, SQLite, ORACLE, PostgreSQL, Sybase and Cubrid, CSV and MS EXCEL files, and create interactive dynamic dashboards and business intelligence reports. This open source dashboard provides a variety of chats like line chart, scatter chart, bar chart, pie chart, donuts chart, bubble chart, stack chat, area chart, heatmap chart, sankey diagrams, and choropleth map. The user can download these dynamic charts in PNG image format. This open source dashboard enables to customize dashboard layout with the most powerful drag-and-drop features to place each chart exactly where you want for optimal representation. This drag-and-drop layout is fully responsive and compatible with PC, mobile phone and tablets using the most powerful front-end open source dashboard framework such as D3.js and Bootstrap framework.

The dashboards produced by our open source dashboard tools are pure dynamic and based the best open source dashboard frameworks including D3.js which is the most widely used JavaScript library for producing dynamic and interactive data visualizations in web browsers. Our dashboard uses the widely implemented SVG, HTML5, and CSS standards which can be created either static or real-time data coming from a variety of data sources.

Getting Started

In our dashboard PHP MySQL open-source example, we will be fetching data from MySQL open source database and build a simple dashboard and then will generate PHP source code for our web application. For this, we will be demonstrating with our freely available open-source drag and drop based open source web dashboards. To install and run the open-source dashboard php, following are the requirements.

 

Requirements

This open source dashboard can be installed any platforms like Windows, Linux and Ubuntu or any other platforms support Apache, Nginx etc.

  • PHP Version 5.6 or later
  • Apache 2 or later
  • Windows 7 or later /Linux 3 or later
  • Firefox 52, Chrome 57, IE 8

 

Installation

There is a Free version of the Open Source Dashboard available for trail bases

 

Open Source Dashboard examples

Before really going into connecting the database and fetching the data with this web dashboard open source software, make sure that your Web Server (like Apache, Nginx, etc) is configured to display documents in the folder which will contain dashboard. Read-Write permission to the folders and sub-folders of dashboardbuilder i.e chmod -R 777 dashbboardbuilder-v3-FREE. Check your browser inspector/console to make sure that there isn't any error being reported, and all the Open Source Dashboard builder files are being loaded properly.


How to create your first dashboard with open source dasbhaord tool

In this section, we will walk you through with the step by step on how to create your first inertactive open source dahsobard with this great open source tool.

 

 

Welcome Screen

 

This is the main panel of the Open Source Dashboard an HTML5 based fully responsive interface built in PHP, HTML, JavaScript and CSS. The interface has a minimal design with a drag-and-drop feature that allows you to add multiple chart panel to customize the dashboard on according to the way you want.

  • Following screen will appear. Select Database from data source tab. Select SQLite from the drop down list of Database, Enter your "../data/Northwind.db" in the DB name field and Save changes    as mentioned in the screen.

 

Select your Database

 

 

  • A green tick mark with Database  will appear when your database is successfully connected.

 

Dashboard Preference

 

  • Select the gear icon for your Dashboard MySQL open source preference.

 

Database Connected

 

  • The following screen will appear. List of the tables will appear.

 

Chart Preference

 

  • Enter your SQL statement in text box, SQL field as the following manner

SELECT strftime('%Y-%m',o.shippeddate) as xaxis, sum(d.quantity) as yaxis from `order details` d, orders o where o.orderid = d.orderid group by strftime('%Y-%m',o.orderdate) limit 50

  • Click the Run Query button

SQL Statement

 

  • Query Result will appear. Now Select your x-axis data from the drop down list of   and y-axis data from the drop down list of Y .
  • Click Save Changes

 

SQL Query Result

 

  • Charts will be appeared on the screen as shown below.

 

Chart Preference2

 

  • You may adjust the size and the position of the Chart Panel by draging it's corncer.

Chart Preference 3

  • Now Click the Generate   button

 

Chart Preference 4

 

  • PHP dashboard open source code for the chart will automatically generate, you may copy past this code to your PHP application.

 

Auto-generated PHP dashboard open source code



/**
 * DashboardBuilder
 *
 * @author Diginix Technologies www.diginixtech.com
 * Support  - http://www.dashboardbuilder.net
 * @copyright (C) 2018 Dashboardbuilder.net
 * @version 2.1.5
 * @license: license.txt
 */

include("inc/dashboard_dist.php");  // copy this file to inc folder 


// for chart #1
$data = new dashboardbuilder(); 
$data->type =  "line";

$data->source =  "Database"; 
$data->rdbms =  "sqlite"; 
$data->servername =  "";
$data->username =  "";
$data->password =  "";
$data->dbname =  "data\Northwind.db";
$data->xaxisSQL[0]=  "SELECT strftime(^%Y-%m^,o.shippeddate) as xaxis, sum(d.quantity) as yaxis from `order details` d, orders o  where o.orderid = d.orderid group by strftime(^%Y-%m^,o.orderdate) limit 50";
$data->xaxisCol[0]=  "xaxis";
$data->yaxisSQL[0]=  "SELECT strftime(^%Y-%m^,o.shippeddate) as xaxis, sum(d.quantity) as yaxis from `order details` d, orders o  where o.orderid = d.orderid group by strftime(^%Y-%m^,o.orderdate) limit 50";
$data->yaxisCol[0]=  "yaxis";
$data->name = "linechart";
$data->title = "Line Chart";
$data->orientation = "";
$data->xaxistitle = "x-axis title";
$data->yaxistitle = "y-axis title";
$data->showgrid = "";
$data->showline = "";
$data->height = "167";
$data->width = "";
$data->col = "0";
$result[0] = $data->result();

?>

<!DOCTYPE html>
<html> 
<head> 
	<script src="assets/js/dashboard.min.js"></script> <!-- copy this file to assets/js folder --> 
	<link rel="stylesheet" href="//maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css"> <!-- Bootstrap CSS file, change the path accordingly --> 

<style>
@media screen and (min-width: 960px) {
.id0 {position:absolute;margin-top:67px;}

}
.panel-heading {line-height:0.7em;}
#kpi {font-size:34px; font-weight:bold;text-align:center;}
#kpi_legand {font-size:11px; color:#999;text-align:center;}
</style>


</head>
<body> 

<div class="container-fluid main-container">
<div class="col-md-12 col-lg-12 col-xs-12">
<div class="row">
<div class="col-md-4 col-lg-4 col-md-offset-4 col-lg-offset-4 col-xs-12 id0">
<div class="panel panel-default">
<div class="panel-heading">Line Chart</div>
    <div class="panel-body">
        <?php echo $result[0];?>
    </div>
</div>
</div>
</div>
</div>
</div>
</body>

 

 

Open Source License

This auto-generated PHP source code generated by our Open Source Dashboard PHP is under MIT license, the most popular software license on GitHub, ahead of any GPL variant and other free and open-source software (FOSS) licenses.

This MIT license puts a very limited restriction on reuse and has, therefore, excellent license compatibility. This license permits reuse within proprietary the source code generated by our dashboard tool open source, provided that all copies of the source code include a copy of the MIT License terms and the copyright notice. This license is also compatible with many copyleft licenses, such as the GNU General Public License (GPL). The source code generated by our open source tool can be integrated into GPL software.

The source code generated by the Opensource Dashboards allow you to customize as per your desire needs and can be used an anywhere you want. You can find the complete information about the license here

 

Conclusion

Now we have a Dashboard open source PHP code which can be used with any web application and can be customized to fit the requirements of the web design. The project also offers free and paid plans. You can also download Free Dashboard Software Open Source version. The code for free open source dashboard can be found on GitHub under this license

Best of all, with our Standard and Enterprise licenses include 100% source code, for you to enhance the functionality or incorporate the Open Source Dashboard into your web application or any PHP software solutions/products, analytics/data science/data warehouse enterprise systems or Joomla, Wordpress or Drupal sites.

All editions of our dashboard tools open source series are still fully functional, for sale and supported and provides increasing levels of support to address the queries of users and developers.

Dashboard software open source can also be implemented using an online API where you don’t have to mix with a PHP script or PHP source code. The online API uses universal HTML code which can be used in any platform. The data will be added or retrieved from the database using the API. You may find more information about the Online Dashboard.


You may want to take a look at our complete documentation and video tours of the latest version along with a live tour of user interface and step by step instructions for performing key features.


Download Open Source Dashboard