When accessing the database in WordPress, you need to use the global variable $wpdb
. This will take the constants you set in wp-config.php to connect to your database and retrieve whichever results you specify. But what if you have a second database you wish to connect to for whatever reason? To do that all you need is the following snippet:
$newdb = new wpdb($DB_USER, $DB_PASSWORD, $DB_NAME, $DB_HOST); $newdb->show_errors();
Add the code snippet to your functions.php file or a specific page template, and then you can use $newdb
just like you would $wpdb
to access a second database and retrieve some data.