Hello masters, we have a project and i want to send the data to hosted mysql database server using GSM GPRS module sim900. Can you please hand me a guide or steps of how can i achieve that. THANK YOU!
You should read this;
To test the system I would send sms messages to my own mobile then, once they are correct, to the database server.
The sms messages will need to be in the format expected by the whatever software on the database server is parsing them.
If you are writing that software yourself then you can define your own message syntax. If the parser already exists then you will need to find out what syntax it uses and adopt that.
If you have not written any arduino software before then you should start by working through some tutorials.
i have successfully request sensor data from GSM and replies to me by their specific values. So my only thing that i need to know is to store the data to Mysql Database in the internet not in the local server. Can you please help me?
BINS:
i have successfully request sensor data from GSM and replies to me by their specific values. So my only thing that i need to know is to store the data to Mysql Database in the internet not in the local server. Can you please help me?
If you forget about the GSM aspect how would you normally store data into the MySQL Datase "in the internet"?
Also what do you mean by "in the internet", do you have access to the server running the database, can you write programs and have them executed on that server?
I mean sending the data to cloud database and its up to me to fetch that data to my webpage cuz i have knowledge of web developing. I JUST NEED TO KNOW HOW CAN MY SENSOR DATA BE SENT TO THE INTERNET(MYSQL CLOUD DATABASE, HOSTING SITES WITH MYSQL DATABASE OR WHATELSE) THAT I CAN FETCH. Just the way to send the data.
this is the picture of what module im using. I've read everything about that module. But the logic to send data to database is very hard for me as fuck. MASTER, can you please help me for this. THANK YOU!!!
In post #2 you wrote;
i have successfully request sensor data from GSM and replies to me by their specific values. So my only thing that i need to know is to store the data to Mysql Database in the internet not in the local server. Can you please help me?
Sorry but I really don't understand your problem.
If you have managed to send your data over GSM, and it seems you have, then you use an API or whatever to write the data into your database. I really cannot tell you any more than that.
No, i dont achieve that. i just want to know is how do i send the sensor data from my arduino and GSM GPRS module to online database. Thats it, thats the main problem. Please tell me about it how can i achieve that.
Break the problem down into small steps.
First write a sketch that sends an SMS to your own phone.
Next get the sketch to read your sensor data and send that as a message to your own phone.
Finally add in the database part.
You need to find and read the documentation for your GSM module, it probably has examples.
You also need to find and read the documentation that explains how to write data into the database you are using.
If you don't send links to this documentation I doubt people here will be able to help much.