為什么說非對象調用成員函數fetch()
問題描述
<?phpclass Db{ private $dbConfig=['db'=>'mysql','host'=>'localhost','port'=>'3306','user'=>'root','pass'=>'root','charset'=>'utf8','dbname'=>'edu',]; //單例模式 private static $instance = null; public $insertID = null; public $num1 = null; ///數據庫的連接 private $conn = null; private function __construct($params) {//初始化參數array_merge($this->dbConfig, $params);//連接數據庫$this->connect(); } private function __clone() {// TODO: Implement __clone() method. } public static function getInstance($params=[]) {if(!self::$instance instanceof self){ self::$instance = new self($params);}return self::$instance; } private function connect() {try {$dsn="{$this->dbConfig['db']}:host={$this->dbConfig['host']};port={$this->dbConfig['port']};dbname={$this->dbConfig['dbname']};charset={$this->dbConfig['charset']}";//創建pdo對象$this->conn= new PDO($dsn,$this->dbConfig['user'],$this->dbConfig['pass']); //// $this->conn->query("SET NAMES {$this->dbConfig['charset']}");}catch (PDOException $e){ die('數據庫連接失敗'.$e->getMessage());} } public function exec($sql) {$num = $this->conn->exec($sql);if($num>0){ if(null !== $this->conn->lastInsertID()) {$this->insertID = $this->conn->lastInsertID(); } $this->num1= $num;}else{ $error = $this->conn->errorInfo(); //0 是錯誤標識符 1 是錯誤代碼 2 是錯誤信息 print '操作失敗'.$error[0].':'.$error[1].':'.$error[2];} } public function fetch($sql) {return $this->conn->query($sql)->fetch(PDO::FETCH_ASSOC); } public function fetchALl($sql) {return $this->conn->query($sql)->fetch(PDO::FETCH_ASSOC);; }}
問題解答
回答1:pdo對象沒有獲取成功,調用了一個對象成員方法fetch, 檢查連接參數
相關文章:
1. javascript - 原生canvas中如何獲取到觸摸事件的canvas內坐標?2. sql語句 - mysql中關聯表查詢問題3. javascript - iframe 為什么加載網頁的時候滾動條這樣顯示?4. javascript - vscode alt+shift+f 格式化js代碼,通不過eslint的代碼風格檢查怎么辦。。。5. javascript - [js]為什么畫布里不出現圖片呢?在線等6. javascript - 有什么比較好的網頁版shell前端組件?7. javascript - 求解答:實例對象調用constructor,此時constructor內的this的指向?8. javascript - 如何將一個div始終固定在某個位置;無論屏幕和分辨率怎么變化;div位置始終不變9. css - chrome下a標簽嵌套img 顯示會多個小箭頭?10. html - vue項目中用到了elementUI問題
