Posted 7 months 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
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
Posted 7 months 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
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
Posted 7 months 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?
Many thanks
B.RGDs
Jonson
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
Posted 7 months 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
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
Posted 7 months ago #
Hi, Tobias
YEAH, It's great, now it looks like what the table should be.
Thanks, Tobias.
B.RGDs
Jonson
Hi Jonson,
very cool! :-) Nice to hear that this did it :-)
Best wishes,
Tobias
Posted 5 months 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.
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
You must log in to post.
