Insert data through a script directly in the db

Question

is it possible to insert data through a script or HTML site into the wpdb and this will show up as normal article in the, the same as when I use the 'create new post' page?

Which tables are affected or should I care about?

BR, mybecks

Answer 1

Yes its possible but why go over the trouble when you can use the native functions like wp_insert_post that will take care of the interaction with the database.

If you are still looking to do it directly by $wpdb then the post data is saved in the posts table, the meta data for posts is saved in the postmeta table.