[phpLiteAdmin-Commits] phpLiteAdmin ChangeLog,1.6,1.7 navbar.php5,1.3,1.4 tbl.php5,1.3,1.4

[Eric F. <wg...@us...>]

Update of /cvsroot/phpliteadmin/phpLiteAdmin
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv929

Modified Files:
	ChangeLog navbar.php5 tbl.php5 
Log Message:
Added table structure

Index: tbl.php5
===================================================================
RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/tbl.php5,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- tbl.php5	11 Aug 2004 00:18:42 -0000	1.3
+++ tbl.php5	26 Aug 2004 00:01:51 -0000	1.4
@@ -128,6 +128,23 @@
 	// List columns, the table's structure
 	case 'structure':
 	default:
+	
+		print '<?xml-stylesheet href="style/tbl_structure.xsl" type="text/xsl" ?>' . "\n";
+		print '<table>' . "\n";
+		print "\t<db>$db_name</db>\n";
+		print "\t<tbl>$tbl</tbl>\n";
+
+		$columns = $Database->fetch_column_types( $tbl );
+
+		foreach( $columns as $name => $type )
+		{
+			print "\t<column>\n";
+			print "\t\t<name>$name</name>\n";
+			print "\t\t<type>$type</type>\n";
+			print "\t</column>\n";
+		}
+
+		print "</table>\n";
 
 	break;
 }

Index: navbar.php5
===================================================================
RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/navbar.php5,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- navbar.php5	7 Aug 2004 10:19:50 -0000	1.3
+++ navbar.php5	26 Aug 2004 00:01:51 -0000	1.4
@@ -54,7 +54,7 @@
 
 	while( $row = $Database->fetch_array( $result ) )
 	{
-		print "\t\t<table>" . $row['name'] . "</table>\n";
+		print "\t\t" . '<table database="' . substr( $db, 0, -7 ) . '">' . $row['name'] . "</table>\n";
 	}
 
 	print "\t</database>\n";

Index: ChangeLog
===================================================================
RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/ChangeLog,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -d -r1.6 -r1.7
--- ChangeLog	11 Aug 2004 00:19:08 -0000	1.6
+++ ChangeLog	26 Aug 2004 00:01:51 -0000	1.7
@@ -3,6 +3,15 @@
 ========================
 $Id$
 
+2004-08-25 Eric Faerber <wg...@us...>
+	* navbar.php5
+	tbl.php5
+	style/navbar.css
+	style/navbar.xsl
+	style/tbl_structure.css
+	style/tbl_structure.xsl
+	Added table structure
+
 2004-08-10 Eric Faerber <wg...@us...>
 	* lib/sqlite.php5
 	  Added a bunch of functions