84669 Lernen von Personen
152542 Lernen von Personen
20005 Lernen von Personen
5487 Lernen von Personen
7821 Lernen von Personen
359900 Lernen von Personen
3350 Lernen von Personen
180660 Lernen von Personen
48569 Lernen von Personen
18603 Lernen von Personen
40936 Lernen von Personen
1549 Lernen von Personen
1183 Lernen von Personen
32909 Lernen von Personen
Mein Code erhält ständig Fehler: Schwerwiegender Fehler: Aufruf einer Mitgliedsfunktion exec() auf Null
<?php
class db{
private $dbConfig = [
'db' => 'mysql',
'host' => 'localhost',
'port' => '3306',
'dbname' => 'one',
'user' => 'root',
'password' => '1234',//
'charset' => 'utf'
];
public $insertId = null;
public $num = 0;
private static $instance = null;
private $conn = null;
private function __construct($params){
$this->dbConfig = array_merge($this->dbConfig,$params);
$this->conncet();
}
private function __clone(){
public function getInstance(){
if(!self::$instance instanceof self){
self::$instance = new self();
return self::$instance;
public function connect(){
try{
$dsn = "{$this->dbConfig['db']}:{$this->dbConfig['host']};
port = {$this->dbConfig['port']};
charset = {$this->dbConfig['charset']}";
$this->conn = new pdo($dsn,$this->dbConfig['user'],$this->dbConfig['password']);
catch(PDOExecption $e){
die("数据库连接失败".$e->getMessage());
// 完成数据表的写操作 新增 更新 删除
// 返回受影响的记录 如果新增还返回新增主键id
public function exec($sql){
$num = $this->conn->exec($sql);
// 如果有受影响的记录
if($num>0){
// 如果是新增操作 初始化新增主键ID的属性
if(null !==$this->conn->lastInsertId()){
$this->insertId = $this->conn->lastInsertId();
$this->num = $rum;//返回受影响的记录
}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){
<?php
class db{
private $dbConfig = [
'db' => 'mysql',
'host' => 'localhost',
'port' => '3306',
'dbname' => 'one',
'user' => 'root',
'password' => '1234',//
'charset' => 'utf'
];
public $insertId = null;
public $num = 0;
private static $instance = null;
private $conn = null;
private function __construct($params){
$this->dbConfig = array_merge($this->dbConfig,$params);
$this->conncet();
}
private function __clone(){
}
public function getInstance(){
if(!self::$instance instanceof self){
self::$instance = new self();
}
return self::$instance;
}
public function connect(){
try{
$dsn = "{$this->dbConfig['db']}:{$this->dbConfig['host']};
port = {$this->dbConfig['port']};
charset = {$this->dbConfig['charset']}";
$this->conn = new pdo($dsn,$this->dbConfig['user'],$this->dbConfig['password']);
}
catch(PDOExecption $e){
die("数据库连接失败".$e->getMessage());
}
}
// 完成数据表的写操作 新增 更新 删除
// 返回受影响的记录 如果新增还返回新增主键id
public function exec($sql){
$num = $this->conn->exec($sql);
// 如果有受影响的记录
if($num>0){
// 如果是新增操作 初始化新增主键ID的属性
if(null !==$this->conn->lastInsertId()){
$this->insertId = $this->conn->lastInsertId();
}
$this->num = $rum;//返回受影响的记录
}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);
}
}