PHP Classes

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

Recommend this page to a friend!
     
  Info   Example   Screenshots   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStar 39%Total: 420 All time: 6,397 This week: 35Up
Version License PHP version Categories
mysqlinfo 1.0.7Freely Distributable5PHP 5, Databases, System information, P...
Description 

Author

Stefan Kientzler

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: 19 packages by
Country: Germany Germany
Age: 57
All time rank: 71346 in Germany Germany
Week rank: 46 Up2 in Germany Germany Up

Level 5 StarStarStarStarStar

 Innovation award
Innovation award
Nominee: 11x

Winner: 6x

Recommendations

What is the best PHP mysql report class?
Build a nice report

What is the best PHP mysql report generator class?
How to generate report from MySQL data

Example

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

/**
 * generating report for MySQL Database
 *
 * @version 1.1.0
 * @author Stefanius <[email protected]>
 */

$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 (1)  
  • MySqlInfoScreenshot.jpg
  Files folder image Files (6)  
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 (6)  /  images  
File Role Description
  Accessible without login Plain text file mysql_logo.png Data image

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
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:420
This week:0
All time:6,397
This week:35Up
 User Ratings  
 
 All time
Utility:58%StarStarStar
Consistency:58%StarStarStar
Documentation:-
Examples:50%StarStarStar
Tests:-
Videos:-
Overall:39%StarStar
Rank:3864
  

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.