GUI for Data Entry

Question

question

TaRan-7586 asked Feb 1, '22 OuryBa-MSFT commented Feb 28, '22

GUI for Data Entry

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.

azure-database-mysql azure-managed-applications

· 4

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OuryBa-MSFT · Feb 04 at 02:58 AM

Hi @TaRan-7586 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

0 ·

OuryBa-MSFT OuryBa-MSFT · Feb 11 at 11:43 PM

Hi @TaRan-7586 Did the answer above helped resolve your issue.
Please let me know if you need more assistance

Regards,
Oury

0 ·

TaRan-7586 OuryBa-MSFT · Feb 15 at 09:08 PM

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.

0 ·

Show more comments

question