comparison: www/getwatersources.php
www/getwatersources.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_waters ORDER BY name"; | 4 $query = "SELECT record,name,unlimited_stock,calcium,sulfate,chloride,sodium,magnesium,ph,total_alkalinity,inventory,cost FROM inventory_waters ORDER BY 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 $waters[] = array( | 13 $waters[] = $row; |
| 14 'record' => $row['record'], | |
| 15 'name' => $row['name'], | |
| 16 'unlimited_stock' => $row['unlimited_stock'], | |
| 17 'calcium' => $row['calcium'], | |
| 18 'sulfate' => $row['sulfate'], | |
| 19 'chloride' => $row['chloride'], | |
| 20 'sodium' => $row['sodium'], | |
| 21 'magnesium' => $row['magnesium'], | |
| 22 'ph' => $row['ph'], | |
| 23 'total_alkalinity' => $row['total_alkalinity'], | |
| 24 'inventory' => $row['inventory'], | |
| 25 'cost' => $row['cost'] | |
| 26 ); | |
| 27 } | 14 } |
| 28 header("Content-type: application/json"); | 15 header("Content-type: application/json"); |
| 29 echo json_encode($waters); | 16 echo json_encode($waters); |
