Tiny File Manager

Back Back Up Advanced Editor

// ne pas oublier
header('Content-type: application/json');

$(document).ready(function () {
		var source =
		{
			 datatype: "json",
			 datafields: [
				 { name: 'OrderDate', type: 'date'},
				 { name: 'Quantity'},
				 { name: 'ProductName'}
			],
			url: 'data.php'
		};

});
</script>

<?php
	
	include('connect.php');
	# Connect to the database
	$mysqli = new mysqli($hostname, $username, $password, $database);
	/* check connection */
	if (mysqli_connect_errno())
	{
		printf("Connect failed: %s\n", mysqli_connect_error());
		exit();
	}
	
	
	// get data and store in a json array
	$from = 0;
	$to = 30;
	$query = "SELECT OrderDate, ProductName, Quantity FROM  invoices ORDER BY OrderDate LIMIT ?, ?";
	$result = $mysqli->prepare($query);
	$result->bind_param('ii', $from, $to);
	$result->execute();
	/* bind result variables */
	$result->bind_result($OrderDate, $ProductName, $Quantity);
	/* fetch values */
	while ($result->fetch())
	{
	$orders[] = array(
		'OrderDate' => $OrderDate,
		'ProductName' => $ProductName,
		'Quantity' => $Quantity
	);
	}
	echo json_encode($orders);
	/* close statement */
	$result->close();
	/* close connection */
	$mysqli->close();

//https://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxchart/jquery-chart-data-source.htm
	
?>