function compare_tables($db_master, $db_test, $table_name, $masterdb, $testdb) { $master_details = get_table_structure($db_master, $table_name, $masterdb); $master_field_no = count($master_details); $test_details = get_table_structure($db_test, $table_name, $testdb); $test_field_no = count($test_details); if ($test_field_no == 0) { $class = 'dkred'; echo "<table class=\"nonexist\" cellpadding=\"1\" cellspacing=\"0\" border=\"1\">"; } else { $class = 'grey'; echo "<table cellpadding=\"1\" cellspacing=\"0\" border=\"1\">"; } echo "<tr><td class=\"{$class}\">Field</td><td class=\"{$class}\">Type</td><td class=\"{$class}\">Null</td><td class=\"{$class}\">Key</td><td class=\"{$class}\">Default</td><td class=\"{$class}\">Extra</td></tr>\n"; for ($i = 0; $i < $master_field_no; $i++) { echo "<tr>"; $master_line = $master_details[$i]; if (isset($test_details[$i])) { $test_line = $test_details[$i]; for ($col = 0; $col < 6; $col++) { $text = format_text($master_line[$col]); if ($master_line[$col] === $test_line[$col]) { echo "<td>{$text}</td>"; } else { echo "<td class=\"err\">{$text}</td>"; } } } else { for ($col = 0; $col < 6; $col++) { $text = format_text($master_line[$col]); echo "<td class=\"err\">{$text}</td>"; } } echo "</tr>"; } // Display extra fields in test table. if (count($test_details) > count($master_details)) { for ($i = $master_field_no; $i < $test_field_no; $i++) { $test_line = $test_details[$i]; for ($col = 0; $col < 6; $col++) { $text = format_text($test_line[$col]); echo "<td class=\"err\">{$text}</td>"; } } } echo "</table>\n<br />\n"; }
function commit_sauvegarde($type_sauvegarde, $DEBUG = FALSE) { $PHP_SELF = $_SERVER['PHP_SELF']; $session = session_id(); header("Pragma: no-cache"); header("Content-Type: text/x-delimtext; name=\"php_conges_" . $type_sauvegarde . ".sql\""); header("Content-disposition: attachment; filename=php_conges_" . $type_sauvegarde . ".sql"); // // Build the sql script file... // $maintenant = date("d-m-Y H:i:s"); echo "#\n"; echo "# PHP_CONGES\n"; echo "#\n# DATE : {$maintenant}\n"; echo "#\n"; //recup de la liste des tables $sql1 = "SHOW TABLES"; $ReqLog = SQL::query($sql1); while ($resultat = $ReqLog->fetch_array()) { $table = $resultat[0]; echo "#\n#\n# TABLE: {$table} \n#\n"; if ($type_sauvegarde == "all" || $type_sauvegarde == "structure") { echo "# Struture : \n#\n"; echo get_table_structure($table); } if ($type_sauvegarde == "all" || $type_sauvegarde == "data") { echo "# Data : \n#\n"; echo get_table_data($table); } } }