Before this function worked.
What might have happened?
My site - https://paul-74128-14.000webhostapp.com/cabinet/tasks/
VIEW
<form class = "form-horizontal" name = "taskInfo" data-ng-submit = "saveTask ()">
<input type = "hidden" id = "taskId" data-ng-model = "taskId">
<legend> Editing a task </ legend>
<div class = "form-group">
<label for = "category" class = "col-sm-3"> Question text </ label>
<div class = "col-sm-9">
<input type = "text" data-ng-model = "text_answer" id = "text_answer" class = "form-
control">
</ div>
</ div>
<div class = "form-group">
<label for = "category" class = "col-sm-3"> Variant of answer 1 </ label>
<div class = "col-sm-9">
<input type = "text" data-ng-model = "variant_a" id = "variant_a" class = "form-control">
</ div>
</ div>
<div class = "form-group">
<label for = "content" class = "col-sm-3"> Option 2 </ label>
<div class = "col-sm-9">
<input type = "text" data-ng-model = "variant_b" id = "variant_b" class = "form-control">
</ div>
</ div>
<div class = "form-group">
Variant 3 </ label> <label>
<div class = "col-sm-9">
<input type = "text" data-ng-model = "variant_c" id = "variant_c" class = "form-control">
</ div>
</ div>
<div class = "form-group">
<label for = "content" class = "col-sm-3"> Variant 4 </ label>
<div class = "col-sm-9">
<input type = "text" data-ng-model = "variant_d" id = "variant_d" class = "form-control">
</ div>
</ div>
<div class = "form-group">
Correct answer </ label> <label for = "content" class = "col-sm-3"
<div class = "col-sm-9">
<input type = "text" data-ng-model = "correct_id" id = "correct_id" class = "form-
control">
</ div>
</ div>
<div class = "form-group">
<div class = "col-sm-offset-3 col-sm-9">
<button class = "btn btn-default"> Save </ button>
<button class = "btn btn-danger" type = "button" data-ng-click = "deleteTask (taskId)">
Delete </ button>
</ div>
</ div>
</ form>
MODEL
public function saveTaskInfo($id, $text_answer, $variant_a, $variant_b, $variant_c, $variant_d,
$correct_id) {
$sql = "UPDATE tasks
SET text_answer = :text_answer,
variant_a = :variant_a,
variant_b = :variant_b,
variant_c = :variant_c,
variant_d = :variant_d,
correct_id =:correct_id
WHERE id = :id
";
$stmt = $this->db->prepare($sql);
$stmt->bindValue(":text_answer", $text_answer, PDO::PARAM_STR);
$stmt->bindValue(":variant_a", $variant_a, PDO::PARAM_STR);
$stmt->bindValue(":variant_b", $variant_b, PDO::PARAM_STR);
$stmt->bindValue(":variant_c", $variant_c, PDO::PARAM_STR);
$stmt->bindValue(":variant_d", $variant_d, PDO::PARAM_STR);
$stmt->bindValue(":correct_id", $correct_id, PDO::PARAM_INT);
$stmt->bindValue(":id", $id, PDO::PARAM_INT);
$stmt->execute();
return true;
}
CONTROLLER
public function saveTask(){
if(!$_SESSION['user']){
header("Location: /");
return;
}
if (!isset($_POST['id']) || trim($_POST['text_answer'])=='' || trim($_POST['variant_a'])=='' ||
trim($_POST['variant_b'])=='' || trim($_POST['variant_c'])=='' ||
trim($_POST['variant_d'])==''|| !isset($_POST['correct_id']) ){
echo json_encode(array("success" =>false));
} else{
$taskId = $_POST['id'];
$text_answer = trim($_POST['text_answer']);
$variant_a = trim($_POST['variant_a']);
$variant_b = trim($_POST['variant_b']);
$variant_c = trim($_POST['variant_c']);
$variant_d = trim($_POST['variant_d']);
$correct_id = $_POST['correct_id'];
}
if($this -> model -> saveTaskInfo($taskId, $text_answer, $variant_a, $variant_b, $variant_c,
$variant_d, $correct_id)){
echo json_encode(array("success" =>true));
}else{
echo json_encode(array("success" =>false));
}
}