PHP Classes

PHP MySQL Compare Two Tables: Show the differences between tables and columns

Recommend this page to a friend!
     
  Info   Example   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 237 All time: 8,070 This week: 38Up
Version License PHP version Categories
mysqlcompare 1.0.0MIT/X Consortium ...5HTML, PHP 5, Databases, Tools
Description 

Author

Janes Oosthuizen

This package can show the differences between tables and columns.

It can connect to one or two MySQL database servers and compares the structure of their tables.

The class outputs a HTML table showing the differences between the tables of the two databases, as well the differences between the columns of each of the tables that are present in the two databases.

Picture of Janes Oosthuizen
  Performance   Level  

Level 2 StarStar

 

Example

<?php
/**
 * Copyright (c) Janes Oosthuizen (hello@janes.co.za)
 *
 * Licensed under The MIT License
 * For full copyright and license information, please see the LICENSE.txt
 * Redistributions of files must retain the above copyright notice.
 *
 * @copyright (c) Janes Oosthuizen (hello@janes.co.za)
 * @since 1.0.0
 * @license https://opensource.org/licenses/mit-license.php MIT License
 */

include("mysql_compare.php");

$comp = new DatabaseCompare();
$comp->SelectDatabaseOne("database_name_1");
$comp->SelectDatabaseTwo("database_name_2");
$comp->ConnectDatabaseOne("localhost","user","password");
$comp->ConnectDatabaseTwo("localhost","user","password");
$comp->displayMatches = false;
$comp->DoComparison();

  Files folder image Files (3)  
File Role Description
Accessible without login Plain text file example.php Example Example script
Accessible without login Plain text file LICENSE.txt Lic. License text
Plain text file mysql_compare.php Class Class source

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
Downloadmysqlcompare-2018-08-17.zip 3KB
Downloadmysqlcompare-2018-08-17.tar.gz 2KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 100%
Total:237
This week:0
All time:8,070
This week:38Up
User Comments (1)
changed to mysqli and works perfectly.
5 years ago (Fred kembo)		70%StarStarStarStar
 

  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.