A
A
Artoym22018-03-30 18:43:22
Laravel
Artoym2, 2018-03-30 18:43:22

Laravel module search?

Good afternoon, tell me, I want to find a ready-made package for creating a universal structure for working with dynamic content. The idea is as follows, there are several tables:
element (all elements are stored dynamically, the selection is made by the type field and additional parameters. If you want to select all news from the database, we make a query select element where type=news)
categories (similarly with elements, in the database data, there is a type field to select data for certain sections)
Elements can be extended through the Entity-attribute-value model in this case, it will allow you to create properties for elements and categories.
Can you please tell me if there is a similar solution? Perhaps you should think in a different direction. Thanks

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Alexander Aksentiev, 2018-03-30
@Sanasol

There will be worse shit at the exit (if you fill in at least a decent amount of content).
EAV is good for all sorts of stores, doing faceted searches and stuff like that.
And then you need an "ideal" implementation of EAV, when each data type has its own table (integer, string, etc.).
In Magento, there is just such an implementation: devdocs.magento.com/guides/m1x/magefordev/mage-for...
Bitrix uses a similar approach when everything is put together like this, everything is kind of flexible, but with a load / amount of content it becomes clear due to What is all this flexibility.
In short, it depends on the site.

S
sim3x, 2018-03-31
@sim3x

Try
The next step is to store queries to the subd in separate tables of the same database. After
that, store the PHP code that will work with queries from the previous one in another table . This is let tsms - who try to do everything and do not know how to do anything

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question