Skip to main content

Compare 2 mysql databases

Below code will list all the tables with fields (& type) and total records in each table, so that we can verify whether fields are same in both database fields and record counts.
<?php
mysql_connect("localhost", "user1", "pwd1") or die(mysql_error());
mysql_select_db("db1") or die(mysql_error());

$tables = array('tbl1', 'tbl2','tbl3');

echo "<table  border='1' style='float: left'>";
foreach($tables as $tbl){
  $sel = "SELECT COUNT(1) FROM $tbl";
  $res = mysql_query($sel);
  $rec = mysql_fetch_row($res);
 
  echo "<tr><th colspan='2'>$tbl ($rec[0])</th></tr>";
  $sel1 = "SHOW FIELDS FROM $tbl";
  $res1 = mysql_query($sel1) or die($sel1.mysql_error());
  while($rec1 = mysql_fetch_row($res1)){
    echo "<tr><td>$rec1[0]</td><td>$rec1[1]</td></tr>";
  }
}
echo "</table>";
mysql_close();
mysql_connect("localhost", "user2", "pwd2") or die(mysql_error());
mysql_select_db("db2") or die(mysql_error());
echo "<table  border='1' style='float: left'>";
foreach($tables as $tbl){
  $sel = "SELECT COUNT(1) FROM $tbl";
  $res = mysql_query($sel);
  $rec = mysql_fetch_row($res);
 
  echo "<tr><th colspan='2'>$tbl ($rec[0])</th></tr>";
  $sel1 = "SHOW FIELDS FROM $tbl";
  $res1 = mysql_query($sel1) or die($sel1.mysql_error());
  while($rec1 = mysql_fetch_row($res1)){
    echo "<tr><td>$rec1[0]</td><td>$rec1[1]</td></tr>";
  }
}
echo "</table>";
?>
Labels:

Comments

Post a Comment

Want to tell something about this post. Please feel free to write...

Popular posts from this blog

PHP Code Review Guidelines

General  The code works  The code is easy to understand  Follows coding conventions  Names are simple and if possible short  Names are spelt correctly  Names contain units where applicable  There are no usages of magic numbers  No hard coded constants that could possibly change in the future  All variables are in the smallest scope possible  There is no commented out code  There is no dead code (inaccessible at Runtime)  No code that can be replaced with library functions  Variables are not accidentally used with null values  Variables are immutable where possible  Code is not repeated or duplicated  There is an else block for every if clause even if it is empty  No complex/long boolean expressions  No negatively named boolean variables  No empty blocks of code  Ideal data structures are used  Constructors do not accept null/none values  Catch clause...
Post a Comment
Find more....

PHP script to upload file securely

How to Write a Secure PHP Script for File Uploads File uploads are a common feature in web applications, but they can introduce significant security risks if not handled properly. In this article, we'll walk through the steps to securely upload files to a server using PHP. We'll cover key security measures such as file validation, limiting file types, setting file size limits, and managing file storage. We will also create reusable functions to handle the upload process. 1. Create the HTML Form First, we need an HTML form that allows users to select and upload a file. Ensure that the form uses the POST method and includes the enctype="multipart/form-data" attribute. <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Secure File Upload</title> </head> <body> <form action="upload.php" method="post" enctype="multipart/...
Post a Comment
Find more....

Multiple Checkboxes Validation

This is a regular problem and solution is hardly available on google. When we use multiple checkboxes of same group (same name with square brackets) and you've to read the values from server side, then below solution will help you. Here I'm using jQuery (https://jquery.com/) and jQuery Validate plugin (https://jqueryvalidation.org/) For an example, I've to ask a user which of the listed book they are interested to know about <form id="BooksForm" method="post" name="BooksForm"> <p>Books you are interested in </p> <input class="Books" id="Book1" name="Books[]" type="checkbox" value="1" /> The Inner Game of Tennis <br /> <input class="Books" id="Book2" name="Books[]" type="checkbox" value="1" /> Monk who sold his ferrari <br /> <input class="Books" id="Book3" name=...
Post a Comment
Find more....