PHP的Android脚本,使用php脚本和来自android的httppost将数据添加到在线数据库

在我的应用程序中，我为用户完成了特定的表单，并且希望将这些数据存储在我的在线数据库中。

这是我在java中的代码：

public void send_data_to_DB(){

String result = "";

InputStream is = null;

StringBuilder sb=null;

ArrayList nameValuePairs = new ArrayList();//() before

nameValuePairs.add(new BasicNameValuePair("table", table));

nameValuePairs.add(new BasicNameValuePair("code", Integer.toString(code)));

nameValuePairs.add(new BasicNameValuePair("name", name));

nameValuePairs.add(new BasicNameValuePair("email", email));

try{

HttpClient httpclient = new DefaultHttpClient();

HttpPost httppost = new HttpPost("http://myurl.php");

HttpEntity entity = new UrlEncodedFormEntity(nameValuePairs);

httppost.addHeader(entity.getContentType());

httppost.setEntity(entity);

HttpResponse response = httpclient.execute(httppost);

//HttpEntity entity = response.getEntity();

//is = entity.getContent();

}catch(Exception e){

Log.e("log_tag", "Error in http connection "+e.toString());

}

}这是我的PHP脚本：

mysql_connect("dserver","User","Code");

mysql_select_db("DB_Name");

$table.=$_POST['table'];

$code.=$_POST['code'];

$name.=$_POST['name'];

$email.=$_POST['email'];

$q=mysql_query(" INSERT INTO {$table} (code,name,email) VALUES ({$code},{$name},{$email}) ")or die(mysql_error());

mysql_close();

?>我认为它必须是我的PHP和我分配或使用变量的方式，但我不是很有经验的PHP。你可以帮我吗？