First of all, I'm a beginner. I don't have programming experience, but I'm an advanced (Linux, openwrt) user. I can run/configure a web server and I have experience compiling from source, applying patches, etc. I'm trying to find the best suitable hardware for the following project:
I want to pick up the state (open/close) of a couple of switches through the input terminals of an I/O board. This I/O board has to be network capable, because it will be far from the pc that will host the database. I want to update a database via sql as soon as the state of any of the switches changes. Then I want to show these states on a excel sheet alike table via a browser. I was thinking to use google charts (table charts) for this, because I don't know how to code in PHP, but I find google charts fairly easy to use and it is a well documented project.
I have spent a lot of time trying to find a hardware that would pick up the open/close signal and would do the update in the database via sql. I was hoping that there is an off the shelf solution already which I can configure via the webif of the hardware. I'm not lucky so far, that is why I ended up here.
Does anyone know of any proprietary hardware that is capable of doing what I'm trying to achieve?
If not, what is the most simple way of doing this with an arduino board?
Many thanks ahead!
Update: I have created a connection diagram for the project. This will help further explain what I'm trying to achive. What hardware do you guys recommend for the project? Keep in mind that I can only do basic changes to an existing program, so I prefer to use the hardware that already has a script/program written for it that performs very similar task to what I'm trying to do here.
Click here for zooming functions: https://creately.com/diagram/example/iwxxu1cq1/Switch+status+data+logger