Index

  1. Home
  2. Docs
  3. Index
  4. Plugin Settings
  5. Plugin

Plugin

Plugin menu

Enable checkbox Hide plugin menu in admin panel to the plugin menu. All plugin features remain available. This is for developers who want to use WP Data Access features without using the plugin menu.

Panel cookies

Panel cookies are used to save settings like your currently selected database and search criteria. Panel cookies are cleared after one hour.

When set to Clear when switching panels, the plugin clears these cookies every time the user switches to another page. When set to Keep when switching panels, cookies are preserved when the user switches to another page.

Secret key and IV

Enter any prase to secure your remote database connection information. When set, all current remote database connections will be converted immediately.

Remote database connections

Edit or delete remote database connections.

More info about remote database connection management…

Shortcode WPDATAACCESS

Grant access to shortcode in posts and/or pages.

Shortcode WPDADIEHARD

Grant access to shortcode in posts and/or pages.

Date format

Output format cannot be changed here. Please use the WordPress settings (Settings > General) page to change the output format.

Select a predefined input format or enter a custom one and adjust the placeholder.

Time format

Output format cannot be changed here. Please use the WordPress settings (Settings > General) page to change the output format.

Select a predefined input format or enter a custom one and adjust the placeholder.

Date/time test

Click on the button to test if your setting work before you save!

Was this article helpful to you? Yes No

4 Replies to “Plugin”

  1. I have been using your plugin with great joy!
    I have run into one issue I can’t seem to fix.

    In my database, dates are stored as a UNIX timestamp, and I was hoping to setup the table to show the date converted into something readable. Is this possible? I can for some reason not find it.

    A bonus question would be, can we do conditioned formating. Say if its a row has 1 in the database you display a checkmark picture or something ­čÖé

    Kind regards

    1. Hi Nickolai,

      >>> In my database, dates are stored as a UNIX timestamp
      Is this a MySQL date(time) column? Or is the date inserted into a varchar column? You cannot (re)format a date if it is stored in a varchar column. But you should be able to format your date field on the plugin settings page.

      Can you send me some screenshots? I’m interesed in your table structure and the layout of your data. You can use the contactform to send me your screenshots in private.

      Thanks,
      Peter

  2. Hi Peter,

    Your app is just about the perfect solution, however I was not able to find one solution.

    Is there a way to hook into your program to reformat the outputted data on the front-end table? For example, a price column is stored in my database as an int value of 10000, which means $100.00, and I would like it displayed like that. Is there a way to hook into your program, (PHP hook or JavaScript) so I can write a function with an input of 10000 from the DB returns $100.00 and displays that way in the front-end table? Thank you.

    1. Hi Cory,

      Yes, you can hook into the plugin! ­čÖé

      To reformat data with the Data Publisher, you can use function fnRowCallback in advanced settings. Here is an example:
      https://wpdataaccess.com/docs/documentation/data-publisher/advanced-settings/

      To reformat data with Data Projects, you can use filter wpda_column_default. Here is the (minimal) documentation:
      https://wpdataaccess.com/2020/01/29/filter-wpda_column_default-to-influence-column-layout-in-list-table/

      Let me know if you need help!

      Best regards,
      Peter

Leave a Reply

Your email address will not be published. Required fields are marked *

19 + eleven =