Thank you vaj4088 for your reply.
Here I attached my full code. I am using this code for transferring GPS latitude and longitude to mySql server.But this code, couldn't transfer any data to my mysql database, either "0" or any value. Thats why my database is empty.
#include <SoftwareSerial.h>
SoftwareSerial gprsSerial(7, 8);
char aux_str[30];
char aux;
char latitude[15];
char longitude[15];
char inChar;
int index;
char inData[200];
void setup()
{
gprsSerial.begin(9600);
Serial.begin(9600);
Serial.println("Config SIM808...");
delay(2000);
Serial.println("Done!...");
gprsSerial.flush();
Serial.flush();
start_GSM();
delay(5000);
start_GPS();
}
void loop()
{
read_GPS();
delay(2000);
send_GPRS();
delay(30000);
}
void start_GSM(){
//Configuracion GPRS Claro Argentina
Serial.println("AT");
delay(2000);
Serial.println("AT+CREG?");
delay(2000);
Serial.println("AT+SAPBR=3,1,\"APN\",\"my3g\"");
delay(2000);
/*Serial.println("AT+SAPBR=3,1,\"USER\",\"yourUser\"");
delay(2000);
Serial.println("AT+SAPBR=3,1,\"PWD\",\"YourPWD\"");
delay(2000);*/
Serial.println("AT+SAPBR=3,1,\"Contype\",\"GPRS\"");
delay(2000);
Serial.println("AT+SAPBR=1,1");
delay(10000);
Serial.println("AT+HTTPINIT");
delay(2000);
Serial.println("AT+HTTPPARA=\"CID\",1");
delay(2000);
gprsSerial.println("AT++CGPSINF=0");
delay(2000);
}
void send_GPRS(){
Serial.print("AT+HTTPPARA=\"URL\",\"event.esy.es/writeData.php?latitude=");
Serial.print(latitude);
Serial.print("&longitude=");
Serial.print(longitude);
Serial.println("\"");
delay(2000);
Serial.println("AT+HTTPACTION=0"); //now GET action
delay(2000);
}
void start_GPS(){
//Configuracion en Inicializacion GPS
Serial.print("AT");
delay(1000);
Serial.println("AT+CGPSIPR=9600");// (set the baud rate)
delay(1000);
Serial.println("AT+CGPSPWR=1"); // （turn on GPS power supply）
delay(1000);
Serial.println("AT+CGPSRST=1"); //（reset GPS in autonomy mode）
delay(10000); //delay para esperar señal del GPS
}
void read_GPS(){
Serial.println("AT+CGPSINF=0");
read_String();
strtok(inData, ",");
strcpy(longitude,strtok(NULL, ",")); // Gets longitude
strcpy(latitude,strtok(NULL, ",")); // Gets latitude
convert2Degrees(latitude);
convert2Degrees(longitude);
}
void read_String() {
index=0;
while(Serial.available() > 0) // Don't read unless
// there you know there is data
{
if(index < 199) // One less than the size of the array
{
inChar = Serial.read(); // Read a character
inData[index] = inChar; // Store it
index++; // Increment where to write next
inData[index] = '\0'; // Null terminate the string
}
}
}
int8_t convert2Degrees(char* input){
float deg;
float minutes;
boolean neg = false;
//auxiliar variable
char aux[10];
if (input[0] == '-')
{
neg = true;
strcpy(aux, strtok(input+1, "."));
}
else
{
strcpy(aux, strtok(input, "."));
}
// convert string to integer and add it to final float variable
deg = atof(aux);
strcpy(aux, strtok(NULL, '\0'));
minutes=atof(aux);
minutes/=1000000;
if (deg < 100)
{
minutes += deg;
deg = 0;
}
else
{
minutes += int(deg) % 100;
deg = int(deg) / 100;
}
// add minutes to degrees
deg=deg+minutes/60;
if (neg == true)
{
deg*=-1.0;
}
neg = false;
if( deg < 0 ){
neg = true;
deg*=-1;
}
float numeroFloat=deg;
int parteEntera[10];
int cifra;
long numero=(long)numeroFloat;
int size=0;
while(1){
size=size+1;
cifra=numero%10;
numero=numero/10;
parteEntera[size-1]=cifra;
if (numero==0){
break;
}
}
int indice=0;
if( neg ){
indice++;
input[0]='-';
}
for (int i=size-1; i >= 0; i--)
{
input[indice]=parteEntera[i]+'0';
indice++;
}
input[indice]='.';
indice++;
numeroFloat=(numeroFloat-(int)numeroFloat);
for (int i=1; i<=6 ; i++)
{
numeroFloat=numeroFloat*10;
cifra= (long)numeroFloat;
numeroFloat=numeroFloat-cifra;
input[indice]=char(cifra)+48;
indice++;
}
input[indice]='\0';
}
void toSerial()
{
while(gprsSerial.available()!=0)
{
Serial.write(gprsSerial.read());
}
}
After uploading my full code into arduino. I got bellows result in the Serial Monitor.
AT
AT+CREG?
AT+SAPBR=3,1,"APN","my3g"
AT+SAPBR=3,1,"Contype","GPRS"
AT+SAPBR=1,1
AT+HTTPINIT
AT+HTTPPARA="CID",1
ATAT+CGPSIPR=9600
AT+CGPSPWR=1
AT+CGPSRST=1
AT+CGPSINF=0
AT+HTTPPARA="URL","event.esy.es/writeData.php?latitude=0.000000&longitude=0.000000"
AT+HTTPACTION=0
AT+CGPSINF=0
AT+HTTPPARA="URL","event.esy.es/writeData.php?latitude=0.000000&longitude=0.000000"
AT+HTTPACTION=0
AT+CGPSINF=0
AT+HTTPPARA="URL","event.esy.es/writeData.php?latitude=0.000000&longitude=0.000000"
AT+HTTPACTION=0
My database have only 3 Columns.
One is ID, and another 2 is longitude and latitude. I tested my code many different ways. Then see AT+HTPACTION=0 is not working. Got errors. Maybe there have another issues also. But I couldnt find.
I am using Elecrow SIM808 GPRS/GSM+GPS Shield v1.1 with Arduino Uno.