duplicate entries in database while using save_post or wp_insert_post

wp_insert_post runs when a post is updated as well. If you scan the source you will see numerous blocks of code switching between an update or not an update. In fact, wp_update_post() just passes data, after a little processing, to wp_insert_post() for the bulk of the work. That is why your code runs more than you think it should– the hook doesn’t work as you think it should. Fortunately, WordPress passes a parametere telling you if the hook is being used on an update or not.

do_action( 'wp_insert_post', $post_ID, $post, $update );

So…

function update_profile_record( $post_ID, $post, $update ) {
  if (true == $update) return;

  //if ($post->post_type="post") return;
  $pro_realname = get_post_meta( $post_id, 'realname', true );
  $pro_cell = get_post_meta( $post_id, 'cell', true );
  $pro_email = get_post_meta( $post_id, 'e_mail', true );
  $pro_subdate = get_post_meta( $post_id, 'submit_date', true );
  if ($pro_subdate == '') { 
    $pro_subdate = get_the_date( $format, $post_id ); 
  }

  global $wpdb;
  $table_name = $wpdb->prefix . "profile_record";
  $wpdb->insert( 
    $table_name, 
    array(
      'rec_profile_name' => $pro_realname,
      'rec_profile_contact' => $pro_cell,
      'rec_profile_email' => $pro_email,
      'rec_profile_date' => $pro_subdate,
    )
  );
}
add_action(  'wp_insert_post',  'update_profile_record', 10, 3 );

Related Posts:

  1. using $wpdb to insert a form into a post
  2. Programmatically Creating Page using $wpdb and getting 404 error
  3. How to run wp_insert_post() & wpdb on the background?
  4. $wpdb->insert() doesnt work anymore
  5. adding a log row log table, when the draft post publish
  6. Out of Memory – Line 791 of WP-DB.php (mysql_real_escape_string)
  7. WordPress 4.8.1 uses mysql_connect which doesn’t work with PHP 7
  8. How to use $wpdb to delete in a custom table
  9. Matching database content types to PHP types
  10. Does $wpdb->prepare not create a prepared statement that I can execute multiple times?
  11. $wpdb->last_error doesn’t show the query on error
  12. save_post + insert_post = infinite loop
  13. Saving custom form data into database
  14. Get data from database table by post_id to get data from second database table
  15. wp-content/db.php : where is this file?
  16. $wpdb sql help. Select post id and post meta value based on 2 other post_meta values
  17. $wpdb->get_results() returns good result only in first foreach iteration
  18. $wpdb->insert – inserting multiple rows
  19. $wpdb prepared with search term
  20. Set Primary category using the Yoast SEO plugin
  21. WPDB->insert with special characters
  22. Is there a (better) way to access $wpdb results?
  23. $wpdb->prepare not working with update table prefix
  24. How to use prepare to query with variables
  25. Use $wpdb in wordpress theme files
  26. wpdb->get_row() / get_results – is it possible to return an object instances of my own class?
  27. Problem in creating table through plugin code
  28. I want to update my postcontent with $wpdb
  29. $wpdb->replace / Replace or update primary key
  30. Create an array with a string key from wpdb->get_results
  31. $wpdb – do you have to use foreach even if there will always only be one result?
  32. Is it possible to create a post using a metabox?
  33. Replicating the WP_Query ‘s’ param with $wpdb
  34. Need help writing a $wpdb query
  35. get the number of queries made on a page(inside my plugin)
  36. Doing a loop with multiple DBs simultaneoulsy
  37. $wpdb->insert query changes to SHOW COLUMNS query Output
  38. Set default Custom Post Meta Value
  39. Fixing wpdb->get_results and wpdb->prepare?
  40. How does the WXR file differ from the WPDB?
  41. WordPress SQL query – returning ‘true’ ‘false’ or ‘null’
  42. Modify the structure of data returned by $wpdb
  43. WPDB If primary key already exists, add +1 to integer field
  44. How to get an array of user roles with or without a specific capability?
  45. save_post action to include wp_insert_post_data filter, gathering meta field info & prevent infinite loop
  46. What is wrong with this wpdb update?
  47. Constructing a dynamic WPDB query with multiple LIKEs
  48. Auto-Select Parent Category as Primary
  49. Check if post is added manually or through wp_insert_post()
  50. 301 Redirect Code
  51. Counting posts with argument without retrieving the posts
  52. $wpdb->insert inserting only f character in custom table
  53. Why does wpdb->update delete other meta?
  54. Increment integer field in database when WHERE needs to be dynamic [closed]
  55. Getting variable from Database
  56. Create new database through static page code
  57. Custom $wpdb returns unexpected time based results
  58. WordPress “wpdb->update” – Append Text Value
  59. how to connect to another database in wordpress
  60. Need help converting get_user_meta [keys] into own array
  61. Can’t call WPDB inside RSS template
  62. Save sql file after doing insert wpdb
  63. Perform a function when a user clicks register button
  64. Can I use wpdb to insert query results into a post?
  65. $wpdb->prepare error after WordPress update [duplicate]
  66. $wpdb->num_rows doesn’t work
  67. $wpdb->get_var next var?
  68. How do I modify this wpdb query to include posts that have a post_status of publish and draft?
  69. WordPress ajax response save into database
  70. Can’t find out why dbDelta dosen’t create my table
  71. How to pass an input value into wpdb->Prepare
  72. Check if Value Exists in Database, adding row details to variables and echoing result
  73. wpdb replace returning 1 where delete and insert is expected
  74. wpdb discards duplicate column names?
  75. update_post_meta not working in template_redirect action
  76. WPDB SQL query SELECT from category
  77. How to work with constraints on wordpress user metadata?
  78. wp_insert_post inside save_post adds wrong metadata to inserted post
  79. How to Update multiple rows using $wpdb->update
  80. Unable to use $wpdb in WordPress
  81. How to display specific data from custom database table in WordPress
  82. Get 3 row ID’s via ARRAY_A
  83. Getting record from three wpdb tables
  84. Why is an empty result an error? ( $wpdb->get_row )
  85. get_row returns empty when data exists
  86. wpdb insert working in one function, but not another
  87. How to set up prepared query using IN statement
  88. Problem on wpdb queries, wp_insert_post, wp_insert_user etc. The query runs twice
  89. WPDB Prepared Delete
  90. wpdb select from using array as search parameters
  91. wpdb Cannot Access Associative Array Data in a Count Query
  92. Using $wpdb to update current post
  93. Can’t get expected result from a wpdb query
  94. Can’t seem to get set_blog_id working, it just doesn’t reset the blog ID
  95. selecting row using wpdb which contain special symbols
  96. Query Problem in Clustom Plugin
  97. How does $wpdb->get_var work with offset?
  98. Get count of rows based if column exists in two different tables
  99. Table wont load into WPDB
  100. WPDB prepare – like % – placeholders?