Page 1 of 1

post to mysql

PostPosted: 19. October 2011 14:02
by trektrak
Hello guys,

I'm so in need of help. I've been using xampp for one week now and I need a guidance on something ...
I'm creating a simple geolocation web server (Simple Long Lat Locator). Basically it can access by phone or support browsers and read its geolocation.
Well theoretically, I do understand that there are two sides : -

I/ server : -
a. Geolocation html scrip
b. php
c. mysql

II/ client (gps via browser)

What should I do with my html script... how do I connect with php to post the data (lat,lng)... and how to store the data to mysqlserver...

Really appreciate if anyone can help me on this.. I'm so new with all this stuffs...

Re: post to mysql

PostPosted: 19. October 2011 17:23
by WilliL
trektrak wrote:I'm creating a simple geolocation web server (Simple Long Lat Locator). Basically it can access by phone or support browsers and read its geolocation.
Well theoretically, I do understand that there are two sides : -

what do you mean "by phone"?
Usually you reach a html-page. In your case you information must be send to (address ..)
Code: Select all
http://yourdomain.tdl/geo_get_page.php?parm1=DATA_TO_SEND1&parm2=HASHED_IDENTIFIER
//
http://yourdomain.tdl/geo_formular.php //or .html
//where the user has to enter location parameters.

trektrak wrote:I/ server : -
a. Geolocation html scrip
b. php
c. mysql
II/ client (gps via browser)

I agree with you.

trektrak wrote:What should I do with my html script... how do I connect with php to post the data (lat,lng)... and how to store the data to mysqlserver...

there's a lot to learn :wink:
php - http://www.w3schools.com/PHP/php_intro.asp
sql - http://www.w3schools.com/sql/default.asp