{"id":1023,"date":"2011-07-19T10:07:49","date_gmt":"2011-07-19T10:07:49","guid":{"rendered":"http:\/\/premiumcoding.com\/?p=1023"},"modified":"2021-03-11T14:20:09","modified_gmt":"2021-03-11T14:20:09","slug":"jquery-sort-saving-database","status":"publish","type":"post","link":"https:\/\/premiumcoding.com\/jquery-sort-saving-database\/","title":{"rendered":"jQuery Sort and saving to database"},"content":{"rendered":"
DEMO<\/a><\/div><\/div><\/div>\n

 <\/p>\n

When we used to sort elements<\/strong> we had to refresh web page for every change. Since javasrcipt and jQuery<\/strong> we can now do that dynamiclly. In this tutorial I will show you just how to do that. It is even more useful when you combine with it databases<\/strong> in which order of elements<\/strong> is crucial. In our example following table with name jquerysort will be used:<\/p>\n\n\n\n\n\n\n
id<\/strong><\/td>\ntext<\/strong><\/td>\nsort<\/strong><\/td>\n<\/tr>\n
1<\/td>\nsome text<\/td>\n1<\/td>\n<\/tr>\n
2<\/td>\nsome text<\/td>\n2<\/td>\n<\/tr>\n
3<\/td>\nsome txt\u2026.<\/td>\n3<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

We will use two files. First file will call the second one each time element is moved. Entries in second file update MySql table each time that happens. First file will be named sort.php.<\/p>\n

First thing we have to do is include links to jQuery in < head > tag<\/strong>.<\/p>\n


\n