www/getmiscsources.php

changeset 60
dbbe408108ea
child 296
69fadd1aded2
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/www/getmiscsources.php	Sat Sep 22 15:02:43 2018 +0200
@@ -0,0 +1,23 @@
+<?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']
+	);
+}
+echo json_encode($miscs);

mercurial