XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Modules Support forums / 
  3. Module usage questions 
  4.  / [Tutorial] Make tables sortable without further mysql queries or page reloads
Register
1
kaotik
[Tutorial] Make tables sortable without further mysql queries or page reloads

  • 2006/9/14 18:53

  • kaotik

  • Just can't stay away

  • Posts: 861

  • Since: 2004/2/19


One of the things that always bothered me was having to reload a page in order to sort a table. If the data is already on the client side why not sort it on his end?
While searching for a better solution I stumbled on this little piece of javascript code. This sorts your tables on the clients side and is really simple to implement! I was so happy with this I decided to share it here on the forums in case other module developers are also facing the same dilemma.
link to sortable tables
2
McNaz
Re: [Tutorial] Make tables sortable without further mysql queries or page reloads

  • 2006/9/14 19:58

  • McNaz

  • Just can't stay away

  • Posts: 574

  • Since: 2003/4/21


Wow! Its not that simple is it?


/me ...quick fires up PHPEclipse....
3
damaster
Re: [Tutorial] Make tables sortable without further mysql queries or page reloads

  • 2006/9/14 23:45

  • damaster

  • Just can't stay away

  • Posts: 556

  • Since: 2003/5/11


Hi,

Already use it within XOOPS Cube admin theme templates without troubles.
Also use collapsed tables. Both to improve ergonomic efficiency.




P.S. As XOOPS Cube Legacy can run old modules from xoops.org it should work with the last releases. It's DOM.
I like people more than machines or money. But that's me!
Lets do something good and great: Lets do open source!
4
kaotik
Re: [Tutorial] Make tables sortable without further mysql queries or page reloads

  • 2006/9/15 10:39

  • kaotik

  • Just can't stay away

  • Posts: 861

  • Since: 2004/2/19


The next step would be to have javascript break the results into "pages". That way users could change "page" without having to reload the webpage or do aditional queries (using xajax for ex.). If someone has figured this out please let me know
5
giba
Re: [Tutorial] Make tables sortable without further mysql queries or page reloads

  • 2006/9/15 11:19

  • giba

  • Just can't stay away

  • Posts: 638

  • Since: 2003/4/26


Yes good sharing

Code SorTable

Thanks Kaotik
6
damaster
Re: [Tutorial] Make tables sortable without further mysql queries or page reloads

  • 2006/9/15 13:56

  • damaster

  • Just can't stay away

  • Posts: 556

  • Since: 2003/5/11


Hi,

Yes! It's already done by Wanikoo (ajaxed modules and themes)
With a few improvements you wont need to refresh the all page, you can easily modify your templates to refresh only part of you content.

Read this thread !

Some people here, are not "open" to source
It's vain to contribute with creativity and
new stuff Never mind, if you want a copy of
Xoops 2.0.14 JP Ajax, pm or mail:
xoopserver at gmail dot com

I like people more than machines or money. But that's me!
Lets do something good and great: Lets do open source!

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

388 user(s) are online (324 user(s) are browsing Support Forums)

Members: 0

Guests: 388

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits