I want add the new supports data via http post. Im getting an error response code is 500. I check code and php files i cant see any problem. And I dont complete code how i can get result after solve 500 error.
NewSupport.java
try{
URL url = new URL("myurl/db_newSupport.php");
HttpURLConnection conn = (HttpURLConnection) url.openConnection();
conn.setReadTimeout(15000);
conn.setConnectTimeout(15000);
conn.setRequestMethod("POST");
conn.setDoInput(true);
conn.setDoOutput(true);
Uri.Builder builder = new Uri.Builder()
.appendQueryParameter("uniq", "UNIQ")
.appendQueryParameter("data", "DATA")
.appendQueryParameter("date", "DATE");
String query = builder.build().getEncodedQuery();
OutputStream os = conn.getOutputStream();
BufferedWriter writer = new BufferedWriter(
new OutputStreamWriter(os, "UTF-8"));
writer.write(query);
writer.flush();
writer.close();
os.close();
int responseCode=conn.getResponseCode();
if (responseCode == HttpURLConnection.HTTP_OK) {
BufferedReader in=new BufferedReader(new InputStreamReader(conn.getInputStream()));
StringBuffer sb = new StringBuffer("");
String line="";
while((line = in.readLine()) != null) {
sb.append(line);
break;
}
in.close();
}
}
catch(Exception e){
e.printStackTrace();
}
db_newSupport.php
$response = array();
if (isset($_POST['uniq']) && isset($_POST['data']) && isset($_POST['date'])) {
$uniq = $_POST['uniq'];
$data = $_POST['data'];
$date = $_POST['date'];
require_once __DIR__ . '/db_connect.php';
$db = new DB_CONNECT();
$result= mysql_query("INSERT INTO new(uniq, data, date) VALUES('$uniq', '$data', '$date')");
if ($result) {
$response["code"] = 1;
$response["info"] = "successfully";
echo json_encode($response);
} else {
$response["code"] = 0;
$response["info"] = "error";
echo json_encode($response);
}
} else {
$response["code"] = 99;
$response["info"] = "error";
echo json_encode($response);
}
?>