This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Azure offers MySQL as a service. If I were to set up a MySQL database, does Azure also offer an app (maybe a web-facing PHP app) for data entry? Initial and large data uploads and management would happen via SQL on the backend, but does Azure offer an app that can connect to the MySQL database for easy data entry for non-code proficient users?
I am looking to set up a database that would eliminate the need for my coworkers to edit multiple Excel files to keep track of client data. I can manage the database through SQL fine, but they would need to have some user-friendly interface in which to input the data. I was thinking a PHP web page would work. Does Azure offer something like that? I know PHP, but it's been a while and I'm not sure if I could stand up something like that with my own coding skills.
Hi @TaRan Thank you for posting your question on Microsoft Q&A.
From what I understand you are looking for a use-friendly interface in which to input data for MySQL Database.
There is a tutorial how to do it using Azure data explorer Query Azure Database for MySQL -Flexible Server from Azure Data Explorer
Regards,
Oury
I did not ever find a solution. The project is still sitting in limbo at this time.
Hi Wilson, TaRan (Avison Young - US)
Power Platform is the easiest way to go about but you would need to have that service and there's a subscription cost associated. Another option is to use Microsoft Forms, export the data into excel file, and upload the file into a SQL database. But that's INSERT only.
The last thing I can think of is doing a dotnet web app.
Regards,
Oury
Hi @TaRan Did the answer above helped resolve your issue.
Please let me know if you need more assistance
Regards,
Oury
I apologize for the late reply.
This isn't exactly what I am looking for. I am needing a user-friendly interface that my coworkers can connect to that will feed into a MySQL database. The interface should be something a simple as a form. So if my users want to enter a new entry into the data base, they can fill out the required fields (name, city, state, etc.) and click submit on the "form" and it would enter the entry into the MySQL database. Also, if they wanted to update an entry, should be able to find it from the interface (perhaps a search field that queries the DB for the appropriate location). Then they can edit the information within the database. All of this would be through a user-friendly, front-end interface.
Hi @TaRan Sorry for the delay in my response.
What you are looking for is not doable with any tool. You would need to build your own app to do that based on your database. But if you want to manage and build, the database workbench is good tool to get started with.
https://dev.mysql.com/doc/visual-studio/en/visual-studio-install.html
Regards,
Oury
Hi @TaRan did you find a solution? I have the same issue?
Regards,
Ivan
Sign in to comment