New post from database

With few lines of code you can transfer your data from your custom table to post table.

  1. Do some MySQL query using $wpdb Object to get data from your custom table.
  2. And then in foreach() loop use wp_insert_post and add_post_meta to add all those rows in your post table.

And you are Done!

Related Posts:

  1. modify all posts of a category to “no comments allowed”
  2. Ordering Post 2 Post admin meta box by meta from CPT
  3. Create Pages from Database
  4. How do I write this SQL statement for Posts written in last 24 hours?
  5. Combine tax_query and meta_query in WP_Query
  6. Query to change custom post type with specific category
  7. Mass convert MySQL data entries into custom post type?
  8. Calculating Bayesian average for custom post type
  9. Deleting Custom Post type data using mySQL command
  10. wpdb custom post_type problem
  11. Adding custom tables to WordPress
  12. $wpdb: Counting posts corresponding to 3 terms in 3 different taxonomies
  13. Insert post metadata for all posts in CPT at once if metadata no existent
  14. Convert simple SQL Query to WordPress query
  15. Assign External Database Queries to Global Variables and Make Them Accessible
  16. How to import a custom MySQL DB table into a WordPress custom post type
  17. Function causing the loop display posting more (empty)
  18. wp_insert_post sometimes fails after API call
  19. Proper way to display latest 5 posts grouped by post type?
  20. Front end access to a SQL data repository – recommended way?
  21. Navigate posts with different post type that are in the same categories
  22. Update post if exist from PHP
  23. I’m trying to create a custom version of the wp_list_authors function that includes custom post types
  24. Convert Custom Taxonomy Posts to Normal Posts
  25. How to import database table as custom post type and custom fields?
  26. $wpdb is queried but results don’t show
  27. SQL query – get ids – Advanced Custom Fields / WPeC
  28. Why doesnt my tag page populate with this custom post type?
  29. Fetch data of 2 relational Custom Post in WordPress
  30. Custom post type and custom taxonomy key lenght & query performance
  31. Why is this function so slow?
  32. Sql Update CPT from publish to draft and particular custom field
  33. Dropwdown: Get taxonomy terms from posts that share preselected terms from 3 other taxonomies
  34. Post that populates itself (almost) automatically using data from imported excel file
  35. Populate custom post type/custom fields from an external database
  36. Custom post order when using OR relation
  37. Problem with a query in custom posts
  38. Filtering problem
  39. Create a WordPress Database query to find users who purchased specific product through WooCommerce [closed]
  40. Assign a tag to custom post type using a query
  41. How to get the posts of a custom taxonomy term
  42. How can I rewrite URLs to pass taxonomy and post type values to the query?
  43. Custom Post Type menu name
  44. Adding %author% in custom post type URL structure?
  45. Syntax to get the Nth item in a list of custom post types?
  46. Problem excluding category from get_next_post
  47. remove support for ‘Categories’ for a custom post type
  48. Display different gutenberg template from selected post attributes
  49. Display custom taxonomy as dropdown list
  50. WordPress is executing URL in code when called via wp_mail()
  51. How to display the categories of the post? (custom post type)
  52. How to use custom fields to enable sticky posts on custom post types?
  53. Pagination problem
  54. Custom meta fields for specific custom type only
  55. Display different custom post type each week
  56. How do I create a form to search a custom post type
  57. Setting posts per page in query_posts
  58. How to insert content from another Custom Post type into Post?
  59. Insert HTML inside link in a walker
  60. Using global $post; to get featured image for custom post via WP_Query
  61. How do I order multiple custom post types in the same menu position ( menu_position = 20 – below Pages)?
  62. Add archive slug to default post post type
  63. Custom Post type and permalink settings
  64. How to order separated Custom Post Search results
  65. Set URL link to featured image of custom post type
  66. Rewrite CPT child page URL to support query var
  67. Pagination with custom query, custom search form, single and pages, ajax and no plugins
  68. PHP Code to Display Term URL & Name of a Post Under a Custom Post Type
  69. Flush Rewrite Rules when new site is created on network
  70. Problems wp_insert_post and save_posts filter
  71. Cant get paginations on single.php to work with my custom post types
  72. Loop to display custom post type from a custom Taxonomy
  73. the_content(); of custom post type treated as an array or object
  74. Getting a custom post’s custom field based on another custom post’s custom field select
  75. Inserting custom fields into single.php
  76. Is it possible to have “two” sets of tags?
  77. Custom post type is using the index.php template
  78. Redirect Existing Post to CPT
  79. Grouping custom wordpress post types by acf value
  80. Get_post_custom not fetching value from array wordpress
  81. Creating a custom post type upon registration for a specific user role
  82. WordPress Post ID overwritten when I create a new post?
  83. I cannot display custom posts in custom taxonomy
  84. Publish metabox postition?
  85. How to change URL structure for custom post type in wordpress? Custom taxonomy + custom Post name [duplicate]
  86. Custom taxonomy with custom post type template not showing
  87. Loop to display parent categories in custom taxonomy
  88. Collect custom post in a calendar
  89. CPT Efficient way to display posts from different categories with custom query
  90. Extensive search filtering and results->PDF in the front-end
  91. How to add a custom post type in child theme? (WordPress > 3.0)
  92. Displaying wp post categories into my custom metabox
  93. Advanced search form with filters for custom taxonomies and custom fields
  94. $wpdb returns no results with SELECT query on custom post type, works on default post type
  95. current_page_item and custom post type?
  96. How to display custom message for (Genesis) featured posts if no posts
  97. One set of categories for multiple custom posts
  98. CPT Archive Pagination – Page not found
  99. How to add categories to a custom post type using wp_insert_post($new_post);
  100. Modify permalink of CPT archive to support two taxonomies