Not sure what I have missed here. I give this error when workForce data get inserted. When I check MySQL, all data get inseted, only twf is 0.
public void addWorkForce(final String subcontractors, final String noPeople, final String noHours, final long id)
{
class AddWorkForce extends AsyncTask<String, Void, String> {
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<String, String> data = new HashMap<String,String>();
data.put(Config.KEY_SUBCONTRACTORS,subcontractors);
data.put(Config.KEY_NUMBERPERSONS,noPeople);
data.put(Config.KEY_NUMBERHOURS,noHours);
data.put(Config.KEY_TWF,String.valueOf(id));
RequestHandler rh=new RequestHandler();
String result = rh.sendPostRequest(Config.ADD_WORKFORCE,data);
return result;
}
}
AddWorkForce ru = new AddWorkForce();
ru.execute(subcontractors,noPeople,noHours);
}
addWorkForce.php
<?php
if($_SERVER['REQUEST_METHOD']=='POST'){
//Getting values
$subcontractors = $_POST['subcontractors'];
$noPeople = $_POST['noPeople'];
$noHours = $_POST['noHours'];
$twf = $_POST['id'];
//Creating an sql query
$sql = "INSERT INTO work_force(subcontractors, number_of_person, number_of_hours, twf) VALUES ('$subcontractors','$noPeople','$noHours','$twf')";
//Importing our db connection script
require_once('dbConnect.php');
//Executing query to database
if(mysqli_query($con,$sql)){
echo 'Work Force Added Successfully';
}else{
echo 'Could Not Add Work Force';
}
//Closing the database
mysqli_close($con);
}
?>
