Continue to Site

Welcome to EDAboard.com

Welcome to our site! EDAboard.com is an international Electronics Discussion Forum focused on EDA software, circuits, schematics, books, theory, papers, asic, pld, 8051, DSP, Network, RF, Analog Design, PCB, Service Manuals... and a whole lot more! To participate you need to register. Registration is free. Click here to register now.

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

Status
Not open for further replies.

jit_singh_tara

Full Member level 6
Joined
Dec 22, 2006
Messages
325
Helped
9
Reputation
18
Reaction score
4
Trophy points
1,298
Location
Delhi , India
Activity points
4,293
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...
 

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....?
 

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.....
 

Status
Not open for further replies.

Part and Inventory Search

Welcome to EDABoard.com

Sponsor

Back
Top