Mercurial > bms / file revision

• file
• latest
• revisions
• annotate
• diff
• comparison
• raw

www/getmiscsources.php@793af7691a5e

www/getmiscsources.php

Sat, 15 Dec 2018 21:27:01 +0100

author

Michiel Broek <mbroek@mbse.eu>

date

Sat, 15 Dec 2018 21:27:01 +0100

changeset 142

793af7691a5e

parent 60

dbbe408108ea

child 296

69fadd1aded2

permissions

-rw-r--r--

During hops load an extra weight in grams field is generated for the grid. Edit the amount is done on the weight field and the amount field is updated too. During save to the database the extra field is removed.

<?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);