• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号
登陆 注册
描述文字

PHP pg_close函数代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了PHP中pg_close函数的典型用法代码示例。如果您正苦于以下问题：PHP pg_close函数的具体用法？PHP pg_close怎么用？PHP pg_close使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。



在下文中一共展示了pg_close函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。

示例1: all_reset

function all_reset($baseDir)
{
    //Очищаем временную папку temp
    if (file_exists($baseDir . 'tempFiles')) {
        foreach (glob($baseDir . 'tempFiles/*') as $file) {
            unlink($file);
        }
    }
    //Очищаем временную папку для граббера
    if (file_exists($baseDir . 'tempGrab')) {
        foreach (glob($baseDir . 'tempGrab/*') as $file) {
            unlink($file);
        }
    }
    //Очищаем временную папку для куков
    if (file_exists($baseDir . 'cookies')) {
        foreach (glob($baseDir . 'cookies/*') as $file) {
            unlink($file);
        }
    }
    //Приводим все ключи "в обработке" к состоянию "в ожидании"
    $dbconn = pg_connect(DB_CONN_STR) or die('Не могу подключиться к БД: ' . pg_last_error());
    //Сбросить "занятые" аккаунты
    $query = 'UPDATE accounts SET busy=0 ' . "WHERE busy=1";
    pg_query($query) or die('Ошибка запроса: ' . pg_last_error());
    //Сбросить "занятые" прокси
    $query = 'UPDATE proxys SET busy=0 ' . "WHERE busy=1";
    pg_query($query) or die('Ошибка запроса: ' . pg_last_error());
    pg_close($dbconn);
}
开发者ID:hxhxd，项目名称:ggkprun，代码行数:30，代码来源:startDaemon.php


示例2: disconnect

 function disconnect()
 {
     if (!empty($this->db)) {
         pg_close($this->db);
         $this->db = null;
     }
 }
开发者ID:Spark-Eleven，项目名称:revive-adserver，代码行数:7，代码来源:BucketDb_PgSQL.php


示例3: disconnect

 /**
  * @return PgSQL
  **/
 public function disconnect()
 {
     if ($this->isConnected()) {
         pg_close($this->link);
     }
     return $this;
 }
开发者ID:justthefish，项目名称:hesper，代码行数:10，代码来源:PgSQL.php


示例4: disconnect

 public function disconnect()
 {
     if ($this->connection) {
         pg_close($this->connection);
         $this->connection = NULL;
     }
 }
开发者ID:jasir，项目名称:dbal，代码行数:7，代码来源:PgsqlDriver.php


示例5: disconnect

 function disconnect()
 {
     if (pg_close($this->connection)) {
         return 1;
     }
     return 0;
 }
开发者ID:Return-To-The-Roots，项目名称:s2map-php，代码行数:7，代码来源:pgsql.php


示例6: __destruct

 function __destruct()
 {
     if ($this->is_connected()) {
         $this->query('ROLLBACK');
         pg_close($this->db);
     }
 }
开发者ID:BackupTheBerlios，项目名称:igoan，代码行数:7，代码来源:Igoandb.class.php


示例7: getDetails

