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