comparison: www/getwatersources.php
www/getwatersources.php
- changeset 54
- 294dda7f1779
- child 99
- f433193f7bb6
equal
deleted
inserted
replaced
| 53:a17c644a0510 | 54:294dda7f1779 |
|---|---|
| 1 <?php | |
| 2 require_once('config.php'); | |
| 3 | |
| 4 $query = "SELECT * FROM inventory_waters ORDER BY name"; | |
| 5 $connect = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); | |
| 6 if (! $connect) { | |
| 7 echo "[]"; | |
| 8 return; | |
| 9 } | |
| 10 $result = mysqli_query($connect, $query); | |
| 11 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { | |
| 12 $waters[] = array( | |
| 13 'record' => $row['record'], | |
| 14 'name' => $row['name'], | |
| 15 'unlimited_stock' => $row['unlimited_stock'], | |
| 16 'calcium' => $row['calcium'], | |
| 17 'sulfate' => $row['sulfate'], | |
| 18 'chloride' => $row['chloride'], | |
| 19 'sodium' => $row['sodium'], | |
| 20 'magnesium' => $row['magnesium'], | |
| 21 'ph' => $row['ph'], | |
| 22 'total_alkalinity' => $row['total_alkalinity'], | |
| 23 'default_water' => $row['default_water'], | |
| 24 'cost' => $row['cost'] | |
| 25 ); | |
| 26 } | |
| 27 echo json_encode($waters); |
