Data Analyzer – PHP Script

Overview

Data Analyzer is a web tool to create dynamically chart with tabular data connecting with your MySQL database. You are able to create different type of chart using simple or complex select query and save that’s report with layout. There are save just select query, report layout and others settings. When show the report next time then live data come from your connected database depend on your select query. You can create new report, edit existing report, delete existing report and export each report to Excel, PDF as well as Print media format.

Features

  • Creation New Report with Graph and Table
  • Add Different Type of Graph
    • Bar
    • Column
    • Pie
    • Line
    • Area
    • Stack Bar
    • Stack Column
    • Stack Percentage Column
    • Stack Percentage Bar
    • Group Bar
    • Group Column
  • Show Responsive Tabular Data
    • Basic Table
    • Show Total of Numerical Column
    • Ordering by Each Column
    • Searching in Table
    • Column Reorder
    • Pagination
  • Edit Existing Report Individually
  • Deletion Existing Report Individually
  • Export Report to Different Format
    • Excel
    • PDF
    • Print Media
  • Show Report Description of Every Report Individually

Requirements

  • Apache server
  • PHP>=5.4
  • MySQL Database

Instructions

  • Extract the archive file on your machine which you’ve downloaded from codester.
  • Copy the dataanalyzer folder to your application source directory (Like as E:xampphtdocs).
  • Import Database from dataanalyzer folder
  • Change database connection
  • Browse the dataanalyzer using suggested browser

Related