function getDetails($ptdb, $id, $type, $langs, $offset)
{
    global $format, $callback;
    // request
    $wikipediarequest = "SELECT\n\t\t\t\t\t\t\t\tfoo.keys, foo.values\n\t\t\t\t\t\t\tFROM (\n\t\t\t\t\t\t\t\tSELECT\n\t\t\t\t\t\t\t\t\tskeys(tags) AS keys,\n\t\t\t\t\t\t\t\t\tsvals(tags) AS values\n\t\t\t\t\t\t\t\tFROM " . $type . "s\n\t\t\t\t\t\t\t\tWHERE (id = " . $id . ")\n\t\t\t\t\t\t\t) AS foo\n\t\t\t\t\t\t\tWHERE substring(foo.keys from 1 for 9) = 'wikipedia';";
    $namerequest = "SELECT\n\t\t\t\t\t\t\t\tfoo.keys, foo.values\n\t\t\t\t\t\t\tFROM (\n\t\t\t\t\t\t\t\tSELECT\n\t\t\t\t\t\t\t\t\tskeys(tags) AS keys,\n\t\t\t\t\t\t\t\t\tsvals(tags) AS values\n\t\t\t\t\t\t\t\tFROM " . $type . "s\n\t\t\t\t\t\t\t\tWHERE (id = " . $id . ")\n\t\t\t\t\t\t\t) AS foo\n\t\t\t\t\t\t\tWHERE substring(foo.keys from 1 for 4) = 'name';";
    // connnecting to database
    $connection = connectToDatabase($ptdb);
    // if there is no connection
    if (!$connection) {
        exit;
    }
    $wikipediaresponse = requestDetails($wikipediarequest, $connection);
    $nameresponse = requestDetails($namerequest, $connection);
    pg_close($connection);
    $response = tagTransform("../locales/departures.xml", getTags($ptdb, $id, $type), $type);
    if ($response) {
        if ($format == "text") {
            echo textDetailsOut($response, $nameresponse, $wikipediaresponse, $langs, $offset);
        } else {
            if ($format == "json") {
                echo jsonDetailsOut($response, $nameresponse, $wikipediaresponse, $langs, $offset, $id, $type, $callback);
            } else {
                echo xmlDetailsOut($response, $nameresponse, $wikipediaresponse, $langs, $offset, $id, $type);
            }
        }
        return true;
    } else {
        return false;
    }
}
开发者ID:dieterdreist，项目名称:OpenLinkMap，代码行数:31，代码来源:ptdetails.php


示例8: consulta

 public function consulta($aux)
 {
     $auxcon = $this->conectar();
     $resultado = pg_query($aux) or die('La consulta fallo: ' . pg_last_error());
     pg_close($auxcon);
     return $resultado;
 }
开发者ID:RFDO93，项目名称:proyecto，代码行数:7，代码来源:cls_conexion.php


示例9: wsoBruteForce

 function wsoBruteForce($ip, $port, $login, $pass)
 {
     $str = "host='" . $ip . "' port='" . $port . "' user='" . $login . "' password='" . $pass . "' dbname=postgres";
     $res = @pg_connect($str);
     @pg_close($res);
     return $res;
 }
开发者ID:santatic，项目名称:brute-dict，代码行数:7，代码来源:brute.php


示例10: execute

 /**
  *
  * @param type $query
  * @param type $type
  * @return type
  */
 public function execute($query, $type = null)
 {
     $result = array();
     switch ($this->db_engine) {
         case "pgsql":
             $resultado = pg_query($this->conn, $query);
             while ($row = pg_fetch_row($resultado)) {
                 $result[] = $row;
             }
             pg_close($this->conn);
             break;
         case "mssql":
             $resultado = odbc_exec($this->conn, $query);
             while ($row = odbc_fetch_array($resultado)) {
                 $result[] = $row;
             }
             break;
         case "mysql":
             $result = array();
             $resultado = mysql_query($query);
             if (gettype($resultado) == "boolean") {
                 $result = $resultado;
             } else {
                 while ($row = mysql_fetch_row($resultado)) {
                     $result[] = $row;
                 }
             }
             mysql_close($this->conn);
             break;
     }
     return $result;
 }
开发者ID:emildev35，项目名称:distribuidos，代码行数:38，代码来源:Conexion.php


示例11: close

 /**
  * {@inheritdoc}
  */
 public function close()
 {
     if ($this->dbHandle) {
         \pg_close($this->dbHandle);
         $this->dbHandle = null;
     }
 }
开发者ID:sugiphp，项目名称:database，代码行数:10，代码来源:PgSqlDriver.php


示例12: close_conn

 public static function close_conn()
 {
     if (self::$is_conn_set) {
         pg_close(self::$conn);
         self::$is_conn_set = false;
     }
 }
开发者ID:jls14，项目名称:SpireSessions，代码行数:7，代码来源:ConnDB.php


示例13: auth

