comparison: www/includes/db_inventory_miscs.php
www/includes/db_inventory_miscs.php
- changeset 767
- 08c0343b622b
- parent 715
- 8fb922c00a2d
- child 785
- aa79acfdf8a9
equal
deleted
inserted
replaced
| 766:86289b0c4a27 | 767:08c0343b622b |
|---|---|
| 8 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); | 8 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); |
| 9 if (! $connect) { | 9 if (! $connect) { |
| 10 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); | 10 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
| 11 } | 11 } |
| 12 mysqli_set_charset($connect, "utf8" ); | 12 mysqli_set_charset($connect, "utf8" ); |
| 13 | |
| 14 $response = array( | |
| 15 'error' => false, | |
| 16 'msg' => 'Ok', | |
| 17 ); | |
| 13 | 18 |
| 14 if (isset($_POST['insert']) || isset($_POST['update'])) { | 19 if (isset($_POST['insert']) || isset($_POST['update'])) { |
| 15 if (isset($_POST['insert'])) { | 20 if (isset($_POST['insert'])) { |
| 16 $sql = "INSERT INTO `inventory_miscs` SET "; | 21 $sql = "INSERT INTO `inventory_miscs` SET "; |
| 17 } | 22 } |
| 42 $sql .= ";"; | 47 $sql .= ";"; |
| 43 } | 48 } |
| 44 if (isset($_POST['update'])) { | 49 if (isset($_POST['update'])) { |
| 45 $sql .= " WHERE record='" . $_POST['record'] . "';"; | 50 $sql .= " WHERE record='" . $_POST['record'] . "';"; |
| 46 } | 51 } |
| 47 //syslog(LOG_NOTICE, $sql); | |
| 48 | |
| 49 $result = mysqli_query($connect, $sql); | 52 $result = mysqli_query($connect, $sql); |
| 50 if (! $result) { | 53 if (! $result) { |
| 51 syslog(LOG_NOTICE, "db_inventory_miscs: ".$sql." result: ".mysqli_error($connect)); | 54 syslog(LOG_NOTICE, "db_inventory_miscs: ".$sql." result: ".mysqli_error($connect)); |
| 52 //} else { | 55 $response['error'] = true; |
| 53 // if (isset($_POST['update'])) { | 56 $response['msg'] = "SQL fout: ".mysqli_error($connect); |
| 54 // syslog(LOG_NOTICE, "db_inventory_miscs: updated record ".$_POST['record']); | 57 } |
| 55 // } else { | 58 exit(json_encode($response)); |
| 56 // $lastid = mysqli_insert_id($connect); | |
| 57 // syslog(LOG_NOTICE, "db_inventory_miscs: inserted record ".$lastid); | |
| 58 // } | |
| 59 } | |
| 60 echo $result; | |
| 61 | 59 |
| 62 } else if (isset($_POST['delete'])) { | 60 } else if (isset($_POST['delete'])) { |
| 63 // DELETE COMMAND | 61 // DELETE COMMAND |
| 64 $sql = "DELETE FROM `inventory_miscs` WHERE record='".$_POST['record']."';"; | 62 $sql = "DELETE FROM `inventory_miscs` WHERE record='".$_POST['record']."';"; |
| 65 $result = mysqli_query($connect, $sql); | 63 $result = mysqli_query($connect, $sql); |
| 66 if (! $result) { | 64 if (! $result) { |
| 67 syslog(LOG_NOTICE, "db_inventory_miscs: ".$sql." result: ".mysqli_error($connect)); | 65 syslog(LOG_NOTICE, "db_inventory_miscs: ".$sql." result: ".mysqli_error($connect)); |
| 68 } else { | 66 $response['error'] = true; |
| 69 syslog(LOG_NOTICE, "db_inventory_miscs: deleted record ".$_POST['record']); | 67 $response['msg'] = "SQL fout: ".mysqli_error($connect); |
| 70 } | 68 } |
| 71 echo $result; | 69 exit(json_encode($response)); |
| 72 | 70 |
| 73 } else { | 71 } else { |
| 74 // SELECT COMMAND | 72 // SELECT COMMAND |
| 75 $query = "SELECT * FROM inventory_miscs ORDER BY name"; | 73 $query = "SELECT * FROM inventory_miscs ORDER BY name"; |
| 76 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); | 74 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
| 90 'production_date' => $row['production_date'], | 88 'production_date' => $row['production_date'], |
| 91 'tht_date' => $row['tht_date'] | 89 'tht_date' => $row['tht_date'] |
| 92 ); | 90 ); |
| 93 } | 91 } |
| 94 header("Content-type: application/json"); | 92 header("Content-type: application/json"); |
| 95 echo json_encode($miscs); | 93 exit(json_encode($miscs)); |
| 96 } | 94 } |
| 95 | |
| 96 syslog(LOG_NOTICE, "db_inventory_miscs: missing arguments"); | |
| 97 $response['error'] = true; | |
| 98 $response['msg'] = "missing arguments"; | |
| 99 echo json_encode($response); | |
| 100 | |
| 97 ?> | 101 ?> |
