framework for easy database entry and retreival

[M.O.S. Studios]

Hey Everyone,

 

I am hoping to find a framework that can easily do the following:

1. Take the information I feed it, and turn it into a simple form that can store and validate entries into a MYSQL Database

2. Use entries from one table as drop-down options for another

3. Allow me to search the database and display them easily.

 

I originally used Google Sheets for it, but I'm finding that is going to be a lot of work.

 

I attached screenshots of the documents to give an idea of what the functionality is going to be

 

I know none of this is hard to do. I don't want to go through the trouble of making a front-end, and troubleshooting if there is a faster way.

 

 

 

[gizmola]

If you were to utilize an MVC framework like Laravel or Symfony, they each have libraries that can easily generate CRUD for simple updates.  I'm not sure you're going to find anything which gives you a spreadsheet-like interface, but you may find it gets you most of the way to what you need.

There are probably many of these I don't know about but just as a start:

For Laravel:

https://github.com/awais-vteams/laravel-crud-generator

https://github.com/misterdebug/crud-generator-laravel

For Symfony:

Symfony has the maker bundle, that provides features that let you generate code, including CRUD.  This article outlines some of the basic things you install:  https://digitaldeveloper.dev/create-crud-symfony-7

There's also the well known Easyadmin bundle that works with Symfony 7:  https://github.com/EasyCorp/EasyAdminBundle

In both cases, you have to get a lot of the foundation classes built, and there will be a significant learning curve.  You can customize things once you know what you are doing, but again it is going to require some developer knowledge.  For example, people often will do a bit of integration with a css framework like bootstrap or tailwind in order to get things to look nice.