I am trying to bulk insert Wordpress pages into database directly. I feel like I used to just be able to insert into wp_posts, with post_content as the page content.
However, this theme/setup/new WP has the content sections in a sub-section of the page builder, and it's using Title and Caption for each content section.
I tried manually adding a section, and see what SQL inserts are done, and I can just replicate that. But not sure why they're not working when I do.
I'm not using any Native WP functions as of right now. Just PHP to insert SQL.
I tried adding post_meta entries to just add a content section, but not sure that random string behind field_XXXXXXX, and if thats required. When I added the below SQL, they didn't show up in backend nor front end.
I just need to be able to dynamically create a page in wp_post, and auto-add wp_postmeta entires for each content paragraph (title, content) for each one. But either I'm doing something wrong with the wp_postmeta queries?
Thoughts? Is there a plugin for this? or a more direct native approach?
Tried inserting SQL directly. Not working.
INSERT INTO `wp_postmeta` (`meta_id`, `post_id`, `meta_key`, `meta_value`) VALUES
(24748, 274, 'post_content_1_title', 'test4'),
(24749, 274, '_post_content_1_title', 'field_5cf6a56fecee5'),
(24750, 274, 'post_content_1_caption', 'test4content_goes_here'),
(24751, 274, '_post_content_1_caption', 'field_5cf6a58decee6');
I expect the insert SQL to successful insert a Content block of TITLE and CONTENT into my Wordpress Page, just from an SQL insert. Both Page and content sections need to be done from php/mysql query.
