9 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); |
9 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); |
10 if (! $connect) { |
10 if (! $connect) { |
11 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
11 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
12 } |
12 } |
13 mysqli_set_charset($connect, "utf8" ); |
13 mysqli_set_charset($connect, "utf8" ); |
|
14 |
|
15 $response = array( |
|
16 'error' => false, |
|
17 'msg' => 'Ok', |
|
18 ); |
14 |
19 |
15 // get data and store in a json array |
20 // get data and store in a json array |
16 if (isset($_POST['insert']) || isset($_POST['update'])) { |
21 if (isset($_POST['insert']) || isset($_POST['update'])) { |
17 if (isset($_POST['insert'])) { |
22 if (isset($_POST['insert'])) { |
18 $sql = "INSERT INTO `inventory_fermentables` SET "; |
23 $sql = "INSERT INTO `inventory_fermentables` SET "; |
55 $sql .= ";"; |
60 $sql .= ";"; |
56 } |
61 } |
57 if (isset($_POST['update'])) { |
62 if (isset($_POST['update'])) { |
58 $sql .= " WHERE record='" . $_POST['record'] . "';"; |
63 $sql .= " WHERE record='" . $_POST['record'] . "';"; |
59 } |
64 } |
60 //syslog(LOG_NOTICE, $sql); |
|
61 |
|
62 $result = mysqli_query($connect, $sql); |
65 $result = mysqli_query($connect, $sql); |
63 if (! $result) { |
66 if (! $result) { |
64 syslog(LOG_NOTICE, "db_inventory_fermentables: ".$sql." result: ".mysqli_error($connect)); |
67 syslog(LOG_NOTICE, "db_inventory_fermentables: ".$sql." result: ".mysqli_error($connect)); |
65 //} else { |
68 $response['error'] = true; |
66 // if (isset($_POST['update'])) { |
69 $response['msg'] = "SQL fout: ".mysqli_error($connect); |
67 // syslog(LOG_NOTICE, "db_inventory_fermentables: updated record ".$_POST['record']); |
|
68 // } else { |
|
69 // $lastid = mysqli_insert_id($connect); |
|
70 // syslog(LOG_NOTICE, "db_inventory_fermentables: inserted record ".$lastid); |
|
71 // } |
|
72 } |
70 } |
73 echo $result; |
71 exit(json_encode($response)); |
74 |
72 |
75 } else if (isset($_POST['delete'])) { |
73 } else if (isset($_POST['delete'])) { |
76 // DELETE COMMAND |
74 // DELETE COMMAND |
77 $sql = "DELETE FROM `inventory_fermentables` WHERE record='".$_POST['record']."';"; |
75 $sql = "DELETE FROM `inventory_fermentables` WHERE record='".$_POST['record']."';"; |
78 $result = mysqli_query($connect, $sql); |
76 $result = mysqli_query($connect, $sql); |
79 if (! $result) { |
77 if (! $result) { |
80 syslog(LOG_NOTICE, "db_inventory_fermentables: ".$sql." result: ".mysqli_error($connect)); |
78 syslog(LOG_NOTICE, "db_inventory_fermentables: ".$sql." result: ".mysqli_error($connect)); |
81 } else { |
79 $response['error'] = true; |
82 syslog(LOG_NOTICE, "db_inventory_fermentables: deleted record ".$_POST['record']); |
80 $response['msg'] = "SQL fout: ".mysqli_error($connect); |
83 } |
81 } |
84 echo $result; |
82 exit(json_encode($response)); |
85 |
83 |
86 } else { |
84 } else { |
87 // SELECT COMMAND |
85 // SELECT COMMAND |
88 $query = "SELECT * FROM inventory_fermentables ORDER BY supplier,name"; |
86 $query = "SELECT * FROM inventory_fermentables ORDER BY supplier,name"; |
89 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
87 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
115 'production_date' => $row['production_date'], |
113 'production_date' => $row['production_date'], |
116 'tht_date' => $row['tht_date'] |
114 'tht_date' => $row['tht_date'] |
117 ); |
115 ); |
118 } |
116 } |
119 header("Content-type: application/json"); |
117 header("Content-type: application/json"); |
120 echo json_encode($fermentables); |
118 exit(json_encode($fermentables)); |
121 } |
119 } |
|
120 |
|
121 syslog(LOG_NOTICE, "db_inventory_fermentables: missing arguments"); |
|
122 $response['error'] = true; |
|
123 $response['msg'] = "missing arguments"; |
|
124 echo json_encode($response); |
|
125 |
122 ?> |
126 ?> |