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: 415 All time: 6,433 This week: 119Up
Version License PHP version Categories
mysqlinfo 1.0.7Freely Distributable5PHP 5, Databases, System information, P...
Description 

Author

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
Winner


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: 18 packages by
Country: Germany Germany
Age: 56
All time rank: 73147 in Germany Germany
Week rank: 14 Up1 in Germany Germany Up
Innovation award
Innovation award
Nominee: 11x

Winner: 6x

Recommendations

Example

<?php
require_once 'autoloader.php';
require_once
'MySqlInfoTable.php';

/**
 * generating report for MySQL Database
 *
 * @version 1.1.0
 * @author Stefanius <s.kien@online.de>
 */

$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 . ']');
$pdf->initGrid('mysqlinfotable.json');
$pdf->setLogo('images/mysql_logo.png');
$pdf->prepare();
$pdf->buildInfo();

$pdf->createPDF('mysqlinfo');
   
   


Screenshots  
  • 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

Downloadmysqlinfo-2021-09-10.zip 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  
 0%
Total:415
This week:0
All time:6,433
This week:119Up