<?php
	include 'dbconnect.php';

	$query = 'CALL prcGetRoutes();';

	$json = '{ "routes": [';

	// execute query
	if ($mysqli->multi_query($query)) {

	    do {  // build our json array
	        if ($result = $mysqli->store_result()) {
	            while ($row = $result->fetch_row()) {
	                $json .= $row[0];
					$json .= ',';
	            }
	            $result->close();
	        }
	    } while ($mysqli->next_result());
	}
	else {
		die('error: '  . $mysqli->error);
	}
	
	$json = rtrim($json, ",");
	$json .= '] }';

	header('Content-Type: application/json');
	echo $json;

	$mysqli->close();
?>