Sending data from microcontroller to mysql database table on a web hosting server....

[jit_singh_tara]

Hello Friends , i have to design a system where i need to send data ( some voltages , status of some pins of mcu) via gprs (using sim 800 gsm /gprs module) to a web hosting server's database table .

DATA -> GPRS COMMUNICATION -> WEB HOSTING SERVER ->MYSQL SERVER -> TABLE ROWS.....

The data needs to be saved on the server on database file , so that it could be accessed from any where on the internet.

I will be accessing a php based file on address bar which will access the table of the database and return the result in form of html file in tabular form....


Please suggest what will be the best approach .....

The medium has to be gprs only as the hardware will not have access to ethernet or wifi .

So basically i need to remote monitor a hardware i/p and some data , which i could access from anywhere.....


Is it possible to connect to web server database table via AT commands . What all needs to be done if yes......
Since i will be communication with a server , then do i need to implement TCP/IP client server handshaking....

Please guide...

 

[Mithun_K_Das]

I'm also looking for this type of work.

- - - Updated - - -

I'm also looking for this type of work.

 

[jit_singh_tara]

HI friends ,

So far succeeded in sending data to server using following command....:

UART1_Write_Text("AT+HTTPPARA="URL","http://----------------------.co.in/-------.php?v2=147&v3=240&v4=46&v5='LOW'&v6='LOW'&v7='LOW'&v8='LOW'&v9='NO'&v10='NO'&v11='NO'&v12='NO'"");UART1_Write(13);delay_ms(1000);

BUt i want to send variable data using this command.
i.e i want to send values of variables using this command .
But it accepts only in form of string.

How to proceed....?

 

[jit_singh_tara]

Trying to convert variables to string , then join the strings using strcat(string concatenate) to form the following http post command :

UART1_Write_Text("AT+HTTPPARA="URL","http://----------------------.co.in/-------.php?v2=147&v3=240&v4=46&v5='LOW'&v6='LOW'&v7='LOW '&v8='LOW'&v9='NO'&v10='NO'&v11='NO'&v12='NO'"");U ART1_Write(13);delay_ms(1000);

But after a certain no of string joining the command becomes vague......I guess there is something wrong with either the string concatenate process .PLease suggest.....