PHP Classes

PHP MySQL Table Information: Creates a PDF report with a MySQL table structure

Recommend this page to a friend!
  Info   View files Example   Screenshots Screenshots   View files View files (5)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 419 All time: 6,404 This week: 63Up
Version License PHP version Categories
mysqlinfo 1.0.7Freely Distributable5PHP 5, Databases, System information, P...


This package can be used to creates a PDF report with a MySQL table structure.

It provides a class to access a MySQL database using MySQLi and query the structure of a database table.

Another class can generate a PDF document to display the details of the MySQL database structure like the table name, MySQL engine, rows, create time, update time and comment.

Innovation Award
PHP Programming Innovation award winner
March 2020

Prize: One official elePHPant Plush Mascott
Sometimes it is necessary to document the structure of a database and show it in a way that it is easier to understand by the members of a team of developers.

This package can generate PDF documents that show details of the structure of tables of a MySQL database. This way the team members can view or print the documents to understand better those document details.

Manuel Lemos
Picture of Stefan Kientzler
  Performance   Level  
Name: Stefan Kientzler is available for providing paid consulting. Contact Stefan Kientzler .
Classes: 19 packages by
Country: Germany Germany
Age: 56
All time rank: 72246 in Germany Germany
Week rank: 18 Up1 in Germany Germany Up
Innovation award
Innovation award
Nominee: 11x

Winner: 6x



require_once 'autoloader.php';

 * generating report for MySQL Database
 * @version 1.1.0
 * @author Stefanius <>

$strDBHost = 'localhost';
 $strDBUser = 'root';
 $strDBPwd = 'xxxx';
 $strDBName = 'xxxx';
$strDBUser = 'hsg';
$strDBPwd = 'kien1';
$strDBName = 'hsg-homepage';
$oDB = mysqli_connect($strDBHost, $strDBUser, $strDBPwd, $strDBName);

$pdf = new MySqlInfoTable($oDB);

// set some file informationv and generall settings
$pdf->setInfo('MySql Information', '', 'Stefan Kientzler');
$pdf->setPageHeader('Overview of Database [' . $strDBName . ']');


  • MySqlInfoScreenshot.jpg
  Files folder image Files  
File Role Description
Files folder imageimages (1 file)
Accessible without login Plain text file MySqlInfo.php Example mysql queries for the report
Accessible without login Plain text file mysqlinfotable.json Data grid formats
Plain text file MySqlInfoTable.php Class class to generate the pdf
Accessible without login Image file mysql_logo.png Icon logo

  Files folder image Files  /  images  
File Role Description
  Accessible without login Plain text file mysql_logo.png Data image 63KB
Downloadmysqlinfo-2021-09-10.tar.gz 63KB
Install with ComposerInstall with Composer
Needed packages  
Class DownloadWhy it is needed Dependency
PHP PDF Table using FPDF Download .zip .tar.gz Base class for PDF creation Required
 Version Control Unique User Downloads Download Rankings  
This week:0
All time:6,404
This week:63Up