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"));
Esempio n. 2
0
    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;