www/getfermentablesources.php

changeset 771
9856238e9217
parent 705
d77b723f7b35
equal deleted inserted replaced
770:dc37f2b0a00b 771:9856238e9217
1 <?php 1 <?php
2 require_once('config.php'); 2 require_once('config.php');
3 3
4 $query = "SELECT * FROM inventory_fermentables ORDER BY supplier,name"; 4 $query = "SELECT record,name,type,yield,color,add_after_boil,origin,supplier,coarse_fine_diff,moisture,diastatic_power,protein,dissolved_protein,max_in_batch,recommend_mash,graintype,di_ph,acid_to_ph_57,inventory,cost FROM inventory_fermentables ORDER BY supplier,name";
5 $connect = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); 5 $connect = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME);
6 if (! $connect) { 6 if (! $connect) {
7 echo "[]"; 7 echo "[]";
8 return; 8 return;
9 } 9 }
10 mysqli_set_charset($connect, "utf8"); 10 mysqli_set_charset($connect, "utf8");
11 $result = mysqli_query($connect, $query); 11 $result = mysqli_query($connect, $query);
12 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { 12 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
13 $fermentables[] = array( 13 $fermentables[] = $row;
14 'record' => $row['record'],
15 'name' => $row['name'],
16 'type' => $row['type'],
17 'yield' => $row['yield'],
18 'color' => $row['color'],
19 'add_after_boil' => $row['add_after_boil'],
20 'origin' => $row['origin'],
21 'supplier' => $row['supplier'],
22 'coarse_fine_diff' => $row['coarse_fine_diff'],
23 'moisture' => $row['moisture'],
24 'diastatic_power' => $row['diastatic_power'],
25 'protein' => $row['protein'],
26 'dissolved_protein' => $row['dissolved_protein'],
27 'max_in_batch' => $row['max_in_batch'],
28 'recommend_mash' => $row['recommend_mash'],
29 'graintype' => $row['graintype'],
30 'di_ph' => $row['di_ph'],
31 'acid_to_ph_57' => $row['acid_to_ph_57'],
32 'inventory' => $row['inventory'],
33 'cost' => $row['cost']
34 );
35 } 14 }
36 header("Content-type: application/json"); 15 header("Content-type: application/json");
37 echo json_encode($fermentables, JSON_UNESCAPED_UNICODE); 16 echo json_encode($fermentables, JSON_UNESCAPED_UNICODE);

mercurial