1 <?php |
1 <?php |
2 require_once('config.php'); |
2 require_once('config.php'); |
3 |
3 |
4 $query = "SELECT * FROM inventory_hops ORDER BY origin,name"; |
4 $query = "SELECT record,name,alpha,beta,humulene,caryophyllene,cohumulone,myrcene,hsi,total_oil,type,form,origin,inventory,cost FROM inventory_hops ORDER BY origin,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 $hops[] = array( |
13 $hops[] = $row; |
14 'record' => $row['record'], |
|
15 'name' => $row['name'], |
|
16 'alpha' => $row['alpha'], |
|
17 'beta' => $row['beta'], |
|
18 'humulene' => $row['humulene'], |
|
19 'caryophyllene' => $row['caryophyllene'], |
|
20 'cohumulone' => $row['cohumulone'], |
|
21 'myrcene' => $row['myrcene'], |
|
22 'hsi' => $row['hsi'], |
|
23 'total_oil' => $row['total_oil'], |
|
24 'type' => $row['type'], |
|
25 'form' => $row['form'], |
|
26 'origin' => $row['origin'], |
|
27 'inventory' => $row['inventory'], |
|
28 'cost' => $row['cost'] |
|
29 ); |
|
30 } |
14 } |
31 header("Content-type: application/json"); |
15 header("Content-type: application/json"); |
32 echo json_encode($hops); |
16 echo json_encode($hops); |