Ajax update

Hi

I did it, it works now.
Pick up some example wordpress ajax code: https://wptheming.com/2013/07/simple-ajax-example/

Maby are there oder there need the same.

Best Regards
Morten

But i have a problem with ajax Update, my ajax response as it should and show the new values i request. But it dont get to the Database

function ajax_(hidden)_update_top_banner() {
    global $wpdb;
      $table_name = $wpdb->prefix . "topbanner";
      $outPut = $wpdb->get_results(
    "
    SELECT *
    FROM $table_name
    "
    );

    foreach ( $outPut as $(hidden)_top_banner ) {
      if ( isset($_REQUEST['submit_update'.$(hidden)_top_banner->id])) {

      $(hidden)_top_banner_name                  = wp_kses_post($_POST['(hidden)_top_banner_name'.$(hidden)_top_banner->id]);
      $(hidden)_top_banner_name_color            = sanitize_hex_color($_POST['(hidden)_top_banner_name_color'.$(hidden)_top_banner->id]);
      $(hidden)_top_banner_name_top_text_line    = sanitize_text_field($_POST['(hidden)_top_banner_name_top_text_line'.$(hidden)_top_banner->id]);
      $(hidden)_top_banner_name_top_height       = sanitize_text_field($_POST['(hidden)_top_banner_name_top_height'.$(hidden)_top_banner->id]);
      $(hidden)_top_banner_name_top_start_date   = sanitize_text_field($_POST['(hidden)_top_banner_name_top_start_date'.$(hidden)_top_banner->id]);
      $(hidden)_top_banner_name_top_stop_date    = sanitize_text_field($_POST['(hidden)_top_banner_name_top_stop_date'.$(hidden)_top_banner->id]);
      $(hidden)_top_banner_name_media            = sanitize_text_field($_POST['(hidden)_top_banner_name_media'.$(hidden)_top_banner->id]);
      $(hidden)_image_attachment_id              = sanitize_text_field($_POST['(hidden)_image_attachment_id'.$(hidden)_top_banner->id]);

    $wpdb->update(
    $table_name,
    array(
      '(hidden)_top_banner_name'                   => $(hidden)_top_banner_name,
      '(hidden)_top_banner_name_color'             => $(hidden)_top_banner_name_color,
          '(hidden)_top_banner_name_top_text_line'     => $(hidden)_top_banner_name_top_text_line,
          '(hidden)_top_banner_name_top_height'        => $(hidden)_top_banner_name_top_height,
          '(hidden)_top_banner_name_top_start_date'    => $(hidden)_top_banner_name_top_start_date,
          '(hidden)_top_banner_name_top_stop_date'     => $(hidden)_top_banner_name_top_stop_date,
          '(hidden)_top_banner_name_media'             => $(hidden)_top_banner_name_media,
          '(hidden)_image_attachment_id'               => $(hidden)_image_attachment_id,
    ),
    array( 'id' => $(hidden)_top_banner->id ),
    array(
      '%s',
      '%s',
          '%s',
          '%s',
          '%s',
          '%s',
          '%s',
          '%d',
    ),
    array( '%d' )
    );
      // The $_REQUEST contains all the data sent via ajax
    }
      }
    print_r($_REQUEST);
      // Always die in functions echoing ajax content
     die();
}

  add_action( 'wp_ajax_ajax_(hidden)_update_top_banner', 'ajax_(hidden)_update_top_banner' );

Best regards
Morten

Take that INSERT query string that was output by directly calling the function and try executing it in phpMyAdmin’s SQL tab after you’ve navigated to your WP DB. It should give you a better idea about what it doesn’t like about the query. It looks OK to me, but phpMyAdmin is much more discerning.

Isn’t it odd that the name field is empty? Or is it just because of the way you had to execute the function to see any output? I think the output to console failed because of quotes in the query string. The string probably needs to be serialized or converted to JSON before outputting to the browser.

Hi

I have found the bug, it is my id i not can get.
Here is the problem:

  function ajax_(hidden)_update_top_banner() {
    global $wpdb;
      $table_name = $wpdb->prefix . "topbanner";

      if ( isset($_REQUEST)) {

      $(hidden)_top_banner_name                  = wp_kses_post($_REQUEST['(hidden)_top_banner_name']);
      $(hidden)_top_banner_name_color            = sanitize_hex_color($_REQUEST['(hidden)_top_banner_name_color']);
      $(hidden)_top_banner_name_top_text_line    = sanitize_text_field($_REQUEST['(hidden)_top_banner_name_top_text_line']);
      $(hidden)_top_banner_name_top_height       = sanitize_text_field($_REQUEST['(hidden)_top_banner_name_top_height']);
      $(hidden)_top_banner_name_top_start_date   = sanitize_text_field($_REQUEST['(hidden)_top_banner_name_top_start_date']);
      $(hidden)_top_banner_name_top_stop_date    = sanitize_text_field($_REQUEST['(hidden)_top_banner_name_top_stop_date']);
      $(hidden)_top_banner_name_media            = sanitize_text_field($_REQUEST['(hidden)_top_banner_name_media']);
      $(hidden)_image_attachment_id              = sanitize_text_field($_REQUEST['(hidden)_image_attachment_id']);
    
    $wpdb->update(
    $table_name,
    array(
      '(hidden)_top_banner_name'                   => $(hidden)_top_banner_name,
      '(hidden)_top_banner_name_color'             => $(hidden)_top_banner_name_color,
          '(hidden)_top_banner_name_top_text_line'     => $(hidden)_top_banner_name_top_text_line,
          '(hidden)_top_banner_name_top_height'        => $(hidden)_top_banner_name_top_height,
          '(hidden)_top_banner_name_top_start_date'    => $(hidden)_top_banner_name_top_start_date,
          '(hidden)_top_banner_name_top_stop_date'     => $(hidden)_top_banner_name_top_stop_date,
          '(hidden)_top_banner_name_media'             => $(hidden)_top_banner_name_media,
          '(hidden)_image_attachment_id'               => $(hidden)_image_attachment_id,
    ),

    array( 'id' => $outPut ),
    array(
      '%s',
      '%s',
          '%s',
          '%s',
          '%s',
          '%s',
          '%s',
          '%d',
    ),
    array( '%d' )
    );
    }

      // The $_REQUEST contains all the data sent via ajax
    echo $wpdb->last_query;
      // Always die in functions echoing ajax content
     die();
}

  add_action( 'wp_ajax_ajax_(hidden)_update_top_banner', 'ajax_(hidden)_update_top_banner' );

Can i somehow do this:
$_REQUEST[‘id’] = $id;
$outPut = $wpdb->get_results( $wpdb->prepare( “SELECT * FROM $table_name WHERE id = %d”, $id ) );

Have a hidden input with id.
I hoped i cut use it to get id from call from my form.

Best regards
Morten

Hi
It all works now.
Insert, update and delete in ajax.
Now its time secure the plugin.
Have done database ok.
So is it my insert update and delete I need to work with.

If you more good method I will be happy.

And thanks for all you help and time.

Best regards
Morten

Thanks for your help ??
I close this question for now ??

Best Regards
Morten