[Plugin: WP-Table Reloaded] Referencing tables created with the plugin with php?

Hi David,

this is similar to your other question: Unfortunately, the plugin lacks querying functions. Now, there is a way to use PHP to access the table as an array however, and then do your own rendering/HTML generation. This would, to some extent, allow a manipulation of the data.
For details, I suggest that you take a look at the source code of the plugin, probably starting with the Shortcode handler in controller-frontend.php.

Regards,
Tobias

I’m really hoping for an “out of the box” solution here ??

Here is what I am trying to do – perhaps you have a recommendation of how I can accomplish something similar with wp-table-reloaded.

I have a page like this:
https://ewh.ieee.org/r1/schenectady/Whoweare.php

At the top of the page I currently have a “filter by year” so you can see the volunteers of any year. If I simply maintain a table of the people in each collection, there is no “history” – that is, the table would reflect only the current situation, and there would be no way to display a past situation.

Additionally, a person’s information must be copied multiple times. Say I am the Chair of two committees – my phone, email, etc will appear twice, leading to things potentially getting out of sync/conflicting. The way I have it now there is a People table and then the chapter tables simply reference (via a sql join) people from the People table. This way all of the information about the people is all located, and only once, in one place.

Someone suggested “You can create tables per user and then you can simply call them in your committee lists.” Does that mean anything to you? I don’t follow haha.

The reason I can’t use my existing php/sql solution is that my site admin will not install the plugin to run php from a wp page citing security concerns. Any suggestions of how to accomplish these things are welcome!

Thanks,

David

Hi David,

thanks for the detailed description. Unfortunately, something like this is not possible with WP-Table Reloaded, because of the lack of the mentioned query/join functionality in the plugin (which only a full database software like mySQL has).

Thus, the only real way here is to use mySQL/PHP. And actually it is not really a problem that your admin doesn’t want to install such a PHP plugin: You can simply code this in a WordPres Page Template in your theme. That means, that all the PHP code goes there, and you just select this special Page Template for the page in question. See https://codex.www.ads-software.com/Pages#Page_Templates for more.

Regards,
Tobias

Thanks for your response.

The only problem is that I don’t have access (ftp or otherwise) to the server where I would have to add the php file to the Themes directory.

I guess it’s back to the drawing board.

David

Hi David,

ah, ok. No, if you don’t have access to the theme PHP files, this approach won’t work.
Without any PHP/mySQL access, I don’t see a way to do this though…

Best wishes,
Tobias