A simple Mysql Data Browser

This Program It can be used to browse Mysql Data. You can make some modifications to make a good MySQL browser.
*/

/*
? Cmd = DB
? Cmd = TABLE & DB = {}
? Cmd = Record & dB ={}& table = {}
*/

$ Host = 'localhost ';
$ User = 'test ';
$ Password = '';

If (! Isset ($ cmd) $ cmd = 'db ';
Switch ($ cmd ){
Case 'db ':
Break;
Case 'table ':
Break;
Case 'record ':
Break;
Default:
$ Cmd = 'db ';
Break;
}

$ Con = @ mysql_connect ($ host, $ user, $ password) or die ('unable to connect '. $ host );

Switch ($ cmd ){
Case 'db ':
$ DBS = mysql_list_dbs ($ con) or die ('mysql _ list_dbs error: '. $ php_errmsg );
Echo 'databases on '. $ host.': <br> '. CHR (13 );
$ Num_rows = mysql_num_rows ($ DBS );
For ($ I = 0; $ I <$ num_rows; $ I ++ ){
$ Db = mysql_tablename ($ DBS, $ I );
Echo '<a href = "'. $ php_self .'? Cmd = TABLE & DB = '.
Urlencode ($ dB). '">'. $ db. '</a> <br>'. CHR (13 );
}
Mysql_free_result ($ DBS );
Break;
Case 'table ':
$ Tables = @ mysql_list_tables ($ db, $ con) or die ('mysql _ list_tables error :'.
$ Php_errmsg );
Echo 'tables on '. $ db.' of '. $ host.': <br> '. CHR (13 );
$ Num_rows = mysql_num_rows ($ tables );
For ($ I = 0; $ I <$ num_rows; $ I ++ ){
$ Table = mysql_tablename ($ tables, $ I );
Echo '<a href = "'. $ php_self .'? Cmd = Record & DB = '.
Urlencode ($ dB). '& table ='. urlencode ($ table). '">'. $ table. '</a> <br> '.
CHR (13 );
}
Mysql_free_result ($ tables );
Echo '<HR> <a href = "'. $ php_self .'? Cmd = DB "> show databases </a> '. CHR (13 );
Break;
Case 'record ':
$ Records = mysql_db_query ($ db, 'select * from'. $ table, $ con) or
Die ('mysql _ db_query error: '. $ php_errmsg );
Echo 'records on '. $ table.': <br> '. CHR (13 );
Echo '<Table border = "1" cellspacing = "0" cellpadding = "0">'. CHR (13 );
Echo '<tr>'. CHR (13 );
$ Num_fields = mysql_num_fields ($ records );
For ($ I = 0; $ I <$ num_fields; $ I ++)
Echo '<TH>'. mysql_field_name ($ records, $ I). '</Th>'. CHR (13 );
Echo '</tr>'. CHR (13 );
While ($ ROW = mysql_fetch_row ($ records )){
Echo '<tr>'. CHR (13 );
For ($ I = 0; $ I <$ num_fields; $ I ++)
Echo '<TD>'. $ row [$ I]. '</TD>'. CHR (13 );
Echo '</tr>'. CHR (13 );
}
Echo '</table>'. CHR (13 );
Mysql_free_result ($ records );
Echo '<HR> <a href = "'. $ php_self .'? Cmd = DB "> show databases </a>
<A href = "'. $ php_self .'? Cmd = TABLE & DB = '. urlencode ($ dB).' "> show tables
</A> '. CHR (13 );
Break;
}

Mysql_close ($ con) or die ('cannot be disconnected from'. $ host ');
?>