<?php 
$host = 'localhost';
$user = 'u520518518_valoevent_demo';
$pass = 'Valoevent@dem0';
$db_name = "u520518518_valoevent_demo";

$mysqli = new mysqli($host, $user, $pass, $db_name);
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$link = mysqli_connect("localhost", "u520518518_valoevent_demo", "Valoevent@dem0", "u520518518_valoevent_demo");
$row = [];
    if($_POST['id']){
        $query = mysqli_query($link, "UPDATE qrcode set status = ".$_POST['updated_status']." WHERE id =" .$_POST['id']);
        /* Get the number of rows in the result set */
     
        if($query)
        {
            $row['status'] = 200;
            $row['result'] = "status updated";
        }    
    }
    else{
        $row['status'] = 101;
        $row['result'] = 'something went wrong';
    }
    
    echo json_encode($row);

$mysqli->close();
?>