List Database, Table, and Field Php

<html>
<head>
<title> veritabanı, tablo ve alan Listeleme</title>
</head>
<body>
<?php
include(“baglan.php”);
?>
<?php
$link = mysql_connect($hostaneme,$username, $password );
if ( ! $link )
die( “MySQL bağlantısı kurulamadı” );

$db_res = mysql_list_dbs( $link );

while ( $db_rows = mysql_fetch_row( $db_res ) ) {
print “<b>$db_rows[0]</b>\n”;
if ( !@mysql_select_db( $db_rows[0], $link ) ) {
print “<dl><dd> bağlantantı hatası oluştu — ” . 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>

Bir cevap yazın

E-posta hesabınız yayımlanmayacak. Gerekli alanlar * ile işaretlenmişlerdir

nineteen − eighteen =

This site uses Akismet to reduce spam. Learn how your comment data is processed.