$sql = $wpdb->prepare("INSERT INTO {$wpdb->prefix}tbl_my_table
            ( 
              user_id,
              CreatedOn
            ) VALUES (
              %d,
              Now()
            )", $user_id);
  if (current_user_can('administrator'))
    $wpdb->show_errors();
  $wpdb->query($sql);

Get Auto ID Of New Record


  $Result = $wpdb->query($sql);
  if ($Result == True)
    return($wpdb->insert_id);
  else
    return(False);

The insert_id() function returns the auto generated id used in the latest querywith a column having the AUTO_INCREMENT attribute.

Feel free to comment if you can add help to this page or point out issues and solutions you have found. I do not provide support on this site, if you need help with a problem head over to stack overflow.

Comments

Your email address will not be published.