Jump to content

framework for easy database entry and retreival


Recommended Posts

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.

 

 

 

Screenshot 2024-05-14 at 12.28.28 PM.png

Screenshot 2024-05-14 at 12.28.39 PM.png

Link to comment
Share on other sites

  • 3 weeks later...

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.