Okay
  Public Ticket #3816913
editing a database
Open

Comments

  • mike started the conversation

    Hello - I'm looking for a way to edit a 2nd database through wordpress. I have a client that has a membership section, but they don't want to use the membership side to really manage their members (there are valid reasons). Currently they do this on a custom app that somebody built 20 years ago that's starting to give them issues. The process would be I/they would be able to look at, sort and edit a 2nd database of their members using wordpress. I see how WPDataTables would work for viewing and sorting, but will it let me/them make edits as well? Thank you. Mike

  •  1,874
    Miloš replied

    Hi Mike,

    In regards to CMS functionality, our Plugin wpDataTables can not be used as a CMS if that is what you need.

    wpDataTables can only be used to build Tables which can pull data and the Tables can be made editable, but only if you don't use any SQL JOIN on them.

    You can check out our Documentation about creating editable tables here;

    Please note the limitations for editing :

    • Only one MySQL table can be edited at a time. Queries from multiple tables with joins cannot be used as an editable feature, since SQL UPDATE and INSERT statements are generated automatically, and there currently is no way to update multiple tables.

    • Only MySQL tables or tables created with “Create a table manually” and “Create a table by importing data from data source” options of “Create a Table” page can be edited.

    • Server-side processing MUST be turned on for front-end editing – Note: It will turn on automatically if you forget to enable it.

    • MySQL Views cannot be edited properly – only one of the underlying tables can be edited if you pass the proper ID.

     

    9457807155.png

     

    So, it depends if you only need to pull the data from an SQL Database, and if you will join data from multiple tables and if you need the Table(s) to be editable.

    If you plan to use a Membership Plugin to register users/members, usually this kind of data is stored in multiple WP database tables, so if you somehow find a way to only pull one SQL table at a time, then there is a chance you could edit that way, but as mentioned above, if you merge data from multiple SQL tables, then it can't be edited.


    And i just wanted to point out that you can try wpDataTables before purchasing

     on our sandbox Demo sites ( you can find links for the main plugin Demo,  

    as well as add-on Demos, in my signature),

     

    and there is a 15-day money-back guarantee period, 

    so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)

    Let me know if you have any additional questions. 





    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables