"$postjson[$i]", ]; $wrkarr = array_merge($wrkarr, $newarr); endif; endforeach; if (!isset($wrkarr["token"]) || trim($wrkarr["token"]) == ""): die('{ "status": "token was not provided.\ncould not add a click." }'); else: $query = $pdo->prepare("SELECT token, team, clicks FROM users WHERE token LIKE ?"); $query->execute([$wrkarr["token"]]); $found = $query->fetch(PDO::FETCH_ASSOC); if ($found): $newuserclicks = $found["clicks"] + 1; $query = $pdo->prepare("UPDATE users SET clicks = :clicks WHERE users.token = :token"); $query->execute([ "clicks" => "$newuserclicks", "token" => "$wrkarr[token]", ]); $query = $pdo->prepare("SELECT team, clicks FROM stats WHERE team LIKE ?"); $query->execute([$found["team"]]); $found = $query->fetch(PDO::FETCH_ASSOC); $newteamclicks = $found["clicks"] + 1; $query = $pdo->prepare("UPDATE stats SET clicks = :clicks WHERE stats.team = :team"); $query->execute([ "clicks" => "$newteamclicks", "team" => "$found[team]", ]); die("{ \"status\": \"success\", \"nuc\": \"$newuserclicks\", \"ntc\": \"$newteamclicks\" }"); else: die('{ "status": "user does not exist in the database." }'); endif; endif; echo '{ "status": "online" }'; ?>