[FreeTrade-dev] Code to display tables and fields of database

[Kent Nguyen]

Hi,

I've attached a code to display tables and fields corresponding to a 
database.  Code is embedded below.

I do this because I wanted a reference to use while I write my FreeTrade 
code.  Leon also made a PDF diagram of FreeTrade.

This code can go under contrib.

-- 
Kent Nguyen 
Linux and KDE in every library
http://www.mslinux.com/research/library


/*********************  Code **************************/

<?

/*
** File:  dbstructure.php
** Quick PHP script to parse the database for fields and types
**
*/

    define("DATABASE_HOST", "localhost");
    define("DATABASE_USER", "changeme");
    define("DATABASE_PASSWORD", "changeme");
    define("DATABASE_NAME", "changeme");
    //establish persistent connection
    $DatabaseLink = mysql_pconnect(DATABASE_HOST, DATABASE_USER, 
DATABASE_PASSWORD);
    if(!$DatabaseLink)
    {
        print("<!--mysql_pconnect " .
            mysql_errno() . ": " .
            mysql_error() . "-->\n");
    }

    //select database
    if(!(mysql_select_db(DATABASE_NAME, $DatabaseLink)))
    {
        print("<!--mysql_select_db " .
            mysql_errno() . ": " .
            mysql_error() . "-->\n");
    }

/********************************************************/

$Query = "show tables";
$DatabaseResult = mysql_query($Query, $DatabaseLink);
while($DatabaseRow = mysql_fetch_object($DatabaseResult))
{
        $table = $DatabaseRow->Tables_in_chung;
        print("Table: <font color=green><b>$table</b></font>\n");
        print("<table border=1>");
        print("<tr><td><b>Field</b></td><td><b>Type</b></td><td>" .
                "<b>Null</b></td><td><b>Key</b></td><td><b>Default</b>".
                "</td><td><b>Extra</b></td></tr>");
        // Let's print out all the table property in a table
        $Query2 = "show columns from $table";
        $DatabaseResult2 = mysql_query($Query2, $DatabaseLink);
        while($DatabaseRow2 = mysql_fetch_object($DatabaseResult2))
        {
                $field = $DatabaseRow2->Field;
                $type = $DatabaseRow2->Type;
                $null = $DatabaseRow2->Null;
                $key = $DatabaseRow2->Key;
                $default = $DatabaseRow2->Default;
                $extra = $DatabaseRow2->Extra;

                print("<tr><td>$field</td><td>$type</td><td>$null</td>".
                        "<td>$key</td><td>$default</td><td>$extra</td></tr>\n");
        }
        print("</table><br>\n");
}
?>





_______________________________________________
FreeTrade-dev mailing list
[EMAIL PROTECTED]
http://share.whichever.com/mailman/listinfo/freetrade-dev