SQL queries from an external DB in WordPress

Question

Actually I have a php website in my hosting. Now I am personalizing a Wordpress theme to replace it. It's all ok for now, but the old website has a built in function to connect to another database with a token. This connection is only to get some data.

Can you tell me how to implement this in my new wordpress theme?
Did a wordpress plugin exists for this?

Thanks

what database? where? WP is nailed at the hips to mysql, generally, and won't know how to talk to a "foreign" db, especially if the old site is using vendor extensions in the sql syntax. — Marc B
– Marc B, Commented Jun 17, 2016 at 16:53
@MarcB If you look at the tags it's Mysql related database. With this trick you can use any query and work on it with php. I have done this before many times. — LoicTheAztec
– LoicTheAztec, Commented Jun 17, 2016 at 17:02
@LoicTheAztec: doesn't mean much. WP implies mysql, but "external database" DOESN'T — Marc B
– Marc B, Commented Jun 17, 2016 at 17:05
@MarcB Ok if you say it, then… The OP is satisfy with my answer, for his needs. That is the main purpose here. You can use WP API for all other cases or build a special plugin. — LoicTheAztec
– LoicTheAztec, Commented Jun 17, 2016 at 17:06

Community · Accepted Answer · 2017-04-13 12:37:31Z

7

The easiest way to connect wordpress to a second database (without a token) is to add this little piece of code (replacing strings by your connexion data) :

$wpdb2 = new WPDB( 'remote_user', 'remote_password', 'remote_db', 'remote_server');

Then you can use this new object to query anything that you want to, just like the main $wpdb object. You can use this on the function.php file of your active child theme (or theme).

I think that maybe there is some plugins, for this kind of purpose… You will have to search.

Reference: Using wpdb to connect to a separate database

edited Apr 13, 2017 at 12:37

CommunityBot

11 silver badge

answered Apr 21, 2016 at 4:21

LoicTheAztec

257k25 gold badges403 silver badges451 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Bennett Forkner Over a year ago

Does this work with a sqlserver database? Or only with mySQL?

LoicTheAztec Over a year ago

@BennettForkner This works for wordpress and all databases that wordpress allow.

Collectives™ on Stack Overflow

SQL queries from an external DB in WordPress

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related