//this is an api to show job leaderboard // +-----------------------------------+ // + STEP 1: include required files + // +-----------------------------------+ require_once "../php_include/db_connection.php"; require_once "DataClass.php"; $success = $msg = "0"; $data = array(); // +-----------------------------------+ // + STEP 2: get data + // +-----------------------------------+ $flag = $_REQUEST['flag'] ? $_REQUEST['flag'] : 2; //flag values 1- prev week leader board and 2- current week leader board //fetching kids leader board details ordering by position(maximum completed jobs on top) $data = DataClass::get_leaderboard($flag) ? DataClass::get_leaderboard($flag) : []; if ($data) { $success = '1'; $msg = "Kids Jobs Leaderboard Details"; } else { $success = '0'; $msg = "No data found"; } // +-----------------------------------+ // + 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_saved_jobs($uid) ? DataClass::get_saved_jobs($uid) : []; if ($data) { $success = '1'; $msg = "User Saved 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));
$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)); }
$sth->execute(); } catch (Exception $e) { } $result = $sth->fetchAll(); if (count($result)) { $sql = "update friends set status=1 where kid_id2=:kid and buddy_key=:code"; $sth = $conn->prepare($sql); $sth->bindValue("kid", $kid); $sth->bindValue("code", $code); try { $sth->execute(); $success = '1'; $msg = "Status Updated"; } catch (Exception $e) { } $data = DataClass::get_buddy_details($kid, $code) ? DataClass::get_buddy_details($kid, $code) : []; } else { $success = '0'; $msg = "No Result Found"; } } else { $success = '0'; $msg = "Invalid User"; } } // +-----------------------------------+ // + STEP 4: send json data + // +-----------------------------------+ if ($success == '1') { echo json_encode(array("success" => $success, "msg" => $msg, "data" => $data)); } else {
// + STEP 2: get data + // +-----------------------------------+ global $conn; $day = date('w'); $week_start = date('Y-m-d', strtotime('-' . $day . ' days +8 days')); $week_end = date('Y-m-d', strtotime('+' . (13 - $day) . ' days')); for ($date = strtotime($week_start); $date <= strtotime($week_end); $date = strtotime("+1 day", $date)) { echo date('Y-m-d', $date) . " "; echo date("l", $date) . " "; } 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 {
$sth->bindValue("my_id", $myid); try { $sth->execute(); } catch (Exception $e) { } } else { $sql = "update connect set status=1 where user_id2=:uid and user_id1=:my_id"; $sth = $conn->prepare($sql); $sth->bindValue("uid", $uid); $sth->bindValue("my_id", $myid); try { $sth->execute(); } catch (Exception $e) { } } $data = DataClass::get_details($uid, $code); if ($data) { $success = '1'; $msg = "Result Found"; } else { $success = '0'; $msg = "No Result Found"; } } else { $success = '0'; $msg = "No Result Found"; } } else { $success = '0'; $msg = "Invalid User"; }
/** * Remove this item by deleting it * * @param DataClass $item * @todo Allow for amendment of this behaviour - for example, we can remove an item from * an "ActiveItems" DataList by chaning the status to inactive. */ public function remove($item) { // By default, we remove an item from a DataList by deleting it. if ($item instanceof $this->dataClass) { $item->delete(); } }
// +-----------------------------------+ // + STEP 1: include required files + // +-----------------------------------+ require_once("../php_include/db_connection.php"); require_once("DataClass.php"); $success=$msg="0";$data=array(); // +-----------------------------------+ // + STEP 2: get data + // +-----------------------------------+ global $conn; $data = DataClass::get_rewards()? DataClass::get_rewards():[]; if($data){ $success='1'; $msg="Rewards Details"; } else{ $success='0'; $msg="No data found"; } // +-----------------------------------+ // + STEP 4: send json data + // +-----------------------------------+ if($success=="1"){
// + STEP 1: include required files + // +-----------------------------------+ require_once "../php_include/db_connection.php"; require_once "DataClass.php"; $success = $msg = "0"; $data = array(); // +-----------------------------------+ // + STEP 2: get data + // +-----------------------------------+ $flag = $_REQUEST['flag'] ? $_REQUEST['flag'] : 2; $job_parameter = $_REQUEST['job_parameter'] ? $_REQUEST['job_parameter'] : 1; $country = $_REQUEST['country'] ? $_REQUEST['country'] : ""; ////flag values 1-prev week 2- current week 3- next week 4-this month 5- this year 6-all time //job_parameter 1-completed jobs 2-approved jobs 3-bonus approved jobs 4-badges won //fetching kids leader board details ordering by position(maximum completed jobs on top) $data = DataClass::get_leaderboard($flag, $job_parameter, $country) ? DataClass::get_leaderboard($flag, $job_parameter, $country) : []; if ($data) { $success = '1'; $msg = "Kids Jobs Leaderboard Details"; } else { $success = '0'; $msg = "No data found"; } // +-----------------------------------+ // + 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)); }
$success = "0"; $msg = "Incomplete Parameters"; $data = array(); } else { $sql = "select * from users where verification_code=:token and is_deleted=0"; $sth = $conn->prepare($sql); $sth->bindValue('token', $token); try { $sth->execute(); } catch (Exception $e) { echo $e->getMessage(); } $res = $sth->fetchAll(); $uid = $res[0]['id']; if (count($res)) { $tnt = DataClass::get_friends($contacts, $uid); $data['profile'] = $tnt ? $tnt : []; if ($data) { $success = 1; $msg = "Profile Active"; } else { $success = 0; $msg = "No Records Found"; } } else { $success = 0; $msg = "Invalid User"; } } // +-----------------------------------+ // + STEP 4: send json data +
require_once "DataClass.php"; $success = $msg = "0"; $data = array(); // +-----------------------------------+ // + STEP 2: get data + // +-----------------------------------+ $uid = $_REQUEST['user_id']; $flag = $_REQUEST['flag'] ? $_REQUEST['flag'] : 2; //1-prev 2- current 3- next global $conn; if (!$uid) { $success = "0"; $msg = "Incomplete Parameters"; $data = array(); } else { $data = DataClass::get_day_jobs($uid, $flag) ? DataClass::get_day_jobs($uid, $flag) : []; 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));
$success=$msg="0";$data=array(); // +-----------------------------------+ // + STEP 2: get data + // +-----------------------------------+ $email=$_REQUEST['email']; $password=$_REQUEST['password']; $apn_id=$_REQUEST['apn_id']?$_REQUEST['apn_id']:""; if(!($email && $password && $email!='null')){ $success="0"; $msg="Incomplete Parameters"; $data=array(); } else{ $data = DataClass::get_profile($email,$password)? DataClass::get_profile($email,$password):[]; if($data){ $success='1'; $msg="Login Successful"; /*if($apn_id) $sql="update users set apn_id=:apn_id where email=:email"; $sth=$conn->prepare($sql); $sth->bindValue('email',$email); if($apn_id) $sth->bindValue('apn_id',$apn_id); try{$sth->execute();} catch(Exception $e){} */ } else{ $success='0'; $msg="Invalid Email or Password";
$result=$sth->fetchAll(); if(count($result)){ $success='1'; $msg="Connection Removed"; $rnd_code= DataClass::generateRandomString(12); $sql="DELETE from connect where user_id2 IN (:uid2,:uid) and user_id1 IN (:uid,:uid2) and kid_id=:kid_id"; $sth=$conn->prepare($sql); $sth->bindValue("uid",$uid); $sth->bindValue("uid2",$uid2); $sth->bindValue('kid_id',$kid); try{$sth->execute();} catch(Exception $e){} $data= DataClass::get_connect_data($uid)? DataClass::get_connect_data($uid):[]; /*$sql="update grownup_alias set access=0 where user_id=:uid and kid_id IN (select connect.kid_id from connect where user_id2=:uid2 and user_id1=:uid UNION select connect.kid_id from connect where user_id2=:uid and user_id1=:uid2)"; $sth=$conn->prepare($sql); $sth->bindValue("uid",$uid); $sth->bindValue("uid2",$uid2); try{$sth->execute();} catch(Exception $e){}*/ //$data=DataClass::get_details($uid,$code); /*if($data){ $success='1'; $msg="Result Found"; } else{ $success='0';
$kid_id = $_REQUEST['kid_id']; if (!$kid_id) { $success = "0"; $msg = "Incomplete Parameters"; $data = array(); } else { $sql = "select * from kids where id=:id"; $sth = $conn->prepare($sql); $sth->bindValue('id', $kid_id); try { $sth->execute(); } catch (Exception $e) { } $res = $sth->fetchAll(); if (count($res)) { $data = DataClass::get_connected_friends($user_id) ? DataClass::get_connected_friends($user_id) : []; if ($data) { $success = '1'; $msg = 'Records Found'; } else { $success = '0'; $msg = "No Records Found"; } } else { $success = '0'; $msg = "Invalid User"; } } // +-----------------------------------+ // + STEP 4: send json data + // +-----------------------------------+
// +-----------------------------------+ require_once "../php_include/db_connection.php"; require_once "DataClass.php"; $success = $msg = "0"; $data = array(); // +-----------------------------------+ // + STEP 2: get data + // +-----------------------------------+ $kid = $_REQUEST['kid_id']; global $conn; if (!$kid) { $success = "0"; $msg = "Incomplete Parameters"; $data = array(); } else { $data = DataClass::getBadge($kid) ? DataClass::getBadge($kid) : []; if ($data) { $success = '1'; $msg = "Kid Badge Details"; } else { $success = '0'; $msg = "No data found for this kid"; } } // +-----------------------------------+ // + 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 "DataClass.php"; $success = $msg = "0"; $data = array(); // +-----------------------------------+ // + STEP 2: get data + // +-----------------------------------+ $kid_id = $_REQUEST['kid_id']; $flag = $_REQUEST['flag'] ? $_REQUEST['flag'] : 2; //1-prev 2- current 3- next global $conn; if (!$kid_id) { $success = "0"; $msg = "Incomplete Parameters"; $data = array(); } else { $data = DataClass::get_kids_week_jobs($kid_id, $flag) ? DataClass::get_kids_week_jobs($kid_id, $flag) : []; if ($data) { $success = '1'; $msg = "Kids Job Details"; } else { $success = '0'; $msg = "No data found for this kid"; } } // +-----------------------------------+ // + 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 { //$bonus_count= DataClass::get_bonus_job_count($uid)? DataClass::get_bonus_job_count($uid):0; $data = DataClass::get_dashboard_data($uid) ? DataClass::get_dashboard_data($uid) : []; if ($data) { $success = '1'; $msg = "User Dashboard 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));
foreach ($tnt1 as $r) { foreach ($contacts as $row) { $a = substr_compare($r['phone_number'], $row, -10, 10); if ($a == 0) { $dict[] = $row; } } } //matched contacts b/w device and database if ($dict) { foreach ($dict as $key => $val) { $m = $val; $post_nums .= $m . ','; } $num = rtrim($post_nums, ', '); $tnt = DataClass::get_friends_photos($num, $uid, $zone, $user_date, $date); $data = $tnt ? $tnt : []; if ($data) { $success = 1; $msg = "Profile Active"; } else { $success = 0; $msg = "No Records Found"; } } else { $success = 0; $msg = "No Records Found"; } } else { $success = 0; $msg = "Invalid User";
require_once "../php_include/db_connection.php"; require_once "DataClass.php"; $success = $msg = "0"; $data = array(); // +-----------------------------------+ // + STEP 2: get data + // +-----------------------------------+ $kid_id = $_REQUEST['kid_id']; $flag = $_REQUEST['flag'] ? $_REQUEST['flag'] : 2; global $conn; if (!$kid_id) { $success = "0"; $msg = "Incomplete Parameters"; $data = array(); } else { $counts = DataClass::get_bonus_counts($kid_id, $flag) ? DataClass::get_bonus_counts($kid_id, $flag) : []; if ($counts) { $success = '1'; $msg = "Kids Job Details"; } else { $success = '0'; $msg = "No data found for this kid"; } } // +-----------------------------------+ // + STEP 4: send json data + // +-----------------------------------+ if ($success == "1") { echo json_encode(array("success" => $success, "msg" => $msg, "extra_counts" => $counts)); } else { echo json_encode(array("success" => $success, "msg" => $msg));
$sth->bindValue('kid_id', $kid); $sth->bindValue('kid2', $value['kid_id']); $c = 0; try { $c = $sth->execute(); } catch (Exception $e) { } } else { $success = '0'; $msg = 'Already sent'; } } if ($c) { $success = '1'; $msg = 'Buddy Code sent.'; $msg1 = "Buddy Code for Jobstars"; DataClass::sendEmail($email, $msg1, $code, SMTP_EMAIL); } } else { $success = '0'; $msg = "Invalid email or no kid is linked with it"; } } // +-----------------------------------+ // + 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));
// + STEP 2: get data + // +-----------------------------------+ $uid=$_REQUEST['user_id']; if(!($uid)){ $success="0"; $msg="Incomplete Parameters"; $data=array(); } else{ $path=BASE_PATH."uploads/"; $kid=DataClass::getKidsList($uid); foreach($kid as $row){ $num.=$row.','; } $kid_ids=rtrim($num,','); $sql="SELECT kids_wishlist.kid_id,reward.id as reward_id,reward.category_id,reward.title,reward.description,reward.price,reward.status,category.name as category_name, category.filepath as category_image, (SELECT group_concat(concat('$path',rewardimages.image) SEPARATOR ',') FROM rewardimages WHERE rewardimages.reward_id=reward.id ORDER BY defaultImage DESC) as reward_image, (SELECT group_concat(tags.name SEPARATOR ',') FROM tags WHERE tags.reward_id=reward.id) as tag_name FROM kids_wishlist join `reward` on reward.id=kids_wishlist.reward_id join category on category.id=reward.category_id where kid_id IN ($kid_ids)"; $sth=$conn->prepare($sql); //$sth->bindValue('kid_id',$kid);
$success = "0"; $msg = "Incomplete Parameters"; } else { $sql = "select * from users where phone_number=:phone_number and is_deleted=0"; $sth = $conn->prepare($sql); $sth->bindValue("phone_number", $phone); try { $sth->execute(); } catch (Exception $e) { //echo $e->getMessage(); } $res = $sth->fetchAll(); if (count($res)) { $token = $res[0]['verification_code']; $success = "1"; $msg = "An reset link sent to you"; $path = UPLOAD_PATH . 'reset-password.php?token=' . $token; $body = "Reset your Password using {$path}"; try { DataClass::sendSMS($phone, $body); } catch (Exception $e) { } } else { $success = "0"; $msg = "The phone number seems invalid"; } } // +-----------------------------------+ // + STEP 4: send json data + // +-----------------------------------+ echo json_encode(array("success" => $success, "msg" => $msg, 'path' => $path));
$count = $sth->execute(); $uid = $conn->lastInsertId(); $success = 1; $msg = "User Successfully registered"; } catch (Exception $e) { } /*if($image){ $sql="INSERT INTO `codebrew_gander`.`photos` (`id`, `user_id`, `image`, `date`, `auto_approved`, `created_on`) VALUES (DEFAULT, :user_id, :image,NOW(), 0, NOW())"; $sth=$conn->prepare($sql); $sth->bindValue("user_id",$uid); $sth->bindValue("image",$image_path); try{$sth->execute();} catch(Exception $e){} }*/ $tnt = DataClass::get_profile($phone); $data['profile'] = $tnt ? $tnt : []; /*if($count){ try{ DataClass::sendSMS($phone,$body); } catch(Exception $e){} }*/ } } // +-----------------------------------+ // + STEP 4: send json data + // +-----------------------------------+ if ($success == 1) { echo json_encode(array("success" => $success, "msg" => $msg, "verification_code" => $v_code, "status" => $phn_status, "data" => $data)); } else {
else $msg="You failed to achieve this raffle. Try Again next week"; } else{ $sql="INSERT INTO kid_raffles VALUES(DEFAULT,:raffle_id,:kid_id,:kid_answer,:status,NOW())"; $sth=$conn->prepare($sql); $sth->bindValue('kid_id',$kid); $sth->bindValue('raffle_id',$raffle_id); $sth->bindValue('kid_answer',$answer); $sth->bindValue('status',$status); try{$sth->execute(); $success='1'; $msg='Raffle Answered'; if($status) DataClass::AddBadge($kid,'raffle'); } catch(Exception $e){} } } // +-----------------------------------+ // + STEP 4: send json data + // +-----------------------------------+ /*if($success=='1'){ echo json_encode(array("success"=>$success,"msg"=>$msg,"data"=>$data));
$type = 2; if (!empty($apnid)) { try { $apns->newMessage($apnid); $apns->addMessageAlert($msg); $apns->addMessageSound('x.wav'); $apns->addMessageCustom('u', $uid); $apns->addMessageCustom('k', $kid_id); $apns->addMessageCustom('t', $type); $apns->queueMessage(); $apns->processQueue(); } catch (Exception $e) { } } if ($week_parameter == 1) { $data = DataClass::get_week_jobs($uid, 2) ? DataClass::get_week_jobs($uid, 2) : []; } else { $data = DataClass::get_day_jobs($uid, 2) ? DataClass::get_day_jobs($uid, 2) : []; } } 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)); }
//0-none, 1-monthly,2-yearly $kid = $_REQUEST['kid_id']; $uid = $_REQUEST['user_id']; if (!($kid && $uid)) { $success = "0"; $msg = "Incomplete Parameters"; $data = array(); } else { $sql = "delete from `kids` where id=:id"; $sth = $conn->prepare($sql); $sth->bindValue('id', $kid); try { $sth->execute(); $success = '1'; $msg = 'Kid Deleted'; $data = DataClass::get_all_kids_user($uid) ? DataClass::get_all_kids_user($uid) : []; } catch (Exception $e) { } $sql = "delete from `jobs` where kid_id=:kid"; $sth = $conn->prepare($sql); $sth->bindValue('kid', $kid); try { $sth->execute(); } catch (Exception $e) { } $sql = "delete from `job_status` where kid_id=:kid"; $sth = $conn->prepare($sql); $sth->bindValue('kid', $kid); try { $sth->execute(); } catch (Exception $e) {
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));
$kid_id = $_REQUEST['kid_id']; if (!$kid_id) { $success = "0"; $msg = "Incomplete Parameters"; $data = array(); } else { $sql = "select * from kids where id=:id"; $sth = $conn->prepare($sql); $sth->bindValue('id', $kid_id); try { $sth->execute(); } catch (Exception $e) { } $res = $sth->fetchAll(); if (count($res)) { $data = DataClass::get_buddy_list($kid_id) ? DataClass::get_buddy_list($kid_id) : []; if ($data) { $success = '1'; $msg = 'Records Found'; } else { $success = '0'; $msg = "No Records Found"; } } else { $success = '0'; $msg = "Invalid Kid"; } } // +-----------------------------------+ // + STEP 4: send json data + // +-----------------------------------+
$sth->bindValue('user_id', $uid); try { $sth->execute(); } catch (Exception $e) { } $res = $sth->fetchAll(); if (count($res)) { $success = '1'; $msg = "Already Liked"; } else { $sql = "INSERT into likes values(DEFAULT,:job_id,:user_id,1,'like',0,NOW())"; $sth = $conn->prepare($sql); $sth->bindValue('user_id', $uid); $sth->bindValue('job_id', $job_id); try { $sth->execute(); $success = '1'; $msg = 'Liked Job'; $data = DataClass::get_likes_by_jobid($job_id); } 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)); }
$user_id = $_REQUEST['user_id']; if (!$user_id) { $success = "0"; $msg = "Incomplete Parameters"; $data = array(); } else { $sql = "select * from users where id=:id and is_deleted=0"; $sth = $conn->prepare($sql); $sth->bindValue('id', $user_id); try { $sth->execute(); } catch (Exception $e) { } $res = $sth->fetchAll(); if (count($res)) { $data = DataClass::get_buddy_list($user_id) ? DataClass::get_buddy_list($user_id) : []; if ($data) { $success = '1'; $msg = 'Records Found'; } else { $success = '0'; $msg = "No Records Found"; } } else { $success = '0'; $msg = "Invalid User"; } } // +-----------------------------------+ // + STEP 4: send json data + // +-----------------------------------+