Menu
▾
▴
phpsqliteadmin-devel — phpSQLiteAdmin developer mailing list
You can subscribe to this list here.
| 2004 |
Jan
|
Feb
|
Mar
(12) |
Apr
(1) |
May
(19) |
Jun
(5) |
Jul
|
Aug
|
Sep
|
Oct
(2) |
Nov
(26) |
Dec
(3) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2005 |
Jan
(12) |
Feb
|
Mar
(26) |
Apr
(11) |
May
(8) |
Jun
|
Jul
(20) |
Aug
(13) |
Sep
(23) |
Oct
(2) |
Nov
|
Dec
|
| 2007 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(3) |
Dec
|
| 2008 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
(22) |
Aug
(4) |
Sep
(3) |
Oct
(4) |
Nov
(1) |
Dec
(1) |
| 2009 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(6) |
Dec
(2) |
| 2010 |
Jan
(3) |
Feb
(2) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(1) |
Nov
(2) |
Dec
(1) |
| 2011 |
Jan
(3) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2012 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2013 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
| 2016 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Steve D. <sd...@wo...> - 2004-11-07 18:28:10
|
>>I think the class needs to be tweaked a little bit. I havent looked >>at all of it, but I don't like how on $class->query it returns an >>HTML error if there's a problem. I'd rather have it return bool >>true/false, and then output the error to an object variable, and be >>able to display it with another function (similar to PEAR's DB >>class). > > > yes that's true. The class was and is a good idea, but it should be > solid and clean. > > I have to admit that since some time I did not hack on phpsqliteadmin > anymore, neither did Felipe. > > But we still love the project and I think that we should be able to > restart development and release a new version if there are some new > features. A new team member is great news for us! > > Do you plan to work more on a regular base on phpsla? Yah, I'm planning on working on it quite a bit now. I'm ditching MySQL for SQLite, and I use phpMyAdmin a lot, so I really need a replacment tool. I think I can hack on it enough to get it working, so that's why I'm trying. I've already started changing a lot of stuff around, and I'll submit the changes when I have something that actually works. I've mostly just been cleaning up the code and adding some new functionality. I'm also working on a new class named PMA which stores the common functions. My coding style is usually that if there's anything I have to do more than once, I'll dump it in a function to save time. :) I'm also writing the new class so it's compatible with PhpDocumentor so I can generate a helpfile which explains everything. Ideally, what I would like to do, is use PEAR's DB class instead of the SQLite class included. The reason being that PEAR's class is already available publically, and has some great functionality, but it's sqlite support is a little weak. It would be great if we could submit patches to them using the old SQLite class, and whatever they don't accept, I can put in the PSA class instead. There's only a few areas whey their class is lacking (and I remember seeing a webpage once that described it's functionality for each database, but I couldnt find it) and they are mostly small things like getting the table information, getting the database information, etc. Stuff like that. It would need also stuff that's singular to SQLite like grabbing the schema, and we could add in our own class a way to alter tables by copying to temporary tables and stuff like that. As far as the look and feel, I don't know if you'll like all my changes or not -- I'm kind of modeling it after phpMyAdmin a bit since that's what I'm familiar with. I'm mostly just taking this of the approach of where it has the functionality I'd like to have, and then going back and cleaning it up to make it pretty. :) Steve |
|
From: Yves G. <yg...@mi...> - 2004-11-07 10:16:13
|
On Friday 05 November 2004 20:14, Steve Dibb wrote: > Here's my minor changes, since I'm not gonna have time to finish this > up today. > > http://sdibb.frogcircus.org/psa_20041105.tgz > > You can see the diffs by running rcsdiff -r1.1 -r1.2 * thanks, will try to check it out asap > I also stole phpmyadmin's images and put them in img/ :-D > Also created a basic phpdocumenation from the SQLite class in phpdoc/ cool > I think the class needs to be tweaked a little bit. I havent looked > at all of it, but I don't like how on $class->query it returns an > HTML error if there's a problem. I'd rather have it return bool > true/false, and then output the error to an object variable, and be > able to display it with another function (similar to PEAR's DB > class). yes that's true. The class was and is a good idea, but it should be solid and clean. I have to admit that since some time I did not hack on phpsqliteadmin anymore, neither did Felipe. But we still love the project and I think that we should be able to restart development and release a new version if there are some new features. A new team member is great news for us! Do you plan to work more on a regular base on phpsla? cu, Yves > Steve > > > > ------------------------------------------------------- > This SF.Net email is sponsored by: > Sybase ASE Linux Express Edition - download now for FREE > LinuxWorld Reader's Choice Award Winner for best database on Linux. > http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click > _______________________________________________ > Phpsqliteadmin-devel mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpsqliteadmin-devel -- Linux 2.6.8.1 #1 Sun Oct 31 11:27:19 CET 2004 i686 11:10:24 up 1:03, 1 user, load average: 2.70, 1.62, 1.33 |
|
From: Yves G. <yg...@mi...> - 2004-11-07 10:09:53
|
On Friday 05 November 2004 19:56, Steve Dibb wrote: > Hey guys, Hi Steve, > I'm working on an edit row patch right now. I've actually got it > working, and I'll submit it once you can delete a row, too. Thats great news! > The only bad side effect that I noticed is that SQLite doesn't allow > the LIMIT clause when using DELETE or UPDATE unlike MySQL. Bummer. > So what happens is when you update a row there's no way to tell it to > limit it to one instance. The workaround I coded was to update the > row where the old values match. That'll work, but it will also > update/delete if there's more than one row. If you guys know a > workaround to create a safety net, that'd be cool. Of course, it's a > rare occurence it'd be needed, but still. well right now I don't know a real workaround for that... maybe we should disable row edit/delete in case a table has no primary key, or an other possibility would be to show an intermediary page that shows the user which rows are to be updated/deleted (in case more than 1 row would be affected) > The other thing is that in order to access SQLite through the web on > linux, the database AND it's directory need to be world writeable. > So I created a new directory named db and dumped phpsla.sqilte in > there. very good idea, thank you! > What's the best way to submit patches anyway? right now I'd say, send them to this list as an attachment. In case you want to contribute regurlarly, using cvs would be the best. hope to hear from you soon, Yves > Steve > > > > ------------------------------------------------------- > This SF.Net email is sponsored by: > Sybase ASE Linux Express Edition - download now for FREE > LinuxWorld Reader's Choice Award Winner for best database on Linux. > http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click > _______________________________________________ > Phpsqliteadmin-devel mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpsqliteadmin-devel -- Linux 2.6.8.1 #1 Sun Oct 31 11:27:19 CET 2004 i686 11:04:26 up 57 min, 1 user, load average: 2.13, 1.09, 1.22 |
|
From: Steve D. <sd...@wo...> - 2004-11-05 19:14:41
|
Here's my minor changes, since I'm not gonna have time to finish this up today. http://sdibb.frogcircus.org/psa_20041105.tgz You can see the diffs by running rcsdiff -r1.1 -r1.2 * I also stole phpmyadmin's images and put them in img/ Also created a basic phpdocumenation from the SQLite class in phpdoc/ I think the class needs to be tweaked a little bit. I havent looked at all of it, but I don't like how on $class->query it returns an HTML error if there's a problem. I'd rather have it return bool true/false, and then output the error to an object variable, and be able to display it with another function (similar to PEAR's DB class). Steve |
|
From: Steve D. <sd...@wo...> - 2004-11-05 18:56:23
|
Hey guys, I'm working on an edit row patch right now. I've actually got it working, and I'll submit it once you can delete a row, too. The only bad side effect that I noticed is that SQLite doesn't allow the LIMIT clause when using DELETE or UPDATE unlike MySQL. Bummer. So what happens is when you update a row there's no way to tell it to limit it to one instance. The workaround I coded was to update the row where the old values match. That'll work, but it will also update/delete if there's more than one row. If you guys know a workaround to create a safety net, that'd be cool. Of course, it's a rare occurence it'd be needed, but still. The other thing is that in order to access SQLite through the web on linux, the database AND it's directory need to be world writeable. So I created a new directory named db and dumped phpsla.sqilte in there. What's the best way to submit patches anyway? Steve |
|
From: Yves G. <yg...@mi...> - 2004-10-11 18:52:26
|
On Sunday 10 October 2004 15:46, Robin Bowes wrote: > Hi, Hi, > I've just pulled the latest version from CVS (as of about 14:00 UTC > 2004-10-20) and it doesn't seem to work. :-( > Here's what I see in the apache error log: > > [client 192.168.2.128] PHP Notice: Use of undefined constant > SQLITE_BOTH - assumed 'SQLITE_BOTH' in > /home/apache/robinbowes.com/phpsqliteadmin/main-CVS/include > .php on line 30 > [Sun Oct 10 14:45:12 2004] [error] [client 192.168.2.128] File does > not exist: > /home/apache/robinbowes.com/phpsqliteadmin/live/favicon.ico > > Any suggestions? Well this is a PHP-notice, and I have them turned off... Could you try setting up your webserver the way that PHP does not print=20 out notices? Tell me if you still have trouble, best regards Yves > Thanks, > > R. =2D-=20 Linux 2.4.27 #1 Sun Aug 8 13:07:51 CEST 2004 i686 20:18:26 up 20 min, 1 user, load average: 1.99, 0.68, 0.33 |
|
From: Robin B. <rob...@ro...> - 2004-10-10 13:47:51
|
Hi, I've just pulled the latest version from CVS (as of about 14:00 UTC 2004-10-20) and it doesn't seem to work. Here's what I see in the apache error log: [client 192.168.2.128] PHP Notice: Use of undefined constant SQLITE_BOTH - assumed 'SQLITE_BOTH' in /home/apache/robinbowes.com/phpsqliteadmin/main-CVS/include .php on line 30 [Sun Oct 10 14:45:12 2004] [error] [client 192.168.2.128] File does not exist: /home/apache/robinbowes.com/phpsqliteadmin/live/favicon.ico Any suggestions? Thanks, R. -- http://robinbowes.com |
|
From: Yves G. <yg...@us...> - 2004-06-27 21:34:49
|
Update of /cvsroot/phpsqliteadmin/phpsqliteadmin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv12141 Modified Files: index.php check_login.php login.class.php table_structure.php include.php dbconfig.php dbaction.php query.php config.php table_browse.php leftframe.php changelog.txt mainframe.php editdb.php Log Message: Converted from html 4.01 to xhtml 1.0 transitional (not that much changes have been necessary... :-) ) The alias configuration now always comes back to the mainframe, and not "_top" Misc. html fixes Index: index.php =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin/index.php,v retrieving revision 1.2 retrieving revision 1.3 diff -u -d -r1.2 -r1.3 --- index.php 21 May 2004 17:05:03 -0000 1.2 +++ index.php 27 Jun 2004 21:34:36 -0000 1.3 @@ -4,23 +4,25 @@ require_once('include.php'); ?> -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN"> -<html> +<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Frameset//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-frameset.dtd"> +<html xmlns="http://www.w3.org/1999/xhtml"> <head> - <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> - <meta http-equiv="expires" content="0"> + <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-15" /> + <link href="phpsla.css" rel="stylesheet" type="text/css" /> <title>phpSQLiteAdmin</title> + <meta http-equiv="expires" content="0" /> + <meta http-equiv="pragma" content="no-cache" /> + <meta http-equiv="cache-control" content="no-cache" /> <script language="Javascript" src="javascript.txt" type="text/javascript"></script> - <link href="phpsla.css" rel="stylesheet" type="text/css"> </head> <frameset cols="150,*"> <!-- -<frame src="leftframe.php?<?=SID?>" name=tablelist scrolling=auto> -<frame src="mainframe.php?<?=SID?>" name=mainframe scrolling=auto> +<frame src="leftframe.php?<?=SID?>" name="tablelist" scrolling="auto" /> +<frame src="mainframe.php?<?=SID?>" name="mainframe" scrolling="auto" /> --> -<frame src="leftframe.php" name=tablelist scrolling=auto> -<frame src="mainframe.php" name=mainframe scrolling=auto> +<frame src="leftframe.php" name="tablelist" scrolling="auto" /> +<frame src="mainframe.php" name="mainframe" scrolling="auto" /> </frameset> </html> Index: changelog.txt =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin/changelog.txt,v retrieving revision 1.3 retrieving revision 1.4 diff -u -d -r1.3 -r1.4 --- changelog.txt 21 May 2004 19:25:42 -0000 1.3 +++ changelog.txt 27 Jun 2004 21:34:36 -0000 1.4 @@ -1,10 +1,12 @@ -phpSQLiteAdmin changelog +phpSQLiteAdmin changelog ( see http://phpsqliteadmin.sourceforge.net/ for more details) -(21.05.2004) +0.3 (xx.xx.2004) - added login - fixed session problem concerning database names - added field names on browse +- converted from html 4.01 to xhtml 1.0 transitional +- fixed the alias configurator to return always to the mainframe window and not the "_top" window 0.2 (05.03.2004) Index: editdb.php =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin/editdb.php,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -u -d -r1.1.1.1 -r1.2 --- editdb.php 11 May 2004 18:23:20 -0000 1.1.1.1 +++ editdb.php 27 Jun 2004 21:34:36 -0000 1.2 @@ -19,7 +19,7 @@ $sysdbh->query("insert into databases (user,alias,path,description) values ({$alias->user},'{$alias->alias}','{$alias->path}','{$alias->description}')"); // do we really want this? $_SESSION['phpSQLiteAdmin_currentdb'] = $alias->path; - header("Location: index.php"); + header("Location: dbconfig.php"); exit; } @@ -39,7 +39,7 @@ if (isset($_POST['update'])) { $sysdbh->query("update databases set alias = '{$alias->alias}', path = '{$alias->path}', description = '{$alias->description}' where user = {$alias->user} and alias = '{$_POST[oldalias]}'"); - header("Location: index.php"); + header("Location: dbconfig.php"); exit; } @@ -48,43 +48,46 @@ $sysdbh->query("delete from databases where user = {$alias->user} and alias = '{$alias->alias}'"); //unlink($alias->path); nooooooo don't do that... $_SESSION['phpSQLiteAdmin_currentdb'] = ''; - header("Location: index.php"); + header("Location: dbconfig.php"); exit; } $type = text; echo<<<EOT -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"> -<html> +<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> +<html xmlns="http://www.w3.org/1999/xhtml"> <head> - <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> + <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-15" /> + <link href="phpsla.css" rel="stylesheet" type="text/css" /> <title>phpSQLiteAdmin</title> - <meta http-equiv="expires" content="0"> - <script language="javascript" src="javascript.txt" type="text/javascript"></script> - <link href="phpsla.css" rel="stylesheet" type="text/css"> + <meta http-equiv="expires" content="0" /> + <meta http-equiv="pragma" content="no-cache" /> + <meta http-equiv="cache-control" content="no-cache" /> + <script language="Javascript" src="javascript.txt" type="text/javascript"></script> + <base target="mainframe" /> </head> <body class="right" onload="document.adddb.alias.focus();"> <h3>$title</h3> -<form name="adddb" action="editdb.php" method="post" target="_top"> -<input type="hidden" name="oldalias" value="{$_GET[alias]}"> +<form name="adddb" action="editdb.php" method="post"> +<input type="hidden" name="oldalias" value="{$_GET[alias]}" /> <table> -<tr><td class=label>Alias:</td><td><input type=text size=80 name=alias value="{$alias->alias}"></td></tr> -<tr><td class=label>Path on server:</td><td><input type=$type size=80 name=path value="{$alias->path}"></td></tr> -<tr><td class=label>Description:</td><td><input type=text size=80 name=description value="{$alias->description}"></td></tr> -<tr><td class=label></td><td class=label><input type=submit name=$action value="Save"> <input type=button value="Cancel" onClick="history.back();"></td></tr> -</form> +<tr><td class="label">Alias:</td><td><input type="text" size="80" name="alias" value="{$alias->alias}" /></td></tr> +<tr><td class="label">Path on server:</td><td><input type="$type" size="80" name="path" value="{$alias->path}" /></td></tr> +<tr><td class="label">Description:</td><td><input type="text" size="80" name="description" value="{$alias->description}" /></td></tr> +<tr><td class="label"></td><td class="label"><input type="submit" name="$action" value="Save" /> <input type="button" value="Cancel" onclick="history.back();" /></td></tr> </table> +</form> EOT; if (isset($_GET['alias'])) { echo<<<EOT -<br><br><br><br><br> -<form name=delete action=editdb.php method=post onsubmit="" target="_top"> -<input type=hidden name=user value="{$current_user}"> -<input type=hidden name=alias value="{$_GET[alias]}"> -<input type=submit name=delete value="Remove this alias"> +<br /><br /><br /><br /><br /> +<form name="delete" action="editdb.php" method="post" onsubmit=""> +<input type="hidden" name="use"r value="{$current_user}" /> +<input type="hidden" name="alias" value="{$_GET[alias]}" /> +<input type="submit" name="delete" value="Remove this alias" /> </form> EOT; } @@ -93,5 +96,4 @@ print "</body>\n"; print "</html>\n"; - ?> \ No newline at end of file Index: include.php =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin/include.php,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -u -d -r1.1.1.1 -r1.2 --- include.php 11 May 2004 18:23:21 -0000 1.1.1.1 +++ include.php 27 Jun 2004 21:34:36 -0000 1.2 @@ -26,7 +26,7 @@ // connect to the system database -if (!is_writable('phpsla.sqlite')) die("<br>System database 'phpsla.sqlite' is not writeable by webserver account."); +if (!is_writable('phpsla.sqlite')) die("<br />System database 'phpsla.sqlite' is not writeable by webserver account."); $sysdbh =& new SPSQLite('phpsla.sqlite'); $current_db = $_SESSION['phpSQLiteAdmin_currentdb']; $current_user = 1; @@ -58,14 +58,14 @@ echo<<<EOT <div id="currentdb">Database: {$_SESSION['phpSQLiteAdmin_currentdb']}</div> <p class="sqliteversion">SQLite version: $sqliteversion</p> -<br> +<br /> <a href="mainframe.php" target="mainframe">Back</a> | <a href="table_structure.php?object=$current_table" target="mainframe">Structure</a> | <a href="table_browse.php?object=$current_table" target="mainframe">Browse</a> | <a href="query.php?object=$current_table" target="mainframe">Query</a> | <!--<a href="export.php?object=$current_table" target="mainframe">Export</a> |--> -<a href="dbaction.php?action=empty_table&object=$current_table" target="_top" onclick="return confirm_empty_table();">Empty</a> | -<a href="dbaction.php?action=drop_table&object=$current_table" target="_top" onclick="return confirm_drop_table();">Drop</a> +<a href="dbaction.php?action=empty_table&object=$current_table" target="_top" onclick="return confirm_empty_table();">Empty</a> | +<a href="dbaction.php?action=drop_table&object=$current_table" target="_top" onclick="return confirm_drop_table();">Drop</a> EOT; } @@ -75,8 +75,8 @@ <a href="table_structure.php?object=$current_table" target="mainframe">Structure</a> | <a href="table_browse.php?object=$current_table" target="mainframe">Browse</a> | <a href="query.php?object=$current_table" target="mainframe">Query</a> | -<a href="dbaction.php?action=empty_table&object=$current_table" target="_top" onclick="return confirm_empty_table();">Empty</a> | -<a href="dbaction.php?action=drop_table&object=$current_table" target="_top" onclick="return confirm_drop_table();">Drop</a> +<a href="dbaction.php?action=empty_table&object=$current_table" target="_top" onclick="return confirm_empty_table();">Empty</a> | +<a href="dbaction.php?action=drop_table&object=$current_table" target="_top" onclick="return confirm_drop_table();">Drop</a> EOT; } @@ -84,24 +84,24 @@ function print_index_action_links($current_index) { echo<<<EOT -<a href="dbaction.php?action=drop_index&object=$current_index" target="_top" onclick="return confirm_drop_index();">Drop</a> +<a href="dbaction.php?action=drop_index&object=$current_index" target="_top" onclick="return confirm_drop_index();">Drop</a> EOT; } function print_db_selector($current_db) { global $db_dir,$database,$sysdbh; - print "<form name=choosedb action=\"set_session.php\" method=post target=\"_top\">\n"; - print "<input type=hidden name=sessionname value=phpSQLiteAdmin_currentdb>\n"; - print "<select name=sessionvalue onchange=\"this.form.submit();\">\n"; + print "<form name=\"choosedb\" action=\"set_session.php\" method=\"post\" target=\"_top\">\n"; + print "<input type=\"hidden\" name=\"sessionname\" value=\"phpSQLiteAdmin_currentdb\" />\n"; + print "<select name=\"sessionvalue\" onchange=\"this.form.submit();\">\n"; $sysdbh->query("select alias,path from databases order by alias"); while($row = $sysdbh->fetchArray()) { - //print $row[0].'-'.$current_db."<br>\n"; + //print $row[0].'-'.$current_db."<br />\n"; if ($row[1] != $current_db) { print '<option value="'.$row[1].'">'.$row[0]."</option>\n"; } else { - print '<option value="'.$row[1].'" selected>'.$row[0]."</option>\n"; + print '<option value="'.$row[1].'" selected="selected">'.$row[0]."</option>\n"; } // dunno what this is for... remove it later $available_dbs[] = $row[0]; @@ -180,7 +180,7 @@ var $alias; var $path; var $description; - + function get($user,$alias) { // select here and return object return 0; @@ -205,4 +205,4 @@ $hm_dbpath[] = $hm_dbdir; $hm_dbpath = implode('/',$hm_dbpath); // hoster mode stuff ends here -?> +?> \ No newline at end of file Index: query.php =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin/query.php,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -u -d -r1.1.1.1 -r1.2 --- query.php 11 May 2004 18:23:22 -0000 1.1.1.1 +++ query.php 27 Jun 2004 21:34:36 -0000 1.2 @@ -3,14 +3,16 @@ require_once('include.php'); ?> -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"> -<html> +<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> +<html xmlns="http://www.w3.org/1999/xhtml"> <head> - <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> + <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-15" /> + <link href="phpsla.css" rel="stylesheet" type="text/css" /> <title>phpSQLiteAdmin</title> - <meta http-equiv="expires" content="0"> + <meta http-equiv="expires" content="0" /> + <meta http-equiv="pragma" content="no-cache" /> + <meta http-equiv="cache-control" content="no-cache" /> <script language="Javascript" src="javascript.txt" type="text/javascript"></script> - <link href="phpsla.css" rel="stylesheet" type="text/css"> </head> <body class="right"> <?php @@ -29,19 +31,19 @@ ?> -<form name=query method=post action="<?=$_SERVER['PHP_SELF']?>"> -<input type=hidden name=object value="<?=$current_table?>"> -<textarea name=sql rows=8 cols=80> +<form name="query" method="post" action="<?=$_SERVER['PHP_SELF']?>"> +<input type="hidden" name="object" value="<?=$current_table?>" /> +<textarea name="sql" rows="8" cols="80"> <?=$show?> -</textarea><br> -<input type=submit name=submit value="Execute SQL"> +</textarea><br /> +<input type="submit" name="submit" value="Execute SQL" /> </form> <?php if ($_POST['sql'] != '') { - print "<br><table>\n"; + print "<br /><table>\n"; //sqlite_escape_string($_POST['sql']); $userdbh->query(trim($_POST['sql'])); while($row = $userdbh->fetchArray()) { Index: leftframe.php =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin/leftframe.php,v retrieving revision 1.2 retrieving revision 1.3 diff -u -d -r1.2 -r1.3 --- leftframe.php 21 May 2004 17:26:26 -0000 1.2 +++ leftframe.php 27 Jun 2004 21:34:36 -0000 1.3 @@ -3,24 +3,26 @@ require_once('include.php'); echo<<<EOT -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"> -<html> +<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> +<html xmlns="http://www.w3.org/1999/xhtml"> <head> - <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> + <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-15" /> + <link href="phpsla.css" rel="stylesheet" type="text/css" /> <title>phpSQLiteAdmin</title> - <meta http-equiv="expires" content="0"> + <meta http-equiv="expires" content="0" /> + <meta http-equiv="pragma" content="no-cache" /> + <meta http-equiv="cache-control" content="no-cache" /> <script language="Javascript" src="javascript.txt" type="text/javascript"></script> - <link href="phpsla.css" rel="stylesheet" type="text/css"> - <base target="mainframe"> + <base target="mainframe" /> </head> -<body class=left> +<body class="left"> <a href="index.php" target="_top">Main</a> -<br> +<br /> <a href="dbconfig.php">Alias configuration</a> -<br> +<br /> <a href="login.php?logoff=1" target="_top">Logoff</a> -<br> -<br> +<br /> +<br /> EOT; print "<div class=\"list\">\n"; @@ -46,4 +48,4 @@ print "</html>\n"; -?> +?> \ No newline at end of file Index: config.php =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin/config.php,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -u -d -r1.1.1.1 -r1.2 --- config.php 11 May 2004 18:23:16 -0000 1.1.1.1 +++ config.php 27 Jun 2004 21:34:36 -0000 1.2 @@ -6,9 +6,10 @@ $datetime_format = 'd.m.Y - H:i:s'; +// encoding for the php function "htmlentities", see http://www.php.net/htmlentities +$encoding = 'ISO-8859-15'; -// hoster mode stuff - +// hoster-mode stuff // in your directory structure, at which depth is the users directory // e.g. for /home/USER/public_html it would be 2 // e.g. for /home/webroot/users/USER/public_html it would be 4 Index: check_login.php =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin/check_login.php,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- check_login.php 21 May 2004 17:14:51 -0000 1.1 +++ check_login.php 27 Jun 2004 21:34:36 -0000 1.2 @@ -9,4 +9,4 @@ header("Location: login.php"); } -?> +?> \ No newline at end of file Index: mainframe.php =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin/mainframe.php,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -u -d -r1.1.1.1 -r1.2 --- mainframe.php 11 May 2004 18:23:16 -0000 1.1.1.1 +++ mainframe.php 27 Jun 2004 21:34:36 -0000 1.2 @@ -3,17 +3,18 @@ require_once('include.php'); echo<<<EOT -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"> -<html> +<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> +<html xmlns="http://www.w3.org/1999/xhtml"> <head> - <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> + <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-15" /> + <link href="phpsla.css" rel="stylesheet" type="text/css" /> <title>phpSQLiteAdmin</title> - <meta http-equiv="expires" content="0"> - <script language="javascript" src="javascript.txt" type="text/javascript"></script> - <link href="phpsla.css" rel="stylesheet" type="text/css"> - <base target="mainframe"> + <meta http-equiv="expires" content="0" /> + <meta http-equiv="pragma" content="no-cache" /> + <meta http-equiv="cache-control" content="no-cache" /> + <script language="Javascript" src="javascript.txt" type="text/javascript"></script> </head> -<body class=right> +<body class="right"> <div id="currentdb">Database: {$_SESSION['phpSQLiteAdmin_currentdb']}</div> EOT; @@ -28,7 +29,7 @@ $dbinfo = $userdbh->dbInfo(); print "<table id=\"dbinfotable\">\n"; -print "<tr><th colspan=2>Database file information</th></tr>\n"; +print "<tr><th colspan=\"2\">Database file information</th></tr>\n"; print "<tr><td>Size:</td><td>".($dbinfo['size']/1024)."KB</td></tr>\n"; print "<tr><td>Last modification:</td><td>".$dbinfo['last_mod']."</td></tr>\n"; @@ -39,7 +40,7 @@ print "<tr><td>Group:</td><td>".$group['name']."</td></tr>\n"; } -print "</table><br>\n"; +print "</table><br />\n"; print "<h3>Tables:</h3>\n"; @@ -56,12 +57,12 @@ print "</td></tr>\n"; } } -print "</table><br>\n"; +print "</table><br />\n"; */ +$userdbh->query("select name,upper(name) from SQLITE_MASTER where type = 'table' order by 2"); print "<table id=\"tabletable\">\n"; print "<tr><th>Name</th><th>Rows</th><th>Action</th></tr>\n"; -$userdbh->query("select name,upper(name) from SQLITE_MASTER where type = 'table' order by 2"); while($row = $userdbh->fetchArray()) { print "<tr><td>".$row[0]."</td>\n"; $userdbh2->query("select count(*) from $row[0]"); @@ -72,29 +73,26 @@ print_table_action_links($row[0]); print "</td></tr>\n"; } -print "</table><br>\n"; +print "</table><br />\n"; echo<<<EOT <h3>Database operations:</h3> - -<table class="blind"> -<form action="table_create.php" method=post onsubmit=""> -<tr> -<td>Create a new table named</td> -<td><input type=text name=tablename value="" size=20><td>with</td> -<td><input type=text name=columns value="" size=3> colums</td> -<td><input type=submit name=submit value="Go"></td> -</tr> +<ul> +<li> +<form action="table_create.php" method="post" onsubmit="">Create a new table named +<input type="text" name="tablename" value="" size="20" /> with +<input type="text" name="columns" value="" size="3" /> colums +<input type="submit" name="submit" value="Go" /> </form> - +</li> <!-- +<li> <form action="index_create.php" method=post onsubmit=""> -<tr> -<td>Create an index on table</td> -<td><select name=create_index>\n +Create an index on table +<select name="create_index">\n EOT; foreach($rows as $row) { @@ -102,23 +100,21 @@ } echo<<<EOT -</select></td> -<td colspan=3 align=right><input type=submit name=submit value="Go"></td> -</tr> -</form> +</select> +<input type="submit" name="submit" value="Go" /> +</li> --> -<tr><td colspan=5><a href="dbaction.php?action=schema" target="mainframe">Show Database schema</a></td></tr> -<tr><td colspan=5><a href="dbaction.php?action=vacuum" target="_top" onclick="return confirm_vacuum_db();">Vacuum Database</a></td></tr> +<li><a href="dbaction.php?action=schema" target="mainframe">Show Database schema</a></li> +<li><a href="dbaction.php?action=vacuum" target="_top" onclick="return confirm_vacuum_db();">Vacuum Database</a></li> EOT; -if ($current_db != 'phpsla.sqlite') print "<tr><td colspan=5><a href=\"dbaction.php?action=drop\" target=\"_top\" onclick=\"return confirm_drop_db();\">Drop Database</a></td></tr>\n"; - -print "</table>\n"; +if ($current_db != 'phpsla.sqlite') print "<li><a href=\"dbaction.php?action=drop\" target=\"_top\" onclick=\"return confirm_drop_db();\">Drop Database</a></li>\n"; +print "</ul>\n"; print "</body>\n"; print "</html>\n"; -?> +?> \ No newline at end of file Index: dbaction.php =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin/dbaction.php,v retrieving revision 1.2 retrieving revision 1.3 diff -u -d -r1.2 -r1.3 --- dbaction.php 21 May 2004 17:28:14 -0000 1.2 +++ dbaction.php 27 Jun 2004 21:34:36 -0000 1.3 @@ -37,19 +37,21 @@ if ($action == 'schema') { echo<<<EOT -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"> -<html> +<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> +<html xmlns="http://www.w3.org/1999/xhtml"> <head> - <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> + <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-15" /> + <link href="phpsla.css" rel="stylesheet" type="text/css" /> <title>phpSQLiteAdmin</title> - <meta http-equiv="expires" content="0"> - <script language="javascript" src="javascript.txt" type="text/javascript"></script> - <link href="phpsla.css" rel="stylesheet" type="text/css"> + <meta http-equiv="expires" content="0" /> + <meta http-equiv="pragma" content="no-cache" /> + <meta http-equiv="cache-control" content="no-cache" /> + <script language="Javascript" src="javascript.txt" type="text/javascript"></script> </head> -<body class=right> +<body class="right"> <div id="currentdb">Database: {$_SESSION['phpSQLiteAdmin_currentdb']}</div> <p class="sqliteversion">SQLite version: $sqliteversion</p> -<br> +<br /> <a href="mainframe.php" target="mainframe">Back</a>\n EOT; print "<h3>Database schema</h3>\n"; @@ -94,4 +96,4 @@ } -?> +?> \ No newline at end of file Index: login.class.php =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin/login.class.php,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- login.class.php 21 May 2004 17:24:34 -0000 1.1 +++ login.class.php 27 Jun 2004 21:34:36 -0000 1.2 @@ -6,9 +6,9 @@ { var $_user; var $_pass; - + // {{{ function login() - + function login($user, $pass) { $this->_user = $user; @@ -20,7 +20,7 @@ // {{{ function checkLogin() function checkLogin() - { + { $query = "SELECT * FROM users WHERE login = '$this->_user'"; $this->query($query); @@ -56,7 +56,7 @@ function updateLogin($pass) { $this->_pass = md5($pass); - + $query = "UPDATE users SET password = '$this->pass' WHERE login = '$this->user'"; $this->query($query); } @@ -69,7 +69,7 @@ { $query = "SELECT * FROM users"; $this->query($query); - + if ($this->numRows() == 0) { return true; } else { @@ -113,4 +113,4 @@ // }}} } -?> +?> \ No newline at end of file Index: dbconfig.php =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin/dbconfig.php,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -u -d -r1.1.1.1 -r1.2 --- dbconfig.php 11 May 2004 18:23:20 -0000 1.1.1.1 +++ dbconfig.php 27 Jun 2004 21:34:36 -0000 1.2 @@ -3,17 +3,19 @@ require_once('include.php'); echo<<<EOT -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"> -<html> +<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> +<html xmlns="http://www.w3.org/1999/xhtml"> <head> - <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> + <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-15" /> + <link href="phpsla.css" rel="stylesheet" type="text/css" /> <title>phpSQLiteAdmin</title> - <meta http-equiv="expires" content="0"> + <meta http-equiv="expires" content="0" /> + <meta http-equiv="pragma" content="no-cache" /> + <meta http-equiv="cache-control" content="no-cache" /> <script language="Javascript" src="javascript.txt" type="text/javascript"></script> - <link href="phpsla.css" rel="stylesheet" type="text/css"> - <base target="mainframe"> + <base target="mainframe" /> </head> -<body class=right onload="document.adddb.alias.focus();"> +<body class="right" onload="document.adddb.alias.focus();"> <a href="editdb.php">Add a new database alias</a> Index: table_browse.php =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin/table_browse.php,v retrieving revision 1.2 retrieving revision 1.3 diff -u -d -r1.2 -r1.3 --- table_browse.php 21 May 2004 19:18:54 -0000 1.2 +++ table_browse.php 27 Jun 2004 21:34:36 -0000 1.3 @@ -3,16 +3,18 @@ require_once('include.php'); ?> -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"> -<html> +<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> +<html xmlns="http://www.w3.org/1999/xhtml"> <head> - <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> + <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-15" /> + <link href="phpsla.css" rel="stylesheet" type="text/css" /> <title>phpSQLiteAdmin</title> - <meta http-equiv="expires" content="0"> + <meta http-equiv="expires" content="0" /> + <meta http-equiv="pragma" content="no-cache" /> + <meta http-equiv="cache-control" content="no-cache" /> <script language="Javascript" src="javascript.txt" type="text/javascript"></script> - <link href="phpsla.css" rel="stylesheet" type="text/css"> </head> -<body class=right> +<body class="right"> <?php print_top_links($_GET['object']); @@ -40,9 +42,9 @@ print "<tr>\n"; for ($i=0; $i<$nr_fields; $i++) { if (strlen($row[$i]) > 50) { - print '<td>'.substr($row[$i],0,50)."...</td>\n"; + print '<td>'.substr(htmlentities($row[$i],ENT_QUOTES,$encoding),0,50)."...</td>\n"; } else { - print "<td>$row[$i]</td>\n"; + print "<td>".htmlentities($row[$i],ENT_QUOTES,$encoding)."</td>\n"; } } print "</tr>\n"; @@ -54,4 +56,4 @@ print "</html>\n"; -?> +?> \ No newline at end of file Index: table_structure.php =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin/table_structure.php,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -u -d -r1.1.1.1 -r1.2 --- table_structure.php 11 May 2004 18:23:22 -0000 1.1.1.1 +++ table_structure.php 27 Jun 2004 21:34:36 -0000 1.2 @@ -3,23 +3,25 @@ require_once('include.php'); ?> -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"> -<html> +<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> +<html xmlns="http://www.w3.org/1999/xhtml"> <head> - <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> + <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-15" /> + <link href="phpsla.css" rel="stylesheet" type="text/css" /> <title>phpSQLiteAdmin</title> - <meta http-equiv="expires" content="0"> + <meta http-equiv="expires" content="0" /> + <meta http-equiv="pragma" content="no-cache" /> + <meta http-equiv="cache-control" content="no-cache" /> <script language="Javascript" src="javascript.txt" type="text/javascript"></script> - <link href="phpsla.css" rel="stylesheet" type="text/css"> </head> -<body class=right> +<body class="right"> <?php print_top_links($_GET['object']); print "<h3>Table '{$_GET['object']}'</h3>\n"; -print "<table border=1>\n"; +print "<table border=\"1\">\n"; print "<tr><th>Column</th><th>Type</th></tr>\n"; $userdbh->_setTableInfo($_GET['object']); $cols = $userdbh->getColsType(); @@ -46,7 +48,7 @@ */ if($nr_indexes > 0) { - print "<table border=1>\n"; + print "<table border=\"1\">\n"; print "<tr><th>Index name</th><th>On field(s)</th></tr>\n"; foreach($indexes as $row) { if(eregi("\((.*)\)", $row['sql'], $fields)) { @@ -58,7 +60,7 @@ } } print "</table>\n"; - + } else { print "<em>no indexes</em>\n"; |
|
From: Yves G. <yg...@mi...> - 2004-06-23 14:41:07
|
=2D----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Wednesday 23 June 2004 12:52, Kevin Naia wrote: Hi, > 1. You should use valid XHTML 1.0 Strict code for you websites, which > I can help you do. It improves the load times of the pages, helps > users view the page correctly without errors, and just makes you look > good. This is a todo... I was in fact planning to convert it to xhtml 1.0=20 transitional (at least) for the next release. > 2. You NEED to quote attributes to acheive valid XHTML 1.0 Strict > code. I know... :-) In fact the website http://phpsqliteadmin.sf.net is xhtml (and it=20 validates ;-) phpsla was in the beginning not though to be xhtml, which was an error=20 from my side. > 3. You PHP code seems like it could use a little cleaning...or > "beautifying". Could you point me to which codingstyle you would like to use, and maybe=20 to punctual uglynesses in the code? > You can send me an E-Mail at: Kev...@co... or AIM: Golden > Rail308 or MSN: Kev...@co... to talk more on the subject. > > Thanks, > Kevin best regards, Yves =2D --=20 Linux 2.4.26 #4 Wed Apr 14 19:23:19 CEST 2004 i686 16:36:06 up 33 min, 1 user, load average: 0.15, 0.26, 0.20 =2D----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFA2ZZ5fmxiTOp0sQYRAhgcAJ9eDzL8CvSBFyfxDUDgDiUNm13g1QCcDWki YIijRa8PNCHCvhA9tmkOUYo=3D =3DX9lT =2D----END PGP SIGNATURE----- |
|
From: Kevin N. <Kev...@co...> - 2004-06-23 10:53:00
|
1. You should use valid XHTML 1.0 Strict code for you websites, which I = can help you do. It improves the load times of the pages, helps users = view the page correctly without errors, and just makes you look good. 2. You NEED to quote attributes to acheive valid XHTML 1.0 Strict code. 3. You PHP code seems like it could use a little cleaning...or = "beautifying". You can send me an E-Mail at: Kev...@co... or AIM: Golden = Rail308 or MSN: Kev...@co... to talk more on the subject. Thanks, Kevin |
|
From: Yves G. <yg...@mi...> - 2004-06-22 16:23:22
|
On Tuesday 22 June 2004 13:11, Kevin Naia wrote: > Hi, I noticed that you guys only have 2 people working on > phpSQLiteAdmin. I was wondering if I can join the development team? Hi Kevin, yes in fact there are only 2 people right now. So any help is welcome :-) If you have patches/ideas/comments, post them here. Looking forward to hear from you! Yves > -Kevin -- Linux 2.4.26 #4 Wed Apr 14 19:23:19 CEST 2004 i686 18:21:17 up 23 min, 1 user, load average: 0.73, 0.47, 0.45 |
|
From: Kevin N. <Kev...@co...> - 2004-06-22 11:11:36
|
Hi, I noticed that you guys only have 2 people working on = phpSQLiteAdmin. I was wondering if I can join the development team? -Kevin |
|
From: <ben...@id...> - 2004-05-25 08:07:41
|
Dear Open Source developer I am doing a research project on "Fun and Software Development" in which I kindly invite you to participate. You will find the online survey under http://fasd.ethz.ch/qsf/. The questionnaire consists of 53 questions and you will need about 15 minutes to complete it. With the FASD project (Fun and Software Development) we want to define the motivational significance of fun when software developers decide to engage in Open Source projects. What is special about our research project is that a similar survey is planned with software developers in commercial firms. This procedure allows the immediate comparison between the involved individuals and the conditions of production of these two development models. Thus we hope to obtain substantial new insights to the phenomenon of Open Source Development. With many thanks for your participation, Benno Luthiger PS: The results of the survey will be published under http://www.isu.unizh.ch/fuehrung/blprojects/FASD/. We have set up the mailing list fa...@we... for this study. Please see http://fasd.ethz.ch/qsf/mailinglist_en.html for registration to this mailing list. _______________________________________________________________________ Benno Luthiger Swiss Federal Institute of Technology Zurich 8092 Zurich Mail: benno.luthiger(at)id.ethz.ch _______________________________________________________________________ |
|
From: Yves G. <yg...@us...> - 2004-05-23 13:33:26
|
Update of /cvsroot/phpsqliteadmin/phpsqliteadmin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv19259 Modified Files: login.php Log Message: more tweaking of the login page Index: login.php =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin/login.php,v retrieving revision 1.2 retrieving revision 1.3 diff -u -d -r1.2 -r1.3 --- login.php 22 May 2004 20:20:51 -0000 1.2 +++ login.php 23 May 2004 13:33:16 -0000 1.3 @@ -19,28 +19,28 @@ } ?> -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"> -<html> +<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> +<html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> - <title>phpSQLiteAdmin - Login</title> + <title>phpSQLiteAdmin - Login (<?=$_SERVER['HTTP_HOST']?>)</title> <meta http-equiv="expires" content="0"> <link href="phpsla.css" rel="stylesheet" type="text/css"> </head> <body class="right" onload="document.login.user.focus();"> -<h1>phpSQLiteAdmin 0.3</h1> -<p>Running on <em><?=$_SERVER['HTTP_HOST']?></em></p> +<h1>Welcome to phpSQLiteAdmin</h1> +<p>Version 0.3 running on <em><?=$_SERVER['HTTP_HOST']?></em></p> <form name="login" method="post" action="<?=$_SERVER['PHP_SELF']?>"> <table> <tr> -<td>Username:</td> -<td><input type="text" name="user"></td> +<th>Username:</th> +<td><input type="text" name="user" size="24" maxlength="24"></td> </tr> <tr> -<td>Password:</td> -<td><input type="password" name="pass"> +<th>Password:</th> +<td><input type="password" name="pass" size="24" maxlength="24"> <?php if ($obj->isEmpty()) { |
|
From: Yves G. <yg...@us...> - 2004-05-23 13:32:42
|
Update of /cvsroot/phpsqliteadmin/phpsqliteadmin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv19139 Modified Files: todo.txt Log Message: added todo about ui for user management Index: todo.txt =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin/todo.txt,v retrieving revision 1.4 retrieving revision 1.5 diff -u -d -r1.4 -r1.5 --- todo.txt 22 May 2004 20:21:23 -0000 1.4 +++ todo.txt 23 May 2004 13:32:32 -0000 1.5 @@ -24,3 +24,5 @@ <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> - add multi-language support + +- add ui to manager user accounts |
|
From: Yves G. <yg...@us...> - 2004-05-22 20:22:08
|
Update of /cvsroot/phpsqliteadmin/phpsqliteadmin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv31689 Modified Files: phpsla.sqlite Log Message: Added an alias to allow me local testing Index: phpsla.sqlite =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin/phpsla.sqlite,v retrieving revision 1.2 retrieving revision 1.3 diff -u -d -r1.2 -r1.3 Binary files /tmp/cvsEJ6sv1 and /tmp/cvsAS8q8O differ |
|
From: Yves G. <yg...@us...> - 2004-05-22 20:21:32
|
Update of /cvsroot/phpsqliteadmin/phpsqliteadmin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv31603 Modified Files: todo.txt Log Message: added more todo removed completed todo Index: todo.txt =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin/todo.txt,v retrieving revision 1.3 retrieving revision 1.4 diff -u -d -r1.3 -r1.4 --- todo.txt 13 May 2004 20:18:14 -0000 1.3 +++ todo.txt 22 May 2004 20:21:23 -0000 1.4 @@ -2,8 +2,6 @@ - you can remove phpsla.sqlite alias, which is bad as well -- "browse" should show the column names -> sqlite_field_name - - "browse" should have navigation buttons - display of indexes fails sometimes @@ -20,8 +18,9 @@ - add a warning if magic_quotes_gpc is ON -- add some kind of login, to prevent acces to everybody. Make it play nicely with hm. - Maybe this needs a user table. well I guess it needs one. Felipe works in it. - - finish "hoster-mode", which must play nicely with login +- make it xhtml 1.0 Transitional: + <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> + +- add multi-language support |
|
From: Yves G. <yg...@us...> - 2004-05-22 20:21:02
|
Update of /cvsroot/phpsqliteadmin/phpsqliteadmin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv31131 Modified Files: login.php Log Message: Modified html to make it look more phpsla-alike ;-) 4 spaces -> 1 tab Formfield "Username" gets focus onload Index: login.php =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin/login.php,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- login.php 21 May 2004 17:17:10 -0000 1.1 +++ login.php 22 May 2004 20:20:51 -0000 1.2 @@ -5,53 +5,55 @@ $obj =& new login($_POST['user'], $_POST['pass']); $obj->SPSQLite("phpsla.sqlite"); -if ((isset($_GET['logoff'])) && ($_GET['logoff'] == 1)) { - $obj->logOff(); +if ((isset($_GET['logoff'])) && ($_GET['logoff'] == '1')) { + $obj->logOff(); } if (isset($_POST['empty'])) { - $obj->register($_POST['realname'], $_POST['email']); + $obj->register($_POST['realname'], $_POST['email']); } elseif (isset($_POST['notempty'])) { - if ($obj->checkLogin()) { - header("Location: index.php"); - } + if ($obj->checkLogin()) { + header("Location: index.php"); + exit(); + } } ?> +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"> <html> <head> -<title>phpSQLiteAdmin - Login</title> + <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> + <title>phpSQLiteAdmin - Login</title> + <meta http-equiv="expires" content="0"> + <link href="phpsla.css" rel="stylesheet" type="text/css"> </head> -<body> -<form method="POST" action="<?php echo $_SERVER['PHP_SELF']; ?>"> +<body class="right" onload="document.login.user.focus();"> + +<h1>phpSQLiteAdmin 0.3</h1> +<p>Running on <em><?=$_SERVER['HTTP_HOST']?></em></p> + +<form name="login" method="post" action="<?=$_SERVER['PHP_SELF']?>"> <table> <tr> -<td> -User: -</td> -<td> -<input type="text" name="user"> -</td> +<td>Username:</td> +<td><input type="text" name="user"></td> </tr> <tr> -<td> -Pass: -</td> -<td> -<input type="password" name="pass"> +<td>Password:</td> +<td><input type="password" name="pass"> <?php if ($obj->isEmpty()) { - echo "</td></tr>"; - echo "<tr><td>Realname:</td><td><input type=\"text\" name=\"realname\"></td></tr>\n"; - echo "<tr><td>Email:</td><td><input type=\"text\" name=\"email\">\n"; - echo "<input type=\"hidden\" name=\"empty\">\n"; + echo "</td></tr>"; + echo "<tr><td>Realname:</td><td><input type=\"text\" name=\"realname\"></td></tr>\n"; + echo "<tr><td>Email:</td><td><input type=\"text\" name=\"email\">\n"; + echo "<input type=\"hidden\" name=\"empty\">\n"; } else { - echo "<input type=\"hidden\" name=\"notempty\">\n"; + echo "<input type=\"hidden\" name=\"notempty\">\n"; } ?> -<input type="submit" value="login" > + <input type="submit" value="Login"> </td> </tr> </table> |
|
From: Felipe L. <fel...@us...> - 2004-05-21 19:49:40
|
Update of /cvsroot/phpsqliteadmin/phpsqliteadmin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv1823 Modified Files: SPSQLite.class.php Log Message: missed a TAB Index: SPSQLite.class.php =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin/SPSQLite.class.php,v retrieving revision 1.2 retrieving revision 1.3 diff -u -d -r1.2 -r1.3 --- SPSQLite.class.php 21 May 2004 19:17:52 -0000 1.2 +++ SPSQLite.class.php 21 May 2004 19:49:30 -0000 1.3 @@ -1056,7 +1056,7 @@ function fieldName($i) { - return sqlite_field_name($this->_result, $i); + return sqlite_field_name($this->_result, $i); } // }}} |
|
From: Felipe L. <fel...@us...> - 2004-05-21 19:25:53
|
Update of /cvsroot/phpsqliteadmin/phpsqliteadmin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv30088 Modified Files: changelog.txt Log Message: added field names Index: changelog.txt =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin/changelog.txt,v retrieving revision 1.2 retrieving revision 1.3 diff -u -d -r1.2 -r1.3 --- changelog.txt 21 May 2004 17:41:10 -0000 1.2 +++ changelog.txt 21 May 2004 19:25:42 -0000 1.3 @@ -4,6 +4,7 @@ - added login - fixed session problem concerning database names +- added field names on browse 0.2 (05.03.2004) |
|
From: Felipe L. <fel...@us...> - 2004-05-21 19:19:19
|
Update of /cvsroot/phpsqliteadmin/phpsqliteadmin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv28761 Modified Files: table_browse.php Log Message: added field names Index: table_browse.php =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin/table_browse.php,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -u -d -r1.1.1.1 -r1.2 --- table_browse.php 11 May 2004 18:23:22 -0000 1.1.1.1 +++ table_browse.php 21 May 2004 19:18:54 -0000 1.2 @@ -24,6 +24,15 @@ print "<table>\n"; $userdbh->query('select * from '.$_GET['object']); + +print "<tr>\n"; + +for ($i=0; $i<$userdbh->numFields(); $i++) { + print "<th>" . $userdbh->fieldName($i) . "</th>\n"; +} + +print "</tr>\n"; + while($row = $userdbh->fetchArray()) { $nr_fields = count($row); //$rows = $userdbh->returnRows('num'); @@ -45,4 +54,4 @@ print "</html>\n"; -?> \ No newline at end of file +?> |
|
From: Felipe L. <fel...@us...> - 2004-05-21 19:18:01
|
Update of /cvsroot/phpsqliteadmin/phpsqliteadmin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv28511 Modified Files: SPSQLite.class.php Log Message: Added numFields() and fieldName() Index: SPSQLite.class.php =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin/SPSQLite.class.php,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -u -d -r1.1.1.1 -r1.2 --- SPSQLite.class.php 11 May 2004 18:23:28 -0000 1.1.1.1 +++ SPSQLite.class.php 21 May 2004 19:17:52 -0000 1.2 @@ -643,6 +643,8 @@ } } + // }}} + // {{{ lastInsertId() /** @@ -965,10 +967,14 @@ return $cols; } + // }}} + /* HERE STARTS ADD-ON TO SPSQLITE CLASS TO FIT PHPSLA NEEDS */ + // {{{ function listTables() + function listTables() { $query = "SELECT name FROM sqlite_master WHERE type='table' ORDER BY name"; @@ -992,6 +998,10 @@ } + // }}} + + // {{{ function dbInfo() + function dbInfo() { $dbInfo['size'] = filesize($this->_file); @@ -1005,6 +1015,10 @@ } + // }}} + + // {{{ function fetchArray() + function fetchArray($type = 'num') { if (isset($type)) { @@ -1017,15 +1031,37 @@ } + // }}} + + // {{{ function vaccum() + function vacuum() { $this->query("VACUUM"); } -} + // }}} + + // {{{ numFields() + + function numFields() + { + return sqlite_num_fields($this->_result); + } // }}} + + // {{{ function fieldName() + + function fieldName($i) + { + return sqlite_field_name($this->_result, $i); + } + + // }}} + +} /* This product includes PHP, freely available from |
|
From: Felipe L. <fel...@us...> - 2004-05-21 17:41:19
|
Update of /cvsroot/phpsqliteadmin/phpsqliteadmin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv7452 Modified Files: changelog.txt Log Message: last changes...login added and session fixed (21.05.2004) Index: changelog.txt =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin/changelog.txt,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -u -d -r1.1.1.1 -r1.2 --- changelog.txt 11 May 2004 18:23:19 -0000 1.1.1.1 +++ changelog.txt 21 May 2004 17:41:10 -0000 1.2 @@ -1,5 +1,10 @@ phpSQLiteAdmin changelog +(21.05.2004) + +- added login +- fixed session problem concerning database names + 0.2 (05.03.2004) - Implemented an alias-system which allows you to add the databases you want to administer via phpSQLiteAdmin. No need to edit config.php anymore |
|
From: Felipe L. <fel...@us...> - 2004-05-21 17:31:10
|
Update of /cvsroot/phpsqliteadmin/phpsqliteadmin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv5126 Modified Files: phpsla.sqlite Log Message: added one user for login user:user pass:pass - Table users must be empty in fact so ppl register on first access Index: phpsla.sqlite =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin/phpsla.sqlite,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -u -d -r1.1.1.1 -r1.2 Binary files /tmp/cvsJ8uQAG and /tmp/cvskY4Icn differ |
|
From: Felipe L. <fel...@us...> - 2004-05-21 17:28:23
|
Update of /cvsroot/phpsqliteadmin/phpsqliteadmin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv4765 Modified Files: dbaction.php Log Message: fixed a session bug which didnt change its content when a database was deleted Index: dbaction.php =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin/dbaction.php,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -u -d -r1.1.1.1 -r1.2 --- dbaction.php 11 May 2004 18:23:21 -0000 1.1.1.1 +++ dbaction.php 21 May 2004 17:28:14 -0000 1.2 @@ -8,8 +8,8 @@ if ($action == 'drop_table') { - $userdbh->query("drop table '$object'"); - header("Location: index.php"); + $userdbh->query("drop table '$object'"); + header("Location: index.php"); exit; } @@ -67,7 +67,7 @@ if ($action == 'drop') { // system db may not be dropped if ($current_db == 'phpsla.sqlite') { - header("Location: index.php"); + header("Location: index.php"); exit; } @@ -82,6 +82,7 @@ $sysdbh->query("delete from databases where user = {$alias->user} and alias = '{$alias->alias}'"); unset($userdbh); unlink($current_db); + $_SESSION['phpSQLiteAdmin_currentdb'] = "phpsla.sqlite"; header("Location: index.php"); exit; } @@ -93,4 +94,4 @@ } -?> \ No newline at end of file +?> |
2 messages has been excluded from this view by a project administrator.
