PHP DataClass::get_likes_by_jobid示例

示例#1

文件： like_job.php 项目： Gameonn/JS_API

    $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));
}