How to import a custom MySQL DB table into a WordPress custom post type

Question

What I’ve done so far is create a plugin that creates a custom post type, takes a field(ID from the custom DB) and also creates a couple of page templates.

I have a custom MySQL DB that is on the same server as a WP install. What I need is to import a MySQL DB table into a WP custom post type.

I can’t figure out how to import the data itself straight from one MySQL DB to the WP using PHP. The catch is, I need this to happen whenever the custom MySQL DB is updated.

If it helps, we do have a REST API that we can use. I was just trying to make this as hands off as possible.

Any and all help is appreciated!!

0
, , , lz430 2 years 2020-01-12T08:42:23-05:00 0 Answers 80 views 0

Leave an answer

Browse
Browse