Inserting a post in Wordpress using MySql

Question

Does anyone know how to insert a new post into Wordpress using sql?

Answer 1

You can use the Post object:

// Create post object   $my_post = array();   $my_post['post_title'] = 'My post';   $my_post['post_content'] = 'This is my post.';   $my_post['post_status'] = 'publish';   $my_post['post_author'] = 1;   $my_post['post_category'] = array(8,39);  // Insert the post into the database   wp_insert_post( $my_post ); 

More info found here.

Answer 2

Your question asks how to insert a new post into WordPress using SQL. If you really wanted to do that, taking a look at the "wp" database tables and do a standard INSERT - this wouldn't be hard.

But I'd strongly recommend against doing this - even if you want to create a separate admin dashboard outside of the normal WP-provided one, you should use the core functions/API that they provide. For example, the wp_insert_post function is what you want to use.

I believe you can use/load these functions by including /wp-load.php.