comparison: www/includes/db_product.php
www/includes/db_product.php
- changeset 290
- 12aa92828e24
- parent 285
- 0ea9dfb3fce9
- child 292
- 90cd3798edc2
equal
deleted
inserted
replaced
| 289:4082c41f45e9 | 290:12aa92828e24 |
|---|---|
| 432 'stage' => $row['stage'] | 432 'stage' => $row['stage'] |
| 433 ); | 433 ); |
| 434 } | 434 } |
| 435 echo json_encode($brews, JSON_UNESCAPED_UNICODE); | 435 echo json_encode($brews, JSON_UNESCAPED_UNICODE); |
| 436 return; | 436 return; |
| 437 } | |
| 438 | |
| 439 if (isset($_GET['select']) && ($_GET['select'] == "archname")) { | |
| 440 $query = "SELECT record,name,code,birth,batch_size FROM products WHERE stage = '11' ORDER BY name,birth;"; | |
| 441 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); | |
| 442 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { | |
| 443 $brews[] = array( | |
| 444 'record' => $row['record'], | |
| 445 'name' => $row['name'], | |
| 446 'code' => $row['code'], | |
| 447 'birth' => $row['birth'], | |
| 448 'batch_size' => $row['batch_size'] | |
| 449 ); | |
| 450 } | |
| 451 echo json_encode($brews, JSON_UNESCAPED_UNICODE); | |
| 452 return; | |
| 437 } | 453 } |
| 438 | 454 |
| 439 /* | 455 /* |
| 440 * SELECT, produce a list of products that can be fermented. | 456 * SELECT, produce a list of products that can be fermented. |
| 441 */ | 457 */ |
