SQL queries from an external DB in WordPress
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
Comments
-
Fernando Madriaga almost 2 years
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
-
Bennett Forkner almost 4 yearsDoes this work with a sqlserver database? Or only with mySQL?
-
LoicTheAztec almost 4 years@BennettForkner This works for wordpress and all databases that wordpress allow.