class db { private static $db = NULL; public $dbHost = 'ホスト'; public $dbPort = 'ポート'; public $dbName = 'データベース名'; public $dbUser = 'ユーザ名'; public $dbPass = 'パスワード'; public $dbCharSet = '文字コード'; public $sql = NULL; /* Constructer * Singleton */ private function __construct(){ try{ $dsn = 'mysql:host='.$this->dbHost.';port='.$this->dbPort.';dbname='.$this->dbName; self::$db = new PDO($dsn, $this->dbUser, $this->dbPass, array( PDO::MYSQL_ATTR_INIT_COMMAND => 'SET CHARACTER SET '.$this->dbCharSet)); self::$db->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true); }catch(PDOException $e){ header('Content-type: text/plain; charset=UTF-8'); die('データベースの接続に失敗しました。:'.$e->getMessage()); } } public static function getInstance(){ if (is_null(self::$db)) { new self; } return self::$db; } }