Technology or the best way to implement?

Question

PHP

Hello!
There is a task: it is necessary to maintain a simple database of equipment, let's say there are n laptops.
It is necessary to take into account which are issued to employees at the moment, which are free. which will be released soon.
In the future, a form of ordering a laptop for a certain period of time is planned.
Naturally, everything should work via the web
. The first thing that came to mind was to maintain a spreadsheet in Excel, process it with some scripts or forms. To what extent is this the optimal solution for this use case?
What do you recommend otherwise?
I don't want to mess with anything heavy like CMS or php + mysql.

Answer 1

I use google docs for this purpose. There you can make forms, tables and scripts for them, and there is also access control to all this.

Answer 2

The easiest way is to take a CMS and customize it for the right solution. You don't want to get involved with them. It will be much harder to link forms to Excel than to install a ready-made template and add your database to it.

Answer 3

on php + mysql this is done in an evening and it will turn out very convenient, in the future you can keep statistics and build reports.

Answer 4

AngularJS + mongolab as data store. You can write examples for the evening without really straining. And it will be very fashionable youth.
ps we have a corporate wiki for such things. Google docs are also very suitable. True, it will take time to set up the same way so what.

Answer 5

If PHP, then this does not mean that MySQL. After all, there is SQLITE.
Although a DBMS is not needed at all for the described task, a text file, perhaps even one, will suffice.
So on the server: PHP + text file. Its format depends on the amount of your equipment and the operations that need to be taken into account with it.
Options: INI file (easy to open in a text editor, pick it up), TSV (convenient to open and pick it up, both in a text file and in Excel), XML.
The ability to pick a file in the editor will allow you not to create an admin panel for the first time (or at all), but to focus only on the interface for end users.
On the client: Twitter Bootstap (you only need to know HTML to quickly make a decent interface).
If you invest a lot in design (i.e. just think), then the implementation can be made very simple.
I myself have almost implemented a contact management system for the call center.