PHP
php链接数据库的代码,定义私有的端口数据,
尝试通过自定义的账户和密码,运用自给的方法链接数据库,并抽象化。
?php
class MySQLDB{
private $host;
private $port;//端口
private $user;
private $pwd;
private $charset;
private $dbname;
private $link;
private static $instance;
private function __construct($config){//构造方法
$this->host = isset($config['host'])?$config['host']: '127.0.0.1';
$this->port = isset($config['port'])?$config['port']: '3306';
$this->user = isset($config['user'])?$config['user']: 'root';
$this->pwd = isset($config['pwd'])?$config['pwd']: '12345678';
$this->dbname = isset($config['dbname'])?$config['dbname']: 'blog';
}
private function __clone(){};
public static function getInstance($config){
//静态方法
if(self::$instance == null)
{
self::$instance=new MySQLDB($config);
}
return self::$instance;
}
}
private function connect()
{
$this->link = @mysqli_connect($this->host,$this->user,$this->pwd,$this->dbname,$this->port,)
or die ('链接数据库错误');
}
$config= array(
'host'=>'127.0.0.1';
'user'=>'root';
'port'=>'3306';
'pwd'=>'12345678';
'dbname'=>'blog';
);
$db1= MySQLDB::getInstance($config);
///连接数据库*