在我的站点中,我希望从另一个表中提取数据,而不必从另一个站点创建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查询一样,以便所有查询生成器功能都可用。