Tutorials
Collated list of tutorials
Data Tables
Show Tutorial List for Data Tables
- Show all data tables tutorials (list moved to documentation)
- jQuery DataTables reference
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
- Show all data apps tutorials (list moved to documentation)
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.
Show Tutorial List for Data Explorer
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.
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.
Hi Angel,
Is is possible to create a registration page. This is documented here:
https://wpdataaccess.com/docs/data-apps/registration-page/
Does this help?
Peter
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
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.
Hi Lazlo,
You can download the ZIP file from here:
https://wpdataaccess.com/wp-content/uploads/2020/06/sas.zip
The link is available on the SAS demo page as well, but I now see that the YouTube link was broken. I fixed the broken link. The inline tutorials and ZIP file can be found on this page:
https://wpdataaccess.com/docs/app-demos-and-tutorials/data-apps-demos/
Let me know if you have any questions,
Peter
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 🙂
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
🙂 🙂 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.
https://wpdataaccess.com/publication-using-gps/ Hi can you please do a video tutorial on this
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. 🙂