Display of Multple Tables from One Database

Hi Rich,

Here is the documentation for manual table styling:
https://wpdataaccess.com/docs/data-publisher/manual-styling/
This works with any version and allows you to modify the CSS any way you like.

I don’t think you need a table for each category. There are several ways to add static filters to an existing table. For your use case you can probably use shortcode parameters as explained here:
https://wpdataaccess.com/docs/data-publisher/static-filters/
With this filter option you can use the same table on different pages using different arguments.

Does this answer your questions?
Peter

Peter, I appreciate your fast response, and on a weekend no less!

Your answer has solved SOME of my issues, but not all. The static filters feature is going to save me TONS of work!

However, I still need help with:

• How to set the header background and font colors
• How to set the border width and color

My understanding of CSS is a bit too limited to be able to figure this out on my own.

I also have a new issue that I had not anticipated. On several pages in this site, I display multiple tables using different “WHERE” sql commands. However, if I attempt to place two instances of a table on the page with different static filters, I get this error message:

“DataTables warning: table id=3d_projects1 – Cannot reinitialise DataTable. For more information about this error, please see https://datatables.net/tn/3.”

I have gone to the URL and read the page, but the info presented there is a bit beyond my level of understanding. Can I place multiple instances of the same table on a page, or will I need to generate a few extra tables for this?

I absolutely love this plugin! Once I get these details figured out, I’ll be in business!

I got the html table formatting figured out! I did some digging in the Code Manager and found the right codes to use to make my tables look the way I want them to look.

THIS PAGE will show you the result.

I think I know how to solve the multiple tables on the same page problem. That’s next on my research time line.

Absolutely LOVE this plugin!

Hi Rich,

One way to change the styling of your tables it to add your own CSS to your theme. This could be a starting point:

table.wpda-datatable head {
	background-color: blue;
	color: white;
	border: 1px solid grey
}

If you need help with this, just send me the URL of the page containing the table(s) and your color codes and I can prepare the CSS for you. It’s really just a few minutes work.

Thanks for your example page. I see how shortcode parameters can help. Unfortunately, you cannot add multiple tables of the same publication on a page. I never saw a need for this until now. ??

Let me see if I can find a way to change this without risking all active users running into issues. I’ll come back to you and let you know…

Thanks,
Peter

Thanks again for a very informative answer.

For now I made seven tables, all the same, for handling those pages where multiple tables appear on the same page. That was the maximum number I needed for a multiple item page. The code I used was this:

<h2 id=”barrels”>BARRELS & CANS</h2>
[wpdataaccess pub_id=”1″ filter_field_name=”sub_category” filter_field_value=”barrels”]

<h2 id=”boats”>BOATS</h2>
[wpdataaccess pub_id=”2″ filter_field_name=”sub_category” filter_field_value=”boats”]

If you go to THIS PAGE, you can see how I implemented it.

If you can come up with an easier way, I’ll be your beta tester.

• This reply was modified 2 years, 1 month ago by Rich.
• This reply was modified 2 years, 1 month ago by Rich.

Hi Rich,

Love to take your proposal for beta testing! ?? I found a solution last night (much too late ??) to support multiple instance of the same publication on a web page. It needs some more fine tuning. Try to fix that next weekend. I’ll let you when the beta version is available…

Thanks for your offer ??
Peter

The site where I’m using your plugin would be a good beta test site. I can easily set up a test page and try out the code there, with different filters in the various tables.

If you have concerns about the new code causing unanticipated problems, I have a couple other low-traffic domains where we could try it. They are also WordPress sites.

Thanks again for your wonderful plugin!

Peter, have you made any progress on the multiple table display on a single page issue?

I’m using your plugin extensively now in THIS SITE, and it is working very well. I am so glad I found this!

Hi Rich,

So sorry! I really totally forgot to update this issue. ??

Yes, I did make progress. If you update to the latest version you should be able to use multiple instances of the same publication on page. ??

It does not work with geolocation search and the progressive more button, but it should work all standard publications.

Please give it a try and let me know the outcome.

I feel so dumb! I did this for you and forgot to update… ??

Best regards,
Peter

IT WORKS!

On THIS PAGE there are 7 tables. I can use wpdataaccess pub_id=”1″ in all of them now, and the page properly displays.

A note on the update…
Make sure people know they need to update the WP Data Access Premium plugin. I first updated only the basic “WP Data Access” plugin and this update did not work. It was not until I updated the PREMIUM version of the plugin that everything worked OK.

Nicely done!

Hi Rich,

Thank you for reporting back! Good to hear it works. ??

However, this feature should work with the free version as well. Did you update the free version before testing? I works on my server. Can you please confirm it works with the latest free version on your server as well?

Thanks,
Peter

I’m sorry for the confusion on this, Peter. I didn’t notice that when I updated the free version (WP Data Access) that it was DEACTIVATED in my site because I have the Premium version (WP Data Access Premium) installed and activated. So I initially updated something that was not an active plugin.

I would be happy to test and confirm that this works on the free version, but when I click to deactivate the Premium Version I get a warning message saying, “…Deactivating or uninstalling the plugin will automatically disable the license…” Consequently I am hesitant to do that.

I’m also not sure about just activating the free version, when the Premium version is also active.

Your advice would be appreciated.

Hi Rich,

Don’t worry about it. I double checked, it works with the free version. ??

Thank you very much for your contribution,
Peter