$query_data = jsonDataToQueryString($_POST); $query = "INSERT INTO category ({$query_data['fields']}) VALUES({$query_data['values']})"; if (mysql_query($query)) { $id = mysql_insert_id(); $message = "Data has been saved"; $idUpdatesql = "UPDATE category SET id = '{$id}' WHERE tbid = " . $id . ""; mysql_query($idUpdatesql); $result["success"] = 1; } else { $result["success"] = 0; $message = substr(mysql_error(), 0, -9); } } else { // updating category fields $id = $_POST['tbid']; unset($_POST['tbid']); $query_data = jsonEditQuery($_POST); $sql = "UPDATE category SET {$query_data} WHERE tbid = " . $id . ""; // exit; if (mysql_query($sql)) { $result["success"] = 1; $message = "Data has been updated"; } else { $result["success"] = 0; $message = substr(mysql_error(), 0, -9); } } //exit; $result["message"] = $message; echo json_encode($result); }
if ($action_check[1] == $val) { $permissions[$val][$v] = true; } } } $permission_string = json_encode($permissions); $fileds_data['permissions'] = $permission_string; } else { $fileds_data['permissions'] = "[]"; } //insert if (isset($_POST['id'])) { //edit block; $edit_id = $_POST['id']; unset($fileds_data['id']); $edit_query = jsonEditQuery($fileds_data); $sql = "UPDATE users SET {$edit_query} WHERE id ={$edit_id}"; if (mysql_query($sql)) { $return_data = array('status' => true, 'message' => "This user has been updated successfully."); } else { $return_data = array('status' => false, 'message' => "Please Try again."); } echo json_encode($return_data); } else { //add block $post_data = jsonDataToQueryString($fileds_data); $query = "insert into users ({$post_data['fields']}) values ({$post_data['values']})"; //echo $query; if (mysql_query($query)) { $return_data = array('status' => true, 'message' => "This user has been added successfully."); echo json_encode($return_data);