467,877 Members | 1,257 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,877 developers. It's quick & easy.

simple mysql table browser with sort / filter and edit option

Hi,

Does anoone of you know if there is already a simple application doing
something like this.
I would enhance / tune the missing features, but would like to avoid to
start from scratch or to start from something, that has far too many
features and is difficult to setup.
Usecase: a group sheet as collabortation tool.

Currently we're having a simple Excel file with one table and about 10
columns.
The process of downloading the table, modifying one or two entries and
uploading it again is not very efficient. Especially if multiple users
could try to modify different rows at the same time.
The table / sheet should be modifiable by any member.
(security is no issue, the data is non critical, the DB contains no
other data, the server could only be accessed by authorized users)
I thought, that having a MYSQL table with a simple web front end (PHP or
perl CGI) would be a nice idea.

PhPMyAdmin looks a little too complex and does not do exactly what I need.

Requirements:
filtering entries (pregenerated filters)
------------------------------------------
it should be possible to choose a 'where' conditions.
The idea would be to select pregenerated 'where' conditions from a list
(and perhaps even to enter conditions manually

selectable columns (pregenerated column views)
------------------------------------------------------
It should be possible to select which columns should be displayed.
(A list box should contain certain pre-created combinations of column
combinations).
sortable
----------
It should be possible to sort by columns (e.g. like in phpMyAdmin when
clicking on a column title)

Sorting by onbly one columns should be fine

editing a cell/row while having the default table view
--------------------------------------------------------

The look and feel of editing should be as close as possible to editing
an Excel spread sheet. (no formatting needed, no formulas needed, only
text and number entries)

Whether updates occur after every cell change or only when confirming a
row change is not that important.
very basic collision detection
---------------------------------

Very basic collision detection would be enough as described here:
When two users try to change the same table row at the same time, then
the user who 'submitted' first will win and the other one will get a
warning.
Thanks in advance for any suggestions and bye

N

Mar 25 '06 #1
  • viewed: 5375
Share:
2 Replies
Does anoone of you know if there is already a simple application doing
something like this.


Have you looked at http://www.navicat.com/ ?

I can't do without it !

J
Mar 25 '06 #2
check out TableEditor on www.phpguru.org
(it requires some PEAR packages)
Apr 5 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Bob | last post: by
11 posts views Thread by DJJ | last post: by
13 posts views Thread by LRW | last post: by
7 posts views Thread by Ivan Marsh | last post: by
1 post views Thread by www.web20developers.com | last post: by
1 post views Thread by cctham | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.