Total members 11793 |It is currently Fri Aug 23, 2019 12:38 pm Login / Join Codemiles

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka





Code:
<html>
<head>
<title>Listing every database, table, and field</title>
</head>
<body>
<?php
$user 
= "user";
$pass = "password";
$db = "dbname";
$link =  mysql_connect( "server", $user, $pass );
if ( ! $link )
    die( "Couldn't connect to MySQL" );

$db_res = mysql_list_dbs( $link );

while ( $db_rows = mysql_fetch_row( $db_res ) ) {
    print "<b>$db_rows[0]</b>\n";
    if ( [email protected]mysql_select_db( $db_rows[0], $link ) ) {
        print "<dl><dd>couldn't connect -- " . mysql_error() ." </dl>";
        continue;
    }
    $tab_res = mysql_list_tables( $db_rows[0], $link );
    print "\t<dl><dd>\n";
    while ( $tab_rows = mysql_fetch_row( $tab_res ) ){
        print "\t<b>$tab_rows[0]</b>\n";
        $query_res = mysql_query( "SELECT * from $tab_rows[0]" );
        $num_fields = mysql_num_fields( $query_res );
        print "\t\t<dl><dd>\n";
        for ( $x=0; $x<$num_fields; $x++ ){
            print "\t\t<i>";
            print mysql_field_type( $query_res, $x );
            print "</i> <i>";
            print mysql_field_len( $query_res, $x );
            print "</i> <b>";
            print mysql_field_name( $query_res, $x );
            print "</b> <i>";
            print mysql_field_flags( $query_res, $x );
            print "</i><br>\n";
        }
        print "\t\t</d1>\n";
    }
    print "\t</d1>\n";
}
mysql_close( $link );
?>
</body>
</html>





Author:
Mastermind
User avatar Posts: 2707
Have thanks: 74 time
Post new topic Reply to topic  [ 1 post ] 

  Related Posts  to : List Database, Table, and Field in php
 List all database in php     -  
 need help building table in my database!     -  
 Delete data from database table in php     -  
 database contents display in table format in swing     -  
 Please help me in the form field     -  
 Get Text Field value by php     -  
 Get field length     -  
 How To Store Date Dynamically as a field in mysql using JSP     -  
 MYSQL TEXT field types lengths     -  
 List C++ implementation     -  



Topic Tags

PHP Database






Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com