comparison: www/prod_beerxml.php
www/prod_beerxml.php
- changeset 606
- 39d4b9e7b447
- parent 605
- 538627a5555c
- child 667
- 1246550451ca
equal
deleted
inserted
replaced
| 605:538627a5555c | 606:39d4b9e7b447 |
|---|---|
| 16 | 16 |
| 17 //setlocale ( LC_ALL, 'nl_NL.UTF-8'); | 17 //setlocale ( LC_ALL, 'nl_NL.UTF-8'); |
| 18 if (isset($_GET["record"])) | 18 if (isset($_GET["record"])) |
| 19 $record = $_GET["record"]; | 19 $record = $_GET["record"]; |
| 20 else | 20 else |
| 21 $record = 78; | 21 $record = 71; |
| 22 $result = mysqli_query($link, "SELECT * FROM products WHERE record='".$record."'"); | 22 $result = mysqli_query($link, "SELECT * FROM products WHERE record='".$record."'"); |
| 23 $row = mysqli_fetch_array($result); | 23 $row = mysqli_fetch_array($result); |
| 24 | 24 |
| 25 $recipetype = array( 'Extract', 'Partial Mash', 'All Grain' ); | 25 $recipetype = array( 'Extract', 'Partial Mash', 'All Grain' ); |
| 26 $styletype = array( 'Lager', 'Ale', 'Mead', 'Wheat', 'Mixed', 'Cider' ); | 26 $styletype = array( 'Lager', 'Ale', 'Mead', 'Wheat', 'Mixed', 'Cider' ); |
| 249 xmlwriter_end_element($xw); // YEASTS | 249 xmlwriter_end_element($xw); // YEASTS |
| 250 | 250 |
| 251 xmlwriter_start_element($xw, 'WATERS'); | 251 xmlwriter_start_element($xw, 'WATERS'); |
| 252 xmlwriter_start_element($xw, 'WATER'); // Source 1 | 252 xmlwriter_start_element($xw, 'WATER'); // Source 1 |
| 253 field($xw, 'VERSION', '1'); | 253 field($xw, 'VERSION', '1'); |
| 254 field($xw, 'NAME', $item['w1_name']); | 254 field($xw, 'NAME', $row['w1_name']); |
| 255 field($xw, 'AMOUNT', sprintf("%.2f",floatval($row['w1_amount']))); | 255 field($xw, 'AMOUNT', sprintf("%.2f",floatval($row['w1_amount']))); |
| 256 field($xw, 'CALCIUM', sprintf("%.2f",floatval($row['w1_calcium']))); | 256 field($xw, 'CALCIUM', sprintf("%.2f",floatval($row['w1_calcium']))); |
| 257 field($xw, 'MAGNESIUM', sprintf("%.2f",floatval($row['w1_magnesium']))); | 257 field($xw, 'MAGNESIUM', sprintf("%.2f",floatval($row['w1_magnesium']))); |
| 258 field($xw, 'BICARBONATE', sprintf("%.2f",floatval($row['w1_total_alkalinity']) * 1.22)); | 258 field($xw, 'BICARBONATE', sprintf("%.2f",floatval($row['w1_total_alkalinity']) * 1.22)); |
| 259 field($xw, 'SULFATE', sprintf("%.2f",floatval($row['w1_sulfate']))); | 259 field($xw, 'SULFATE', sprintf("%.2f",floatval($row['w1_sulfate']))); |
| 264 xmlwriter_end_element($xw); // WATER | 264 xmlwriter_end_element($xw); // WATER |
| 265 | 265 |
| 266 if (strlen($row['w2_name'])) { | 266 if (strlen($row['w2_name'])) { |
| 267 xmlwriter_start_element($xw, 'WATER'); // Source 2 | 267 xmlwriter_start_element($xw, 'WATER'); // Source 2 |
| 268 field($xw, 'VERSION', '1'); | 268 field($xw, 'VERSION', '1'); |
| 269 field($xw, 'NAME', $item['w2_name']); | 269 field($xw, 'NAME', $row['w2_name']); |
| 270 field($xw, 'AMOUNT', sprintf("%.2f",floatval($row['w2_amount']))); | 270 field($xw, 'AMOUNT', sprintf("%.2f",floatval($row['w2_amount']))); |
| 271 field($xw, 'CALCIUM', sprintf("%.2f",floatval($row['w2_calcium']))); | 271 field($xw, 'CALCIUM', sprintf("%.2f",floatval($row['w2_calcium']))); |
| 272 field($xw, 'MAGNESIUM', sprintf("%.2f",floatval($row['w2_magnesium']))); | 272 field($xw, 'MAGNESIUM', sprintf("%.2f",floatval($row['w2_magnesium']))); |
| 273 field($xw, 'BICARBONATE', sprintf("%.2f",floatval($row['w2_total_alkalinity']) * 1.22)); | 273 field($xw, 'BICARBONATE', sprintf("%.2f",floatval($row['w2_total_alkalinity']) * 1.22)); |
| 274 field($xw, 'SULFATE', sprintf("%.2f",floatval($row['w2_sulfate']))); | 274 field($xw, 'SULFATE', sprintf("%.2f",floatval($row['w2_sulfate']))); |
| 280 } | 280 } |
| 281 xmlwriter_end_element($xw); // WATERS | 281 xmlwriter_end_element($xw); // WATERS |
| 282 | 282 |
| 283 xmlwriter_start_element($xw, 'MASH'); | 283 xmlwriter_start_element($xw, 'MASH'); |
| 284 field($xw, 'VERSION', '1'); | 284 field($xw, 'VERSION', '1'); |
| 285 field($xw, 'NAME', $item['mash_name']); | 285 field($xw, 'NAME', $row['mash_name']); |
| 286 field($xw, 'GRAIN_TEMP', '10.0'); | 286 field($xw, 'GRAIN_TEMP', '10.0'); |
| 287 field($xw, 'PH', sprintf("%.1f",floatval($row['sparge_ph']))); | 287 field($xw, 'PH', sprintf("%.1f",floatval($row['sparge_ph']))); |
| 288 field($xw, 'SPARGE_TEMP', sprintf("%.1f",floatval($row['sparge_temp']))); | 288 field($xw, 'SPARGE_TEMP', sprintf("%.1f",floatval($row['sparge_temp']))); |
| 289 xmlwriter_start_element($xw, 'MASH_STEPS'); | 289 xmlwriter_start_element($xw, 'MASH_STEPS'); |
| 290 $arr = json_decode($row['json_mashs'], true); | 290 $arr = json_decode($row['json_mashs'], true); |
