www/gethopsources.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_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);

mercurial