From: Marc Delisle <marc(a)infomarc.info>
Aris Feryanto a écrit :
Hi all,
I pushed my work to git repo in [0]. My recent commits add
functionality to
remember the column order, so that when we press next, prev, or
anything that refresh the table, we will get same column order. The
commits also fix some bugs and implement some previous suggestions.
If you have some time, you may test the demo at [1]. Any comment or
suggestion is really appreciated. :)
Here is the list of what I did:
- Remember column order in session or phpMyAdmin configuration
storage, if
configured.
Aris, I had a little time to test today. I had a look at how you
store the column order in pma_table_uiprefs. You are using column
numbers. This gave me an idea for a possible bug which I tested and
proved indeed a bug.
If a structure change occurs in the table (let's say I add a
column, either after an existing column or at the end), display
problems happen.
I also see Notice in ./libraries/display_tbl.lib.php#461 Undefined
index: cf7e1a12c9f636989429f8e2d369eaa5
on a table on which I added a column.
Fixed. To solve the problem caused by changing table structure, I add
some checking of table creation time, so everytime a table is
modified, the column order will be reset (any better way?). Please
check it in my git repo or test in the demo server [0].