Sun, 14 Jul 2019 17:08:54 +0200
Fixed possible division/zero. Code compress and some cleanup.
<?php require_once('config.php'); $query = "SELECT * FROM inventory_miscs 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)) { $miscs[] = array( 'record' => $row['record'], 'name' => $row['name'], 'type' => $row['type'], 'use_use' => $row['use_use'], 'time' => $row['time'], 'amount_is_weight' => $row['amount_is_weight'], 'inventory' => $row['inventory'], 'cost' => $row['cost'] ); } header("Content-type: application/json"); echo json_encode($miscs);