post data on mysql using php or html

[ruleworld]

Hi,

I have a mysql database and i add string data to it using a web html form. The html form inserts data to the table using php which is here

<?php

$con = mysql_connect("mysql10.000webhost.com","a7456565_zzz","zzz");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("a7456565_db", $con);

$sql="INSERT INTO GPS (lat,lon)
VALUES
('$_POST[lat]','$_POST[lon]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";
mysql_close($con)

?>

how can i add data to it using JAVA ME?
I add data using a html form which works fine.
I tried the following but is not working

HttpConnection conn =
("http://www.test.it" + "?TextField=Hello&TextField2=Hello2&Submit=Submit");
conn.close();

[hartti]

Your PHP code is expecting the data through HTTP POST. If you add the data in the URL like you have done in the Java Example, you are sending the data with HTTP GET. If that's ok for you, then change the "$_POST" strings in your PHP sample to "$_GET"
If you want to use POST instead, check this code sample
http://wiki.forum.nokia.com/index.ph...est_in_Java_ME

Hartti

[njzk2]

also your parameters are named incorrectly. you php script expects lat and lon, not TextField and TextField2

[ruleworld]

i managed to do it. thanks.