break; case 'tipDownvote': tipDownvote(); break; case 'getCounters': $outp = getCounters(); echo $outp; break; case 'upvote': upvote(); break; case 'downvote': downvote(); break; case 'getTips': echo getTips(); break; } function tipUpvote() { global $dbh; $data = json_decode(file_get_contents("php://input")); $tip_id = $data->tip_id; $sql = "UPDATE general_tips SET vote = vote + 1 where id = {$tip_id}"; $stmt = $dbh->prepare($sql); $stmt->execute(); } function tipDownvote() { global $dbh; $data = json_decode(file_get_contents("php://input"));
case 'getInfo': $champion_weak = $_GET['weak']; $champion_strong = $_GET['strong']; $sql = "SELECT id, name, eng_name FROM champion_list where eng_name = '{$champion_weak}'"; $stmt = $dbh->prepare($sql); $stmt->execute(); $rweak = $stmt->fetch(PDO::FETCH_ASSOC); $sql = "SELECT id, name, eng_name FROM champion_list where eng_name = '{$champion_strong}'"; $stmt = $dbh->prepare($sql); $stmt->execute(); $rstrong = $stmt->fetch(PDO::FETCH_ASSOC); $outp = '{"weak":' . json_encode($rweak) . ',"strong":' . json_encode($rstrong) . '}'; echo $outp; break; case 'getTips': $outp = getTips(); echo $outp; break; case 'upvote': upvote(); break; case 'downvote': downvote(); break; case 'submitTips': submitTip(); break; } function getTips() { global $dbh;