PHP Dashboard

View your data by graph

We provide the template of Dashboard that integrated with Database. It is very simple code and easy to develop


  • Clean and user friendly layout
  • Graphic data from database
  • Ajax form (CRUD)
  • 100% Customization Features
  • Clean PHP Codeigniter Framework


If you want to do demo, please go to


If your server meets the following requirements, this app will run on it.

Server Side Requirements

  • Server Linux/Unix (Recommended), Windows or Mac OS X
  • Web Server Apache (Recommended), Microsoft IIS or any similar web server
  • PHP Version PHP v5.4 or above
  • Database MySQL v5 or higher suggested

Client Side Requirements

  • Chrome
  • Firefox
  • Safari
  • Internet Explorer 9+


The installation is a simple process that should not take more than a few minutes. The following installation guide will help you to install the app on your server.

Upload to server

  • Upload the webapp folders and files to your server. Normally the index.php file will be at your root.
  • Unzip webapp folders.
  • Installation on Server Folder (index.php is on root).
  • Installation on Subdomain.

Import Database

The application needs a MySQL database to store data. You can either use your existing MySQL database or create a dedicated MySQL database for the application on your server. Take note of the username, password, database name, and hostname as you create the database. You will enter this information for database configuration.

  • Create New Schema on your MySql Database
  • Import file database.sql

Database Configuration

For the database configuration, open the application/config/database.php file with a text editor and set your database settings.

$active_group = 'default';
$query_builder = TRUE;

$db['default'] = array(
    'dsn'   => '',
    'hostname' => 'localhost',      
    'username' => 'root',                   //fill with your username
    'password' => '',                       //fill with your password
    'database' => 'database_db',           //fill with your schema
    'dbdriver' => 'mysqli',
    'dbprefix' => '',
    'pconnect' => FALSE,
    'db_debug' => (ENVIRONMENT !== 'production'),
    'cache_on' => FALSE,
    'cachedir' => '',
    'char_set' => 'utf8',
    'dbcollat' => 'utf8_general_ci',
    'swap_pre' => '',
    'encrypt' => FALSE,
    'compress' => FALSE,
    'stricton' => FALSE,
    'failover' => array(),
    'save_queries' => TRUE

Default Controller

For setup the default controller, open the application/config/routes.php file with a text editor.

$route['default_controller'] = "default_controller";
$route['404_override'] = '';

Structure Model

This model use five methods, there are:

  • getByQuery. to select the data.
  • insert. to insert the data.
  • insertRet. to insert the data and return the id.
  • update. to update the data.
  • delete. to delete the data.
class ModelName extends CI_Model {        

    public function __construct() {

    public function getByQuery($qry){
    public function insert($table, $data){
    public function insertRet($table, $data){
    public function update($table, $data, $where){
    public function delete($table, $where){   

Structure View

This application is a fixed layout with header, menu and main. All of the information within the main content area is in folder view/pages and user template in folder view/template and the file is table_tmplt.php. The menu content is in folder view/template and the file is menu_incld.php. The header content is in folder view/template and the file is header_incld.php.

  • table_incld.php
  • menu_incld.php
  • table_tmplt.php

Structure Controller

We created the contoller with standarization and the code adheres to PSR standards. Every contoller user our method standarization, there are:

  • index. in this method you should provide the data for the main page.
  • gridview. to show into the table, you should retrieve data from database and declare it in this method.
  • generateId. this method is a function to generate id or unique id.
  • form. to show data and form that you can insert and update.
  • save. this method will save the data to the database.
  • view. to show data.
  • delete. this method will delete the data.
class ControllerName extends CI_Controller {    
    public function __construct() {

    public function index(){

    public function gridview(){

    public function generateId(){

    public function save(){

    public function form(){

    public function delete(){

Sources and Credits

I've used the following framework and theme as listed.

  • Codeigniter Framework from EllisLab
  • AdminLTE Theme from Almsaeed Studio


If you have any questions relating to this app or want to customization, please feel free to email us at :