我正在为安装了WP域的用户开发一个项目。
我将数据存储在WP使用的同一个DB中（只是存储在不同的表中）。
我不能使用include函数来获取文件，也不能简单地使用其中的信息，因为根据http://wordpress.stackexchange.com的一位用户的说法，在发布了关于我在这样做时遇到的问题（只有有时）的问题（包括文件时遇到的问题）后，wp-config.php永远不应该包含在文件中。
现在，我已经有了一个选项（因为灌输wp-config.php问题仅有时遇到）：
我正在处理的应用程序需要（由用户）安装才能运行。因此，在安装过程中，我只需包含wp-config.php文件ONCE，复制我需要的信息，并将其放入我自己的文件中，然后将其用于应用程序的其余部分。
上述解决方案的问题是，如果我在安装过程中遇到这些问题怎么办？用户将不得不一次又一次地尝试，直到它工作为止。=不高兴的用户。
我有什么想法可以用来简化这个问题吗？
这篇博客文章似乎已经找到了你想要的答案，并配有代码。作者按照你在问题中链接的文章评论中的建议进行了操作。
文章节选：
我需要一个从wp-config.php中提取数据库详细信息的脚本文件，以便在在WP框架之外进行编码。
我想出了一个这样做的类，连接到mysql并选择数据库。有三种连接选项：
PDO、mySQLi或程序CCD_ 6。
更新：由于原始博客文章不可用，以下是原始代码：
<?php
/**
* This class pulls the database logon information out of wp-config.
* It then evals the settings it finds into PHP and then makes the
* database connection.
*
* Acts as a Singleton.
*
* @package wpConfigConnection
* @author Mark Flint
* @link www.bluecubeinteractive.com
* @copyright Please just leave this PHPDoc header in place.
*/
Class wpConfigConnection
{
/**
* @var object $_singleton This is either null in the case that this class has not been
* called yet, or an instance of the class object if the class has been called.
*
* @access public
*/
private static $_singleton;
/**
* @var resource $_con The connection.
* @access public
*/
public $_con;
/**
* The wp-config.php file var
* @var string $str The string that the file is brought into.
* @access private
*/
private $str;
/**
* @var $filePath Path to wp-config.php file
* @access private
*/
private $filePath;
/**
* @var array Array of constant names used by wp-config.php for the
* logon details
* @access private
*/
private $paramA = array(
'DB_NAME',
'DB_USER',
'DB_PASSWORD',
'DB_HOST'
);
/**
* @var bool $database Can check this var to see if your database was connected successfully
*/
public $_database;
/**
* Constructor. This function pulls everything together and makes it happen.
* This could be unraveled to make the whole thing more flexible later.
*
* @param string $filePath Path to wp-config.php file
* @access private
*/
private
function __construct($type = 1, $filePath = './wp-config.php')
{
$this->filePath = $filePath;
$this->getFile();
$this->serverBasedCondition();
/**
* eval the WP contants into PHP
*/
foreach($this->paramA as $p)
{
$this->evalParam('define(''' . $p . '''', ''');');
}
switch ($type)
{
default:
case 1:
$this->conMySQL_Connect();
break;
case 2:
$this->conPDO();
break;
case 3:
$this->conMySQLi();
break;
}
}
/**
* Make the connection using mysql_connect
*/
private
function conMySQL_Connect()
{
try
{
if (($this->_con = @mysql_connect(DB_HOST, DB_USER, DB_PASSWORD)) == false)
{
throw new Exception('Could not connect to mySQL. ' . mysql_error());
}
}
catch(Exception $e)
{
exit('Error on line ' . $e->getLine() . ' in ' . $e->getFile() . ': ' . $e->getMessage());
}
try
{
if (($this->_database = mysql_select_db(DB_NAME, $this->_con)) == false)
{
throw new Exception('Could not select database. ' . mysql_error());
}
}
catch(Exception $e)
{
exit('Error on line ' . $e->getLine() . ' in ' . $e->getFile() . ': ' . $e->getMessage());
}
}
/**
* Make the connection using mySQLi
*/
private
function conMySQLi()
{
$this->_con = @new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
if (mysqli_connect_errno())
{
exit('MySQLi connection failed: ' . mysqli_connect_error());
}
}
/**
* Make the connection using PDO
*/
private
function conPDO()
{
try
{
$dsn = 'mysql:host=' . DB_HOST . ';dbname=' . DB_NAME;
$this->_con = @new PDO($dsn, DB_USER, DB_PASSWORD);
}
catch(PDOException $e)
{
exit('Error on line ' . $e->getLine() . ' in ' . $e->getFile() . ': ' . $e->getMessage());
}
}
/**
* Read the wp-config.php file into a string
*
* @access private
*/
private
function getFile()
{
try
{
$this->str = @file_get_contents($this->filePath);
if ($this->str == false)
{
throw new Exception('Failed to read file (' . $this->filePath . ') into string.');
}
}
catch(Exception $e)
{
exit('Error on line ' . $e->getLine() . ' in ' . $e->getFile() . ': ' . $e->getMessage());
}
}
/**
* Get the logon parameter and evaluate it into PHP.
* Eg, eval("define('DB_NAME', 'm4j3lub3_wordpress');");
*
* @param string $pre This defines what to look for at the start of a logon parameter
* definition. Eg, if you are looking for "define('DB_NAME', 'm4j3lub3_wordpress');"
* then the $pre bit would be "define('DB_NAME'".
*
* @param string $post Like $pre, this defines what to look for at the end of the logon
* parameter definition. In the case of WordPress it is always going to be "');"
*
* @access private
*/
private
function evalParam($pre, $post)
{
$str = $this->str;
$str1 = substr($str, strpos($str, $pre));
$str1 = substr($str1, 0, strpos($str1, $post) + strlen($post));
eval($str1);
}
/**
* Grab the right code block if there are more than one set of definitions
*
* Sets $this->str to be the right code block
*
* Used for when there are conditional settings based on local or remote configuration,
* using the condition: if ($_SERVER['HTTP_HOST']=='localhost') { ...
*
* @access private
*/
private
function serverBasedCondition()
{
if (strpos($this->str, '$_SERVER["HTTP_HOST"]') || strpos($this->str, '$_SERVER[''HTTP_HOST'']'))
{
if (strpos($this->str, '$_SERVER["HTTP_HOST"]'))
{
// case of double quotes - get a substring
$this->str = substr($this->str, strpos($this->str, '$_SERVER["HTTP_HOST"]'));
}
elseif (strpos($this->str, '$_SERVER[''HTTP_HOST'']'))
{
// case of single quotes - get a substring
$this->str = substr($this->str, strpos($this->str, '$_SERVER[''HTTP_HOST'']'));
}
// substring from 1st occurance of {
$this->str = substr($this->str, strpos($this->str, '{') + 1);
if ($_SERVER['HTTP_HOST'] == 'local.dev')
{
// local - substring from start to 1st occurance of } - this is now the block
$this->str = substr($this->str, 0, strpos($this->str, '}') - 1);
}
else
{
// remote - substring from the else condition
$this->str = substr($this->str, strpos($this->str, '{') + 1);
$this->str = substr($this->str, 0, strpos($this->str, '}') - 1);
}
// replace all double quote with single to make it easier to find the param definitions
$this->str = str_replace('"', '''', $this->str);
}
}
/**
* Return an instance of the class based on type of connection passed
*
* $types are:
* 1 = Procedural connection using mysql_connect()
* 2 = OOP connection using PHP Data Objects (PDO)
* 3 = OOP connection using mySQLi
*
* @return resource Database connection
* @access private
*/
private static
function returnInstance($type)
{
if (is_null(self::$_singleton))
{
self::$_singleton = new wpConfigConnection($type);
}
return self::$_singleton;
}
/**
* Action the return of the instance based on Procedural connection using mysql_connect()
*
* @access public
* @return resource Procedural connection using mysql_connect()
*/
public static
function getInstance()
{
return self::returnInstance(1);
}
/**
* Action the return of the instance based on OOP connection using PDO
*
* @access public
* @return resource OOP connection using PHP Data Objects (PDO)
*/
public static
function getPDOInstance()
{
return self::returnInstance(2);
}
/**
* Action the return of the instance based on OOP connection using mySQLi
*
* @access public
* @return resource OOP connection using mySQLi
*/
public static
function getMySQLiInstance()
{
return self::returnInstance(3);
}
}
// USAGE EXAMPLES
// mysql_connect example
$mfdb = wpConfigConnection::getInstance();
try
{
$query = 'select * FROM wp_users';
$res = mysql_query($query);
if ($res == false)
{
throw new Exception('mySQL error: ' . mysql_error() . '. Query: ' . $query);
}
}
catch(Exception $e)
{
echo 'Error on line ' . $e->getLine() . ' in ' . $e->getFile() . ': ' . $e->getMessage();
exit;
}
while ($row = mysql_fetch_assoc($res))
{
echo $row['user_login'] . '<br />';
}
// PDO example, showing prepared statement with bound value
$mfdb = wpConfigConnection::getPDOInstance();
$mfdb->_con->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
$mfdb->_con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$query = "SELECT * FROM wp_users WHERE 1=:cond";
$stmt = $mfdb->_con->prepare($query);
$stmt->bindValue(':cond', 1);
$stmt->execute();
while ($row = $stmt->fetch())
{
echo $row['user_login'] . '<br />';
}
$mfdb->_con = null;
// mySQLi example
$mfdb = wpConfigConnection::getMySQLiInstance();
$sql = ' SELECT * FROM wp_users';
if (!$mfdb->_con->real_query($sql))
{
echo 'Error in query: ' . $mfdb->_con->error;
exit;
}
if ($result = $mfdb->_con->store_result())
{
while ($row = $result->fetch_assoc())
{
echo $row['user_login'] . '<br />';
}
}
$result->close();
?>
来源：https://web.archive.org/web/20130410000149/www.markflint.net/parsing-wordpress-wp-config-php-file/
对于必须与WordPress安装集成的项目，我总是包含'wp-blog-header.php'。
将WordPress与您的网站集成
示例：
<?php
/* Short and sweet */
define('WP_USE_THEMES', false);
require('./wp-blog-header.php');
?>
阅读评论后，我建议（在安装过程中）编写一个脚本，查找WordPress的配置文件，提取DB_NAME、DB_USER、DB_PASSWORD、DB_HOST、DB_CHARSET、DB_COLLATE的定义值，并将它们存储在您自己的配置文件中。
我建议在主题文件夹中创建一个名为page-custom-name.php的文件，并发布一个标题为"自定义名称"的空页面。现在，当您访问www.yoursite/custom-name时，您将看到该页面。
在page-custom-name.php中，您只需键入：
global $wpdb;
并且您可以访问数据库：）
<?php
require_once('wp-load.php');
// your script here. which conforms to wordpress standards.
如果您只想访问wp-config.php而不想访问Wordpress的其他函数。
执行以下步骤：
1：在插件目录中创建一个空的wp-settings.php文件
2：将此广告到您的php文件
define( 'ABSPATH', $_SERVER['DOCUMENT_ROOT'].'/wp-content/plugins/YOUR_PLUGIN_DIR/' ); require_once( $_SERVER['DOCUMENT_ROOT'] . '/wp-config.php' );
这非常适合WordPress 4.2.4"向下和向上"，我在我们自己的插件mywebapplets中测试了它。
这是Soner Gönül解决方案的变体，也是基于独立脚本的。请小心将此文件放在除您之外没有人可以访问的地方（例如：Apache密码保护的文件夹或其他有访问限制的域）。执行以下步骤：
1-创建一个名为wp-settings.php 的空php脚本
2-假设你的WordPress文件夹的路径是/var/www/html/，将下面的代码添加到另一个脚本中（例如：db-info.php），放在与以前创建的空脚本相同的文件夹中。
<?php
// you are defining ABSPATH here, so wp-config.php won't be able to define it again. The result is that wp-config.php, when required, will require your empty script (and not the real wp-settings.php), avoiding this way the start of WordPress loading.
define('ABSPATH', __DIR__ . '/');
// assuming that the path to your WordPress folder is /var/www/html/. Typing the path directly, instead of using $_SERVER['DOCUMENT_ROOT'], will allow you to run the script from anywhere (another domain of your server, for example).
require_once '/var/www/html/wp-config.php';
3-要查看代码的工作情况：在脚本的末尾添加以下行，
echo DB_NAME . '<br>';
echo DB_HOST . '<br>';
并使用浏览器进行测试，访问：http://'one-of-your-domains/path-to-db-info.php