在我的站点中，我希望从另一个表中提取数据，而不必从另一个站点创建API。我已经看到你可以这样做：

$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 />\';
}

然而，我不喜欢把所有东西都放在一个楔子里，包括数据库凭据。

What I\'ve tried:

已将凭据添加到wp-config.php

define(\'DB_CAREERS_NAME\', \'careers\');
define(\'DB_CAREERS_USER\', \'root\');
define(\'DB_CAREERS_PASSWORD\', \'\');
define(\'DB_CAREERS_HOST\', \'localhost\');
define(\'DB_CAREERS_CHARSET\', \'utf8mb4\');
define(\'DB_CAREERS_COLLATE\', \'\');

将函数添加到functions.php

function get_job_listings()
{
    // Create new wpdb instance
    $connection = new wpdb(DB_CAREERS_USER, DB_CAREERS_PASSWORD, DB_CAREERS_NAME, DB_CAREERS_HOST);

    // Assign a table prefix
    $connection->set_prefix(\'\');

    // Status of jobs to show
    $status = "Open";

    // Perform query
    $query = $connection->prepare(
        "SELECT j.*
        FROM $connection->job_posts j
        WHERE j.status = \'%s\'
        ORDER BY j.created_at DESC",
        $status
    );

    $jobs = $connection->get_results($query);

    return $jobs;
}

但是我想使用我的辅助数据库连接，就像使用标准的WordPress查询一样，以便所有查询生成器功能都可用。