PHP get_table_structure Examples

Example #1

File: database_structure.php Project: vinod-co/centa

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";
}

Example #2

File: admin_db_sauve.php Project: kakargias/php-conges

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);
        }
    }
}