invisio v2.0

<?php
session_start();
include ('../../../config/main_function.php');
$secure = "cAh3DrJACzw4RbU";
$connection = connectDB($secure);

if ($connection) {
  $job_id = mysqli_real_escape_string($connection, $_POST['job_id']);
  $remark = mysqli_real_escape_string($connection, $_POST['remark']);
  $status = mysqli_real_escape_string($connection, $_POST['status']);

if ($status == '1') {
    $sql_update = "UPDATE tbl_job SET 
        active_status = '$status'
        WHERE job_id = '$job_id'";

$res_update = mysqli_query($connection, $sql_update) or die($connection->error);

} else if ($status == '0') {
    $sql_update = "UPDATE tbl_job SET 
        active_status = '$status',
        remark = '$remark'
        WHERE job_id = '$job_id'";

$res_update = mysqli_query($connection, $sql_update) or die($connection->error);

}
  if ($res_update) {
    $result = 1;
  } else {
    $result = 0;
  }
} else {
  $result = 9;
}
mysqli_close($connection);
$arr['result'] = $result;
echo json_encode($arr);