$sth->bindValue('kid_id', $kid); $sth->bindValue('day', $day_name); try { $sth->execute(); } catch (Exception $e) { } $res = $sth->fetchAll(); $stat = $res[0]['is_completed']; $is_completed = $stat ? 0 : 1; //all jobs set as complete/incomplete by kid for that day(multiple jobs) $sql = "UPDATE `job_status` set is_completed=:status where kid_id=:kid_id and day=:day"; $sth = $conn->prepare($sql); $sth->bindValue('kid_id', $kid); $sth->bindValue('day', $day_name); $sth->bindValue('status', $is_completed); try { $sth->execute(); $success = '1'; $msg = 'Jobs Completed'; $data = DataClass::get_week_jobs($uid, $flag) ? DataClass::get_week_jobs($uid, $flag) : []; } catch (Exception $e) { } } // +-----------------------------------+ // + STEP 4: send json data + // +-----------------------------------+ if ($success == '1') { echo json_encode(array("success" => $success, "msg" => $msg, "data" => $data)); } else { echo json_encode(array("success" => $success, "msg" => $msg)); }
require_once "../php_include/db_connection.php"; require_once "DataClass.php"; $success = $msg = "0"; $data = array(); // +-----------------------------------+ // + STEP 2: get data + // +-----------------------------------+ $uid = $_REQUEST['user_id']; global $conn; if (!$uid) { $success = "0"; $msg = "Incomplete Parameters"; $data = array(); } else { //$data = DataClass::get_jobs_data($uid)? DataClass::get_jobs_data($uid):[]; $data = DataClass::get_week_jobs($uid, 6) ? DataClass::get_week_jobs($uid, 6) : []; if ($data) { $success = '1'; $msg = "User Job Details"; } else { $success = '0'; $msg = "No data found for this user"; } } // +-----------------------------------+ // + STEP 4: send json data + // +-----------------------------------+ if ($success == "1") { echo json_encode(array("success" => $success, "msg" => $msg, "data" => $data)); } else { echo json_encode(array("success" => $success, "msg" => $msg));