mysql保存arraylist_Java-将ArrayList从Android发送到PHP MySQL

在表work_details中,我有7列(id,项目,work_description,百分比,time_in,time_out,fk).现在,我想将arraylist和fk保存到表中.

我已经尝试编码,但是我知道这不是正确的方法.

public void addWorkDetails(ArrayList listItems, long id)

{

JSONObject object= new JSONObject();

for(int i=0;i

{

try

{

object.put("Count : "+String.valueOf(i + 1),listItems.get(i));

}catch(JSONException e)

{

e.printStackTrace();

}

}

class AddWorkDetails extends AsyncTask {

ProgressDialog loading;

@Override

protected void onPreExecute() {

super.onPreExecute();

loading = ProgressDialog.show(WorkDetailsTable.this, "Please Wait",null, true, true);

}

@Override

protected void onPostExecute(String s) {

super.onPostExecute(s);

loading.dismiss();

Toast.makeText(getApplicationContext(),s,Toast.LENGTH_LONG).show();

}

@Override

protected String doInBackground(String... params) {

HashMap data = new HashMap();

// what should I put here ?

RequestHandler rh=new RequestHandler();

String result = rh.sendPostRequest(Config.ADD_WORKDETAILS,data);

return result;

}

}

AddWorkDetails ru = new AddWorkDetails();

ru.execute(listItems,id);

}

腓

if($_SERVER['REQUEST_METHOD']=='POST'){

$list[]=$_POST['listItems'];

$id=$_POST['id'];

foreach($list as $value){

$value=mysqli_real_escape_string($val);

$sql="INSERT INTO work_details (project, work_description, percentage, timeIn, timeOut, id) VALUES ('$val', '$id')";

//Importing our db connection script

require_once('dbConnect.php');

//Executing query to database

if(mysqli_query($con,$sql)){

echo ' Added Successfully';

}else{

echo 'Could Not Add Data';

}

//Closing the database

mysqli_close($con);

}

?>

请注意,listItems包含project,work_description,percentage,time_in和time_out.