get_params(); $suggestion = $params['content']; $suggestion = stripcslashes( $suggestion ); $suggestion = json_decode( $suggestion, true ); //$suggestion = $request->get_params(); //unset( $suggestion['_locale'] ); global $wpdb; $prefix = 'jet_'; $table_name = $wpdb->prefix . $prefix . 'search_suggestions'; $suggestion_id = esc_sql( $suggestion['id'] ); $suggestion_name = esc_sql( $suggestion['name'] ); $query = $wpdb->prepare( "SELECT * FROM {$table_name} WHERE id != %s AND name = %s", $suggestion_id, $suggestion_name ); $get_request = $wpdb->get_row( $query, ARRAY_A ); if ( NULL === $get_request ) { $query = $wpdb->prepare( "SELECT * FROM {$table_name} WHERE id = %s ", $suggestion_id ); $get_request = $wpdb->get_row( $query, ARRAY_A ); if ( NULL != $get_request ) { unset( $suggestion['child'] ); $where = array( 'id' => $suggestion_id ); $format = array( '%s' ); $where_format = array( '%d' ); $wpdb->update( $table_name, $suggestion, $where, $format, $where_format ); $success_text = sprintf( esc_html__( 'Success! Suggestion: "%s" has been updated', 'jet-search' ), $suggestion['name'] ); return rest_ensure_response( array( 'success' => true, 'data' => $success_text, ) ); } else { $success_text = sprintf( esc_html__( 'Fail! The suggestion with "%s" id has not found', 'jet-search' ), $suggestion['id'] ); return rest_ensure_response( array( 'success' => false, 'data' => $success_text, ) ); } } else { $success_text = sprintf( esc_html__( 'Fail! The suggestion with "%s" already exists.', 'jet-search' ), $suggestion['name'] ); return rest_ensure_response( array( 'success' => false, 'data' => $success_text, ) ); } } /** * Check user access to current end-popint * * @return bool */ public function permission_callback( $request ) { return current_user_can( 'manage_options' ); } /** * Returns arguments config * * @return array */ public function get_args() { return array(); } }