Direct read/write to database | WordPress.org

Resolved bloggy2013
(@bloggy2013)

10 years ago

Does anyone know of a (safe) extension which would allow woo to manipulate a table in a separate mysql database?

We basically need woo to read some fields in order to know how to handle an order then change a field or two in another database. This will allow users in another app to manage their app subscriptions using woo.

The app is yii while the woocommerce app has to be installed and running on a wordpress site.

https://wordpress.org/plugins/woocommerce/

Viewing 6 replies - 1 through 6 (of 6 total)

Plugin Contributor Mike Jolley
(@mikejolley)

10 years ago

You’d need code using direct MYSQL query/connect functions instead of using $wpdb I think here. If it’s on the same server that is.

If it’s not you’d need an API in the other system which you can call and set/get data.

Thread Starter bloggy2013
(@bloggy2013)

10 years ago

Hi, thanks for the reply.

Yes, it can be on the same server but we’ve used a plugin for stuff like this in the past which allowed us to use a separate db server too.

Just wondered if anyone knew of a bridge between woocommerce and yii mainly.

Thanks again.

Plugin Contributor Mike Jolley
(@mikejolley)

10 years ago

I don’t know of an existing solution for it.

Thread Starter bloggy2013
(@bloggy2013)

10 years ago

Here are some other solutions I’ve come up with.

https://docs.woothemes.com/document/woocommerce-rest-api/

https://packagist.org/packages/woothemes/woocommerce-api

Plugin Contributor Mike Jolley
(@mikejolley)

10 years ago

Thats a way to get the data, but it won’t write it anywhere. You still need to facilitate that.

Thread Starter bloggy2013
(@bloggy2013)

10 years ago

Yes, that will be programmed as a bridge but thought I’d share what I have found too.

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Direct read/write to database’ is closed to new replies.

6 replies
2 participants
Last reply from: bloggy2013
Last activity: 10 years ago
Status: resolved