<?php
$host = '127.0.0.1';
$db   = 'testdb';
$user = 'root';
$pass = '';
$charset = 'utf8mb4';

$dsn = "mysql:host=$host;dbname=$db;charset=$charset";
$opt = [
    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
    PDO::ATTR_EMULATE_PREPARES   => false,
];
$pdo = new PDO($dsn, $user, $pass, $opt);
?>







<?php
require("dbcon.php");
?>

<?php
if ($_REQUEST["auth"] && $_REQUEST["id"])
{
    echo "Received ". $_REQUEST["auth"]. " success!";

	$ID = $_REQUEST["id"];
	$Auth = $_REQUEST["auth"];

	$dbcon = new PDO("mysql:host=localhost;dbname=testdb;","root","");
	$sql = $dbcon->prepare("UPDATE test01 SET level = level + 1 WHERE ID = :ID AND Auth = :Auth");

	$sql->bindParam(":ID", $ID);
	$sql->bindParam(":Auth", $Auth);
	$sql->execute();
	exit();
}
else
{
    echo "Request failed.";
	exit();
}
?>