<?php
	include 'cnxdata';
	
	$data = file_get_contents("php://input");
	$data = json_decode($data);
	$data = (array) $data; 
	
	$sucur=$data['Sucursal'];
	$ruta=$data['Ruta'];
	$hora=$data['Hora'];
	$fecha=$data['Fecha'];
	$lat=$data['Lat'];
	$long=$data['Lon'];
	$spd=$data['Spd'];
	$error=0;

	$dt = new DateTime();	
	$dt = $dt->format('Y-m-d H:i:s');
		
	try {
		$conn = new PDO("mysql:host=$servername;dbname=$DB", $username, $password);
		$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
		$conn->setAttribute(PDO::ATTR_TIMEOUT, 500);
    }
	
	catch(PDOException $e){
		echo "ConnectionError";
		$error=1;
	}
	
	$rows = array();
	
	if ($error == 0){	
				
	$sql =  "INSERT INTO `gps`(`Lat`,`Lon`,`Spd`,`Ruta`,`Hora`,`Fecha`,`Sucursal`) VALUES ('$lat','$long','$spd','$ruta','$hora','$fecha','$sucur')";

	if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
	} else {
    echo  $sql;
	}
	}
	
?>