-1

i have a working website... i need to create a database from data collected by sensors connected to Arduino. I am new in this and so would like to ask what should i exactly have or create in order for me to achieve this. Are there ways i can go for except for using ethernet cable?

Thank you in advance.

closed as too broad by Gerben, gre_gor, Michel Keijzers, Enric Blanco, SDsolar Jun 9 '17 at 0:30

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • I hope this find you in good spirit. – T. Mantsha Jun 8 '17 at 14:22
  • 1
    People aren't going to give you a solution, but will steer you in the right direction. You could use WIFI (via and ESP 8266) or Bluetooth. You need to implement a REST interface on your website and secure it. Then you need to program the ESP as a REST client and get it to read the data from the Arduino. – Code Gorilla Jun 8 '17 at 14:36
1

There are several parts to this. Getting the data from the sensor to the computer, inserting it into a database, then displaying it.

You need:
A sensor(s)
A device to read the sensor and send the value(Arduino, esp8266, etc.)
A medium to send the data (wifi, network, Bluetooth, usb)
A program to read the data and insert it into the database (webpage, program, script)
A database to store the data (MySQL, MSSQL, etc.)
A website to display the data (php, .NET, java) A webserver to host the website (IIS, Apache)

I have done this with:
DHT11 - temp / humidity sensor
ESP8266 - WiFi module to read the sensor and send data over wifi
Laptop running Ubuntu, Apache, and MySQL hosting a PHP website. There was a page used to insert data and a couple pages to read data.

To design this yourself, you have to take it one step at a time to design it.

This is about as specific as I can get with the information given. If you have further questions on more specific parts of this, I would be glad to help.

  • Thank you for the reply... it really makes sense now. I am running Windows OS. No Apache, no MySQL, no PHP. Do i need to install all those? – T. Mantsha Jun 10 '17 at 12:30
  • @T.Mantsha - No, because you say you have a working website already, so you need to use the applicable technology for that platform to implement an API for your device. You could use IIS and ASP which is harder to host commercially, but if you are doing it on you local PC it doesn't matter. – Code Gorilla Jun 12 '17 at 8:11
  • @T.Mantsha as Code Gorilla has said, IIS is preferable with windows. The GUI interface is easier to use than the configuration files with Apache. IIS runs natively with ASP and ASP.NET, but you can install PHP modules if you want. For a database you might be able to find a free version of Microsoft SQL, or you can use MySQL. – rpmerf Jun 12 '17 at 14:22
  • @rpmerf Do you perhaps have a demo video to one the similar project you did already? – T. Mantsha Jun 28 '17 at 12:45

Not the answer you're looking for? Browse other questions tagged or ask your own question.