Lester Caine wrote:

> Not that I have seen yet. Single row editing is the best
> I've seen so far.
>
>>Any comments or pointers is welcome.
>
> If you are looking at pure PHP, (actually browser based
> access in general) then since all the information has to be
> posted back to the server for processing, updating a line at
> a time is 'safest' approach.
>
> A grid of input controls is possible, but i suspect that the
> fact that ALL the information for the grid has to go back
> and forth may slow it down. Unless some clever so-an-so has
> an idea ;)

I have.

In my application I have several grids where users can enter tabular
data which are actually rows in a table. I call all input fields like:
name[], id[], etc. And when the form is posted, PHP automagically turns
those into arrays. Then I just do foreach loop for array elements and
insert/update values.

As for it being slow, I never display the entire tables, I do the
pagination with FIRST x SKIP y, and I leave option to user to configure
how many rows he wants to see on screen. Of course, you can always limit
it to 10, 20 or whatever.

However, there are only several grids like this in whole application.
For most data I still use single row editing.

--
Milan Babuskov
http://fbexport.sourceforge.net