Menu
▾
▴
phpliteadmin-commits — Automatically generated list of commits to the CVS Repository
You can subscribe to this list here.
| 2004 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
(36) |
Sep
|
Oct
|
Nov
|
Dec
|
|---|
|
From: Eric F. <wg...@us...> - 2004-08-26 00:02:00
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin/style In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv929/style Modified Files: navbar.css navbar.xsl Added Files: tbl_structure.css tbl_structure.xsl Log Message: Added table structure Index: navbar.css =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/style/navbar.css,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- navbar.css 4 Aug 2004 01:53:02 -0000 1.1 +++ navbar.css 26 Aug 2004 00:01:51 -0000 1.2 @@ -15,4 +15,9 @@ ul li ul li { display: list-item; list-style-type: square; +} + +#home { + text-align: center; + font-weight: bold; } \ No newline at end of file Index: navbar.xsl =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/style/navbar.xsl,v retrieving revision 1.4 retrieving revision 1.5 diff -u -d -r1.4 -r1.5 --- navbar.xsl 7 Aug 2004 10:19:51 -0000 1.4 +++ navbar.xsl 26 Aug 2004 00:01:51 -0000 1.5 @@ -9,6 +9,9 @@ <link rel="stylesheet" href="style/navbar.css" type="text/css" /> </head> <body> + <div id="home"> + <a><xsl:attribute name="href">./main.php5</xsl:attribute><xsl:attribute name="target">main</xsl:attribute>Home</a> + </div> <ul> <xsl:for-each select="/databases/database"> <li><a> @@ -19,7 +22,7 @@ <ul> <xsl:for-each select="table"> <li><a> - <xsl:attribute name="href">./tbl.php5?mode=structure&tbl=<xsl:value-of select="." />&db=<xsl:value-of select="/databases/database/@name" /></xsl:attribute> + <xsl:attribute name="href">./tbl.php5?mode=structure&tbl=<xsl:value-of select="." />&db=<xsl:value-of select="@database" /></xsl:attribute> <xsl:attribute name="target">main</xsl:attribute> <xsl:value-of select="." /> </a></li> --- NEW FILE: tbl_structure.css --- body { font-family: Verdana, Arial, Helvetica, Tahoma, sans-serif; font-size: 10pt; background: #EEFDEE; color: black; white-space: nowrap; overflow: auto; } h1 { font-size: 14pt; font-weight: bold; } #nav { width: 100%; height: 25px; font-size: 80%; text-align: center; } .nav_option { float: left; width: 15%; padding: 5px; margin: 5px; border: 1px #000000 solid; } #columns { width: 100%; text-align: center; } .column_row { width: 100%; height: 20px; } .checkbox { float: left; height: 20px; border-width: 1px 1px 1px 1px; border-color: #000000; border-style: solid; padding: 0px 3px; } .name { float: left; width: 20%; height: 20px; border-width: 1px 1px 1px 0px; border-color: #000000; border-style: solid; text-align: left; padding: 0px 3px; } .type { float: left; width: 20%; height: 20px; border-width: 1px 1px 1px 0px; border-color: #000000; border-style: solid; text-align: left; padding: 0px 3px; } .change { float: left; width: 20%; height: 20px; border-width: 1px 1px 1px 0px; border-color: #000000; border-style: solid; text-align: left; padding: 0px 3px; } .drop { float: left; width: 20%; height: 20px; border-width: 1px 1px 1px 0px; border-color: #000000; border-style: solid; text-align: left; padding: 0px 3px; } --- NEW FILE: tbl_structure.xsl --- <?xml version="1.0" encoding="ISO-8859-1" ?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/"> <html lang="en" dir="ltr"> <head> <title>phpLiteAdmin - Table Structure</title> <link rel="stylesheet" href="style/tbl_structure.css" type="text/css" /> </head> <body> <h1>Database: <a><xsl:attribute name="href">db.php5?db=<xsl:value-of select="/table/db" /></xsl:attribute><xsl:value-of select="/table/db" /></a> <br /> Table: <xsl:value-of select="/table/tbl" /> </h1> <div id="nav"> <div class="nav_option"> <a><xsl:attribute name="href">tbl.php5?mode=browse&db=<xsl:value-of select="/table/db" />&tbl=<xsl:value-of select="/table/tbl" /></xsl:attribute>Browse</a> </div> <div class="nav_option"> <a><xsl:attribute name="href">tbl.php5?mode=sql&db=<xsl:value-of select="/table/db" />&tbl=<xsl:value-of select="/table/tbl" /></xsl:attribute>SQL</a> </div> <div class="nav_option"> <a><xsl:attribute name="href">tbl.php5?mode=export&db=<xsl:value-of select="/table/db" />&tbl=<xsl:value-of select="/table/tbl" /></xsl:attribute>Export</a> </div> <div class="nav_option"> <a><xsl:attribute name="href">tbl.php5?mode=empty&db=<xsl:value-of select="/table/db" />&tbl=<xsl:value-of select="/table/tbl" /></xsl:attribute>Empty</a> </div> <div class="nav_option"> <a><xsl:attribute name="href">tbl.php5?mode=drop&db=<xsl:value-of select="/table/db" />&tbl=<xsl:value-of select="/table/tbl" /></xsl:attribute>Drop</a> </div> </div> <br /> <div id="columns"> <xsl:for-each select="/table/column"> <div class="column_row"> <div class="checkbox"><input type="checkbox"><xsl:attribute name="name"><xsl:value-of select="name" /></xsl:attribute></input></div> <div class="name"><b><xsl:value-of select="name" /></b></div> <div class="type"><xsl:value-of select="type" /></div> <div class="change"><a><xsl:attribute name="href">./tbl.php5?mode=change&tbl=<xsl:value-of select="name" />&db=<xsl:value-of select="/table/db" />&column=<xsl:value-of select="name" /></xsl:attribute>Change</a></div> <div class="drop"><a><xsl:attribute name="href">./tbl.php5?mode=drop&tbl=<xsl:value-of select="name" />&db=<xsl:value-of select="/table/db" />&column=<xsl:value-of select="name" /></xsl:attribute>Drop</a></div> </div> <br /> </xsl:for-each> </div> </body> </html> </xsl:template> </xsl:stylesheet> |
|
From: Eric F. <wg...@us...> - 2004-08-26 00:02:00
|
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 |
|
From: Eric F. <wg...@us...> - 2004-08-11 00:19:16
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv3300 Modified Files: ChangeLog Log Message: Index: ChangeLog =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/ChangeLog,v retrieving revision 1.5 retrieving revision 1.6 diff -u -d -r1.5 -r1.6 --- ChangeLog 10 Aug 2004 23:06:04 -0000 1.5 +++ ChangeLog 11 Aug 2004 00:19:08 -0000 1.6 @@ -3,6 +3,15 @@ ======================== $Id$ +2004-08-10 Eric Faerber <wg...@us...> + * lib/sqlite.php5 + Added a bunch of functions + + * tbl.php5 + style/tbl_browse.css + style/tbl_browse.xsl + Optimized and fixed CSS issues. Still has one problem with CSS in tables with many fields. + 2004-08-10 Gordon P. Hemsley <gph...@us...> * config.php5: Leave the error_reporting() settings as they are. If there's an error, fix |
|
From: Eric F. <wg...@us...> - 2004-08-11 00:18:52
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin/style In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv3171/style Modified Files: tbl_browse.css tbl_browse.xsl Log Message: Optimized and fixed CSS issues. Still has one problem with CSS in tables with many fields. Index: tbl_browse.xsl =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/style/tbl_browse.xsl,v retrieving revision 1.2 retrieving revision 1.3 diff -u -d -r1.2 -r1.3 --- tbl_browse.xsl 10 Aug 2004 23:04:20 -0000 1.2 +++ tbl_browse.xsl 11 Aug 2004 00:18:42 -0000 1.3 @@ -9,49 +9,55 @@ <link rel="stylesheet" href="style/tbl_browse.css" type="text/css" /> </head> <body> - <h1>Database: <xsl:value-of select="/rows/row/db" /><br />Table: <xsl:value-of select="/rows/row/tbl" /></h1> + <h1>Database: <a><xsl:attribute name="href">db.php5?db=<xsl:value-of select="/rows/db" /></xsl:attribute><xsl:value-of select="/rows/db" /></a> + <br /> + Table: <xsl:value-of select="/rows/tbl" /> + </h1> <div id="nav"> <div class="nav_option"> - <a><xsl:attribute name="href">tbl.php5?db=<xsl:value-of select="/rows/row/db" />&tbl=<xsl:value-of select="/rows/row/tbl" /></xsl:attribute>Structure</a> + <a><xsl:attribute name="href">tbl.php5?db=<xsl:value-of select="/rows/db" />&tbl=<xsl:value-of select="/rows/tbl" /></xsl:attribute>Structure</a> </div> <div class="nav_option"> - <a><xsl:attribute name="href">tbl.php5?mode=sql&db=<xsl:value-of select="/rows/row/db" />&tbl=<xsl:value-of select="/rows/row/tbl" /></xsl:attribute>SQL</a> + <a><xsl:attribute name="href">tbl.php5?mode=sql&db=<xsl:value-of select="/rows/db" />&tbl=<xsl:value-of select="/rows/tbl" /></xsl:attribute>SQL</a> </div> <div class="nav_option"> - <a><xsl:attribute name="href">tbl.php5?mode=export&db=<xsl:value-of select="/rows/row/db" />&tbl=<xsl:value-of select="/rows/row/tbl" /></xsl:attribute>Export</a> + <a><xsl:attribute name="href">tbl.php5?mode=export&db=<xsl:value-of select="/rows/db" />&tbl=<xsl:value-of select="/rows/tbl" /></xsl:attribute>Export</a> </div> <div class="nav_option"> - <a><xsl:attribute name="href">tbl.php5?mode=empty&db=<xsl:value-of select="/rows/row/db" />&tbl=<xsl:value-of select="/rows/row/tbl" /></xsl:attribute>Empty</a> + <a><xsl:attribute name="href">tbl.php5?mode=empty&db=<xsl:value-of select="/rows/db" />&tbl=<xsl:value-of select="/rows/tbl" /></xsl:attribute>Empty</a> </div> <div class="nav_option"> - <a><xsl:attribute name="href">tbl.php5?mode=drop&db=<xsl:value-of select="/rows/row/db" />&tbl=<xsl:value-of select="/rows/row/tbl" /></xsl:attribute>Drop</a> + <a><xsl:attribute name="href">tbl.php5?mode=drop&db=<xsl:value-of select="/rows/db" />&tbl=<xsl:value-of select="/rows/tbl" /></xsl:attribute>Drop</a> </div> </div> <br /> - <div id="table"> - <div id="columns"> - <xsl:for-each select="/rows/columns"> - <div class="column_name"> - <xsl:value-of select="name" /> - </div> - </xsl:for-each> + <div class="column"> + <div class="column_name"> + Actions </div> - - <br /> - - <div id="records"> - <xsl:for-each select="/rows/row"> + <xsl:for-each select="/rows/number"> + <div class="value"> + <a><xsl:attribute name="href">record.php5?mode=edit&db=<xsl:value-of select="/rows/db" />&tbl=<xsl:value-of select="/rows/tbl" /></xsl:attribute>Edit</a> | <a><xsl:attribute name="href">record.php5?mode=delete&db=<xsl:value-of select="/rows/db" />&tbl=<xsl:value-of select="/rows/tbl" /></xsl:attribute>Delete</a> + </div> + </xsl:for-each> + </div> + <xsl:for-each select="/rows/column"> + <div class="column"> + <div class="column_name"> + <xsl:value-of select="@name" /> + </div> + <xsl:for-each select="row"> <div class="value"> - <xsl:value-of select="column" /> + <xsl:value-of select="value" /> </div> - <br /> </xsl:for-each> </div> - </div> + </xsl:for-each> </body> + </html> </xsl:template> Index: tbl_browse.css =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/style/tbl_browse.css,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- tbl_browse.css 9 Aug 2004 22:14:43 -0000 1.1 +++ tbl_browse.css 11 Aug 2004 00:18:42 -0000 1.2 @@ -3,6 +3,8 @@ font-size: 10pt; background: #EEFDEE; color: black; + white-space: nowrap; + overflow: auto; } h1 { @@ -26,29 +28,32 @@ } #table { - width: 100%; + width: auto; + height: auto; + white-space: nowrap; + border: 1px #FF0000 solid; } -#columns { - width: 100%; - height: 25px; +.column { + width: 100px; + height: auto; + float: left; } .column_name { - float: left; + width: auto; + height: auto; padding: 5px; margin: 0px; border: 1px #000000 solid; -} - -#records { - width: 100%; + font-weight: bold; + text-align: center; } .value { - float: left; + width: auto; + height: auto; padding: 5px; margin: 0px; border: 1px #000000 solid; - height: 25px; } \ No newline at end of file |
|
From: Eric F. <wg...@us...> - 2004-08-11 00:18:52
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin/db In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv3171/db Modified Files: test.sqlite Log Message: Optimized and fixed CSS issues. Still has one problem with CSS in tables with many fields. Index: test.sqlite =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/db/test.sqlite,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 Binary files /tmp/cvsmFT7mo and /tmp/cvs0zspmM differ |
|
From: Eric F. <wg...@us...> - 2004-08-11 00:18:52
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv3171 Modified Files: tbl.php5 Log Message: Optimized and fixed CSS issues. Still has one problem with CSS in tables with many fields. Index: tbl.php5 =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/tbl.php5,v retrieving revision 1.2 retrieving revision 1.3 diff -u -d -r1.2 -r1.3 --- tbl.php5 10 Aug 2004 23:04:20 -0000 1.2 +++ tbl.php5 11 Aug 2004 00:18:42 -0000 1.3 @@ -61,6 +61,8 @@ case 'browse': print '<?xml-stylesheet href="style/tbl_browse.xsl" type="text/xsl" ?>' . "\n"; print '<rows>' . "\n"; + print "\t<db>$db_name</db>\n"; + print "\t<tbl>$tbl</tbl>\n"; if( isset( $_REQUEST['order'] ) ) { @@ -70,49 +72,39 @@ { $order = 'ASC'; } - - $order_by = ( isset( $_REQUEST['order_by'] ) ) ? ' ORDER BY ' . $_REQUEST['order_by'] . " $order" : ''; - $start = ( isset( $_REQUEST['start'] ) ) ? settype( $_REQUEST['start'], 'integer' ) : 0; - $end = ( isset( $_REQUEST['end'] ) ) ? settype( $_REQUEST['end'], 'integer' ) : $config['default_rows']; + + $order_by = ( isset( $_REQUEST['order_by'] ) ) ? " ORDER BY " . $_REQUEST['order_by'] . " $order" : ''; + + $offset = ( isset( $_REQUEST['offset'] ) ) ? settype( $_REQUEST['offset'], 'integer' ) : 0; + $limit = ( isset( $_REQUEST['limit'] ) ) ? settype( $_REQUEST['limit'], 'integer' ) : $config['default_rows']; $sql = "SELECT * FROM $tbl - $order_by"; - //LIMIT $start, $end"; + $order_by + LIMIT $limit OFFSET $offset"; $result = $Database->query( $sql ); - $columns_array = array(); + $rows = $Database->fetch_all( $result ); + $columns = $Database->fetch_column_types( $tbl ); - while( $row = $Database->fetch_array( $result ) ) + foreach( $columns as $name => $type ) { - print "\t<row>\n"; - - foreach( $row as $key => $value ) + print "\t" . '<column name="' . $name . '">' . "\n"; + + for( $i = 0; $i < count($rows); $i++ ) { - if ( !( in_array( $key, $columns_array ) ) ) - { - $columns_array[] = $key; - } - - print "\t\t" . '<column name="' . $key . '">' . $value . '</column>' . "\n"; - print "\t\t<tbl>$tbl</tbl>\n"; - print "\t\t<db>$db_name</db>\n"; + print "\t\t" . '<row id="' . $i . '">' . "\n"; + print "\t\t\t" . '<value>' . $rows[$i][$name] . '</value>' . "\n"; + print "\t\t</row>\n"; } - print "\t</row>\n"; + print "\t</column>\n"; } - if( count( $columns_array ) ) + for( $i = 0; $i < count($rows); $i++ ) { - print "\t<columns>\n"; - - for( $i = 0; $i < count( $columns_array ); $i++ ) - { - print "\t\t<name>" . $columns_array[$i] . "</name>\n"; - } - - print "\t</columns>\n"; + print "\t<number>$i</number>\n"; } print "</rows>\n"; |
|
From: Eric F. <wg...@us...> - 2004-08-11 00:16:34
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin/lib In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv2876/lib Modified Files: sqlite.php5 Log Message: Added a bunch of functions Index: sqlite.php5 =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/lib/sqlite.php5,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- sqlite.php5 4 Aug 2004 01:53:02 -0000 1.1 +++ sqlite.php5 11 Aug 2004 00:16:23 -0000 1.2 @@ -60,19 +60,113 @@ private $var; /** - * Database query - * + * Executes a query and returns the results as an array + * * @param string $query Database query + * @param integer $result_type Type of array data returned + * @param boolean $decode_binary Whether or not to decode binary data */ - function query( $query ) + function array_query( $query, $result_type = SQLITE_ASSOC, $decode_binary = TRUE ) { if( !( $this->connected ) ) { return FALSE; } - return sqlite_query( $this->connection, $query ); + return sqlite_array_query ( $this->connection, $query, $result_type, $decode_binary ); + } + + /** + * Returns the number of rows that were changed by the most recent sql statement + * + * @params resource $result Resource handle from query + */ + + function changes( $result ) + { + return sqlite_changes( $result ); + } + + /** + * Registers a regular function for use in sql queries + * + * @param string $function Name of the function for use in sql queries + * @param string $callback Name of the function + * @param integer $num_args Number of params in the function + */ + + function create_sqlite_function( $function, $callback, $num_args = FALSE ) + { + if( !( $this->connected ) ) + { + return FALSE; + } + + if ( $num_args != FALSE ) + { + return sqlite_create_function( $this->connection, $function, $callback, $num_args ); + } + else + { + return sqlite_create_function( $this->connection, $function, $callback ); + } + } + + /** + * Returns a human readable form of a sqlite error code + * + * @params integer $error_code Error code number + */ + + function error_string( $error_code ) + { + return sqlite_error_string( $error_code ); + } + + /** + * Escapes strings for use in a query + * + * @param string $string The string that will be escaped + */ + + function escape_string( $string ) + { + return sqlite_escape_string( $string ); + } + + /** + * Executes a sql query that won't return any results + * + * @param string $query Database query + */ + + function execute( $query ) + { + if( !( $this->connected ) ) + { + return FALSE; + } + + return sqlite_exec( $this->connection, $query ); + } + + /** + * Fetch data from database in an array of arrays + * + * @param resource $result Resource handle from query + * @param integer $result_type Type of array data returned + * @param boolean $decode_binary Whether or not to decode binary data + */ + + function fetch_all( $result, $result_type = SQLITE_ASSOC, $decode_binary = TRUE ) + { + if( !( $this->connected ) ) + { + return FALSE; + } + + return sqlite_fetch_all( $result, $result_type, $decode_binary ); } /** @@ -94,6 +188,159 @@ } /** + * Gets the columns and their types + * + * @param string $table Table name for the columns + * + */ + + function fetch_column_types( $table ) + { + if( !( $this->connected ) ) + { + return FALSE; + } + + return sqlite_fetch_column_types( $this->connection, $table ); + } + + /** + * Fetches the first column of a result + * + * @param resource $result Resource handle from query + * @param integer $result_type Type of array data returned + * @param boolean $decode_binary Whether or not to decode binary data + */ + + function fetch_single( $result, $result_type = SQLITE_ASSOC, $decode_binary = TRUE ) + { + if( !( $this->connected ) ) + { + return FALSE; + } + + return sqlite_fetch_single( $result, $result_type, $decode_binary ); + } + + /** + * Returns the name of the given field + * + * @param resource $result Resource handle from query + * @param integer $field_index Number of the field + */ + + function field_name( $result, $field_index ) + { + return sqlite_field_name( $result, $field_index ); + } + + /** + * Returns whether or not more rows are available + * + * @param resource $result Resource handle from query + */ + + function has_more( $result ) + { + return sqlite_has_more( $result ); + } + + /** + * Returns the last error code + */ + + function last_error() + { + if( !( $this->connected ) ) + { + return FALSE; + } + + return sqlite_last_error( $this->connection ); + } + + /** + * Returns the row id of the most recent inserted row + */ + + function last_insert_rowid() + { + return sqlite_last_insert_rowid( $this->connection ); + } + + /** + * Returns the number of fields + * + * @param resource $result Resource handle from query + */ + + function num_fields( $result ) + { + return sqlite_num_fields( $result ); + } + + /** + * Returns the number of rows + * + * @param resource $result Resource handle from query + */ + + function num_rows( $result ) + { + return sqlite_num_rows( $result ); + } + + /** + * Database query + * + * @param string $query Database query + */ + + function query( $query ) + { + if( !( $this->connected ) ) + { + return FALSE; + } + + return sqlite_query( $this->connection, $query ); + } + + /** + * Database query and returns an array either for one column or the first row + * + * @param string $query Database query + * @param boolean $first_row_only Return first row + * @param boolean $decode_binary Whether or not to decode binary data + */ + + function single_query( $query, $first_row_only = FALSE, $decode_binary = TRUE ) + { + if( !( $this->connected ) ) + { + return FALSE; + } + + return sqlite_single_query( $this->connection, $first_row_only, $decode_binary ); + } + + /** + * Database query that doesn't buffer all data + * + * @param string $query Database query + */ + + function unbuffered_query( $query ) + { + if( !( $this->connected ) ) + { + return FALSE; + } + + return sqlite_unbuffered_query( $this->connection, $query ); + } + + /** * Destructor */ |
|
From: Gordon P. H. <gph...@us...> - 2004-08-10 23:06:12
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv22279 Modified Files: ChangeLog Log Message: - Leave the error_reporting() settings as they are. If there's an error, fix it, don't cover it up. - Minor bug fixes and formatting changes. Index: ChangeLog =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/ChangeLog,v retrieving revision 1.4 retrieving revision 1.5 diff -u -d -r1.4 -r1.5 --- ChangeLog 9 Aug 2004 22:14:42 -0000 1.4 +++ ChangeLog 10 Aug 2004 23:06:04 -0000 1.5 @@ -3,6 +3,15 @@ ======================== $Id$ +2004-08-10 Gordon P. Hemsley <gph...@us...> + * config.php5: + Leave the error_reporting() settings as they are. If there's an error, fix + it, don't cover it up. + + * tbl.php5 + style/tbl_browse.xsl: + Minor bug fixes and formatting changes. + 2004-08-09 Gordon P. Hemsley <gph...@us...> * style/db_structure.css: Rearranged height specifications. |
|
From: Gordon P. H. <gph...@us...> - 2004-08-10 23:04:30
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv21934 Modified Files: tbl.php5 Log Message: Minor bug fixes and formatting changes. Index: tbl.php5 =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/tbl.php5,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- tbl.php5 9 Aug 2004 22:14:42 -0000 1.1 +++ tbl.php5 10 Aug 2004 23:04:20 -0000 1.2 @@ -62,7 +62,7 @@ print '<?xml-stylesheet href="style/tbl_browse.xsl" type="text/xsl" ?>' . "\n"; print '<rows>' . "\n"; - if ( $_REQUEST['order'] ) + if( isset( $_REQUEST['order'] ) ) { $order = ( $_REQUEST['order'] == 'ASC' ) ? 'ASC' : 'DESC'; } @@ -70,11 +70,10 @@ { $order = 'ASC'; } - - $order_by = ( $_REQUEST['order_by'] ) ? " ORDER BY " . $_REQUEST['order_by'] . " $order" : ''; - - $start = ( $_REQUEST['start'] ) ? settype( $_REQUEST['start'], 'integer' ) : 0; - $end = ( $_REQUEST['end'] ) ? settype( $_REQUEST['end'], 'integer' ) : $config['default_rows']; + + $order_by = ( isset( $_REQUEST['order_by'] ) ) ? ' ORDER BY ' . $_REQUEST['order_by'] . " $order" : ''; + $start = ( isset( $_REQUEST['start'] ) ) ? settype( $_REQUEST['start'], 'integer' ) : 0; + $end = ( isset( $_REQUEST['end'] ) ) ? settype( $_REQUEST['end'], 'integer' ) : $config['default_rows']; $sql = "SELECT * FROM $tbl @@ -88,25 +87,33 @@ while( $row = $Database->fetch_array( $result ) ) { print "\t<row>\n"; + foreach( $row as $key => $value ) { - if ( !in_array( $key, $columns_array ) ) + if ( !( in_array( $key, $columns_array ) ) ) { $columns_array[] = $key; } + print "\t\t" . '<column name="' . $key . '">' . $value . '</column>' . "\n"; print "\t\t<tbl>$tbl</tbl>\n"; print "\t\t<db>$db_name</db>\n"; } + print "\t</row>\n"; } - print "\t<columns>\n"; - for( $i = 0; $i < count($columns_array); $i++ ) + if( count( $columns_array ) ) { - print "\t\t<name>" . $columns_array[$i] . "</name>\n"; + print "\t<columns>\n"; + + for( $i = 0; $i < count( $columns_array ); $i++ ) + { + print "\t\t<name>" . $columns_array[$i] . "</name>\n"; + } + + print "\t</columns>\n"; } - print "\t</columns>\n"; print "</rows>\n"; break; |
|
From: Gordon P. H. <gph...@us...> - 2004-08-10 23:04:28
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin/style In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv21934/style Modified Files: tbl_browse.xsl Log Message: Minor bug fixes and formatting changes. Index: tbl_browse.xsl =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/style/tbl_browse.xsl,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- tbl_browse.xsl 9 Aug 2004 22:14:43 -0000 1.1 +++ tbl_browse.xsl 10 Aug 2004 23:04:20 -0000 1.2 @@ -4,50 +4,54 @@ <xsl:template match="/"> <html lang="en" dir="ltr"> - <head> - <title>phpLiteAdmin - Table Browse</title> - <link rel="stylesheet" href="style/tbl_browse.css" type="text/css" /> - </head> - <body> - <h1>Database: <xsl:value-of select="/rows/row/db" /><br />Table: <xsl:value-of select="/rows/row/tbl" /></h1> +<head> + <title>phpLiteAdmin - Table Browse</title> + <link rel="stylesheet" href="style/tbl_browse.css" type="text/css" /> +</head> +<body> + <h1>Database: <xsl:value-of select="/rows/row/db" /><br />Table: <xsl:value-of select="/rows/row/tbl" /></h1> - <div id="nav"> - <div class="nav_option"> - <a><xsl:attribute name="href">tbl.php5?db=<xsl:value-of select="/rows/row/db" />&tbl=<xsl:value-of select="/rows/row/tbl" /></xsl:attribute>Structure</a> - </div> - <div class="nav_option"> - <a><xsl:attribute name="href">tbl.php5?mode=sql&db=<xsl:value-of select="/rows/row/db" />&tbl=<xsl:value-of select="/rows/row/tbl" /></xsl:attribute>SQL</a> - </div> - <div class="nav_option"> - <a><xsl:attribute name="href">tbl.php5?mode=export&db=<xsl:value-of select="/rows/row/db" />&tbl=<xsl:value-of select="/rows/row/tbl" /></xsl:attribute>Export</a> - </div> - <div class="nav_option"> - <a><xsl:attribute name="href">tbl.php5?mode=empty&db=<xsl:value-of select="/rows/row/db" />&tbl=<xsl:value-of select="/rows/row/tbl" /></xsl:attribute>Empty</a> - </div> - <div class="nav_option"> - <a><xsl:attribute name="href">tbl.php5?mode=drop&db=<xsl:value-of select="/rows/row/db" />&tbl=<xsl:value-of select="/rows/row/tbl" /></xsl:attribute>Drop</a> - </div> + <div id="nav"> + <div class="nav_option"> + <a><xsl:attribute name="href">tbl.php5?db=<xsl:value-of select="/rows/row/db" />&tbl=<xsl:value-of select="/rows/row/tbl" /></xsl:attribute>Structure</a> + </div> + <div class="nav_option"> + <a><xsl:attribute name="href">tbl.php5?mode=sql&db=<xsl:value-of select="/rows/row/db" />&tbl=<xsl:value-of select="/rows/row/tbl" /></xsl:attribute>SQL</a> + </div> + <div class="nav_option"> + <a><xsl:attribute name="href">tbl.php5?mode=export&db=<xsl:value-of select="/rows/row/db" />&tbl=<xsl:value-of select="/rows/row/tbl" /></xsl:attribute>Export</a> + </div> + <div class="nav_option"> + <a><xsl:attribute name="href">tbl.php5?mode=empty&db=<xsl:value-of select="/rows/row/db" />&tbl=<xsl:value-of select="/rows/row/tbl" /></xsl:attribute>Empty</a> + </div> + <div class="nav_option"> + <a><xsl:attribute name="href">tbl.php5?mode=drop&db=<xsl:value-of select="/rows/row/db" />&tbl=<xsl:value-of select="/rows/row/tbl" /></xsl:attribute>Drop</a> </div> + </div> + + <br /> + + <div id="table"> + <div id="columns"> + <xsl:for-each select="/rows/columns"> + <div class="column_name"> + <xsl:value-of select="name" /> + </div> + </xsl:for-each> + </div> + <br /> - <div id="table"> - <div id="columns"> - <xsl:for-each select="/rows/columns"> - <div class="column_name"> - <xsl:value-of select="name" /> - </div> - </xsl:for-each> - </div> - <br /> - <div id="records"> - <xsl:for-each select="/rows/row"> - <div class="value"> - <xsl:value-of select="column" /> - </div> - <br /> - </xsl:for-each> - </div> - </div> - </body> + + <div id="records"> + <xsl:for-each select="/rows/row"> + <div class="value"> + <xsl:value-of select="column" /> + </div> + <br /> + </xsl:for-each> + </div> + </div> +</body> </html> </xsl:template> |
|
From: Gordon P. H. <gph...@us...> - 2004-08-10 23:03:50
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv21799 Modified Files: config.php5 Log Message: - Leave the error_reporting() settings as they are. If there's an error, fix it, don't cover it up. Index: config.php5 =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/config.php5,v retrieving revision 1.2 retrieving revision 1.3 diff -u -d -r1.2 -r1.3 --- config.php5 9 Aug 2004 22:14:42 -0000 1.2 +++ config.php5 10 Aug 2004 23:03:41 -0000 1.3 @@ -10,7 +10,7 @@ * Configuration and customization settings */ -//error_reporting( E_ALL | E_STRICT ); // DO NOT CHANGE THIS! +error_reporting( E_ALL | E_STRICT ); // DO NOT CHANGE THIS! @ini_set( 'display_errors', '1' ); // DO NOT CHANGE THIS! // Placeholder for customization options |
|
From: Eric F. <wg...@us...> - 2004-08-09 22:14:52
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin/style In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv5172/style Added Files: tbl_browse.css tbl_browse.xsl Log Message: Added table browse, needs major css work --- NEW FILE: tbl_browse.xsl --- <?xml version="1.0" encoding="ISO-8859-1" ?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/"> <html lang="en" dir="ltr"> <head> <title>phpLiteAdmin - Table Browse</title> <link rel="stylesheet" href="style/tbl_browse.css" type="text/css" /> </head> <body> <h1>Database: <xsl:value-of select="/rows/row/db" /><br />Table: <xsl:value-of select="/rows/row/tbl" /></h1> <div id="nav"> <div class="nav_option"> <a><xsl:attribute name="href">tbl.php5?db=<xsl:value-of select="/rows/row/db" />&tbl=<xsl:value-of select="/rows/row/tbl" /></xsl:attribute>Structure</a> </div> <div class="nav_option"> <a><xsl:attribute name="href">tbl.php5?mode=sql&db=<xsl:value-of select="/rows/row/db" />&tbl=<xsl:value-of select="/rows/row/tbl" /></xsl:attribute>SQL</a> </div> <div class="nav_option"> <a><xsl:attribute name="href">tbl.php5?mode=export&db=<xsl:value-of select="/rows/row/db" />&tbl=<xsl:value-of select="/rows/row/tbl" /></xsl:attribute>Export</a> </div> <div class="nav_option"> <a><xsl:attribute name="href">tbl.php5?mode=empty&db=<xsl:value-of select="/rows/row/db" />&tbl=<xsl:value-of select="/rows/row/tbl" /></xsl:attribute>Empty</a> </div> <div class="nav_option"> <a><xsl:attribute name="href">tbl.php5?mode=drop&db=<xsl:value-of select="/rows/row/db" />&tbl=<xsl:value-of select="/rows/row/tbl" /></xsl:attribute>Drop</a> </div> </div> <br /> <div id="table"> <div id="columns"> <xsl:for-each select="/rows/columns"> <div class="column_name"> <xsl:value-of select="name" /> </div> </xsl:for-each> </div> <br /> <div id="records"> <xsl:for-each select="/rows/row"> <div class="value"> <xsl:value-of select="column" /> </div> <br /> </xsl:for-each> </div> </div> </body> </html> </xsl:template> </xsl:stylesheet> --- NEW FILE: tbl_browse.css --- body { font-family: Verdana, Arial, Helvetica, Tahoma, sans-serif; font-size: 10pt; background: #EEFDEE; color: black; } h1 { font-size: 14pt; font-weight: bold; } #nav { width: 100%; height: 25px; font-size: 80%; text-align: center; } .nav_option { float: left; width: 15%; padding: 5px; margin: 5px; border: 1px #000000 solid; } #table { width: 100%; } #columns { width: 100%; height: 25px; } .column_name { float: left; padding: 5px; margin: 0px; border: 1px #000000 solid; } #records { width: 100%; } .value { float: left; padding: 5px; margin: 0px; border: 1px #000000 solid; height: 25px; } |
|
From: Eric F. <wg...@us...> - 2004-08-09 22:14:52
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv5172 Modified Files: ChangeLog config.php5 Added Files: tbl.php5 Log Message: Added table browse, needs major css work --- NEW FILE: tbl.php5 --- <?php /** * @name phpLiteAdmin * @copyright 2004 phpLiteAdmin Team */ /** * $Id: tbl.php5,v 1.1 2004/08/09 22:14:42 wgeric Exp $ * Stucture for databases */ include_once( 'config.php5' ); if( isset( $_REQUEST['db'] ) ) { $db_path = $_REQUEST['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( $_REQUEST['tbl'] ) ) { $tbl = $_REQUEST['tbl']; } else { header( 'Location: db.php5?db=' . $db_name ); exit; } $mode = ( isset( $_REQUEST['mode'] ) ) ? $_REQUEST['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"; switch( $mode ) { // Browse the table case 'browse': print '<?xml-stylesheet href="style/tbl_browse.xsl" type="text/xsl" ?>' . "\n"; print '<rows>' . "\n"; if ( $_REQUEST['order'] ) { $order = ( $_REQUEST['order'] == 'ASC' ) ? 'ASC' : 'DESC'; } else { $order = 'ASC'; } $order_by = ( $_REQUEST['order_by'] ) ? " ORDER BY " . $_REQUEST['order_by'] . " $order" : ''; $start = ( $_REQUEST['start'] ) ? settype( $_REQUEST['start'], 'integer' ) : 0; $end = ( $_REQUEST['end'] ) ? settype( $_REQUEST['end'], 'integer' ) : $config['default_rows']; $sql = "SELECT * FROM $tbl $order_by"; //LIMIT $start, $end"; $result = $Database->query( $sql ); $columns_array = array(); while( $row = $Database->fetch_array( $result ) ) { print "\t<row>\n"; foreach( $row as $key => $value ) { if ( !in_array( $key, $columns_array ) ) { $columns_array[] = $key; } print "\t\t" . '<column name="' . $key . '">' . $value . '</column>' . "\n"; print "\t\t<tbl>$tbl</tbl>\n"; print "\t\t<db>$db_name</db>\n"; } print "\t</row>\n"; } print "\t<columns>\n"; for( $i = 0; $i < count($columns_array); $i++ ) { print "\t\t<name>" . $columns_array[$i] . "</name>\n"; } print "\t</columns>\n"; print "</rows>\n"; break; // Execute an SQL query case 'sql': break; // Export the table case 'export': break; // Drop the table case 'drop': break; // List columns, the table's structure case 'structure': default: break; } ?> Index: config.php5 =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/config.php5,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- config.php5 7 Aug 2004 10:19:10 -0000 1.1 +++ config.php5 9 Aug 2004 22:14:42 -0000 1.2 @@ -10,7 +10,7 @@ * Configuration and customization settings */ -error_reporting( E_ALL | E_STRICT ); // DO NOT CHANGE THIS! +//error_reporting( E_ALL | E_STRICT ); // DO NOT CHANGE THIS! @ini_set( 'display_errors', '1' ); // DO NOT CHANGE THIS! // Placeholder for customization options @@ -18,6 +18,8 @@ $config['navbar_width'] = '150'; // Default: 150 +$config['default_rows'] = '30'; // Default: 30 + /* DO NOT EDIT BELOW THIS LINE! */ $config['revision'] = '$Revision$'; Index: ChangeLog =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/ChangeLog,v retrieving revision 1.3 retrieving revision 1.4 diff -u -d -r1.3 -r1.4 --- ChangeLog 9 Aug 2004 21:48:28 -0000 1.3 +++ ChangeLog 9 Aug 2004 22:14:42 -0000 1.4 @@ -12,6 +12,12 @@ style/db_structure.xsl: Fixed minor problems + * config.php5 + tbl.php5 + style/tbl_browse.xsl + style/tbl_browse.css + Added table browse, needs major css work + 2004-08-07 Gordon P. Hemsley <gph...@us...> * config.php5 index.php5 |
|
From: Eric F. <wg...@us...> - 2004-08-09 22:14:51
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin/db In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv5172/db Modified Files: mysqlitedb.sqlite Log Message: Added table browse, needs major css work Index: mysqlitedb.sqlite =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/db/mysqlitedb.sqlite,v retrieving revision 1.3 retrieving revision 1.4 diff -u -d -r1.3 -r1.4 Binary files /tmp/cvsvAS83v and /tmp/cvseYDzGo differ |
|
From: Gordon P. H. <gph...@us...> - 2004-08-09 21:48:36
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv734 Modified Files: ChangeLog Log Message: - Rearranged height specifications. - Fixed minor problems Index: ChangeLog =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/ChangeLog,v retrieving revision 1.2 retrieving revision 1.3 diff -u -d -r1.2 -r1.3 --- ChangeLog 7 Aug 2004 10:29:17 -0000 1.2 +++ ChangeLog 9 Aug 2004 21:48:28 -0000 1.3 @@ -3,6 +3,15 @@ ======================== $Id$ +2004-08-09 Gordon P. Hemsley <gph...@us...> + * style/db_structure.css: + Rearranged height specifications. + +2004-08-09 Eric Faerber <wg...@us...> + * db.php5 + style/db_structure.xsl: + Fixed minor problems + 2004-08-07 Gordon P. Hemsley <gph...@us...> * config.php5 index.php5 |
|
From: Gordon P. H. <gph...@us...> - 2004-08-09 21:47:01
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin/style In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv488/style Modified Files: db_structure.css Log Message: Rearranged height specifications. Index: db_structure.css =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/style/db_structure.css,v retrieving revision 1.2 retrieving revision 1.3 diff -u -d -r1.2 -r1.3 --- db_structure.css 7 Aug 2004 10:19:51 -0000 1.2 +++ db_structure.css 9 Aug 2004 21:46:52 -0000 1.3 @@ -31,8 +31,8 @@ } .table_row { - height: 20px; width: 100%; + height: 20px; } .checkbox { @@ -57,8 +57,8 @@ .structure { float: left; - height: 20px; width: 10%; + height: 20px; border-width: 1px 1px 1px 0px; border-color: #000000; border-style: solid; @@ -68,8 +68,8 @@ .browse { float: left; - height: 20px; width: 10%; + height: 20px; border-width: 1px 1px 1px 0px; border-color: #000000; border-style: solid; @@ -79,8 +79,8 @@ .input { float: left; - height: 20px; width: 10%; + height: 20px; border-width: 1px 1px 1px 0px; border-color: #000000; border-style: solid; @@ -90,8 +90,8 @@ .empty { float: left; - height: 20px; width: 10%; + height: 20px; border-width: 1px 1px 1px 0px; border-color: #000000; border-style: solid; @@ -101,8 +101,8 @@ .drop { float: left; - height: 20px; width: 10%; + height: 20px; border-width: 1px 1px 1px 0px; border-color: #000000; border-style: solid; |
|
From: Eric F. <wg...@us...> - 2004-08-09 21:29:49
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv29621 Modified Files: db.php5 Log Message: Fixed minor problems Index: db.php5 =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/db.php5,v retrieving revision 1.2 retrieving revision 1.3 diff -u -d -r1.2 -r1.3 --- db.php5 7 Aug 2004 10:19:50 -0000 1.2 +++ db.php5 9 Aug 2004 21:29:39 -0000 1.3 @@ -43,7 +43,6 @@ $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"; switch( $mode ) { @@ -64,6 +63,7 @@ // List tables, the DB structure default: + print '<?xml-stylesheet href="style/db_structure.xsl" type="text/xsl" ?>' . "\n"; print "<tables>\n"; $sql = "SELECT name |
|
From: Eric F. <wg...@us...> - 2004-08-09 21:29:49
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin/style In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv29621/style Modified Files: db_structure.xsl Log Message: Fixed minor problems Index: db_structure.xsl =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/style/db_structure.xsl,v retrieving revision 1.2 retrieving revision 1.3 diff -u -d -r1.2 -r1.3 --- db_structure.xsl 7 Aug 2004 10:19:51 -0000 1.2 +++ db_structure.xsl 9 Aug 2004 21:29:40 -0000 1.3 @@ -32,11 +32,11 @@ <div class="table_row"> <div class="checkbox"><input type="checkbox"><xsl:attribute name="name"><xsl:value-of select="name" /></xsl:attribute></input></div> <div class="table"><b><xsl:value-of select="name" /></b></div> - <div class="structure"><a><xsl:attribute name="href">./tbl.php5?mode=structure&tbl=<xsl:value-of select="name" />&db=<xsl:value-of select="db" /></xsl:attribute>structure</a></div> - <div class="browse"><a><xsl:attribute name="href">./tbl.php5?mode=browse&tbl=<xsl:value-of select="name" />&db=<xsl:value-of select="db" /></xsl:attribute>browse</a></div> - <div class="input"><a><xsl:attribute name="href">./tbl.php5?mode=input&tbl=<xsl:value-of select="name" />&db=<xsl:value-of select="db" /></xsl:attribute>input</a></div> - <div class="empty"><a><xsl:attribute name="href">./tbl.php5?mode=empty&tbl=<xsl:value-of select="name" />&db=<xsl:value-of select="db" /></xsl:attribute>empty</a></div> - <div class="drop"><a><xsl:attribute name="href">./tbl.php5?mode=drop&tbl=<xsl:value-of select="name" />&db=<xsl:value-of select="db" /></xsl:attribute>drop</a></div> + <div class="structure"><a><xsl:attribute name="href">./tbl.php5?mode=structure&tbl=<xsl:value-of select="name" />&db=<xsl:value-of select="db" /></xsl:attribute>Structure</a></div> + <div class="browse"><a><xsl:attribute name="href">./tbl.php5?mode=browse&tbl=<xsl:value-of select="name" />&db=<xsl:value-of select="db" /></xsl:attribute>Browse</a></div> + <div class="input"><a><xsl:attribute name="href">./tbl.php5?mode=input&tbl=<xsl:value-of select="name" />&db=<xsl:value-of select="db" /></xsl:attribute>Insert</a></div> + <div class="empty"><a><xsl:attribute name="href">./tbl.php5?mode=empty&tbl=<xsl:value-of select="name" />&db=<xsl:value-of select="db" /></xsl:attribute>Empty</a></div> + <div class="drop"><a><xsl:attribute name="href">./tbl.php5?mode=drop&tbl=<xsl:value-of select="name" />&db=<xsl:value-of select="db" /></xsl:attribute>Drop</a></div> <div class="records">records?</div> <div class="size">size?</div> </div> |
|
From: Gordon P. H. <gph...@us...> - 2004-08-07 10:29:25
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv28546 Modified Files: ChangeLog Log Message: Line endings change. Index: ChangeLog =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/ChangeLog,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- ChangeLog 7 Aug 2004 10:20:39 -0000 1.1 +++ ChangeLog 7 Aug 2004 10:29:17 -0000 1.2 @@ -1,41 +1,42 @@ -======================== - phpLiteAdmin ChangeLog -======================== -$Id$ - -2004-08-07 Gordon P. Hemsley <gph...@us...> - * config.php5 - index.php5 - main.php5: - Allow for configuration and customization settings. - * db.php5 - navbar.php5 - db/mysqlitedb.sqlite - style/db_structure.css - style/db_structure.xsl - style/main.xsl - style/navbar.xsl: - Code cleanup and GUI formatting. - -2004-08-04 Eric Faerber <wg...@us...> - * db.php5 - index.php5 - navbar.php5 - db/mysqlitedb.sqlite - style/db_structure.css - style/db_structure.xsl - style/navbar.xsl: - Added DB Structure - -2004-08-03 Eric Faerber <wg...@us...> - * index.php5 - main.php5 - navbar.php5 - db/mysqlitedb.sqlite - db/test.sqlite - lib/sqlite.php5 - style/main.css - style/main.xsl - style/navbar.css - style/navbar.xsl: +======================== + phpLiteAdmin ChangeLog +======================== +$Id$ + +2004-08-07 Gordon P. Hemsley <gph...@us...> + * config.php5 + index.php5 + main.php5: + Allow for configuration and customization settings. + + * db.php5 + navbar.php5 + db/mysqlitedb.sqlite + style/db_structure.css + style/db_structure.xsl + style/main.xsl + style/navbar.xsl: + Code cleanup and GUI formatting. + +2004-08-04 Eric Faerber <wg...@us...> + * db.php5 + index.php5 + navbar.php5 + db/mysqlitedb.sqlite + style/db_structure.css + style/db_structure.xsl + style/navbar.xsl: + Added DB Structure + +2004-08-03 Eric Faerber <wg...@us...> + * index.php5 + main.php5 + navbar.php5 + db/mysqlitedb.sqlite + db/test.sqlite + lib/sqlite.php5 + style/main.css + style/main.xsl + style/navbar.css + style/navbar.xsl: Initial Commit (GPHemsley) \ No newline at end of file |
|
From: Gordon P. H. <gph...@us...> - 2004-08-07 10:20:55
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv27597 Added Files: ChangeLog Log Message: - Allow for configuration and customization settings. - Code cleanup and GUI formatting. --- NEW FILE: ChangeLog --- ======================== phpLiteAdmin ChangeLog ======================== $Id: ChangeLog,v 1.1 2004/08/07 10:20:39 gphemsley Exp $ 2004-08-07 Gordon P. Hemsley <gph...@us...> * config.php5 index.php5 main.php5: Allow for configuration and customization settings. * db.php5 navbar.php5 db/mysqlitedb.sqlite style/db_structure.css style/db_structure.xsl style/main.xsl style/navbar.xsl: Code cleanup and GUI formatting. 2004-08-04 Eric Faerber <wg...@us...> * db.php5 index.php5 navbar.php5 db/mysqlitedb.sqlite style/db_structure.css style/db_structure.xsl style/navbar.xsl: Added DB Structure 2004-08-03 Eric Faerber <wg...@us...> * index.php5 main.php5 navbar.php5 db/mysqlitedb.sqlite db/test.sqlite lib/sqlite.php5 style/main.css style/main.xsl style/navbar.css style/navbar.xsl: Initial Commit (GPHemsley) |
|
From: Gordon P. H. <gph...@us...> - 2004-08-07 10:20:04
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin/style In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv27459/style Modified Files: db_structure.css db_structure.xsl main.xsl navbar.xsl Log Message: Code cleanup and GUI formatting. Index: navbar.xsl =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/style/navbar.xsl,v retrieving revision 1.3 retrieving revision 1.4 diff -u -d -r1.3 -r1.4 --- navbar.xsl 4 Aug 2004 21:08:54 -0000 1.3 +++ navbar.xsl 7 Aug 2004 10:19:51 -0000 1.4 @@ -10,14 +10,20 @@ </head> <body> <ul> - <xsl:for-each select="databases/database"> + <xsl:for-each select="/databases/database"> <li><a> <xsl:attribute name="href">./db.php5?db=<xsl:value-of select="@name" /></xsl:attribute> <xsl:attribute name="target">main</xsl:attribute> <xsl:value-of select="@name" /> </a> <ul> - <li><xsl:value-of select="table" /></li> + <xsl:for-each select="table"> + <li><a> + <xsl:attribute name="href">./tbl.php5?mode=structure&tbl=<xsl:value-of select="." />&db=<xsl:value-of select="/databases/database/@name" /></xsl:attribute> + <xsl:attribute name="target">main</xsl:attribute> + <xsl:value-of select="." /> + </a></li> + </xsl:for-each> </ul> </li> </xsl:for-each> Index: main.xsl =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/style/main.xsl,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- main.xsl 4 Aug 2004 01:53:02 -0000 1.1 +++ main.xsl 7 Aug 2004 10:19:51 -0000 1.2 @@ -10,7 +10,8 @@ </head> <body> <h1>Welcome to phpLiteAdmin</h1> - <strong>SQLite <xsl:value-of select="content/details/version" /></strong> + <p><strong>SQLite <xsl:value-of select="/content/details/version" /></strong></p> + <p>Use the navigation panel on the left to navigate to your desired location.</p> </body> </html> Index: db_structure.css =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/style/db_structure.css,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- db_structure.css 4 Aug 2004 21:06:24 -0000 1.1 +++ db_structure.css 7 Aug 2004 10:19:51 -0000 1.2 @@ -31,98 +31,101 @@ } .table_row { - width: 100%; height: 20px; - border-width: 1px 0px 1px 0px; - border-color: #000000; - border-style: solid; + width: 100%; } .checkbox { float: left; - width: 5%; height: 20px; - border-width: 0px 1px 0px 1px; + border-width: 1px 1px 1px 1px; border-color: #000000; border-style: solid; + padding: 0px 3px; } .table { float: left; - width: 25%; + width: 20%; height: 20px; - border-width: 0px 1px 0px 0px; + border-width: 1px 1px 1px 0px; border-color: #000000; border-style: solid; text-align: left; + padding: 0px 3px; } .structure { float: left; - width: 10%; height: 20px; - border-width: 0px 1px 0px 0px; + width: 10%; + border-width: 1px 1px 1px 0px; border-color: #000000; border-style: solid; text-align: center; + padding: 0px 3px; } .browse { float: left; - width: 10%; height: 20px; - border-width: 0px 1px 0px 0px; + width: 10%; + border-width: 1px 1px 1px 0px; border-color: #000000; border-style: solid; text-align: center; + padding: 0px 3px; } .input { float: left; - width: 10%; height: 20px; - border-width: 0px 1px 0px 0px; + width: 10%; + border-width: 1px 1px 1px 0px; border-color: #000000; border-style: solid; text-align: center; + padding: 0px 3px; } .empty { float: left; - width: 10%; height: 20px; - border-width: 0px 1px 0px 0px; + width: 10%; + border-width: 1px 1px 1px 0px; border-color: #000000; border-style: solid; text-align: center; + padding: 0px 3px; } .drop { float: left; - width: 8%; height: 20px; - border-width: 0px 1px 0px 0px; + width: 10%; + border-width: 1px 1px 1px 0px; border-color: #000000; border-style: solid; text-align: center; + padding: 0px 3px; } .records { float: left; - width: 10%; height: 20px; - border-width: 0px 1px 0px 0px; + border-width: 1px 1px 1px 0px; border-color: #000000; border-style: solid; - text-align: right; + text-align: center; + padding: 0px 3px; } .size { float: left; - width: 10%; height: 20px; - border-width: 0px 1px 0px 0px; + border-width: 1px 1px 1px 0px; border-color: #000000; border-style: solid; - text-align: right; + text-align: center; + padding: 0px 3px; } \ No newline at end of file Index: db_structure.xsl =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/style/db_structure.xsl,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- db_structure.xsl 4 Aug 2004 21:06:24 -0000 1.1 +++ db_structure.xsl 7 Aug 2004 10:19:51 -0000 1.2 @@ -9,24 +9,26 @@ <link rel="stylesheet" href="style/db_structure.css" type="text/css" /> </head> <body> - <h1>Database: <xsl:value-of select="tables/table/db" /></h1> + <h1>Database: <xsl:value-of select="/tables/table/db" /></h1> <div id="nav"> <div class="nav_option"> - <a><xsl:attribute name="href">db.php5?db=<xsl:value-of select="tables/table/db" /></xsl:attribute>Structure</a> + <a><xsl:attribute name="href">db.php5?db=<xsl:value-of select="/tables/table/db" /></xsl:attribute>Structure</a> </div> <div class="nav_option"> - <a><xsl:attribute name="href">db.php5?mode=sql&db=<xsl:value-of select="tables/table/db" /></xsl:attribute>SQL</a> + <a><xsl:attribute name="href">db.php5?mode=sql&db=<xsl:value-of select="/tables/table/db" /></xsl:attribute>SQL</a> </div> <div class="nav_option"> - <a><xsl:attribute name="href">db.php5?mode=export&db=<xsl:value-of select="tables/table/db" /></xsl:attribute>Export</a> + <a><xsl:attribute name="href">db.php5?mode=export&db=<xsl:value-of select="/tables/table/db" /></xsl:attribute>Export</a> </div> <div class="nav_option"> - <a><xsl:attribute name="href">db.php5?mode=drop&db=<xsl:value-of select="tables/table/db" /></xsl:attribute>Drop</a> + <a><xsl:attribute name="href">db.php5?mode=drop&db=<xsl:value-of select="/tables/table/db" /></xsl:attribute>Drop</a> </div> </div> + <br /> + <div id="tables"> - <xsl:for-each select="tables/table"> + <xsl:for-each select="/tables/table"> <div class="table_row"> <div class="checkbox"><input type="checkbox"><xsl:attribute name="name"><xsl:value-of select="name" /></xsl:attribute></input></div> <div class="table"><b><xsl:value-of select="name" /></b></div> |
|
From: Gordon P. H. <gph...@us...> - 2004-08-07 10:20:03
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv27459 Modified Files: db.php5 navbar.php5 Log Message: Code cleanup and GUI formatting. Index: navbar.php5 =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/navbar.php5,v retrieving revision 1.2 retrieving revision 1.3 diff -u -d -r1.2 -r1.3 --- navbar.php5 4 Aug 2004 21:06:24 -0000 1.2 +++ navbar.php5 7 Aug 2004 10:19:50 -0000 1.3 @@ -10,67 +10,57 @@ * Side navigation panel */ +include_once( 'config.php5' ); + header( 'Content-Type: text/xml; charset=UTF-8' ); include( 'lib/sqlite.php5' ); -$Database = new Database( 'db/mysqlitedb.sqlite', 0777, $sqlite_error ); - print '<?xml version="1.0" encoding="UTF-8" ?>' . "\n"; print '<?xml-stylesheet href="style/navbar.xsl" type="text/xsl" ?>' . "\n"; print "<databases>\n"; -if( $Database->connected ) -{ -/* 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' ); - var_dump( $Database->fetch_array( $result ) );*/ - - $databases = array(); - $dir = @opendir( 'db/' ); +$databases = array(); +$dir = @opendir( 'db/' ); - while( ( $file = @readdir( $dir ) ) !== FALSE ) +while( ( $file = @readdir( $dir ) ) !== FALSE ) +{ + if( preg_match( '#(.*?)\.sqlite$#', $file ) ) { - if( preg_match( '#(.*?)\.sqlite$#', $file ) ) - { - $contents = (string) fread( fopen( "db/$file", 'r' ), 50 ); + $contents = (string) fread( fopen( "db/$file", 'r' ), 50 ); - if( preg_match( '#\*\* This file contains an SQLite (\d*\.\d*) database \*\*#', $contents ) ) - { - $databases[] = $file; - } + if( preg_match( '#\*\* This file contains an SQLite (\d*\.\d*) database \*\*#', $contents ) ) + { + $databases[] = $file; } } +} -// var_dump( $databases ); +//var_dump( $databases ); - foreach( $databases as $db ) - { - print "\t" . '<database name="' . substr( $db, 0, -7 ) . '">' . "\n"; +foreach( $databases as $db ) +{ + $Database = new Database( "db/$db", 0777, &$sqlite_error ); - $sql = "SELECT name - FROM sqlite_master - WHERE type = 'table' - ORDER BY name ASC"; + print "\t" . '<database name="' . substr( $db, 0, -7 ) . '">' . "\n"; - $result = $Database->query( $sql ); + $sql = "SELECT name + FROM sqlite_master + WHERE type = 'table' + ORDER BY name ASC"; - while( $row = $Database->fetch_array( $result ) ) - { - print "\t\t<table>" . $row['name'] . "</table>\n"; - } + $result = $Database->query( $sql ); - print "\t</database>\n"; + while( $row = $Database->fetch_array( $result ) ) + { + print "\t\t<table>" . $row['name'] . "</table>\n"; } + + print "\t</database>\n"; } -else -{ - die( $sqlite_error ); -} + +unset( $Database ); print "</databases>\n"; Index: db.php5 =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/db.php5,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- db.php5 4 Aug 2004 21:06:24 -0000 1.1 +++ db.php5 7 Aug 2004 10:19:50 -0000 1.2 @@ -10,19 +10,23 @@ * Stucture for databases */ -if ( isset($_GET['db']) || isset($_POST['db']) ) +include_once( 'config.php5' ); + +if( isset( $_REQUEST['db'] ) ) { - $db_path = ( $_GET['db'] ) ? $_GET['db'] : $_POST['db']; + $db_path = $_REQUEST['db']; - if ( !preg_match("/db\//i", $db_path) ) + if ( !( preg_match( '#db/#i', $db_path ) ) ) { $db_path = 'db/' . $db_path; } - if ( !preg_match("/\.sqlite/i", $db_path) ) + + if ( !( preg_match( '#\.sqlite#i', $db_path ) ) ) { $db_path .= '.sqlite'; } - $db_name = preg_replace("/db\/(.*?)\.sqlite/i", "\\1", $db_path); + + $db_name = preg_replace( '#db/(.*?)\.sqlite#i', '\\1', $db_path ); } else { @@ -30,72 +34,55 @@ exit; } -if ( isset($_GET['mode']) || isset($_POST['mode']) ) -{ - $mode = ( $_GET['mode'] ) ? $_GET['mode'] : $_POST['mode']; -} -else -{ - $mode = ''; -} +$mode = ( isset( $_REQUEST['mode'] ) ) ? $_REQUEST['mode'] : ''; - header( 'Content-Type: text/xml; charset=UTF-8' ); include( 'lib/sqlite.php5' ); -$Database = new Database( $db_path, 0777, $sqlite_error ); +$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 an SQL query + case 'sql': - switch( $mode ) - { - // execute a sql query - case 'sql': - - break; + break; - // export the database - case 'export': + // Export the database + case 'export': - break; + break; - //drop the database - case 'drop': + // Drop the database + case 'drop': - break; + break; - // list tables, the db structure - default: - print "<tables>\n"; + // List tables, the DB structure + default: + print "<tables>\n"; - - $sql = "SELECT name - FROM sqlite_master - WHERE type = 'table' - ORDER BY name ASC"; + $sql = "SELECT name + FROM sqlite_master + WHERE type = 'table' + ORDER BY name ASC"; - $result = $Database->query( $sql ); + $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"; - } + 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 ); + print "</tables>\n"; + break; } ?> \ No newline at end of file |
|
From: Gordon P. H. <gph...@us...> - 2004-08-07 10:20:01
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin/db In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv27459/db Modified Files: mysqlitedb.sqlite Log Message: Code cleanup and GUI formatting. Index: mysqlitedb.sqlite =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/db/mysqlitedb.sqlite,v retrieving revision 1.2 retrieving revision 1.3 diff -u -d -r1.2 -r1.3 Binary files /tmp/cvseTRwbr and /tmp/cvsVpalWf differ |
|
From: Gordon P. H. <gph...@us...> - 2004-08-07 10:19:19
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv27413 Modified Files: index.php5 main.php5 Added Files: config.php5 Log Message: Allow for configuration and customization settings. Index: index.php5 =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/index.php5,v retrieving revision 1.2 retrieving revision 1.3 diff -u -d -r1.2 -r1.3 --- index.php5 4 Aug 2004 21:06:24 -0000 1.2 +++ index.php5 7 Aug 2004 10:19:10 -0000 1.3 @@ -7,10 +7,10 @@ /** * $Id$ - * Index file... uh, yeah... + * Sets up frame structure */ -error_reporting( E_ALL | E_STRICT ); +include_once( 'config.php5' ); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Frameset//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-frameset.dtd"> @@ -18,8 +18,11 @@ <head> <title>phpLiteAdmin</title> </head> - <frameset cols="150,*" rows="*"> + <frameset cols="<?php print $config['navbar_width']; ?>,*" 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> + <noframes> + <p>phpLiteAdmin requires frames to be supported and enabled in order to function properly.</p> + </noframes> </html> \ No newline at end of file --- NEW FILE: config.php5 --- <?php /** * @name phpLiteAdmin * @copyright 2004 phpLiteAdmin Team */ /** * $Id: config.php5,v 1.1 2004/08/07 10:19:10 gphemsley Exp $ * Configuration and customization settings */ error_reporting( E_ALL | E_STRICT ); // DO NOT CHANGE THIS! @ini_set( 'display_errors', '1' ); // DO NOT CHANGE THIS! // Placeholder for customization options // In the form of $config['setting'] $config['navbar_width'] = '150'; // Default: 150 /* DO NOT EDIT BELOW THIS LINE! */ $config['revision'] = '$Revision: 1.1 $'; ?> Index: main.php5 =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/main.php5,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- main.php5 4 Aug 2004 01:53:02 -0000 1.1 +++ main.php5 7 Aug 2004 10:19:10 -0000 1.2 @@ -10,11 +10,13 @@ * Main page content */ +include_once( 'config.php5' ); + header( 'Content-Type: text/xml; charset=UTF-8' ); include( 'lib/sqlite.php5' ); -$Database = new Database( 'db/mysqlitedb.sqlite', 0777, $sqlite_error ); +$Database = new Database( 'db/mysqlitedb.sqlite', 0777, &$sqlite_error ); print '<?xml version="1.0" encoding="UTF-8" ?>' . "\n"; print '<?xml-stylesheet href="style/main.xsl" type="text/xsl" ?>' . "\n"; |
|
From: Eric F. <wg...@us...> - 2004-08-04 21:09:03
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin/style In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11704/style Modified Files: navbar.xsl Log Message: Added DB Structure Index: navbar.xsl =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/style/navbar.xsl,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** navbar.xsl 4 Aug 2004 21:06:24 -0000 1.2 --- navbar.xsl 4 Aug 2004 21:08:54 -0000 1.3 *************** *** 2,7 **** <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> - <xsl:output method="html"/> - <xsl:template match="/"> --- 2,5 ---- |
