Connect arduino to MySQL database | Best method and modul

363
August 22, 2017, at 3:19 PM

i try to connect from Arduino to wifi and MySQL database. What is best modul for connection and best way to connect and insert/update/delete data? Thanks

Answer 1

As you haven't posted any codes I can just suggest you how you can do that.

What is best module for connection ?

The selection of best module depends on your need. If the device that you are going to built is moving one like devices on vehicle then I would suggest you GSM module for doing this ( GSM 900A is pretty nice). Else if it is a static device like an automated rain meter gauge then you can use wifi module as per availability of wifi connectivity.

Best way to connect and insert/update/delete data?

So this I would suggest using PHP. In this you first need to setup a PHP code which would insert value to database when that page is requested from arduino. As you haven't posted any codes I think you haven't tried anything yet. So more information on this can be found here.

Answer 2

This link may work:

Arduino-ESP8266

READ ALSO
MYSQL Nested group by using single query

MYSQL Nested group by using single query

I have a db with the following schema

239
Different DISTINCT COUNT results on same record set

Different DISTINCT COUNT results on same record set

I have strange behavior of two nearly identical 'count' queries that should return same results

185
How to get latest records if date is in YYYY-MM-DD and time in hh:mm:ss AM/PM format

How to get latest records if date is in YYYY-MM-DD and time in hh:mm:ss AM/PM format

I want to get the latest records in my database which has fields date and time as varchar and in the format (YYYY-MM-DD and time in hh:mm:ss AM/PM format)I need to figure out a way to sort them

231
Inventory cycle count

Inventory cycle count

What is the easiest way to code for being able to cycle count the highest moving parts in a warehouse database

198