comparison: www/includes/db_product.php
www/includes/db_product.php
- changeset 237
- 9337b5ff8698
- parent 235
- 0a063ac5d7f5
- child 238
- 8e7384587a10
equal
deleted
inserted
replaced
| 236:4b8e5478d08f | 237:9337b5ff8698 |
|---|---|
| 332 /* | 332 /* |
| 333 * Default, select all or a given record. | 333 * Default, select all or a given record. |
| 334 */ | 334 */ |
| 335 if (isset($_GET['record'])) { | 335 if (isset($_GET['record'])) { |
| 336 $query = "SELECT * FROM products WHERE record='" . $_GET['record'] . "';"; | 336 $query = "SELECT * FROM products WHERE record='" . $_GET['record'] . "';"; |
| 337 syslog(LOG_NOTICE, "get products record " . $_GET['record']); | |
| 337 } else { | 338 } else { |
| 338 $query = "SELECT * FROM products ORDER BY birth,code;"; | 339 $query = "SELECT * FROM products ORDER BY birth,code;"; |
| 339 } | 340 } |
| 340 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); | 341 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
| 341 $brews = '['; | 342 $brews = '['; |
| 591 $brew .= '}'; | 592 $brew .= '}'; |
| 592 // syslog(LOG_NOTICE, $brew); | 593 // syslog(LOG_NOTICE, $brew); |
| 593 $brews .= $brew; | 594 $brews .= $brew; |
| 594 } | 595 } |
| 595 $brews .= ']'; | 596 $brews .= ']'; |
| 597 if (isset($_GET['record'])) | |
| 598 syslog(LOG_NOTICE, "ready to sent"); | |
| 596 header("Content-type: application/json"); | 599 header("Content-type: application/json"); |
| 597 echo $brews; | 600 echo $brews; |
| 598 } | 601 } |
| 599 ?> | 602 ?> |
