473,242 Members | 1,728 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,242 software developers and data experts.

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
2 5642
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
DannyE
1
check out TableEditor on www.phpguru.org
(it requires some PEAR packages)
Apr 5 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Bob | last post by:
I am sure this has been answered in over whelming detail in this group, however the search results have not turned up any thing I am interested in. I want a simple form generator in PHP that...
11
by: DJJ | last post by:
I am using the MySQL ODBC 3.51 driver to link three relatively small MySQL tables to a Microsoft Access 2003 database. I am finding that the data from the MySQL tables takes a hell of a long time...
13
by: LRW | last post by:
Having a problem getting a onSubmit function to work, to where it popsup a confirmation depending on which radiobutton is selected. Here's what I have: function checkdel() { if...
7
by: Ivan Marsh | last post by:
Hey Folks, I'm having a heck of a time wrapping mind around AJAX. Anyone know of a simple, straight-forward example for pulling a simple query from mysql with PHP using AJAX? As I...
1
by: www.web20developers.com | last post by:
http://www.web20developers.com http://www.web20developers.com/index.php?option=com_content&task=view... Ajallerix : AJAX, simple, fast Web image gallery demo ; at Novell AJAX -...
1
by: cctham | last post by:
Hi, I have an issue with php and/or mysql. I have a php form that writes "items" to a mysql database, including a description of the item. I am testing it now by putting special characters in...
11
by: kennthompson | last post by:
Trouble passing mysql table name in php. If I use an existing table name already defined everything works fine as the following script illustrates. <?php function fms_get_info() { $result =...
2
osward
by: osward | last post by:
Hello there, I am using phpnuke 8.0 to build my website, knowing little on php programing. I am assembling a module for my member which is basically cut and paste existing code section of...
1
by: javediq143 | last post by:
Hi All, This is my first post in this forum. I'm developing a CMS for my latest website. This CMS is also in PhP & MySQL. I'm done with the ADD section where the Admin can INSERT new records in...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.