Mercurial > bms / file revision

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

www/getmiscsources.php@83cee005d2d9

www/getmiscsources.php

Sun, 27 Jan 2019 17:39:26 +0100

author

Michiel Broek <mbroek@mbse.eu>

date

Sun, 27 Jan 2019 17:39:26 +0100

changeset 215

83cee005d2d9

parent 60

dbbe408108ea

child 296

69fadd1aded2

permissions

-rw-r--r--

Fixed the utf-8 problems when storing json arrays on the server by using manual encoding. The json-encode function sucks for this project. Added step detail edit screen instead of on grid cell editing. This must go into the product and recipe editors too.

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