Wed, 19 Aug 2020 17:13:24 +0200
Fixed st_category_namber to be an integer value instead of float. The calc_acid in a new recipe is integer. Added missing wg_ and wb_ fields in a new recipe.
<?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; } mysqli_set_charset($connect, "utf8"); $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);