/*
*pgsql类
*/
class pgdb {
public $pdo;
public static $pdoinstance;
public $config;
public $data;
public $filed = '*';
public $table;
public $limit;
public $order;
public $where;
public $left;
const login = 7;
const user = 1;
const group = 2;
const usergroup = 3;
const log = 6;
const waring = 1;
const error = 2;
const info = 0;
public function __construct() {
if (!self::$pdoinstance) {
$this->config = json_decode(file_get_contents(./config/db.json), true);
$config = $this->config;
$host = $config[data_base][db_host];
$dbname = $config[data_base][db_name];
$port = $config[data_base][db_port];
$username = $config[data_base][db_user];
$password = $config[data_base][db_pwd];
if ($config[data_base][db_host] != 'localhost') {
$hosturl = host=$host;;
}
try
{
self::$pdoinstance = new pdo(pgsql:
. $hosturl
. port=$port;
. dbname=$dbname;
, $username
, $password
, array(
pdo::attr_persistent => true,
)
);
} catch (exception $ex) {
header(content-type: text/html; charset=utf-8);
$error = 数据库初始化失败,已强制断开链接。
抓取到的异常栈如下:
. print_r($ex, true) .
;
die($error);
}
try {
self::$pdoinstance->query(set client_encoding='utf-8';);
self::$pdoinstance->setattribute(pdo::attr_emulate_prepares, false);
self::$pdoinstance->setattribute(pdo::attr_errmode, pdo::errmode_exception);
} catch (exception $exc) {
$this->pdo=null;
$doc =
doc;
print $doc;
$info=l('服务器变更请刷新');
print();
print('');
exit();
}
}
$this->pdo = self::$pdoinstance;
}
} 以上就介绍了简单的pgsql pdo php操作类,包括了方面的内容,希望对php教程有兴趣的朋友有所帮助。