7 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); |
7 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); |
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 |
|
13 $response = array( |
|
14 'error' => false, |
|
15 'msg' => 'Ok', |
|
16 ); |
12 |
17 |
13 if (isset($_POST['insert']) || isset($_POST['update'])) { |
18 if (isset($_POST['insert']) || isset($_POST['update'])) { |
14 if (isset($_POST['insert'])) { |
19 if (isset($_POST['insert'])) { |
15 $sql = "INSERT INTO `profile_styles` SET "; |
20 $sql = "INSERT INTO `profile_styles` SET "; |
16 } |
21 } |
44 $sql .= "';"; |
49 $sql .= "';"; |
45 } |
50 } |
46 if (isset($_POST['update'])) { |
51 if (isset($_POST['update'])) { |
47 $sql .= "' WHERE record='" . $_POST['record'] . "';"; |
52 $sql .= "' WHERE record='" . $_POST['record'] . "';"; |
48 } |
53 } |
49 |
|
50 $result = mysqli_query($connect, $sql); |
54 $result = mysqli_query($connect, $sql); |
51 if (! $result) { |
55 if (! $result) { |
52 syslog(LOG_NOTICE, "db_profile_styles: ".$sql." result: ".mysqli_error($connect)); |
56 syslog(LOG_NOTICE, "db_profile_styles: ".$sql." result: ".mysqli_error($connect)); |
53 //} else { |
57 $response['error'] = true; |
54 // if (isset($_POST['update'])) { |
58 $response['msg'] = "SQL fout: ".mysqli_error($connect); |
55 // syslog(LOG_NOTICE, "db_profile_styles: updated record ".$_POST['record']); |
59 } |
56 // } else { |
60 exit(json_encode($response)); |
57 // $lastid = mysqli_insert_id($connect); |
|
58 // syslog(LOG_NOTICE, "db_profile_styles: inserted record ".$lastid); |
|
59 // } |
|
60 } |
|
61 echo $result; |
|
62 |
61 |
63 } else if (isset($_POST['delete'])) { |
62 } else if (isset($_POST['delete'])) { |
64 // DELETE COMMAND |
63 // DELETE COMMAND |
65 $sql = "DELETE FROM `profile_styles` WHERE record='".$_POST['record']."';"; |
64 $sql = "DELETE FROM `profile_styles` WHERE record='".$_POST['record']."';"; |
66 $result = mysqli_query($connect, $sql); |
65 $result = mysqli_query($connect, $sql); |
67 if (! $result) { |
66 if (! $result) { |
68 syslog(LOG_NOTICE, "db_profile_styles: ".$sql." result: ".mysqli_error($connect)); |
67 syslog(LOG_NOTICE, "db_profile_styles: ".$sql." result: ".mysqli_error($connect)); |
69 } else { |
68 $response['error'] = true; |
70 syslog(LOG_NOTICE, "db_profile_styles: deleted record ".$_POST['record']); |
69 $response['msg'] = "SQL fout: ".mysqli_error($connect); |
71 } |
70 } |
72 echo $result; |
71 exit(json_encode($response)); |
73 |
72 |
74 } else { |
73 } else { |
75 // SELECT COMMAND |
74 // SELECT COMMAND |
76 $query = "SELECT * FROM profile_styles ORDER BY style_guide,style_letter,name"; |
75 $query = "SELECT * FROM profile_styles ORDER BY style_guide,style_letter,name"; |
77 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
76 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
101 'ingredients' => $row['ingredients'], |
100 'ingredients' => $row['ingredients'], |
102 'examples' => $row['examples'] |
101 'examples' => $row['examples'] |
103 ); |
102 ); |
104 } |
103 } |
105 header("Content-type: application/json"); |
104 header("Content-type: application/json"); |
106 echo json_encode($styles); |
105 exit(json_encode($styles)); |
107 } |
106 } |
|
107 |
|
108 syslog(LOG_NOTICE, "db_profile_styles: missing arguments"); |
|
109 $response['error'] = true; |
|
110 $response['msg'] = "missing arguments"; |
|
111 echo json_encode($response); |
|
112 |
108 ?> |
113 ?> |