我試圖使用 PHP 中的公共函數(shù)從表中獲取數(shù)據(jù)，但出現(xiàn)以下錯誤：未捕獲的錯誤：調用成員函數(shù)prepare()（PDO，php）我搜索了 2、3 個小時...但沒有類似的結果或者我不明白。<?phpclass Config { public static $SQL; private function __construct() { $host_name = "localhost"; $base_user = "root"; $base_pass = ""; $base_name = "home_page"; try { self::$SQL = new PDO("mysql:host=$host_name;dbname=$base_name", $base_user, $base_pass); self::$SQL->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); echo "Connected successfully"; } catch(PDOException $e) { die("Something went wrong, database connection closed. Reason: ". $e->getMessage()); } } public static function GetData($table, $data, $id) { $wc = Config::$SQL->prepare('SELECT `'.$data.'` FROM `'.$table.'` WHERE `ID` = ?'); $wc->execute(array($id)); $r_data = $wc->fetch(); return $r_data[$data]; }}?>我在我的基本文件中使用它：<h1><?php echo Config::GetData("page_details", "Moto", 1) ?></h1>錯誤來自這一行：$wc = self::$SQL->prepare('SELECT `'.$data.'` FROM `'.$table.'` WHERE `ID` = ?');
1 回答
呼啦一陣風
TA貢獻1802條經(jīng)驗 獲得超6個贊
您想在任何地方使用有什么特殊原因嗎STATIC？常見的方法是使用公共的動態(tài)方法和屬性。我用 PHP OOP 中建議的命名約定重寫了您的示例，它有效：
<?php
class Config
{
/** @var PDO $conn */
private $conn = null;
public function __construct()
{
$host_name = "localhost";
$base_user = "root";
$base_pass = "";
$base_name = "home_page";
try {
$this->conn = new PDO("mysql:host=$host_name;dbname=$base_name", $base_user, $base_pass);
$this->conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
echo "Connected successfully"; // <- this is unnnesesary
} catch (PDOException $e) {
die("Something went wrong, database connection closed. Reason: " . $e->getMessage());
}
}
public function findById($table, $data, $id)
{
$stmt = $this->conn->prepare('SELECT `' . $data . '` FROM `' . $table . '` WHERE `uid` = ?');
$stmt->execute(array($id));
return $stmt->fetch(PDO::FETCH_ASSOC);
}
}
// just for test
$cfg = new Config();
print_r($cfg->findById('foo', '*', 1));
或者在你的情況下
<?php echo $cfg->findById("page_details", "Moto", 1)['Moto'] ?>
- 1 回答
- 0 關注
- 122 瀏覽
添加回答
舉報
0/150
提交
取消