How to Connect multiple database in WordPress?

PHP
1

Hi, i am looking for some example code that help me to connect multiple database in WordPress which include class that handles all the database related tasks. While working on PHP projects I have faced many issues related with php questions & answers, so I am hoping for valuable suggestions & great support from the online community.

2

Why do you need multiple databases - WordPress is designed to be able to run thousands of sites from a single database.

4

Yes you can do anything with PHP :grinning: but what is your purpose.
You could just create another config.php file and connect from there?

Example below is calling the table $mycities from $wpdbtest_otherdb

$wpdbtest_otherdb = new wpdb('myaccount_cityuser', 'mypassword', 'myaccount_cities', 'localhost');
$wpdbtest_otherdb->show_errors();
$mycities = $wpdbtest_otherdb->get_results("SELECT name
                                            FROM city
                                            WHERE city.stadium = 1");
foreach ($mycities as $mycity) {
    echo $mycity->name . '<br />';
}

Although the above example is dirty and not the most secure yet would call the data from the other DB as you might need…

PS Be more precise in your question.

5

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.