• Resolved Rich

    (@rpm765)


    I have installed your plugin and it’s working fine. An example is on this page. It was surprisingly easy for this database/php/css novice go get this up and running so quickly! I have added custom css to the site to set the column widths the way I need them to be and to remove the column headers from the footer.

    The other pages in the site display data using the Supsystic Data Tables plugin. I’m about to migrate everything to your plugin because the Supsystic plugin does not query the database dynamically. As this project has grown, this has become a problem.

    I want to mimic the look of the Supsystic tables with:

    • The dark blue header background and white text
    • Darker, more bold borders in the same color as the header background

    All of the data in this site comes from a single database. The selection of data displayed is made using various “WHERE” SQL commands in separate Supsystic data tables. I assume I will have to build a separate WP Data Access table for each category, using a different “WHERE” command in each to retrieve the proper records for display. Or is there a better way to accomplish this?

    Thanks ahead of time for your help.

    Rich Melvin
    rich@ogaugerr.com

    The page I need help with: [log in to see the link]

Viewing 13 replies - 1 through 13 (of 13 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    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

    Thread Starter Rich

    (@rpm765)

    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 http://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!

    Thread Starter Rich

    (@rpm765)

    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!

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    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

    Thread Starter Rich

    (@rpm765)

    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 1 year, 9 months ago by Rich.
    • This reply was modified 1 year, 9 months ago by Rich.
    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    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

    Thread Starter Rich

    (@rpm765)

    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!

    Thread Starter Rich

    (@rpm765)

    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!

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    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

    Thread Starter Rich

    (@rpm765)

    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!

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    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

    Thread Starter Rich

    (@rpm765)

    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.

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Rich,

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

    Thank you very much for your contribution,
    Peter

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘Display of Multple Tables from One Database’ is closed to new replies.