WordPress.org

Ready to get started?Download WordPress

Forums

Where the data of the WP-Table Reload is stored? (12 posts)

  1. jonsonw
    Member
    Posted 1 year ago #

    For some use, I find out the datatable plugin named : WP-Table Reloaded
    It's very good plugin, and do everthing what I want to realize.

    But, I can't find any datasheet about my input data in my MYSQL databse, who can tell me where the data of the WP-Table Reload is stored?

    Many thanks

  2. TobiasBg
    Member
    Posted 1 year ago #

    Hi,

    WP-Table Reloaded stored its data as a so-called "Serialized string" (using the PHP function serialize() in the WordPress Options API) in the "wp_options" table in your WP database.
    Please note that it is not recommended to directly manipulate table data there, as that will likely lead to corrupted tables and data loss.

    Regards,
    Tobias

  3. jonsonw
    Member
    Posted 1 year ago #

    Hi, Tobias

    Got it, and I've find them out in my database,many thanks!!!
    Can I understand or treat it as a 'JSON' data format?

    Another problem, After installed a new theme for my wordpress, the 'search input' and the 'show 10 entries' of the table can not show now, if I uninstall that theme, the table works good again. What's wrong with my theme? How can I repair that?

    B.RGDs
    Jonson

  4. TobiasBg
    Member
    Posted 1 year ago #

    Hi,

    no, unfortunately, that is not possible. Serialized strings and JSON are different, as serialized strings contain length information, and those will cause the data corruption if the table is edited directly.
    Can you explain why you want access to the raw table data? Maybe I can suggest a solution.

    About that theme issue: Likely the theme is doing something wrong with JavaScript loading. If you post the link to the page where this happens, I can try to find out what exactly that is.

    Regards,
    Tobias

  5. jonsonw
    Member
    Posted 1 year ago #

    Hi, Tobias

    Thanks for your help!

    For the datatable,
    I read your documentation for the 'wordpress search', the reasech will search out the table ID, and then show the post which contain the table ID, all right?
    I just want to build a search page which can show all tables contained the search keywords, and highligt the keywords in these tables. would you kindly please give some suggestion?

    For the theme,

    I built a test site, link as follow, under your suggestion, now the javascript has been right loaded and the search input can work, but it looks like not good, maybe some wrong with the css?

    http://42.121.2.24/?p=1

    Many thanks

    B.RGDs
    Jonson

  6. TobiasBg
    Member
    Posted 1 year ago #

    Hi,

    yes, that's how the search through tables works. Unfortunately, I don't really know a good approach to highlight the found search terms. The best way might be via some JavaScript code, which is only executed on search result pages. Unfortunately, I don't know how that could look like, sorry :-(

    About the theme: Yes, the JavaScript works as expected. If you enable the "Use Default CSS" checkbox on the "Plugin Options" screen, the table should look better, with better aligned elements, and also sort arrows.
    (If you already have checked that checkbox, then this could mean that your theme's "header.php" file does not contain a call to wp_head();.)

    Regards,
    Tobias

  7. jonsonw
    Member
    Posted 1 year ago #

    Hi, Tobias

    Thanks, the theme now it works good.
    Can I understand that the WP-Tables Reloads add an 'datatables' CSS link into the wp_head(); as follow?

    @import url("http://42.121.2.24/wp-content/plugins/wp-table-reloaded/css/datatables.css?ver=1.9.3");

    For the datatable, I hope I can try to find out some way to approach it.
    Whatever, thanks again, you make my life easier.

    B.RGDs
    Jonson

  8. TobiasBg
    Member
    Posted 1 year ago #

    Hi,

    yes, that is added by WP-Table Reloaded, and it includes CSS code for table styling.
    Unfortunately, in your case, the theme also seems to add pretty aggressive yellowish styling :-(
    To remove that, I suggest to remove the lines

    .text table {
    	border: 1px solid #FF8E42;
    	background: #FFFF90;
    	margin: 10px 0;
    }
    .text th, .text td {
    	border: 1px solid #FF8E42;
    	padding: 5px 15px;
    }

    from the file mangguo.css.

    Regards,
    Tobias

  9. jonsonw
    Member
    Posted 1 year ago #

    Hi, Tobias

    YEAH, It's great, now it looks like what the table should be.

    Thanks, Tobias.

    B.RGDs
    Jonson

  10. TobiasBg
    Member
    Posted 1 year ago #

    Hi Jonson,

    very cool! :-) Nice to hear that this did it :-)

    Best wishes,
    Tobias

  11. Hemang
    Member
    Posted 1 year ago #

    Hi Tobias,

    I downloaded the plugin and got started. I had a question. I have tables in MySQL db and I wanted to do db manipulation (Insert, Update, Delete, View) using this plugin. Is that possible?

    Can you tell me in what file I need to make changes to make this plugin dynamic? I want the user to be able to insert new data (also includes uploading a file) using form and view the updated table.

  12. TobiasBg
    Member
    Posted 1 year ago #

    Hi,

    thanks for your question. Instead of starting with WP-Table Reloaded, you should better start with its official and designated successor plugin, TablePress, which you can get at http://wordpress.org/extend/plugins/tablepress/

    Now, unfortunately, both plugins do not allow manipulation of mySQL tables, as that is simply not the intended use case of the plugins, sorry.

    Also, having users update data from outside the admin interface is not possible. You will need to look into a custom mySQL/PHP solution.

    Best wishes,
    Tobias

Topic Closed

This topic has been closed to new replies.

About this Topic