JQuery Table is an easy plugin for creating dynamic tables for storing your data. This plugin is licensed unter the GNU General Public License. StickySort is a jQuery plugin for adding sticky headers and columns to your tables, complete with an extended sorting function. Client side export feature into: csv, json and xml formats. It supports client and server side pagination client and server side search custom filters views automatic menu to hide and reorder columns and support for custom tools. KingTable is a jQuery plugin for administrative tables that are able to build themselves, on the basis of their input data. It supports a full stack of spreadsheet operations, including: formulas, sorting, formatting, borders, moving rows, columns, frozen rows or columns, merging and so much more! This plugin as numerous features like cross browser compatible, mobile first approach, font awesome support, bootstrap support and small size 4kb minified.Ī fully fledged native jQuery spreadsheet plugin, designed to look and feel like Google sheets. easyTableĮasyTable allow you to sort, filter and do multiple ways of select using shift and crtl key, allow to get the data selected easily and customize/extend the plugin. Responsive jQuery Menu Plugins for Developersġ2 jQuery Audio Player Plugins 1. Following plugins are easy to use and also enable you to display, manage and sort data to deliver friendly experience to your visitors. Now i can add multiple identifier.In this post we are going to showcase 30 Best jQuery Table Plugins for 2016 which will help you creating tables for showcasing large data on your websites easily. I have just resolve my issue by modifying tableedit plugin. Also within the files "index.php" and "action.php" you will have to give the authentification for root instead of "" in the file, if you have configured a root password.įeli_x thanks for your suggestions and efforts. If there is a password, you will have to give it on the command line. INSERT INTO `tbl_2_ids` (`id0`, `id1`, `last_name`) VALUES ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1 In order to create the database "testing" with the tabel "tbl_2_ids" you can use the following batch file "database_mysql.batch".įor mysql perform the batch file by the command: mysql -u root -p < database_mysql.batch Live Table Data Edit Delete using Tabledit Plugin in PHP Be sure also to adopt the code for actions "edit" and "delete" within the file "action.php". This is achieved using a regular expression: $id_array = preg_split("/ /",$id_ser) (Serialization by the php function serialize() did not work, as there are quotations marks generated by the function, which are not transportet well by the INPUT_POST of tabledit.) Within the file "action.php" one has to "unserialize" the $id_ser back. $id_ser = $row." ".$row Īnd I use this "serialized" id as values for the first column of the displayed table. Therefore I used a kind of handmade serialization of the two identifiers by just putting them after each other separated by a semicolon. I changed the code from webslessons to this end. What you can do is to dump the two identifiers into one column. Tabledit does not work with two identifiers per se. (Honestly, second try, I only had to add the file into the directory.) Just tried the code from your source at webslessons, it worked at the first try.
0 Comments
Leave a Reply. |