function auth($bazaj, $uid, $puid)
{
    $uid_s = pg_escape_string($uid);
    $puid_s = pg_escape_string($puid);
    $res = pg_query($bazaj, "select username, password from users where username='{$uid_s}' and password='{$puid_s}'");
    if (!$res) {
        print "<h2>STOP: Internal system error. Please refresh this page.</h2>";
        exit;
    }
    if (pg_num_rows($res) != 1) {
        return "f";
    }
    $row = pg_fetch_row($res);
    $j_uid = $row[0];
    $j_puid = $row[1];
    if ($j_uid != $uid) {
        pg_close($bazaj);
        return "f";
    } else {
        if ($puid_s === $j_puid) {
            return "t";
        } else {
            return "f";
        }
    }
    return "f";
}
开发者ID:jeidee，项目名称:ejabberd-modules，代码行数:27，代码来源:func.php


示例14: getJSON

 public function getJSON()
 {
     $conn = getConnection();
     $taskid = array_key_exists("taskid", $_GET) ? $_GET["taskid"] : "";
     if (empty($taskid)) {
         $taskid = array_key_exists("taskid", $_POST) ? $_POST["taskid"] : "";
     }
     $year = array_key_exists("year", $_GET) ? $_GET["year"] : "";
     if (empty($year)) {
         $year = array_key_exists("year", $_POST) ? $_POST["year"] : "";
     }
     $quarter = array_key_exists("quarter", $_GET) ? $_GET["quarter"] : "";
     if (empty($quarter)) {
         $quarter = array_key_exists("quarter", $_POST) ? $_POST["quarter"] : "";
     }
     $yearquarter = $year * 10 + $quarter;
     $sql = "SELECT SUM(personnel_actual) AS personnel,\n\t\t\t       SUM(investments_actual) AS investments, \n\t\t\t       SUM(consumables_actual) AS consumables, \n\t\t\t       SUM(services_actual) AS services, \n\t\t\t       SUM(transport_actual) AS transport,\n\t\t\t       SUM(admin) AS admin\n\t\t\tFROM budget \n\t\t\tWHERE task_id = " . (empty($taskid) ? 0 : $taskid) . " \n\t\t\t  AND (year * 10) + quarter < " . $yearquarter . "\n\t\t\t  AND status = 3";
     $output = array();
     $output["taskid"] = $taskid;
     $result = pg_query($conn, $sql);
     if ($result && pg_num_rows($result) > 0) {
         $row = pg_fetch_array($result);
         $output["personnel"] = $row["personnel"];
         $output["investments"] = $row["investments"];
         $output["consumables"] = $row["consumables"];
         $output["services"] = $row["services"];
         $output["transport"] = $row["transport"];
         $output["admin"] = $row["admin"];
     }
     return json_encode($output);
     pg_close($conn);
     return $output;
 }
开发者ID:sasscaloadc，项目名称:budget，代码行数:33，代码来源:load_expenses.php


示例15: getDetails

