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 |
13 |
|
14 $response = array( |
|
15 'error' => false, |
|
16 'msg' => 'Ok', |
|
17 ); |
14 |
18 |
15 // get data and store in a json array |
19 // get data and store in a json array |
16 if (isset($_POST['insert']) || isset($_POST['update'])) { |
20 if (isset($_POST['insert']) || isset($_POST['update'])) { |
17 if (isset($_POST['insert'])) { |
21 if (isset($_POST['insert'])) { |
18 $sql = "INSERT INTO `inventory_yeasts` SET "; |
22 $sql = "INSERT INTO `inventory_yeasts` SET "; |
61 $sql .= ";"; |
65 $sql .= ";"; |
62 } |
66 } |
63 if (isset($_POST['update'])) { |
67 if (isset($_POST['update'])) { |
64 $sql .= " WHERE record='" . $_POST['record'] . "';"; |
68 $sql .= " WHERE record='" . $_POST['record'] . "';"; |
65 } |
69 } |
66 |
|
67 $result = mysqli_query($connect, $sql); |
70 $result = mysqli_query($connect, $sql); |
68 if (! $result) { |
71 if (! $result) { |
69 syslog(LOG_NOTICE, "db_inventory_yeasts: ".$sql." result: ".mysqli_error($connect)); |
72 syslog(LOG_NOTICE, "db_inventory_yeasts: ".$sql." result: ".mysqli_error($connect)); |
70 //} else { |
73 $response['error'] = true; |
71 // if (isset($_POST['update'])) { |
74 $response['msg'] = "SQL fout: ".mysqli_error($connect); |
72 // syslog(LOG_NOTICE, "db_inventory_yeasts: updated record ".$_POST['record']); |
75 } |
73 // } else { |
76 exit(json_encode($response)); |
74 // $lastid = mysqli_insert_id($connect); |
|
75 // syslog(LOG_NOTICE, "db_inventory_yeasts: inserted record ".$lastid); |
|
76 // } |
|
77 } |
|
78 echo $result; |
|
79 |
77 |
80 } else if (isset($_POST['delete'])) { |
78 } else if (isset($_POST['delete'])) { |
81 // DELETE COMMAND |
79 // DELETE COMMAND |
82 $sql = "DELETE FROM `inventory_yeasts` WHERE record='".$_POST['record']."';"; |
80 $sql = "DELETE FROM `inventory_yeasts` WHERE record='".$_POST['record']."';"; |
83 $result = mysqli_query($connect, $sql); |
81 $result = mysqli_query($connect, $sql); |
84 if (! $result) { |
82 if (! $result) { |
85 syslog(LOG_NOTICE, "db_inventory_yeasts: ".$sql." result: ".mysqli_error($connect)); |
83 syslog(LOG_NOTICE, "db_inventory_yeasts: ".$sql." result: ".mysqli_error($connect)); |
86 } else { |
84 $response['error'] = true; |
87 syslog(LOG_NOTICE, "db_inventory_yeasts: deleted record ".$_POST['record']); |
85 $response['msg'] = "SQL fout: ".mysqli_error($connect); |
88 } |
86 } |
89 echo $result; |
87 exit(json_encode($response)); |
90 |
88 |
91 } else { |
89 } else { |
92 // SELECT COMMAND |
90 // SELECT COMMAND |
93 $query = "SELECT * FROM inventory_yeasts ORDER BY laboratory,product_id,name"; |
91 $query = "SELECT * FROM inventory_yeasts ORDER BY laboratory,product_id,name"; |
94 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
92 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
126 'gr_hl_hi' => $row['gr_hl_hi'], |
124 'gr_hl_hi' => $row['gr_hl_hi'], |
127 'sg_hi' => floatval($row['sg_hi']) |
125 'sg_hi' => floatval($row['sg_hi']) |
128 ); |
126 ); |
129 } |
127 } |
130 header("Content-type: application/json"); |
128 header("Content-type: application/json"); |
131 echo json_encode($yeasts); |
129 exit(json_encode($yeasts)); |
132 } |
130 } |
|
131 |
|
132 syslog(LOG_NOTICE, "db_inventory_yeasts: missing arguments"); |
|
133 $response['error'] = true; |
|
134 $response['msg'] = "missing arguments"; |
|
135 echo json_encode($response); |
|
136 |
133 ?> |
137 ?> |