简单的pgsql pdo php操作类实现代码

发布时间:2022-04-30 发布网站:脚本宝典
脚本宝典收集整理的这篇文章主要介绍了简单的pgsql pdo php操作类实现代码脚本宝典觉得挺不错的,现在分享给大家,也给大家做个参考。

核心代码

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);

$con<a href="https://www.js-code.COM/tag/fig/" target="_blank" class="keywords">fig</a> = $this->con<a href="https://www.js-code.com/tag/fig/" target="_blank" class="keywords">fig</a>;
$host = $con<a href="https://www.js-code.com/tag/fig/" target="_blank" class="keywords">fig</a>["data_base"]["db_host"];
$dbname = $con<a href="https://www.js-code.com/tag/fig/" target="_blank" class="keywords">fig</a>["data_base"]["db_name"];
$port = $con<a href="https://www.js-code.com/tag/fig/" target="_blank" class="keywords">fig</a>["data_base"]["db_port"];
$username = $con<a href="https://www.js-code.com/tag/fig/" target="_blank" class="keywords">fig</a>["data_base"]["db_user"];
$password = $con<a href="https://www.js-code.com/tag/fig/" target="_blank" class="keywords">fig</a>["data_base"]["db_pwd"];


if ($con<a href="https://www.js-code.com/tag/fig/" target="_blank" class="keywords">fig</a>["data_base"]["db_host"] != 'localhost') {
  $hosturl = "host=$host;";
}
try
{
  self::$PDOInstance = new PDO("pg<a href="https://www.js-code.com/tag/SQL/" target="_blank" class="keywords">sql</a>:"
    . $hosturl
    . "port=$port;"
    . "dbname=$dbname;",$username,$password,array(
      PDO::ATTR_PERSISTENT => true,)
  );
} catch (Exception $ex) {
  header("Content-type: text/htML; charset=utf-8");
  $error = "<a href="https://www.js-code.com/tag/shujuku/" target="_blank" class="keywords">数据库</a>初始化失败,已强制断开<a href="https://www.js-code.com/tag/lianjie/" target="_blank" class="keywords">链接</a>。<br />抓取到的异常栈如下:<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>
 <html>
  <head>
    <<a href="https://www.js-code.com/tag/Meta/" target="_blank" class="keywords">;meta</a> charset="UTF-8"&amp;gt;
    <script src="layer/jquery-1.11.1.min.js"&gt;</script>
    <script src="layer/layer.js"&gt;</script>
  <head>
 <body>

DOC;

print $doc;
$info=L('服务器变更请刷新');
print("<script>layer.msg('".$info."',{icon: 2,time: 30000},function(){location.reload();});</script>");
print('</body></html>');
exit();
}

}

$this->pdo = self::$PDOInstance;
}
}

脚本宝典总结

以上是脚本宝典为你收集整理的简单的pgsql pdo php操作类实现代码全部内容,希望文章能够帮你解决简单的pgsql pdo php操作类实现代码所遇到的问题。

如果觉得脚本宝典网站内容还不错,欢迎将脚本宝典推荐好友。

本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。
标签:pdopgsql