Tutorials

Collated list of tutorials

Data Tables

Data Tables is a table builder that allows plugin users to create responsive data tables from local and remote databases with just a few mouse clicks. Many styling features are available for free and premium users. Demos and videos are available to help new and experienced users get their data tables up and running in just minutes. Client-side processing is supported for small tables to allow quick local filtering and sorting in the browser. Server-side processing is available to make large tables available to front-end users (several use cases with over two million rows). Advanced options and javascript support are available for more experienced developers.
Show Tutorial List for Data Tables

Data Apps

Data Projects is a tool that allows plugin users to build data management pages for back-end and front-end usage. Projects are table based. Pages are generated on the fly. Database constraints and triggers are integrated automatically. Transaction levels can be added using WordPress roles.

Show Tutorial List for Data Apps

Data Explorer

The Data Explorer allows plugin users to perform data and database related tasks directly from the WordPress dashboard. Tables, columns, indexes and foreign keys can be viewed inline. Common DDL actions, SQL and CSV imports, as well as table and row exports in several formats are available on mouse click. Table data can be viewed and managed from list tables and user friendly data entry forms. Many settings can be managed from the Data Explorer to customize table and view management.

Remote Databases

Show Tutorial List for Remote Databases

Business Intelligence

Share customizable dashboards and widgets on your WordPress dashboard, web pages (using shortcodes) and external websites (using longcodes).

Show Tutorial List for Business Intelligence

Data Designer

Use the Data Designer to create your own tables and indexes. Or load existing tables into the Data Designer with reverse engineering. Works with local and remote databases (make sure you have to necessary credentials). Use the Data Explorer to execute your own sql scripts (button Import data/Execute script(s)) if you are an experience database developer.

Show Tutorial List for Data Designer

Database Beginner

Database Advanced

10 Comments

  1. Angel Renato Jimenez

    This plugin is really great! Is it possible to just show a form instead of a data table/ grid in a page? We are building a members only site and we want to store a lot of member information that we want members to fill up by themselves.

    Reply
  2. Ashad

    Hi
    Is this possible to create a user data API that includes following
    Users can CRUD data to a table with user-specific API key
    Like Thingspeak

    Reply
  3. Lazlo

    There is a great Youtube video showing a LOT of examples by using a Students Administration demonstration (wpda_sas). Forgive me but I can not locate that wpda_sas.zip file. Is it still available for the current version? It would be very helpful to a beginner. Thank you.

    Reply
  4. Lazlo

    Thank you, again, Peter.

    I have started getting the muscle memory for the core features and I am now wondering about the ability to display data without a grid. front-end read-only, just displays. I realize that the grid functionality is fundamental to the system but… in my case the data entry is all back-end (which I have the understanding for now) and my front-end display of details are less for grids and more for general html freedom. I olve your work for the ability to make real database back-ends, Love it… now it’s about the front-ends.

    For example, say you create a simple table of idname, fname, lname. idname is the pk (int, key, mandatory, auto_increment), fname and lname columns are just varchar(20). Back-end DDL and user data entry is easy with your system. Showing a grid of all of the records is easy with the system. But in that grid of all of the names if a user clicks a row (link in a column of a row) then a details page should be called – without a grid display.

    In that Details page, how to trap the fields and put them into a non-grid template. Such as a way iterate the fields passed to the details page in a loop or – hopefully – call each field by its key/fieldname and get the value, then use a new class to php echo my own html concatenated with those field values. No grid, no table, just using the fields collection passed to the Details page to squirt out custom html into the page’s Content area.

    I am looking into the Short_Form class but it is highly complex in that it deals with the grids and all of the complex code for the very beautiful grid displays… is there a very simple example – or one clear place in that code – that cuts that down to just iterating the data values?

    My actual project is a for a library. They have books, books have contributers (authors, illustrators, editors) and code numbers (ISBN, LOC, ASIN, etc) and FOR DISPLAY ONLY a details page would be best to be more like an Amazon product page than grids that open other pages with deeper grids.

    If I can do the simple example from above (id, fname, lname) then I think I might have the basics that I can extend it to iterate sublists on the same Details page (a Person record with id, fname and lname and then under that, a custom display of that Person’s previous addresses and then custom rows of previous employers, whatever else.

    So: Is there a trap/hook for just the fields collection in the Details pages? Thanks so much, I am very appreciative, and your work is beyond what I have found anywhere for a WordPress database option… it is now this one final piece to my puzzle 🙂

    Reply
    • Peter Schulz

      Hi Lazlo,

      Looks like you’re making progress! 🙂

      You can use the WP Data Access API to access your databases. The API contains a sub class of the WordPress wpdb class and allows you to connect to any database available from WP Data Access. This even works with remote connections to other DBMSes like SQL Server or ProgreSQL.

      A very simple example can be found here:
      https://code-manager.com/code/?wpda_search_column_code_id=60
      > You might need to add a slash in front of the WPDataAccess namespace!

      The $wpdadb in the example inherites all wpdb methods. So everyting you can do with the WordPress global $wpdb works with $wpdadb as well. 😉

      Hope this helps,
      Peter

      Reply
  5. Lazlo

    🙂 🙂 Yes, I think I am. I hadn’t seen your reply but I did see the example on the /docs/remote-database-connections/heterogeneous-connections/ and I used that for a direct connection to the db and I am now hitting and getting via a named function. I was going to go completely out of the WPDA data environment to ping directly BUT when I saw that I liked that it hooked WPDA for the database connection on an rdp database and that was nicer (letting you store my login to the db ). ONce I am good with this I will convert to using SPROCs and yes, Peter, things will be great.

    I will look at your above mention , it will probably be another awesome light bulb over my head for the day! Truly, WPDA is very nice work.

    btw: I did struggle with the connection to a “local” “database” (not the same “database” as the wordpress site’s data but created using my host’s cpanel. Such databases did not automatically appear in the WPDA Explorer. Once I figured out that creating an rdp connection using the text “localhost” in the host entry box would connect to another mySql in my host account… life was very happy.

    Reply
    • Kim Leong

      Hi Terry!

      We’ll work on more video tutorials in the future.

      In the meantime, please check this section for some written tutorials involving Geolocation that you might find relevant. 🙂

      Reply

Submit a Comment

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