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: Yves G. <yg...@mi...> - 2016-05-31 21:56:33
|
Hello, I have moved the project to a github repo, this should facilitate collaboration. https://github.com/yglodt/phpSQLiteAdmin If anyone want's access, just request it. You can of course also fork the project. Best regards, Yves |
From: Eric C. <fac...@al...> - 2016-01-06 09:32:54
|
Hi This is Eric,from shenzhen China. We can supply the good quality silicone ice maker,silicone wine glassess. this would help you low the purchase cost. If you need them,i hope you could kindly reply us. Thanks Best regards Eric Chou |
From: Markus R. E. <mar...@gm...> - 2013-12-31 20:51:44
|
Hi everyone! on the Homepage you say if someone is interested to contribute to the project best way is to contact you here. Looks like the project hasnt been active for over a year, is anyone seeing this? I am a PHP developer and would like to do some coding, the project could use some upgrades :) Happy new year! Markus |
From: David D. <dav...@gm...> - 2011-01-22 01:55:48
|
Thanks for the quick reply. That is too bad - this was the only software that seemed like it had potential for what I needed! You don't have a suggestion for something just like this but that can use SQLite3, do you? David On Fri, Jan 21, 2011 at 7:21 PM, Ward De Ridder <war...@gm...>wrote: > Hello David, > > Phpsqliteadmin is for sqlite v2 database files. sqlite v3 (the one you > used) is a complete different database file. > At the moment noone is really developing phpsqliteadmin, so if there won't > be more developpers there will be no support for sqlite 3. > I fixed some bugs a little over a year ago, but I don't think anyone > changed anything to the code since. > > Ward > > 2011/1/21 David Doria <dav...@gm...> > >> Hi all, >> >> When I add a Test.sqlite to the db/ directory and add a row for it in the >> phpsla.sqlite, when I select it in the "Database alias" dropdown, I get >> >> "The selected database is either read-only or does not exist" >> >> The errors makes the problem sound obvious, but the file does exist and it >> is not read only! >> >> The file is here: >> http://daviddoria.com/phpsqliteadmin03a1/db/test.sqlite >> >> I have set the path in the phpsla.sqlite to db/test.sqlite . The file >> permissions are 777. >> >> Any suggestions? The username:pw are the default root:root if anyone would >> care to poke around at http://daviddoria.com/phpsqliteadmin03a1/ >> >> Thanks! >> >> David >> >> >> ------------------------------------------------------------------------------ >> Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! >> Finally, a world-class log management solution at an even better >> price-free! >> Download using promo code Free_Logger_4_Dev2Dev. Offer expires >> February 28th, so secure your free ArcSight Logger TODAY! >> http://p.sf.net/sfu/arcsight-sfd2d >> _______________________________________________ >> Phpsqliteadmin-devel mailing list >> Php...@li... >> https://lists.sourceforge.net/lists/listinfo/phpsqliteadmin-devel >> >> > |
From: Ward De R. <war...@gm...> - 2011-01-22 00:21:46
|
Hello David, Phpsqliteadmin is for sqlite v2 database files. sqlite v3 (the one you used) is a complete different database file. At the moment noone is really developing phpsqliteadmin, so if there won't be more developpers there will be no support for sqlite 3. I fixed some bugs a little over a year ago, but I don't think anyone changed anything to the code since. Ward 2011/1/21 David Doria <dav...@gm...> > Hi all, > > When I add a Test.sqlite to the db/ directory and add a row for it in the > phpsla.sqlite, when I select it in the "Database alias" dropdown, I get > > "The selected database is either read-only or does not exist" > > The errors makes the problem sound obvious, but the file does exist and it > is not read only! > > The file is here: > http://daviddoria.com/phpsqliteadmin03a1/db/test.sqlite > > I have set the path in the phpsla.sqlite to db/test.sqlite . The file > permissions are 777. > > Any suggestions? The username:pw are the default root:root if anyone would > care to poke around at http://daviddoria.com/phpsqliteadmin03a1/ > > Thanks! > > David > > > ------------------------------------------------------------------------------ > Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! > Finally, a world-class log management solution at an even better > price-free! > Download using promo code Free_Logger_4_Dev2Dev. Offer expires > February 28th, so secure your free ArcSight Logger TODAY! > http://p.sf.net/sfu/arcsight-sfd2d > _______________________________________________ > Phpsqliteadmin-devel mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpsqliteadmin-devel > > |
From: David D. <dav...@gm...> - 2011-01-21 22:35:01
|
Hi all, When I add a Test.sqlite to the db/ directory and add a row for it in the phpsla.sqlite, when I select it in the "Database alias" dropdown, I get "The selected database is either read-only or does not exist" The errors makes the problem sound obvious, but the file does exist and it is not read only! The file is here: http://daviddoria.com/phpsqliteadmin03a1/db/test.sqlite I have set the path in the phpsla.sqlite to db/test.sqlite . The file permissions are 777. Any suggestions? The username:pw are the default root:root if anyone would care to poke around at http://daviddoria.com/phpsqliteadmin03a1/ Thanks! David |
From: PHPKode <vh...@ph...> - 2010-12-31 00:17:07
|
To view the message, please use an HTML compatible email viewer! |
From: Yves G. <yg...@mi...> - 2010-11-24 23:06:58
|
Hi Marek, phpSqliteAdmin is currently mostly unmaintained. I suggest you post the question again to the mailing list ( php...@li...), some more people might listen there. Apart of that, the project is open-source, and contributions from anyone are welcome. Best regards, Yves On 19 November 2010 10:56, Marek Šimon <mar...@ca...> wrote: > Hi, > I use your phpsqlite for expoloring my sqlite database, but my data are > "unicoded" so I lack unicode support in phpsqlite. Could submit my > request to your feature request list this way? > > Sincerely Marek > > |
From: Relations M. <rel...@no...> - 2010-11-10 09:10:18
|
Hi, Greetings From Notion Ink! We at Notion Ink are the proud creators of the tablet PC Adam. We came across your Android Application available on freewarelovers.com and were really impressed by the same. We seek to partner with you/your company where we can leverage your current application with Adam platform to create winning applications on Genesis, where we already have more than 200 developers across the world working as the Early Adopters. Adam will be launched in all the continents over the period of one year and has already created great visibility and traction. We intent to use this momentum and do business together where you can build upon our beautiful Eden Application platform which is a very simple derivative of Android. We can share more information on how we would do marketing for you and help you earn more revenue as a return for your simple interest. We look forward to hearing from you and in the meantime, should you have any queries, please do not hesitate to contact us. Warm Regards Notion Ink Design Labs ________________________________________________________________________________________________________________________ "Confidentiality Warning: This message and any attachments are intended only for the use of the intended recipient(s), are confidential and may be privileged. If you are not the intended recipient. you are hereby notified that any review, re-transmission, conversion to hard copy, copying, circulation or other use of this message and any attachments is strictly prohibited. If you are not the intended recipient. please notify the sender immediately by return email, and delete this message and any attachments from your system. Virus Warning: Although the company has taken reasonable precautions to ensure no viruses are present in this email, the company cannot accept responsibility for any loss or damage arising from the use of this email or attachment." |
From: PHPKode E. <ed...@ph...> - 2010-10-26 16:10:20
|
Hi Yves Glodt,Felipe Lopes, As you may notice, one of your high-standarded project, phpSQLiteAdmin is rated to be the choice of PHP developer and it is now part of our site: PHPKode.com. The project is illustrated by title, tags, license, version, descriptions as well as download URL on PHPKode.com with sources from your website. You may reach the project with the following URL: http://www.phpkode.com/projects/item/phpsqliteadmin/ Your project file has been uploaded on PHPKode file server, if you don't like your project to be a part of PHPKode or simply want something to be changed or updated, please feel free to contact us with the email at php...@gm... and we will work with you to fix any problem you may have found with the category listing. Since PHPKode.com is still under development, so 10 recommended places will be provided for each category, if you would like your project to be placed on recommended place of its category to receive more visits and downloads, please kindly add http://www.phpkode.com/projects/item/phpsqliteadmin/ as the backup download URL on your website. Sincerely, PHPKode Editor Tue Oct 26 12:01:20 2010 |
From: Yves G. <yg...@mi...> - 2010-02-16 11:06:27
|
Hi Felipe and list, I tried to reset my list-admin password yesterday (why is it different from my sf.net in the first place...??) :-) but never got a confirmation mail... Do you have access to that Felipe? if not, Ward, mail me the archive to yg...@mi... and I will upload it somewhere best regards, yves On 8 February 2010 18:16, <ff...@gm...> wrote: > Yves, > > Is there anything I could do to help? > > On Feb 8, 2010 11:59am, Yves Glodt <yg...@mi...> wrote: >> Hi, >> >> >> >> as stupid as it sounds... I have found no way to recover my list-admin >> >> password, so I can not unlock your mail... Maybe you can put the file >> >> on the site to download? >> >> >> >> best regards, >> >> yves >> >> >> >> On 8 February 2010 10:02, >> >> php...@li...> wrote: >> >> > The Php...@li... mailing list has 1 >> >> > request(s) waiting for your consideration at: >> >> > >> >> > https://lists.sourceforge.net/lists/admindb/phpsqliteadmin-devel >> >> > >> >> > Please attend to this at your earliest convenience. This notice of >> >> > pending requests, if any, will be sent out daily. >> >> > >> >> > >> >> > Pending posts: >> >> > From: war...@gm... on Sun Jan 10 19:03:18 2010 >> >> > Subject: Re: [Phpsqliteadmin-devel] PHPSQLiteAdmin 0.3 alpha1 packages >> >> > Cause: Message body is too big: 56056 bytes with a limit of 40 KB >> >> > >> >> > >> >> >> >> >> ------------------------------------------------------------------------------ >> >> The Planet: dedicated and managed hosting, cloud storage, colocation >> >> Stay online with enterprise data centers and the best network in the >> business >> >> Choose flexible plans and management services without long-term contracts >> >> Personal 24x7 support from experience hosting pros just a phone call away. >> >> http://p.sf.net/sfu/theplanet-com >> >> _______________________________________________ >> >> Phpsqliteadmin-devel mailing list >> >> Php...@li... >> >> https://lists.sourceforge.net/lists/listinfo/phpsqliteadmin-devel >> |
From: Yves G. <yg...@mi...> - 2010-02-08 14:30:52
|
Hi, as stupid as it sounds... I have found no way to recover my list-admin password, so I can not unlock your mail... Maybe you can put the file on the site to download? best regards, yves On 8 February 2010 10:02, <php...@li...> wrote: > The Php...@li... mailing list has 1 > request(s) waiting for your consideration at: > > https://lists.sourceforge.net/lists/admindb/phpsqliteadmin-devel > > Please attend to this at your earliest convenience. This notice of > pending requests, if any, will be sent out daily. > > > Pending posts: > From: war...@gm... on Sun Jan 10 19:03:18 2010 > Subject: Re: [Phpsqliteadmin-devel] PHPSQLiteAdmin 0.3 alpha1 packages > Cause: Message body is too big: 56056 bytes with a limit of 40 KB > > |
From: Ward De R. <war...@gm...> - 2010-01-17 13:59:44
|
I set up a testserver with php 5.3 and indeed it doesn't work, even the login fails. I'll try to fix this, but if it's to much work I'm not going to do this. Php 5.3 contains sqlite3 by default, and phpsqliteadmin is made for sqlite2, and I think sqlite3 simply won't work with phpsqliteadmin. My plan is to try to "complete" a version for php 5.2 + sqlite2, and maybe add php 5.3 + sqlite2 support, and than stop and maybe start a new one for sqlite3 (witch will work with php5.3). Ward 2010/1/10 Ward De Ridder <war...@gm...> > That's not my work, but I'll try to do something about it. Now I've got to > study to much, but I'll do it later this month. > Feel free to make a patch yourself! > I also attached file with the new development version, it isn't official > released because I still have to write the changelogs and comple te list of > known bugs. Your bug will be one of them, if I am able to install php5.3 on > my debian test-VPS and see what exactly is going on. > Some changes are made to row(add, update and delete). > > > Ward > > 2010/1/10 Samuel ROZE <sam...@gm...> > >> I'll look at that alpha2, but the alpha1 is not working on PHP 5.3 >> because you're using: >> >> $object =& new Object(); >> >> ..and it is deprecated in PHP 5.3, so headers cannot be set and your app >> doesn't work. >> >> Regards, >> Samuel ROZE. >> >> Le dimanche 10 janvier 2010 à 17:41 +0100, Ward De Ridder a écrit : >> > I'll take a look at it! >> > I'd recommend you to download the svn version as I made several >> > improvements, I'll release alpha2 soon! >> > >> > Ward >> > >> > 2010/1/10 Samuel ROZE <sam...@gm...> >> > Hello, >> > >> > Packages of PHPSQLiteAdmin 0.3 alpha1 contains .svn >> > directories. It is >> > normal ? >> > >> > Regards, >> > Samuel. >> > >> > >> > >> ------------------------------------------------------------------------------ >> > This SF.Net email is sponsored by the Verizon Developer >> > Community >> > Take advantage of Verizon's best-in-class app development >> > support >> > A streamlined, 14 day to market process makes app distribution >> > fast and easy >> > Join now and get one step closer to millions of Verizon >> > customers >> > http://p.sf.net/sfu/verizon-dev2dev >> > _______________________________________________ >> > Phpsqliteadmin-devel mailing list >> > Php...@li... >> > >> https://lists.sourceforge.net/lists/listinfo/phpsqliteadmin-devel >> > >> >> >> > |
From: Ward De R. <war...@gm...> - 2010-01-10 16:42:02
|
I'll take a look at it! I'd recommend you to download the svn version as I made several improvements, I'll release alpha2 soon! Ward 2010/1/10 Samuel ROZE <sam...@gm...> > Hello, > > Packages of PHPSQLiteAdmin 0.3 alpha1 contains .svn directories. It is > normal ? > > Regards, > Samuel. > > > > ------------------------------------------------------------------------------ > This SF.Net email is sponsored by the Verizon Developer Community > Take advantage of Verizon's best-in-class app development support > A streamlined, 14 day to market process makes app distribution fast and > easy > Join now and get one step closer to millions of Verizon customers > http://p.sf.net/sfu/verizon-dev2dev > _______________________________________________ > Phpsqliteadmin-devel mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpsqliteadmin-devel > |
From: Samuel R. <sam...@gm...> - 2010-01-10 12:41:18
|
Hello, Packages of PHPSQLiteAdmin 0.3 alpha1 contains .svn directories. It is normal ? Regards, Samuel. |
From: Ward De R. <war...@gm...> - 2009-12-05 14:39:54
|
This is a message only for you, I didn't want to send this to the wole list becouse I found some major security isues. There is only a login check on the startpage, if you go to any other page than you can even change the passwords. I'll try to fix this, but it's exam-time for me now. I'd reccomend to wait with submitting the script till the security issue is fixed, and then we can probably release the new version and imediately upload that. Ward ps. did you like the changes I made to the row add and edit? 2009/12/5 Search Scripts <web...@se...> > *Hello,* > > > > We would like to invite to submit your scripts and programs in > Search-Scripts.com, the fast growing web scripts directory. Registration and > submission to search-scripts.com is totally free. Best of all > search-scripts.com offer SEO friendly URLs for your listings to gain > maximum exposure on search engines. All the listings are manually verified > and approved to maintain quality listings on our scripts directory. > > > > Visit us at http://www.search-scripts.com > > > > Please feel free to contact us at the phone number mentioned below if you > have any questions. I look forward to see you at Search-Scripts.com > > > > With best regards, > > > > *Archana Chadha* (Director) > > > > *Search Scripts Directory* > > 232, Green Model Town > > Jalandhar City, Punjab > > INDIA – 144003 > > > > Tel: +91-181-4613940 > > > ------------------------------------------------------------------------------ > Join us December 9, 2009 for the Red Hat Virtual Experience, > a free event focused on virtualization and cloud computing. > Attend in-depth sessions from your desk. Your couch. Anywhere. > http://p.sf.net/sfu/redhat-sfdev2dev > _______________________________________________ > Phpsqliteadmin-devel mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpsqliteadmin-devel > > |
From: Search S. <web...@se...> - 2009-12-05 08:36:53
|
Hello, We would like to invite to submit your scripts and programs in Search-Scripts.com, the fast growing web scripts directory. Registration and submission to search-scripts.com is totally free. Best of all search-scripts.com offer SEO friendly URLs for your listings to gain maximum exposure on search engines. All the listings are manually verified and approved to maintain quality listings on our scripts directory. Visit us at http://www.search-scripts.com <http://www.search-scripts.com/> Please feel free to contact us at the phone number mentioned below if you have any questions. I look forward to see you at Search-Scripts.com With best regards, Archana Chadha (Director) Search Scripts Directory 232, Green Model Town Jalandhar City, Punjab INDIA - 144003 Tel: +91-181-4613940 |
From: <wa...@us...> - 2009-11-24 11:50:32
|
Revision: 52 http://phpsqliteadmin.svn.sourceforge.net/phpsqliteadmin/?rev=52&view=rev Author: warddr Date: 2009-11-24 11:50:25 +0000 (Tue, 24 Nov 2009) Log Message: ----------- Removed a coupe of bugs from row_edit.php added a "null?" column to row_edit.php (if you check null the primary key will be auto assigned by sqlite, if you don't do so an empty string will be sent as primary key, that will result in an error). Modified Paths: -------------- trunk/phpsqliteadmin2/row_edit.php trunk/phpsqliteadmin2/todo.txt Modified: trunk/phpsqliteadmin2/row_edit.php =================================================================== --- trunk/phpsqliteadmin2/row_edit.php 2009-11-22 22:14:05 UTC (rev 51) +++ trunk/phpsqliteadmin2/row_edit.php 2009-11-24 11:50:25 UTC (rev 52) @@ -1,183 +1,193 @@ -<?php - -require_once('include.php'); - -// Query (form submitted) portion -if ($_POST['type'] == "edit") { - - if (!$_GET['primary_key']) { - print "Table needs a primary key identifier."; - exit(); - } - - //print "<h3>Edit Row</h3>"; - - foreach (array_keys($_POST) as $column) { - // Only do columns, not $_POST['type'] and so on... - if (strstr($column, "column__") !== false) { - $columns .= ", " .str_replace("column__", "", $column). " = '" .$_POST[$column]. "'"; - } - //echo $column. "<br>"; - - } - // Clean up columns: - $columns = "randomkeytoberemoved" .$columns; - $columns = str_replace("randomkeytoberemoved, ", "", $columns); - //print $columns; - - $userdbh->query("UPDATE " .$_POST['object']. " SET " .$columns. " WHERE " .$_POST['primary_key']. " = '" .$_POST['row']. "'"); - $_SESSION['phpSQLiteAdmin_currentdb'] = ''; - header("Location: table_browse.php?object=" .$_POST['object']. ""); - exit(); - -} else if ($_POST['type'] == "add") { - - //print "<h3>Add Row</h3>"; - - foreach (array_keys($_POST) as $column) { - // Only do columns, not $_POST['type'] and so on... - if (strstr($column, "column__") !== false) { - $columns .= str_replace("column__", "", $column). ", "; - $values .= "'" .$_POST[$column]. "', "; - } - //echo $column. "<br>"; - - } - // Clean up columns/values: - $columns = $columns. "randomkeytoberemoved"; - $columns = str_replace(", randomkeytoberemoved", "", $columns); - $values = $values. "randomkeytoberemoved"; - $values = str_replace(", randomkeytoberemoved", "", $values); - //print $columns. "<br>"; - //print $values; - - $userdbh->query("INSERT INTO " .$_POST['object']. "(" .$columns. ") VALUES(" .$values. ")"); - header("Location: table_browse.php?object=" .$_POST['object']. ""); - exit(); - -} -if ($_GET['type'] == "delete") { - if (!$_GET['primary_key']) { - print "Table needs a primary key identifier."; - exit(); - } - - $userdbh->query("delete from ".$_GET['object']. " where " .$_GET['primary_key']. " = '" .$_GET['row']. "'"); - header("Location: table_browse.php?object=" .$_GET['object']. ""); - exit(); -} - -?> -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"> -<html> -<head> - <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> - <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"> -</head> -<body class="right"> -<?php - -print_top_links($_GET['object']); - -// Show main content: add or edit a row form. -if (!$_GET['row']) { - $type = "add"; -} else { - $type = "edit"; -} - -if (!$_GET['object']) { - print "Error: No table selected."; -} - -if ($type == "edit") { - print "<h3>Edit Row from Table '{$_GET['object']}'</h3>\n"; -} else { - print "<h3>Add Row to Table '{$_GET['object']}'</h3>\n"; -} - -print "<form action=\"row_edit.php\" method=\"post\">"; -print "<table border=\"1\">\n"; -print "<tr><th>Column</th><th>Type</th><th>Value</th></tr>\n"; -$userdbh->_setTableInfo($_GET['object']); -$cols = $userdbh->getColsType(); -$k = 0; -while (list($key,$value) = each($cols)) { - $col_name[$k] = $key; - $col_value[$k] = strtolower($value); - - // Clean up col_value to only display databtype. - if ($col_value[$k] == "") { $col_value[$k] = "typeless"; } - //if (strpos(strtolower(" " .$col_value[$k]. " "), "text")) { $col_value[$k] = "text"; } - $col_value[$k] = str_replace("not null", "", $col_value[$k]); - $col_value[$k] = str_replace("null", "", $col_value[$k]); - $col_value[$k] = str_replace("primary key", "", $col_value[$k]); - $col_value[$k] = str_replace("default", "", $col_value[$k]); - $col_value[$k] = preg_replace("/\'[^>]*\'/iU", "", $col_value[$k]); - $col_value[$k] = preg_replace("/\"[^>]*\"/iU", "", $col_value[$k]); - - $k++; -} - -if ($type == "edit") { - $userdbh->query("select * from ".$_GET['object']. " where " .$_GET['primary_key']. " = '" .$_GET['row']. "'"); - //$userdbh->query('select * from '.$_GET['object']); - while($row = $userdbh->fetchArray()) { - $nr_fields = count($row); - for ($i=0; $i<$nr_fields; $i++) { - print "<tr>\n"; - print "<td>" .$col_name[$i]. "</td>\n"; - print "<td>" .$col_value[$i]. "</td>\n"; - if (strpos(" " .$col_value[$i]. " ", "text")) { - print "<td><textarea name=\"column__" .$col_name[$i]. "\">" .$row[$i]. "</textarea></td>\n"; - } else { - print "<td><input type=\"text\" name=\"column__" .$col_name[$i]. "\" value=\"" .$row[$i]. "\" /></td>\n"; - } - print "</tr>\n"; - } - } -} else { - $nr_fields = count($col_name); - for ($i=0; $i<$nr_fields; $i++) { - print "<tr>\n"; - print "<td>" .$col_name[$i]. "</td>\n"; - print "<td>" .$col_value[$i]. "</td>\n"; - if (strpos(" " .$col_value[$i]. " ", "text")) { - print "<td><textarea name=\"column__" .$col_name[$i]. "\"></textarea></td>\n"; - } else { - print "<td><input type=\"text\" name=\"column__" .$col_name[$i]. "\" value=\"\" /></td>\n"; - } - print "</tr>\n"; - } -} -print "<tr>\n<th></th>\n<th></th>\n<th>"; -print "<input type=\"hidden\" name=\"row\" value=\"" .$_GET['row']. "\" />\n"; -print "<input type=\"hidden\" name=\"primary_key\" value=\"" .$_GET['primary_key']. "\" />\n"; -print "<input type=\"hidden\" name=\"object\" value=\"" .$_GET['object']. "\" />\n"; -print "<input type=\"hidden\" name=\"type\" value=\"" .$type. "\" />\n"; -print "<input type=\"submit\" name=\"\" value=\"Save\" />\n"; -print "<input type=button value=\"Cancel\" onclick=\"history.back();\">"; -print "</th>\n</table>\n"; -print "</form>"; - -/* -print "<table border=1>\n"; -print "<tr><th>Column</th><th>Type</th></tr>\n"; -$userdbh->_setTableInfo($_GET['object']); -$cols = $userdbh->getColsType(); -while (list($key,$value) = each($cols)) { - print "<tr><td>$key</td><td>$value</td></tr>\n"; -} -print "</table>\n"; - -print "<p>Rows in table: ".$userdbh->numRows($_GET['object'])."</p>\n"; -*/ - -print "</body>\n"; -print "</html>\n"; - - -?> +<?php + +require_once('include.php'); + +// Query (form submitted) portion +if ($_POST['type'] == "edit") { + + if (!isset($_POST['primary_key']) || ($_POST['primary_key'] == "")) { + print "Table needs a primary key identifier."; + exit(); + } + + //print "<h3>Edit Row</h3>"; + + foreach (array_keys($_POST) as $column) { + // Only do columns, not $_POST['type'] and so on... + if (strstr($column, "column__") !== false) { + $columns .= ", " .str_replace("column__", "", $column). " = '" .$_POST[$column]. "'"; + } + //echo $column. "<br>"; + + } + // Clean up columns: + $columns = "randomkeytoberemoved" .$columns; + $columns = str_replace("randomkeytoberemoved, ", "", $columns); + //print $columns; + + $userdbh->query("UPDATE " .$_POST['object']. " SET " .$columns. " WHERE " .$_POST['primary_key']. " = '" .$_POST['row']. "'"); + $_SESSION['phpSQLiteAdmin_currentdb'] = ''; + header("Location: table_browse.php?object=" .$_POST['object']. ""); + exit(); + +} else if ($_POST['type'] == "add") { + + //print "<h3>Add Row</h3>"; + + foreach (array_keys($_POST) as $column) { + // Only do columns, not $_POST['type'] and so on... + if (strstr($column, "column__") !== false) { + if (!isset($_POST["null_".str_replace("column__", "", $column)])){ + $columns .= str_replace("column__", "", $column). ", "; + $values .= "'" .$_POST[$column]. "', "; + } + } + //echo $column. "<br>"; + + } + // Clean up columns/values: + $columns = $columns. "randomkeytoberemoved"; + $columns = str_replace(", randomkeytoberemoved", "", $columns); + $values = $values. "randomkeytoberemoved"; + $values = str_replace(", randomkeytoberemoved", "", $values); + //print $columns. "<br>"; + //print $values; + + $userdbh->query("INSERT INTO " .$_POST['object']. "(" .$columns. ") VALUES(" .$values. ")"); + header("Location: table_browse.php?object=" .$_POST['object']. ""); + exit(); + +} +if ($_GET['type'] == "delete") { + if (!$_GET['primary_key']) { + print "Table needs a primary key identifier."; + exit(); + } + + $userdbh->query("delete from ".$_GET['object']. " where " .$_GET['primary_key']. " = '" .$_GET['row']. "'"); + header("Location: table_browse.php?object=" .$_GET['object']. ""); + exit(); +} + +?> +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"> +<html> +<head> + <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> + <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"> +</head> +<body class="right"> +<?php + +print_top_links($_GET['object']); + +// Show main content: add or edit a row form. +if (!isset($_GET['row'])) { + $type = "add"; +} else { + $type = "edit"; +} + +if (!$_GET['object']) { + print "Error: No table selected."; +} + +if ($type == "edit") { + if (!isset($_GET['primary_key']) || ($_GET['primary_key'] == "")) { + print "<h3>Table needs a primary key identifier.</h3>"; + exit(); + } + print "<h3>Edit Row from Table '{$_GET['object']}'</h3>\n"; +} else { + print "<h3>Add Row to Table '{$_GET['object']}'</h3>\n"; +} + +print "<form action=\"row_edit.php\" method=\"post\">"; +print "<table border=\"1\">\n"; +$userdbh->_setTableInfo($_GET['object']); +$cols = $userdbh->getColsType(); +$k = 0; +while (list($key,$value) = each($cols)) { + $col_name[$k] = $key; + $col_value[$k] = strtolower($value); + + // Clean up col_value to only display databtype. + if ($col_value[$k] == "") { $col_value[$k] = "typeless"; } + //if (strpos(strtolower(" " .$col_value[$k]. " "), "text")) { $col_value[$k] = "text"; } + $col_value[$k] = str_replace("not null", "", $col_value[$k]); + $col_value[$k] = str_replace("null", "", $col_value[$k]); + $col_value[$k] = str_replace("unique", "", $col_value[$k]); + $col_value[$k] = str_replace("primary key", "", $col_value[$k]); + $col_value[$k] = str_replace("default", "", $col_value[$k]); + $col_value[$k] = preg_replace("/\'[^>]*\'/iU", "", $col_value[$k]); + $col_value[$k] = preg_replace("/\"[^>]*\"/iU", "", $col_value[$k]); + + $k++; +} + +if ($type == "edit") { + print "<tr><th>Column</th><th>Type</th><th>Value</th></tr>\n"; + $userdbh->query("select * from ".$_GET['object']. " where " .$_GET['primary_key']. " = '" .$_GET['row']. "'"); + //$userdbh->query('select * from '.$_GET['object']); + while($row = $userdbh->fetchArray()) { + $nr_fields = count($row); + for ($i=0; $i<$nr_fields; $i++) { + print "<tr>\n"; + print "<td>" .$col_name[$i]. "</td>\n"; + print "<td>" .$col_value[$i]. "</td>\n"; + if (strpos(" " .$col_value[$i]. " ", "text")) { + print "<td><textarea name=\"column__" .$col_name[$i]. "\">" .$row[$i]. "</textarea></td>\n"; + } else { + print "<td><input type=\"text\" name=\"column__" .$col_name[$i]. "\" value=\"" .$row[$i]. "\" /></td>\n"; + } + print "</tr>\n"; + } + } +} else { + print "<tr><th>Column</th><th>Type</th><th>Value</th><th>null?</th></tr>\n"; + $nr_fields = count($col_name); + for ($i=0; $i<$nr_fields; $i++) { + print "<tr>\n"; + print "<td>" .$col_name[$i]. "</td>\n"; + print "<td>" .$col_value[$i]. "</td>\n"; + if (strpos(" " .$col_value[$i]. " ", "text")) { + print "<td><textarea name=\"column__" .$col_name[$i]. "\"></textarea></td>\n"; + } else { + print "<td><input type=\"text\" name=\"column__" .$col_name[$i]. "\" value=\"\" /></td>\n"; + } + print "<td><input type=\"checkbox\" name=\"null__" .$col_name[$i]. "\" value=\"\" onclick=\"column__".$col_name[$i].".disabled = this.checked ? true : false\" /></td>\n"; + print "</tr>\n"; + } +} +print "<tr>\n<th></th>\n<th></th>\n<th>"; +print "<input type=\"hidden\" name=\"row\" value=\"" .$_GET['row']. "\" />\n"; +print "<input type=\"hidden\" name=\"primary_key\" value=\"" .$_GET['primary_key']. "\" />\n"; +print "<input type=\"hidden\" name=\"object\" value=\"" .$_GET['object']. "\" />\n"; +print "<input type=\"hidden\" name=\"type\" value=\"" .$type. "\" />\n"; +print "<input type=\"submit\" name=\"\" value=\"Save\" />\n"; +print "<input type=button value=\"Cancel\" onclick=\"history.back();\">"; +if ($type == "add") (print "</th>\n<th>\n"); +print "</th>\n</table>\n"; +print "</form>"; + +/* +print "<table border=1>\n"; +print "<tr><th>Column</th><th>Type</th></tr>\n"; +$userdbh->_setTableInfo($_GET['object']); +$cols = $userdbh->getColsType(); +while (list($key,$value) = each($cols)) { + print "<tr><td>$key</td><td>$value</td></tr>\n"; +} +print "</table>\n"; + +print "<p>Rows in table: ".$userdbh->numRows($_GET['object'])."</p>\n"; +*/ + +print "</body>\n"; +print "</html>\n"; + + +?> Modified: trunk/phpsqliteadmin2/todo.txt =================================================================== --- trunk/phpsqliteadmin2/todo.txt 2009-11-22 22:14:05 UTC (rev 51) +++ trunk/phpsqliteadmin2/todo.txt 2009-11-24 11:50:25 UTC (rev 52) @@ -16,11 +16,7 @@ - Privilege checks for databases? -COMPLETED BY WARDDR (November 22, 2009): - - - Fix "Table needs a primary key identifier." error, and try to find a way that the id isn't needed - - Row adding: make autoincrement possible - + Old Todo: - "browse" should have navigation buttons This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: Felipe L. <ff...@gm...> - 2009-11-22 22:44:07
|
Welcome to the team Ward!! On Sun, Nov 22, 2009 at 4:51 PM, Yves Glodt <yg...@mi...> wrote: > I added you as developer to the project. You have svn, shell and release > tech. rights. > > Welcome to the team! > > In case you feel the need to discuss anything, please use the mailinglist! > > Regards, > Yves > > 2009/11/22 Ward De Ridder <war...@gm...> >> >> My SourceForge userid is warddr >> >> Ward >> >> 2009/11/22 Yves Glodt <yg...@mi...> >>> >>> Hi Ward, >>> >>> there is no active development since some time, at least since the 0.3 >>> Alpha release. >>> >>> Sure the project could benefit from more resources. >>> >>> If you want to join, give me your sourceforge user-id and I add you as a >>> developer. >>> >>> This way you can feel free to add your code and also release 0.3 (or >>> maybe 1.0). >>> >>> best regards, >>> Yves >>> >>> 2009/11/22 Ward De Ridder <war...@gm...> >>>> >>>> Hello, >>>> >>>> I was wondering if phpsqliteadmin is still being developped on >>>> sourceforge? There has been no activity for more than one year. >>>> I think this is a very promissing project and I'd love to help making it >>>> better! >>>> If you need another developper let me know! >>>> I'm testing version 0.3 Alpha now and I found a litle mistake in the >>>> code: >>>> >>>> if (!$_GET['primary_key']) on line 8 in row_edit.php should be if >>>> (!$_POST['primary_key']) becouse the primary key who is sent on line 158 is >>>> sent with a forum method post. >>>> >>>> Ward De Ridder >>>> >>>> >>>> ------------------------------------------------------------------------------ >>>> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 >>>> 30-Day >>>> trial. Simplify your report design, integration and deployment - and >>>> focus on >>>> what you do best, core application coding. Discover what's new with >>>> Crystal Reports now. http://p.sf.net/sfu/bobj-july >>>> _______________________________________________ >>>> Phpsqliteadmin-devel mailing list >>>> Php...@li... >>>> https://lists.sourceforge.net/lists/listinfo/phpsqliteadmin-devel >>>> >>> >> > > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus > on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > Phpsqliteadmin-devel mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpsqliteadmin-devel > > |
From: <wa...@us...> - 2009-11-22 22:14:12
|
Revision: 51 http://phpsqliteadmin.svn.sourceforge.net/phpsqliteadmin/?rev=51&view=rev Author: warddr Date: 2009-11-22 22:14:05 +0000 (Sun, 22 Nov 2009) Log Message: ----------- Updated to do list + Test if svn works Modified Paths: -------------- trunk/phpsqliteadmin2/todo.txt Modified: trunk/phpsqliteadmin2/todo.txt =================================================================== --- trunk/phpsqliteadmin2/todo.txt 2008-10-12 12:53:29 UTC (rev 50) +++ trunk/phpsqliteadmin2/todo.txt 2009-11-22 22:14:05 UTC (rev 51) @@ -16,6 +16,11 @@ - Privilege checks for databases? +COMPLETED BY WARDDR (November 22, 2009): + + - Fix "Table needs a primary key identifier." error, and try to find a way that the id isn't needed + - Row adding: make autoincrement possible + Old Todo: - "browse" should have navigation buttons This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: Yves G. <yg...@mi...> - 2009-11-22 19:16:15
|
I added you as developer to the project. You have svn, shell and release tech. rights. Welcome to the team! In case you feel the need to discuss anything, please use the mailinglist! Regards, Yves 2009/11/22 Ward De Ridder <war...@gm...> > My SourceForge userid is warddr > > Ward > > 2009/11/22 Yves Glodt <yg...@mi...> > > Hi Ward, >> >> there is no active development since some time, at least since the 0.3 >> Alpha release. >> >> Sure the project could benefit from more resources. >> >> If you want to join, give me your sourceforge user-id and I add you as a >> developer. >> >> This way you can feel free to add your code and also release 0.3 (or maybe >> 1.0). >> >> best regards, >> Yves >> >> 2009/11/22 Ward De Ridder <war...@gm...> >> >>> Hello, >>> >>> I was wondering if phpsqliteadmin is still being developped on >>> sourceforge? There has been no activity for more than one year. >>> I think this is a very promissing project and I'd love to help making it >>> better! >>> If you need another developper let me know! >>> I'm testing version 0.3 Alpha now and I found a litle mistake in the >>> code: >>> >>> if (!$_GET['primary_key']) on line 8 in row_edit.php should be if >>> (!$_POST['primary_key']) becouse the primary key who is sent on line 158 is >>> sent with a forum method post. >>> >>> Ward De Ridder >>> >>> >>> ------------------------------------------------------------------------------ >>> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 >>> 30-Day >>> trial. Simplify your report design, integration and deployment - and >>> focus on >>> what you do best, core application coding. Discover what's new with >>> Crystal Reports now. http://p.sf.net/sfu/bobj-july >>> _______________________________________________ >>> Phpsqliteadmin-devel mailing list >>> Php...@li... >>> https://lists.sourceforge.net/lists/listinfo/phpsqliteadmin-devel >>> >>> >> > |
From: Ward De R. <war...@gm...> - 2009-11-22 16:14:49
|
> > If you need another developper let me know! > That should be if you can use one more developper. I sometimes make some mistakes in english becouse english isn't my first language. Ward |
From: Ward De R. <war...@gm...> - 2009-11-22 16:12:58
|
Hello, I was wondering if phpsqliteadmin is still being developped on sourceforge? There has been no activity for more than one year. I think this is a very promissing project and I'd love to help making it better! If you need another developper let me know! I'm testing version 0.3 Alpha now and I found a litle mistake in the code: if (!$_GET['primary_key']) on line 8 in row_edit.php should be if (!$_POST['primary_key']) becouse the primary key who is sent on line 158 is sent with a forum method post. Ward De Ridder |
From: ecomVia G. S. <no-...@ec...> - 2008-12-12 11:45:48
|
Boost your sales & Start getting new buyers Sir / Madam, As we have been attracted to your site "PhpSQLiteAdmin", we are proud to bring you the option of unique kind of priceless online presentation for your company and your products, that will bring you new potential buyers of your products and multiple your sales. With ecomVia Global System you can: Represent your company Introduce the activities and production of your company in a very latest kind of online presentation, by providing all details and information. Allow potential buyers to get a complete outlook on your company by providing images from inside life, production, etc. Display all of your products Attract daily visitors and convert them to your new buyers. Just add the complete and detailed descriptions of all your products, add the detailed and inviting images and use the enhancements to stand out of products of other companies. Access up-to-date requests & offers Check out, what the others need. There’s a high possibility, that someone is looking for product, you are able to produce or supply. Obtaining a new order has never been easier – just few clicks away. Get contacted with inquiries from possible buyers Providing detailed information about your company and products supplemented with inviting images assures a high possibility of early contacting by new potential buyers. Find supplies & partners for your company Search in milions of suppliers and products and find what you are looking for. At slovak-products.com you are able to find anything you require for your production and even find new dealers and local distributors for your products. Ready yet to receive new orders? Go to http://www.ecomvia.info/registration to start now! Thanks and best regards, ecomVia Inc. SNP street 119, SK-90873 Velke Levare. Slovakia Tel.: +421-910-353111 |
From: MaRtO <mar...@gm...> - 2008-11-26 19:10:48
|
Hi, Whenever I try to insert text into a table I get SQL Syntax error. For example: I first create a new table called t1. Then I make a column named text with text as datatype. Finally I go the the query page and execute this: insert into t1(text) values('test') And I get an error. When I insert a number it works flawless. Is this a bug or am I doing something wrong? Thx in advance BTW, I use phpsqliteadmin 0.2. When I try it with the latest devel version it does work. |