CodeCanyon

DB Reader - Database Management

DB Reader - Database Management

DB Reader is an online database/table viewer you can use to quickly show your data for you or your client with only 2 lines of code. You can search and export database data to excel, pdf, print, csv.

The class has the following functions:

  • Lightweight class libary (clean, easy to understand code)
  • Return data in 2 lines of code
  • Easy Integration
  • Return Array & HTML
  • Export (PDF, Excel & CSV)
  • Print from browser
  • Ajax Search
  • Show databases on host (access required)
  • Show tables on database
  • Show table records
  • Reset table records (wipe/auto increment 0)
  • Pagination
  • No refresh needed
  • Update: Image support
  • Update: Responsive
  • Update: Individual Column Search
  • Update: Support PHP 5.3
  • Update: MariaDB Support
  • Update: Change column headers
  • Update: Hide columns
  • Update: Where clause
Demo’s
Full demo
Multi-Table records demo
Only HTML Table demo
Database & Table demo

Easy explanation

Reviews

Easy install

include_once('dbreader.class.php');
$obj = new DBReader('db_username', 'db_pass', 'host');

Class functions:

$obj->showDatabases() // show the databases on the host 
$obj->showTables('database') // shows the tables in the given database 
$obj->showData('database','table') // returns the columns & records in the given table
$obj->resetTable('database','table') // wipes the table & reset the auto increment.
$obj->showHtmlTable('database','table') // returns columns & records as HTML table
$obj->showHtmlTable('downloadmarkt_b','users', array('search_columns')) // returns columns & records as HTML table with column search
Update 22-12-2014
- MariaDB Support
- Change column headers
- Hide columns
- Where clause

Update 05-11-2014

- Export Filtered Data

Update 22-10-2014

- Individual column search
- Support for PHP 5.3

Update 20-10-2014

- Responsive support
- Image support
by
by
by
by
by
by