Thu, 05 Mar 2020 21:19:14 +0100
Added private yeastlab pdf list
<?php require_once('config.php'); $query = "SELECT * FROM inventory_waters ORDER BY name"; $connect = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); if (! $connect) { echo "[]"; return; } $result = mysqli_query($connect, $query); while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { $waters[] = array( 'record' => $row['record'], 'name' => $row['name'], 'unlimited_stock' => $row['unlimited_stock'], 'calcium' => $row['calcium'], 'sulfate' => $row['sulfate'], 'chloride' => $row['chloride'], 'sodium' => $row['sodium'], 'magnesium' => $row['magnesium'], 'ph' => $row['ph'], 'total_alkalinity' => $row['total_alkalinity'], 'inventory' => $row['inventory'], 'cost' => $row['cost'] ); } header("Content-type: application/json"); echo json_encode($waters);