Version: 0.2

Type: Full Script

Category: Databases

License: GNU General Public License

Description: Outputs the contents of an entire database in HTML tables. Take care not to use it for huge databases.



<?php
//
// PHPdbView 0.2 : 02-06-2000
// Written by Tudor Oprea (tudor@interchange.ubc.ca)
// Shows contents of a database in HTML.
// To show another database, change $dbname
//  
//
 
?>


<?php
		
	$dbname = "test";
	$loginname = "test";
	$loginpass = "test";
	$dbhost = "localhost";
	
	echo('<html><body bgcolor="#FFFFFF">');
	echo('<font face="arial" size="+4"><center>');
	echo("Database $dbname");
	
	$id_link = @mysql_connect($dbhost, $loginname, $loginpass);
	
	$tables = mysql_list_tables($dbname, $id_link);
	
	$num_tables = mysql_num_rows($tables);

	// store table names in an array
	$arr_tablenames[] = '';
	
	// store number of fields per table(index 0,1,2..) in an array
	$arr_num_fields[] = '';
	for ($i=0; $i < $num_tables; $i++) {
		$arr_tablenames[$i] = mysql_tablename($tables, $i);
		$arr_num_fields[$i] = mysql_num_fields(mysql_db_query($dbname, "select * from $arr_tablenames[$i]", $id_link));
	}
	
	// store field names in a multidimensional array:
	// [i] == table number, [ii] == field number for that table
	for ($i=0; $i < $num_tables; $i++) {
		for ($ii=0; $ii < $arr_num_fields[$i]; $ii++) {
			$result = mysql_db_query($dbname, "select * from $arr_tablenames[$i]", $id_link);
			$hash_field_names[$i][$ii] = mysql_field_name($result, $ii);
		}	
	}
	
	for ($i=0; $i < $num_tables; $i++) {
		echo("<center><h2>Table $arr_tablenames[$i] </h2></center>");
		echo('<table align="center" border="2"  cellpadding="2" cellspacing="0"><tr>');
		$result = mysql_db_query($dbname, "select * from $arr_tablenames[$i]", $id_link);
		for ($ii=0; $ii < $arr_num_fields[$i]; $ii++) {
			echo("<th>");
			echo $hash_field_names[$i][$ii];
			echo("</th>");
		}
		echo("</tr><tr>");
		$number_of_rows = @mysql_num_rows($result);
		for ($iii = 0; $iii < $number_of_rows; $iii++) {
			$record = @mysql_fetch_row($result);
			for ($ii=0; $ii < $arr_num_fields[$i]; $ii++) {
				echo("<td>");
				echo $record[$ii];
				echo("</td>");
			}
		echo("</tr>");
		}
		echo("</table>");
	}
	


	echo('</body></html>');
?>