php mysqlデータベース情報コードの取得

 
  
@mysql_connect("localhost", "root","1981427") //                   
  
or die("          "); 
  
$dbs = mysql_list_dbs(); //  mysql_list_dbs   
  
while ($array = mysql_fetch_row($dbs)) //             
  
{ 
  
echo "$array[0]
"; 
  
} 
  
?> 
  
 
 

 
  
@mysql_connect("localhost", "root","1981427") //                   
  
or die("          "); 
  
$dbs = mysql_list_tables("test"); //  mysql_list_tables   
  
while ($array = mysql_fetch_row($dbs)) //           
  
{ 
  
echo "$array[0]
"; 
  
} 
  
?> 
  
 
 

 
  
mysql_connect("localhost","root","1981427"); //      
  
mysql_select_db("test"); //      
  
$result = mysql_query("SELECT * FROM tablename1"); //       
  
echo mysql_num_fields($result); //       
  
?> 
  
 
 

 
  
mysql_connect("localhost","root","1981427"); 
  
mysql_select_db("test"); 
  
$result = mysql_query("SELECT * FROM tablename1"); 
  
echo mysql_field_name($result,0); //       
  
?> 
  
 
 

 
  
mysql_connect("localhost","root","1981427"); 
  
mysql_select_db("test"); 
  
$result = mysql_query("SELECT * FROM tablename1"); 
  
echo mysql_field_type($result,0); //         
  
?> 
  
 
 

 
  
mysql_connect("localhost","root","1981427"); 
  
mysql_select_db("test"); 
  
$result = mysql_query("SELECT * FROM tablename1"); 
  
echo mysql_field_len($result,0); //       
  
?> 
  
 
 

 
  
mysql_connect("localhost","root","1981427"); 
  
mysql_select_db("test"); 
  
$result = mysql_query("SELECT * FROM tablename1"); 
  
echo mysql_field_flag($result,0); //       
  
?> 
  
 
 

 
  
mysql_connect("localhost","root","1981427"); //      
  
mysql_select_db("test"); //      
  
echo ""; //     
  
echo ""; 
  
$result = mysql_query("SELECT * FROM tablename1"); // mytable    SQL   
  
$fields = mysql_num_fields($result); //       
  
for($i=0; $i{ 
  
//         
  
$name = mysql_field_name($result,$i); //       
  
$type = mysql_field_type($result,$i); //       
  
$length = mysql_field_len($result,$i); //       
  
$flags = mysql_field_flags($result,$i); //       
  
echo "


"; 
  
//       
  
} 
  
echo "
  
  
  
  
$name
 
  
$type
 
  
$length
 
  
$flags
"; 
  
mysql_close(); //          
  
?>