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 if (isset($_POST['insert']) || isset($_POST['update'])) { |
20 if (isset($_POST['insert']) || isset($_POST['update'])) { |
16 if (isset($_POST['insert'])) { |
21 if (isset($_POST['insert'])) { |
17 $sql = "INSERT INTO `inventory_hops` SET "; |
22 $sql = "INSERT INTO `inventory_hops` SET "; |
18 } |
23 } |
49 $sql .= "';"; |
54 $sql .= "';"; |
50 } |
55 } |
51 if (isset($_POST['update'])) { |
56 if (isset($_POST['update'])) { |
52 $sql .= "' WHERE record='" . $_POST['record'] . "';"; |
57 $sql .= "' WHERE record='" . $_POST['record'] . "';"; |
53 } |
58 } |
54 //syslog(LOG_NOTICE, $sql); |
|
55 |
|
56 $result = mysqli_query($connect, $sql); |
59 $result = mysqli_query($connect, $sql); |
57 if (! $result) { |
60 if (! $result) { |
58 syslog(LOG_NOTICE, "db_inventory_hops: ".$sql." result: ".mysqli_error($connect)); |
61 syslog(LOG_NOTICE, "db_inventory_hops: ".$sql." result: ".mysqli_error($connect)); |
59 //} else { |
62 $response['error'] = true; |
60 // if (isset($_POST['update'])) { |
63 $response['msg'] = "SQL fout: ".mysqli_error($connect); |
61 // syslog(LOG_NOTICE, "db_inventory_hops: updated record ".$_POST['record']); |
64 } |
62 // } else { |
65 exit(json_encode($response)); |
63 // $lastid = mysqli_insert_id($connect); |
|
64 // syslog(LOG_NOTICE, "db_inventory_hops: inserted record ".$lastid); |
|
65 // } |
|
66 } |
|
67 echo $result; |
|
68 |
66 |
69 } else if (isset($_POST['delete'])) { |
67 } else if (isset($_POST['delete'])) { |
70 // DELETE COMMAND |
68 // DELETE COMMAND |
71 $sql = "DELETE FROM `inventory_hops` WHERE record='".$_POST['record']."';"; |
69 $sql = "DELETE FROM `inventory_hops` WHERE record='".$_POST['record']."';"; |
72 $result = mysqli_query($connect, $sql); |
70 $result = mysqli_query($connect, $sql); |
73 if (! $result) { |
71 if (! $result) { |
74 syslog(LOG_NOTICE, "db_inventory_hops: ".$sql." result: ".mysqli_error($connect)); |
72 syslog(LOG_NOTICE, "db_inventory_hops: ".$sql." result: ".mysqli_error($connect)); |
75 } else { |
73 $response['error'] = true; |
76 syslog(LOG_NOTICE, "db_inventory_hops: deleted record ".$_POST['record']); |
74 $response['msg'] = "SQL fout: ".mysqli_error($connect); |
77 } |
75 } |
78 echo $result; |
76 exit(json_encode($response)); |
79 |
77 |
80 } else { |
78 } else { |
81 // SELECT COMMAND |
79 // SELECT COMMAND |
82 $query = "SELECT * FROM inventory_hops ORDER BY origin,name"; |
80 $query = "SELECT * FROM inventory_hops ORDER BY origin,name"; |
83 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
81 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
104 'tht_date' => $row['tht_date'], |
102 'tht_date' => $row['tht_date'], |
105 'total_oil' => $row['total_oil'] |
103 'total_oil' => $row['total_oil'] |
106 ); |
104 ); |
107 } |
105 } |
108 header("Content-type: application/json"); |
106 header("Content-type: application/json"); |
109 echo json_encode($hops); |
107 exit(json_encode($hops)); |
110 } |
108 } |
|
109 |
|
110 syslog(LOG_NOTICE, "db_inventory_hops: missing arguments"); |
|
111 $response['error'] = true; |
|
112 $response['msg'] = "missing arguments"; |
|
113 echo json_encode($response); |
|
114 |
111 ?> |
115 ?> |