function getDetails($db, $id, $type, $langs, $offset)
{
    global $format;
    global $callback;
    // request
    $request = "SELECT\n\t\t\t\ttags->'addr:street' AS \"street\",\n\t\t\t\ttags->'addr:housenumber' AS \"housenumber\",\n\t\t\t\ttags->'addr:country' AS \"country\",\n\t\t\t\ttags->'addr:postcode' AS \"postcode\",\n\t\t\t\ttags->'addr:city' AS \"city\",\n\t\t\t\ttags->'addr:housename' AS \"housename\",\n\t\t\t\ttags->'addr:suburb' AS \"suburb\",\n\t\t\t\ttags->'addr:province' AS \"province\",\n\t\t\t\ttags->'addr:unit' AS \"unit\",\n\t\t\t\ttags->'addr:floor' AS \"floor\",\n\t\t\t\ttags->'addr:door' AS \"door\",\n\t\t\t\ttags->'wikipedia' AS \"wikipedia\",\n\t\t\t\ttags->'phone' AS \"phone1\",\n\t\t\t\ttags->'contact:phone' AS \"phone2\",\n\t\t\t\ttags->'addr:phone' AS \"phone3\",\n\t\t\t\ttags->'phone:mobile' AS \"mobilephone1\",\n\t\t\t\ttags->'contact:mobile' AS \"mobilephone2\",\n\t\t\t\ttags->'fax' AS \"fax1\",\n\t\t\t\ttags->'contact:fax' AS \"fax2\",\n\t\t\t\ttags->'addr:fax' AS \"fax3\",\n\t\t\t\ttags->'website' AS \"website1\",\n\t\t\t\ttags->'url' AS \"website2\",\n\t\t\t\ttags->'url:official' AS \"website3\",\n\t\t\t\ttags->'contact:website' AS \"website4\",\n\t\t\t\ttags->'operator' AS \"operator\",\n\t\t\t\ttags->'email' AS \"email1\",\n\t\t\t\ttags->'contact:email' AS \"email2\",\n\t\t\t\ttags->'addr:email' AS \"email3\",\n\t\t\t\ttags->'opening_hours' AS \"openinghours\",\n\t\t\t\ttags->'service_times' AS \"servicetimes\",\n\t\t\t\ttags->'fee' AS \"fee\",\n\t\t\t\ttags->'toll' AS \"toll\",\n\t\t\t\ttags->'ref' AS \"ref\",\n\t\t\t\ttags->'capacity' AS \"capacity\",\n\t\t\t\ttags->'internet_access' AS \"internet_access\",\n\t\t\t\ttags->'image' AS \"image\",\n\t\t\t\ttags->'image:panorama' AS \"panorama\",\n\t\t\t\ttags->'description' AS \"description\",\n\t\t\t\ttags->'stars' AS \"stars\",\n\t\t\t\ttags->'cuisine' AS \"cuisine\",\n\t\t\t\ttags->'smoking' AS \"smoking\",\n\t\t\t\ttags->'biergarten' AS \"biergarten\",\n\t\t\t\ttags->'beer_garden' AS \"beer_garden\",\n\t\t\t\ttags->'brewery' AS \"beer\",\n\t\t\t\ttags->'microbrewery' AS \"microbrewery\",\n\t\t\t\ttags->'fuel:diesel' AS \"diesel\",\n\t\t\t\ttags->'fuel:GTL_diesel' AS \"gtldiesel\",\n\t\t\t\ttags->'fuel:HGV_diesel' AS \"hgvdiesel\",\n\t\t\t\ttags->'fuel:biodiesel' AS \"biodiesel\",\n\t\t\t\ttags->'fuel_octane_91' AS \"octane91\",\n\t\t\t\ttags->'fuel:octane_95' AS \"octane95\",\n\t\t\t\ttags->'fuel:octane_98' AS \"octane98\",\n\t\t\t\ttags->'fuel:octane_100' AS \"octane100\",\n\t\t\t\ttags->'fuel:octane_98_leaded' AS \"octane98l\",\n\t\t\t\ttags->'fuel:1_25' AS \"fuel25\",\n\t\t\t\ttags->'fuel:1_50' AS \"fuel50\",\n\t\t\t\ttags->'fuel:alcohol' AS \"alcohol\",\n\t\t\t\ttags->'fuel:ethanol' AS \"ethanol\",\n\t\t\t\ttags->'fuel:methanol' AS \"methanol\",\n\t\t\t\ttags->'fuel:svo' AS \"svo\",\n\t\t\t\ttags->'fuel:e85' AS \"e85\",\n\t\t\t\ttags->'fuel:biogas' AS \"biogas\",\n\t\t\t\ttags->'fuel:lpg' AS \"lpg\",\n\t\t\t\ttags->'fuel:cng' AS \"cng\",\n\t\t\t\ttags->'fuel:LH2' AS \"lh2\",\n\t\t\t\ttags->'fuel:electricity' AS \"electro\",\n\t\t\t\ttags->'fuel:adblue' AS \"adblue\",\n\t\t\t\ttags->'car_wash' AS \"carwash\",\n\t\t\t\ttags->'car_repair' AS \"carrepair\",\n\t\t\t\ttags->'shop' AS \"shop\",\n\t\t\t\ttags->'kiosk' AS \"kiosk\",\n\t\t\t\ttags->'ele' AS \"ele\",\n\t\t\t\ttags->'population' AS \"population\",\n\t\t\t\ttags->'iata' AS \"iata\",\n\t\t\t\ttags->'icao' AS \"icao\",\n\t\t\t\ttags->'disused' AS \"disused\",\n\t\t\t\ttags->'wheelchair' AS \"wheelchair\",\n\t\t\t\ttags->'wheelchair:toilets' AS \"wheelchair:toilets\",\n\t\t\t\ttags->'wheelchair:rooms' AS \"wheelchair:rooms\",\n\t\t\t\ttags->'wheelchair:access' AS \"wheelchair:access\",\n\t\t\t\ttags->'wheelchair:places' AS \"wheelchair:places\"\n\t\t\tFROM " . $type . "s WHERE (id = " . $id . ");";
    $wikipediarequest = "SELECT\n\t\t\t\t\t\t\t\tfoo.keys, foo.values\n\t\t\t\t\t\t\tFROM (\n\t\t\t\t\t\t\t\tSELECT\n\t\t\t\t\t\t\t\t\tskeys(tags) AS keys,\n\t\t\t\t\t\t\t\t\tsvals(tags) AS values\n\t\t\t\t\t\t\t\tFROM " . $type . "s\n\t\t\t\t\t\t\t\tWHERE (id = " . $id . ")\n\t\t\t\t\t\t\t) AS foo\n\t\t\t\t\t\t\tWHERE substring(foo.keys from 1 for 9) = 'wikipedia';";
    $namerequest = "SELECT\n\t\t\t\t\t\t\t\tfoo.keys, foo.values\n\t\t\t\t\t\t\tFROM (\n\t\t\t\t\t\t\t\tSELECT\n\t\t\t\t\t\t\t\t\tskeys(tags) AS keys,\n\t\t\t\t\t\t\t\t\tsvals(tags) AS values\n\t\t\t\t\t\t\t\tFROM " . $type . "s\n\t\t\t\t\t\t\t\tWHERE (id = " . $id . ")\n\t\t\t\t\t\t\t) AS foo\n\t\t\t\t\t\t\tWHERE substring(foo.keys from 1 for 4) = 'name';";
    // connnecting to database
    $connection = connectToDatabase($db);
    // if there is no connection
    if (!$connection) {
        exit;
    }
    $response = requestDetails($request, $connection);
    $wikipediaresponse = requestDetails($wikipediarequest, $connection);
    $nameresponse = requestDetails($namerequest, $connection);
    pg_close($connection);
    if ($response) {
        if ($format == "text") {
            echo textMoredetailsOut($response[0], $nameresponse, $wikipediaresponse, $langs, $offset);
        } else {
            if ($format == "json") {
                echo jsonMoredetailsOut($response[0], $nameresponse, $wikipediaresponse, $langs, $offset, $id, $type, $callback);
            } else {
                echo xmlMoredetailsOut($response[0], $nameresponse, $wikipediaresponse, $langs, $offset, $id, $type);
            }
        }
        return true;
    } else {
        return false;
    }
}
开发者ID:dieterdreist，项目名称:OpenLinkMap，代码行数:33，代码来源:extdetails.php


