<?php 
$host = '159.203.121.73';
////////////////////////////////////
$user           = "root1";
$pass           = "tlKPkRzWKnhhGEWJJCdSwere";
$db_name        = "bilimbe_live";

$mysqli = new mysqli($host, $user, $pass, $db_name);

/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}
if(isset($_POST['action']) && isset($_POST['seat'])){	
	if($_POST['action']=='entry'){
		$sql = "SELECT * from qrcode where seat_no='".$_POST['seat']."' and status=0";
	} else {
		$sql = "SELECT * from qrcode where seat_no='".$_POST['seat']."' and dinner_status=0";
	}
	/* $result = $mysqli ->query($sql);
	if($result->num_rows >0){
		$sql_update = "UPDATE qrcode set ".(($_POST['action']=='entry')?' status=1':' dinner_status=1')." where seat_no='".$_POST['seat']."'";
		$mysqli ->query($sql_update);
		$row = $result -> fetch_array();
		$row['status'] = 'success';
		echo json_encode($row);
		//$success = 'Success';
		//echo json_encode($success);
	} else{
		$row = array();
		$row['status'] = 'failure';
		echo json_encode($row);
		//$failure = 'Failure';
		//echo json_encode($failure);
    } */
    echo $sql;
	
} else{
	$row = array();
	$row['result'] = 'No Qrcode found';
	echo json_encode($row);
}

$mysqli->close();

?>