Sitego, У тебя уже там синглтон есть, только конструктор очистить надо и все
__construct (+/-)
class DB
{
// Данные для подключения
//private $db_config = array
//(
// 'dbHost' => 'localhost',
// 'dbName' => 'name_base',
// 'dbUser' => 'admin_base',
// 'dbPass' => 'pass_base'
//);
/**
* @var object - Singleton
*/
protected static $_instance;
/**
* Query counter
* @var int
*/
public $query_count = 0;
/**
* Errors
* @var array
*/
public $errors = array();
private $connect;
/**
* Class constructor
*/
private function __construct()
{
//$db_host = isset($this->db_config['HOST']) ? $this->db_config['HOST'] : 'localhost';
//$db_user = isset($this->db_config['USER']) ? $this->db_config['USER'] : '';
//$db_pass = isset($this->db_config['PASSWORD']) ? $this->db_config['PASSWORD'] : '';
//$db_name = isset($this->db_config['DATABASE']) ? $this->db_config['DATABASE'] : '';
$this->connect = new mysqli(DBHOST, DBUSER, DBPASS, DBNAME);// NEW CODE
if ($this->connect->connect_errno) {
echo "Error: cannot connect to database server: " . $this->connect->connect_error;
}
$this->query("SET NAMES 'utf8'");
}
// remaining codeиспользуешь
define ("DBHOST", 'localhost');
define ("DBNAME", 'john');
define ("DBUSER", 'root');
define ("DBPASS", 'pass');
// так
DB::getInstance();
$result=DB::getInstance()->query('select name from users;')->fetch_row();
// или так()
$db = DB::getInstance();
$res=$db->query('select name from users;')->fetch_row();