[phpLiteAdmin-Commits] phpLiteAdmin db.php5,NONE,1.1 index.php5,1.1,1.2 navbar.php5,1.1,1.2

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

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

Modified Files:
	index.php5 navbar.php5 
Added Files:
	db.php5 
Log Message:
Added DB Structure

Index: navbar.php5
===================================================================
RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/navbar.php5,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** navbar.php5	4 Aug 2004 01:53:02 -0000	1.1
--- navbar.php5	4 Aug 2004 21:06:24 -0000	1.2
***************
*** 26,30 ****
  /*	var_dump( $Database );
  
! 	$Database->query( 'CREATE TABLE foo (bar varchar(10))' );
  	$Database->query( "INSERT INTO foo VALUES ('fnord')" );
  	$result = $Database->query( 'SELECT bar FROM foo' );
--- 26,30 ----
  /*	var_dump( $Database );
  
! 	$Database->query( 'CREATE TABLE foo3 (bar varchar(10))' );
  	$Database->query( "INSERT INTO foo VALUES ('fnord')" );
  	$result = $Database->query( 'SELECT bar FROM foo' );

Index: index.php5
===================================================================
RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/index.php5,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** index.php5	4 Aug 2004 01:53:02 -0000	1.1
--- index.php5	4 Aug 2004 21:06:24 -0000	1.2
***************
*** 20,25 ****
  	</head>
  	<frameset cols="150,*" rows="*">
! 		<frame src="navbar.php5" frameborder="1" scrolling="auto" id="navbar" />
! 		<frame src="main.php5" frameborder="0" scrolling="auto" id="main" />
  	</frameset>
  </html>
\ No newline at end of file
--- 20,25 ----
  	</head>
  	<frameset cols="150,*" rows="*">
! 		<frame src="navbar.php5" frameborder="1" scrolling="auto" id="navbar" name="navbar" />
! 		<frame src="main.php5" frameborder="0" scrolling="auto" id="main" name="main" />
  	</frameset>
  </html>
\ No newline at end of file

--- NEW FILE: db.php5 ---
<?php

/**
 * @name phpLiteAdmin
 * @copyright 2004 phpLiteAdmin Team
 */

/**
 * $Id: db.php5,v 1.1 2004/08/04 21:06:24 wgeric Exp $
 * Stucture for databases
 */

if ( isset($_GET['db']) || isset($_POST['db']) )
{
	$db_path = ( $_GET['db'] ) ? $_GET['db'] : $_POST['db'];

	if ( !preg_match("/db\//i", $db_path) )
	{
		$db_path = 'db/' . $db_path;
	}
	if ( !preg_match("/\.sqlite/i", $db_path) )
	{
		$db_path .= '.sqlite';
	}
	$db_name = preg_replace("/db\/(.*?)\.sqlite/i", "\\1", $db_path);
}
else
{
	header( 'Location: main.php5' );
	exit;
}

if ( isset($_GET['mode']) || isset($_POST['mode']) )
{
	$mode = ( $_GET['mode'] ) ? $_GET['mode'] : $_POST['mode'];
}
else
{
	$mode = '';
}
	

header( 'Content-Type: text/xml; charset=UTF-8' );

include( 'lib/sqlite.php5' );

$Database = new Database( $db_path, 0777, $sqlite_error );

print '<?xml version="1.0" encoding="UTF-8" ?>' . "\n";
print '<?xml-stylesheet href="style/db_structure.xsl" type="text/xsl" ?>' . "\n";

if( $Database->connected )
{

	switch( $mode )
	{
		// execute a sql query
		case 'sql':

			break;

		// export the database
		case 'export':

			break;

		//drop the database
		case 'drop':

			break;

		// list tables, the db structure
		default:
			print "<tables>\n";

			
				$sql = "SELECT name
						FROM sqlite_master
						WHERE type = 'table'
						ORDER BY name ASC";

				$result = $Database->query( $sql );

				while( $row = $Database->fetch_array( $result ) )
				{
					print "\t<table>" . "\n";
					print "\t\t<name>" . $row['name'] . "</name>\n";
					print "\t\t<db>" . $db_name . "</db>\n";
					print "\t</table>\n";
				}

				print "</tables>\n";
			break;
	}
}
else
{
   die( $sqlite_error );
}

?>