I have a database of collectibles, which is visible on my website using wpDataTables.  Can you please give me some recommendations as to how I might code the functionality of a 'wishlist' for visitors to the site?

Since the visitor has to be logged in, there must be a way for them to select lines from the SQL tables the plugin has generated and display them as a wishlist.

Thanks for any help or suggestions.

John

Hello Miljko,

I am thinking of something similar to the Amazon wishlist functionality for books and DVDs etc.

The wpDataTables table would include a column of checkboxes as well as the regular data, and the logged in user could select any number of these checkboxes and then click an 'add to wishlist' button - this action would save the relevant line numbers or SQL table line ids for the chosen checkboxes to a file.  By clicking on a 'show my wishlist' button wpDataTables would use this file to build a table just showing the selected lines from the main table.  The user could sort and filter this as normal and deselect any lines using the checkboxes.

I am willing to try code customisation.  The tricky bit is understanding how the interfacing with wpDataTables might work.  I am not sure how the checkboxes - or similar - might be included in the table, how the table line ids might be recorded and how the selected lines might be rebuild into a new table.

Thanks for your help.

John