<?php


    // header('Content-Type: bitmap; charset=utf-8');
	header('Content-type: application/json; charset=utf-8');
 
    require_once __DIR__ . '/../db_config.php';

   $post = json_decode(file_get_contents("php://input"), true);

   $driver_serial_no = $post['driver_serial_no'];
//   $status = $post['status'];

	
    //$query = "SELECT * FROM `users` WHERE phone_no = '+821042898587'";
    //$query = "SELECT * FROM `SCP_Ready_Room` WHERE status = '$status' AND driver_serial_no = '$driver_serial_no'";
    $query = "SELECT * FROM `SCP_Waiting_Room` WHERE driver_serial_no = '$driver_serial_no'";
   
    $result = mysql_query($query) or die(mysql_error());
    $row = mysql_fetch_row($result);
    $row_count = mysql_affected_rows();

	if ($row_count>0) {
    	$response["select_status"] = "select confirmed";	
		$columns = mysql_num_fields($result);    
		$fields = array();    
		
		for($i = 0; $i < $columns; $i++) {     
			$field = mysql_field_name($result,$i);
			$response[$field] = $row[$i];
		}
	} else {
	  $response["select_status"] = "select failed";	
	}
	
	echo json_encode($response);	
	

?>