示例16: importOsmFile

function importOsmFile($filename, $db)
{
    global $offset, $offsetfactorrels, $connection;
    $connection = connectToDatabase($db);
    // if there is no connection
    if (!$connection) {
        reportError("Cannot connect to database.");
        return false;
    }
    $result = pg_query($connection, "TRUNCATE nodes");
    $result = pg_query($connection, "TRUNCATE ways");
    $result = pg_query($connection, "TRUNCATE relations");
    $xml_parser = xml_parser_create();
    xml_set_element_handler($xml_parser, "startElement", "endElement");
    if (!($fp = fopen($filename, "r"))) {
        reportError("Cannot open file.");
        return false;
    }
    while ($data = fread($fp, 4096)) {
        if (!xml_parse($xml_parser, $data, feof($fp))) {
            reportError("XML-Error.");
            return false;
        }
    }
    xml_parser_free($xml_parser);
    fclose($fp);
    pg_close($connection);
    echo "Finished " . $db . "...\n";
    return true;
}
开发者ID:dieterdreist，项目名称:OpenLinkMap，代码行数:30，代码来源:import.php


示例17: close_connection

 public function close_connection()
 {
     if (isset($this->connection)) {
         pg_close($this->connection);
         unset($this->connection);
     }
 }
开发者ID:natas333x2，项目名称:kg-geodata，代码行数:7，代码来源:database.php


