send gps data to my sql server via http get

i am new to programming ,i am trying with gprs and AT commands, after initializing http connection, if i send the url as
"AT+HTTPPARA="URL","http://myserver.com/add_data.php?lat=656&lng=565""
if i send this, data correctly added to my data base. but how can i use some variable instead of that direct values

but how can i use some variable instead of that direct values

At last count, there were 123,535,345,345,098 ways to do it. A little time with google would surely have found one of them. If not, here's a hint: sprintf().

You could also use

client.print( F("AT+HTTPPARA=\"URL\",\"http://myserver.com/add_data.php?lat=") );
client.print( lat );
client.print( F("&lng=") );
client.print( lon );
client.println( '\"' );

Using the F macro keeps from using RAM for that string constant. The last println is the special one-char print, no RAM wasted. sprintf uses more program space than the above snippet, but it's worth it if you have a lot of these kind of variable prints.

Cheers,
/dev