当前位置： 维易PHP培训学院 > PHP学习 > 内容正文

PHP应用：简单的pgsql pdo php操作类实现代码

作者：VEPHP   时间 2017-09-26

《PHP应用：简单的pgsql pdo php操作类实现代码》要点：
本文介绍了PHP应用：简单的pgsql pdo php操作类实现代码，希望对您有用。如果有疑问，可以联系我们。

PHP教程核心代码：

  1. PHP教程
  2. /*
  3. *pgsql类
  4. */
  5. class pgdb {
  6.  public $pdo;
  7.  public static $PDOInstance;
  8.  public $config;
  9.  public $data;
  10.  public $filed = '*';
  11.  public $table;
  12.  public $limit;
  13.  public $order;
  14.  public $where;
  15.  public $left;
  16.  const LOGIN = 7;
  17.  const USER = 1;
  18.  const GROUP = 2;
  19.  const USERGROUP = 3;
  20.  const LOG = 6;
  21.  const WARING = 1;
  22.  const ERROR = 2;
  23.  const INFO = 0;
  24.  public function __construct() {
  25.   if (!self::$PDOInstance) {
  26.     $this->config = json_decode(file_get_contents("./config/db.json"), true);
  27.     $config = $this->config;
  28.     $host = $config["data_base"]["db_host"];
  29.     $dbname = $config["data_base"]["db_name"];
  30.     $port = $config["data_base"]["db_port"];
  31.     $username = $config["data_base"]["db_user"];
  32.     $password = $config["data_base"]["db_pwd"];
  33.     if ($config["data_base"]["db_host"] != 'localhost') {
  34.       $hosturl = "host=$host;";
  35.     }
  36.     try
  37.     {
  38.       self::$PDOInstance = new PDO("pgsql:"
  39.         . $hosturl
  40.         . "port=$port;"
  41.         . "dbname=$dbname;"
  42.         , $username
  43.         , $password
  44.         , array(
  45.           PDO::ATTR_PERSISTENT => true,
  46.         )
  47.       );
  48.     } catch (Exception $ex) {
  49.       header("Content-type: text/html; charset=utf-8");
  50.       $error = "数据库初始化失败,已强制断开链接.<br />抓取到的异常栈如下：<br /><pre>" . print_r($ex, true) . "</pre>";
  51.       die($error);
  52.     }
  53.     try {
  54.       self::$PDOInstance->query("SET client_encoding='UTF-8';");
  55.       self::$PDOInstance->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
  56.       self::$PDOInstance->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  57.      } catch (Exception $exc) {
  58.      $this->pdo=NULL;
  59.      $doc = <<<DOC
  60.      <!DOCTYPE html>
  61.      <html>
  62.       <head>
  63.         <meta charset="UTF-8">
  64.         <script src="layer/jquery-1.11.1.min.js"></script>
  65.         <script src="layer/layer.js"></script>
  66.       <head>
  67.      <body>
  68. DOC;
  69.     print $doc;
  70.     $info=L('服务器变更请刷新');
  71.     print("<script>layer.msg('".$info."', {icon: 2,time: 30000},function(){location.reload();});</script>");
  72.     print('</body></html>');
  73.     exit();
  74.     }
  75.    }
  76.   
  77.    $this->pdo = self::$PDOInstance;
  78.   }
  79. }

转载请注明本页网址：
http://www.vephp.com/jiaocheng/3978.html


    标签：  




同类教程排行


特辑教程