ok, so an android app I am working on needs to read from an online database and display the results dynamically. This works fine, but then when I press a button in my UI, I need it to add a new row into the same database. When I test the app and click the button, it doesn't throw any exceptions or anything and once it finsihes the process goes right back to letting me do w/e I need on the UI. When I test the PHP script through the browser, it goes through all the echos I have in the script and reaches the bottom of the script no problem, however it doesn't add the row... I am at a loss here... Maybe you all can help.
Here is my PHP file:
[syntax=php]
<?php
mysql_connect("localhost","XXXXX","XXXXX");
mysql_select_db("bonafie0_mm");
echo "connected to database";
mysql_query("INSERT INTO Comments (user, comment) VALUES ('".$_REQUEST['user']."', ".$_REQUEST['comment']."')");
echo "done. ";
mysql_close();
?>
[/syntax]
and for those of you who are experienced with java and/or the android SDK, here is my android code:
[syntax=java]
private void postComment()
{
String user = editName.getText().toString();
String comment = editComment.getText().toString();
OutputStream os = null;
ArrayList<NameValuePair> nameValuePair = new ArrayList<NameValuePair>();
nameValuePair.add(new BasicNameValuePair("user", user));
nameValuePair.add(new BasicNameValuePair("comment", comment));
try
{
HttpClient client = new DefaultHttpClient();
HttpPost post = new HttpPost(ROTM_POST_URL);
post.setEntity(new UrlEncodedFormEntity(nameValuePair));
HttpResponse response = client.execute(post);
}
catch(IOException e)
{
Toast.makeText(RoTM.this, "Unable to post comments", Toast.LENGTH_SHORT).show();
}
editName.setText("");
editComment.setText("");
}
[/syntax]
Any ideas? I posted this on the only two reputable android dev forums I could find, but no one has been able to help me as of yet... Since I am fairly confident in my java abilities, I figured my problem probably lies in my PHP code.
