Yes WordPress is an excellent platform for this type of application.
You will be writing your own plugin that contains you code, it will publish some shortcodes that let your code run in nominated pages, all the rest of WordPress provides the support features to your app, things like user registration and management, instruction pages, menus, all of this functionality arrives free of charge and without additional effort.
The shortcode function will first check that the user is logged in and has the required capabilities, otherwise generating a page “You do not have the credentials to access this page”. Otherwise it does your SQL query and displays the results in a table, or displays a form to upload a file etc. You maintain user data separation by having the user ID as a key field.
When I was getting started with this type of app, I found this plugin a very helpful starting place:
https://wordpress.org/plugins/wp-csv-to-database/
I always acknowledge the author in my derived works.
Initially I focus upon the user app side and do the creation of SQL tables and data admin in phpmyadmin, only coding those aspects subsequently.
Thank you Ross! I will have a look. Did you say you’ve already done this yourself? Did you make a plugin that I could use?
Did you say you’ve already done this yourself?
Yes, I have developed several applications this way.
Did you make a plugin that I could use?
Unfortunately not. They were developed for a client, they are only used on his websites.
