8 if (! $connect) { |
8 if (! $connect) { |
9 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
9 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
10 } |
10 } |
11 mysqli_set_charset($connect, "utf8" ); |
11 mysqli_set_charset($connect, "utf8" ); |
12 |
12 |
|
13 $response = array( |
|
14 'error' => false, |
|
15 'msg' => 'Ok', |
|
16 ); |
13 |
17 |
14 if (isset($_POST['insert']) || isset($_POST['update'])) { |
18 if (isset($_POST['insert']) || isset($_POST['update'])) { |
15 if (isset($_POST['insert'])) { |
19 if (isset($_POST['insert'])) { |
16 $sql = "INSERT INTO `inventory_waters` SET "; |
20 $sql = "INSERT INTO `inventory_waters` SET "; |
17 } |
21 } |
36 $sql .= "';"; |
40 $sql .= "';"; |
37 } |
41 } |
38 if (isset($_POST['update'])) { |
42 if (isset($_POST['update'])) { |
39 $sql .= "' WHERE record='" . $_POST['record'] . "';"; |
43 $sql .= "' WHERE record='" . $_POST['record'] . "';"; |
40 } |
44 } |
41 //syslog(LOG_NOTICE, $sql); |
|
42 |
|
43 $result = mysqli_query($connect, $sql); |
45 $result = mysqli_query($connect, $sql); |
44 if (! $result) { |
46 if (! $result) { |
45 syslog(LOG_NOTICE, "db_inventory_waters: ".$sql." result: ".mysqli_error($connect)); |
47 syslog(LOG_NOTICE, "db_inventory_waters: ".$sql." result: ".mysqli_error($connect)); |
46 //} else { |
48 $response['error'] = true; |
47 // if (isset($_POST['update'])) { |
49 $response['msg'] = "SQL fout: ".mysqli_error($connect); |
48 // syslog(LOG_NOTICE, "db_inventory_waters: updated record ".$_POST['record']); |
50 } |
49 // } else { |
51 exit(json_encode($response)); |
50 // $lastid = mysqli_insert_id($connect); |
|
51 // syslog(LOG_NOTICE, "db_inventory_waters: inserted record ".$lastid); |
|
52 // } |
|
53 } |
|
54 echo $result; |
|
55 |
52 |
56 } else if (isset($_POST['delete'])) { |
53 } else if (isset($_POST['delete'])) { |
57 // DELETE COMMAND |
54 // DELETE COMMAND |
58 $sql = "DELETE FROM `inventory_waters` WHERE record='".$_POST['record']."';"; |
55 $sql = "DELETE FROM `inventory_waters` WHERE record='".$_POST['record']."';"; |
59 $result = mysqli_query($connect, $sql); |
56 $result = mysqli_query($connect, $sql); |
60 if (! $result) { |
57 if (! $result) { |
61 syslog(LOG_NOTICE, "db_inventory_waters: ".$sql." result: ".mysqli_error($connect)); |
58 syslog(LOG_NOTICE, "db_inventory_waters: ".$sql." result: ".mysqli_error($connect)); |
62 } else { |
59 $response['error'] = true; |
63 syslog(LOG_NOTICE, "db_inventory_waters: deleted record ".$_POST['record']); |
60 $response['msg'] = "SQL fout: ".mysqli_error($connect); |
64 } |
61 } |
65 echo $result; |
62 exit(json_encode($response)); |
66 |
63 |
67 } else { |
64 } else { |
68 // SELECT COMMAND |
65 // SELECT COMMAND |
69 $query = "SELECT * FROM inventory_waters ORDER BY name"; |
66 $query = "SELECT * FROM inventory_waters ORDER BY name"; |
70 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
67 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
85 'inventory' => $row['inventory'], |
82 'inventory' => $row['inventory'], |
86 'cost' => $row['cost'] |
83 'cost' => $row['cost'] |
87 ); |
84 ); |
88 } |
85 } |
89 header("Content-type: application/json"); |
86 header("Content-type: application/json"); |
90 echo json_encode($waters); |
87 exit(json_encode($waters)); |
91 } |
88 } |
|
89 |
|
90 syslog(LOG_NOTICE, "db_inventory_water: missing arguments"); |
|
91 $response['error'] = true; |
|
92 $response['msg'] = "missing arguments"; |
|
93 echo json_encode($response); |
|
94 |
92 ?> |
95 ?> |