Tutorials

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.

More complex features are available for experienced developers, like remote database access and executing SQL scripts. Remote database access is supported by all features.

Data Publisher

The Data Publisher allows plugin users to create responsive tables from local and remote databases. Publications can be created with just a few mouse clicks. Customizable styles are available for download for free. Demos and videos are available to help new and experienced users getting their publications up and running. The Data Publisher supports client side processing for small tables and server side processing for large tables (several use cases with over two million rows). Advanced options and javscript support is available for more experienced developers.

Data Projects

Manage your local and remote data with Data Projects. Supports many features like parent-child relationships, lookups, autocomplete, many customizable options and access rights per page supporting WordPress roles. Projects can be executed from the dashboard or a web page using a shortcode. Data Forms is a premium feature which allows plugin users to turn their Data Projects into fully responsive AngularJS apps without the need to make any modifications to their projects. Data Projects is optimized to work with large tables.

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.

Shortcodes

Publications and projects created directly from a shortcode is still supported for backward compatibility. This is an old feature with many limitations. Please update your shortcodes and use the Data Publisher for your publications and Data Projects for data management.

 

Databases

Here are some external tutorials that might help to get a better understanding of databases.

Beginner

Advanced

jQuery DataTables

WP Data Access uses jQuery DataTables for publications and Data Forms. Some table options can be managed interactively, many other options are available through customizable JSON. A link is provided to a reference showing all available options.

 

10 Replies to “Tutorials”

  1. 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.

  2. 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

  3. 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.

  4. 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 🙂

    1. 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

  5. 🙂 🙂 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.

    1. 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. 🙂

Leave a Reply

Your email address will not be published.