从插件访问非wordpress数据库

Question

I'm trying to access a 'non-wordpress' database from a WordPress plugin that I am writing. I know that you can access the Wordpress database by using the <?php $wpdb->query('query'); ?> hook. I can't find anything on how to access other local databases.

So if I have another database called zipcodes, how would I access it? Is there a hook for it? I've done some searching and haven't seen much on this subject.

Thanks!

Answer 1

So I figured out how to do this. You need to use the following:

$newdb = new wpdb( 'user', 'password', 'database', 'hostname' );

From there you can use:

$newdb->get_results("SELECT your query");