Mercurial > bms / file revision

<?php
require_once('config.php');

$query = "SELECT * FROM inventory_hops ORDER BY origin,name";
$connect = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME);
if (! $connect) {
	echo "[]";
	return;
}
mysqli_set_charset($connect, "utf8" );
$result = mysqli_query($connect, $query);
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
	$hops[] = array(
		'record' => $row['record'],
		'name' => $row['name'],
		'alpha' => $row['alpha'],
		'beta' => $row['beta'],
		'humulene' => $row['humulene'],
		'caryophyllene' => $row['caryophyllene'],
		'cohumulone' => $row['cohumulone'],
		'myrcene' => $row['myrcene'],
		'hsi' => $row['hsi'],
		'total_oil' => $row['total_oil'],
		'type' => $row['type'],
		'form' => $row['form'],
		'origin' => $row['origin'],
		'inventory' => $row['inventory'],
		'cost' => $row['cost']
	);
}
header("Content-type: application/json");
echo json_encode($hops);