Simple pgsql pdo php operation class implementation code, pgsqlpdo

Simple pgsql pdo php operation class implementation code, pgsqlpdo

Core code:

/** Pgsql class */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 = "database initialization failed, forcibly disconnected. <Br/> the captured exception stack is as follows: <br/> <pre> ". print_r ($ ex, true ). "</pre>"; 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 <! DOCTYPE html>