示例18: check_pgsql

/**
 * Check mysql connection (master & slaves).
 *
 * @return array(FALSE, "") in case of failure and array(TRUE, "") otherwise.
 */
function check_pgsql()
{
    global $databases;
    // collect response time
    $time = microtime();
    // check master connection
    $master = $databases['default']['default'];
    $connection_string = "host=" . $master['host'] . ' ' . "port=" . $master['port'] . ' ' . "dbname=" . $master['database'] . ' ' . "user=" . $master['username'] . ' ' . "password=" . $master['password'];
    $db_connection = pg_connect($connection_string);
    if (!$db_connection) {
        return array(FALSE, "pgsql: cannot connect to postgres master");
    }
    pg_close($db_connection);
    // collect response time
    $time_spent = microtime() - $time;
    $time_spent = round(1000 * $time_spent) . "ms";
    // convert in ms
    // check slaves connections if any
    if (!isset($databases['default']['slave'])) {
        return array(TRUE, "pgsql: OK (" . $time_spent . ")");
    }
    $slaves = $databases['default']['slave'];
    foreach ($slaves as $slave) {
        $connection_string = "host=" . $slave['host'] . ' ' . "port=" . $slave['port'] . ' ' . "dbname=" . $slave['database'] . ' ' . "user=" . $slave['username'] . ' ' . "password=" . $slave['password'];
        $db_connection = pg_connect($connection_string);
        if (!$db_connection) {
            return array(FALSE, "PgSQL: cannot connect to PgSql slave (" . $slave['host'] . ")");
        }
        pg_close($db_connection);
    }
    return array(TRUE, "PgSQL: OK (" . $time_spent . ")");
}
开发者ID:singhneeraj，项目名称:im-portal，代码行数:37，代码来源:healthCheck.php


示例19: disconnect

 private function disconnect()
 {
     if (!is_null($this->link)) {
         return pg_close($this->link);
     }
     return false;
 }
开发者ID:mmr，项目名称:b1n，代码行数:7，代码来源:SQLLink.lib.php


示例20: __destruct

 public function __destruct()
 {
     /*
              | About:
      | 	-> Close the connection and returns the elapsed time.
     */
     if (!empty($this->connection['debugMode'])) {
         $this->errorHandling();
     }
     switch ($this->connection['db_type']) {
         case 'mysql':
             $this->conn->close();
             break;
         case 'mssql':
             mssql_close($this->conn);
             break;
         case 'sqlserv':
             sqlsrv_close($this->conn);
             break;
         case 'pgsql':
             pg_close($this->conn);
             break;
     }
     return $this->elapsedTime();
 }
开发者ID:samukt，项目名称:T-Rex，代码行数:25，代码来源:class_db.php



注：本文中的pg_close函数示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花
握手
雷人
路过
鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
More+
上一篇：
PHP pg_cmdtuples函数代码示例发布时间：2022-05-15
下一篇：
PHP pg_client_encoding函数代码示例发布时间：2022-05-15
热门推荐
More+
热门话题
More+
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服（服务时间 9:00～18:00）

在线QQ客服
地址：深圳市南山区西丽大学城创智工业园
电邮：jeky_zhao#qq.com
移动电话：139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap