How to create a table on a page and a form in Joomla that will interact with the database?

Question

Joomla

I need advice, I have a task: On the Joomla site, create a table that would display elements from the database and when you click on any of the elements, a window would open with detailed information about this element. You also need to create a form through which you could fill in this table, the form should also be on the page with the table.
It is important that this is done on Joomla.
Advise how you can do this, you are interested in the steps - is it worth looking for some ready-made module and rewriting it, or trying to create a module yourself?
I myself am new to Joomla, so I want to know the direction where to move and mb some tips on how to do it easier.

Answer 1

The task on any cms in php comes down to writing a solution to the main task, and how to arrange it (a module, not a module) is already a nuance at the level of reading the documentation of this cms.
Here:
- create a table, fill with data
- display data from the table in the html template, embed data in the template that identifies the row in the table (data-id=123 type)
- write a js handler that will read the click on the cell and redirect to the page editing this line with a cell (or changing the value in place, as you can write)
- write a form for adding a line, in the action set the URL of a php handler that will receive data, save it to a table and return to the table display page.
Solutions to all problems are googled separately without Joomla, then as you progress, you can figure out how to plug it into it