|
||||||
|
 |
| Login with username, password and session length |
|
1
on: November 15, 2009, 05:11:41 PM
|
||
| Started by sykkes - Last post by sykkes | ||
|
A little 'Thank You' for your work!
This is probably the best tool I've seen yet for editing an sqlite database remotely. I use SQLitev2 and have no need for version 3 yet until PHP 5.3 comes out! However I'd like to see a few more features such as paginated results, and perhaps ajax? Thanks!  |
||
|
2
on: November 15, 2009, 04:34:01 PM
|
||
| Started by sykkes - Last post by sykkes | ||
|
When displaying data from a table which contains a lot of data, all the data is output by default. Would be nice to have pagination (although I've had problems doing this myself in the past!
 )Obviously you can override the ouput using the LIMIT command via an sql query in phpLiterAdmin for now. |
||
|
3
on: May 03, 2009, 09:45:57 AM
|
||
| Started by aldo - Last post by aldo | ||
|
Just incase anyone is wondering when phpLiterAdmin v1.0 Final will be released, here you go
Right now, I am, of course, still accepting bug reports and other issues... Because I would like to have this version as bug free as possible, but that can't happen without the help of others  Also, I would like to attempt to have v1.0 SQLite v3 compatible, which I cannot attempt until PHP 5.3 is released, though that should come soon. No promises of v3 compatibility though, but I will try my best  |
||
|
4
on: April 22, 2009, 04:00:33 PM
|
||
| Started by lanshark - Last post by aldo | ||
|
Okay, so I guess something is wrong with the function calls in v1.0 RC, will look into it
 ~ UPDATE ~ I believe I found the problem, buildFunctionList had parameters in wrong order fixed in SVN, revision 36. |
||
|
5
on: April 22, 2009, 12:18:41 PM
|
||
| Started by lanshark - Last post by lanshark | ||
|
Aldo,
It works in 0.90, but not v1-RC1. I'm glad I tried the stable release... Cheers! jim |
||
|
6
on: April 22, 2009, 12:09:26 PM
|
||
| Started by lanshark - Last post by lanshark | ||
|
Aldo,
No problem on the reply time... I tried it with sqlite_escape_string and I still got the same error. If I get some time I'll debug it to find out just where the error is occurring. I'll pass along a diff file if I solve it. Thanks! Jim |
||
|
7
on: April 15, 2009, 09:58:38 PM
|
||
| Started by lanshark - Last post by aldo | ||
|
Sorry about the time it took for a reply!
Thanks for the comment Glad you like it.Anyways, try sqlite_escape_string... The thing with SQLite is, that unlike MySQL, SQLite doesn't escape ' with a \, it escapes it with another ' so to escape ' it gets converted to '' which is what sqlite_escape_string does. The reason htmlspecialchars doesn't work is the fact that the Quote Style parameter needs to be set to ENT_QUOTES in order to convert ' to the html entity. I suppose I make phpLiterAdmin do that..? |
||
|
8
on: April 09, 2009, 12:47:26 PM
|
||
| Started by lanshark - Last post by lanshark | ||
|
First, nice program!
I'm using v1-rc1. Declared a table, three columns, one coolumn is varchar(100). When I attempt to add "Madison's Stuff" to that column, I get the following error: Query Error: near "s": syntax error. I've tried to use the htmlspecialcharacters, addslashes, and the like from the dropdowns provided, but I am still unable to add text that has an apostrophe in it. Thanks! Jim |
||
|
9
on: March 28, 2009, 03:49:54 PM
|
||
| Started by aldo - Last post by aldo | ||
|
Oh yes... forgot to mention this...
It is a known problem that for some reason, on Debian/Ubuntu based OS's (110MB, this host, uses Debian) that the session garbage collector does not work, at least not well, if at all. So if you do for some reason decide to keep using database driven sessions it is highly recommended you purge your {db_prefix}sessions table every so often to remove old sessions. I checked my database today and I had 414 rows! 0.0 removing that much can really increase load times |
||
|
10
on: March 28, 2009, 03:42:15 PM
|
||
| Started by aldo - Last post by soren121 | ||
|
Finally! Hope you get it! |
||
