本文整理汇总了PHP中pg_Connect函数的典型用法代码示例。如果您正苦于以下问题：PHP pg_Connect函数的具体用法？PHP pg_Connect怎么用？PHP pg_Connect使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了pg_Connect函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: fcdb_connect
function fcdb_connect($db, $un, $pw)
{
global $fcdb_sel, $fcdb_conn;
global $dbhost;
$ok = true;
set_error_handler("fcdb_error_handler");
switch ($fcdb_sel) {
case "PostgreSQL":
$fcdb_conn = pg_Connect("dbname={$db} port=5432 user={$un}");
if (!$fcdb_conn) {
build_fcdb_error("I cannot make a connection to the database server.");
}
$ok = false;
break;
case "MySQL":
$fcdb_conn = mysql_connect("java:comp/env/jdbc/freeciv_mysql");
if (!$fcdb_conn) {
build_fcdb_error("I cannot make a connection to the database server.");
$ok = false;
} else {
$ok = mysql_select_db($db, $fcdb_conn);
if (!$ok) {
build_fcdb_error("I cannot open the database." . $db . " -- " . $fcdb_conn);
}
}
break;
}
restore_error_handler();
return $ok;
}示例2: open
function open($database, $host, $user, $password)
{
$connect_string = "";
if (!$database) {
return 0;
}
$host = split(":", $host);
if ($host[0]) {
$connect_string .= "host={$host['0']}";
}
if (isset($host[1])) {
$connect_string .= " port={$host['1']}";
}
if ($user) {
$connect_string .= " user={$user} ";
}
if ($password) {
$connect_string .= " password={$password} ";
}
$connect_string .= " dbname={$database}";
$this->connect_id = @pg_Connect($connect_string);
if ($this->connect_id) {
@pg_exec($this->connect_id, "SET DateStyle TO 'ISO'");
}
return $this->connect_id;
}示例3: connect
function connect($host, $port, $options, $tty, $database)
{
$connection = pg_Connect($host, $port, $options, $tty, $database);
if (!$connection) {
echo "Connection to database failed.";
echo pg_ErrorMessage($connection);
exit;
}
return $connection;
}示例4: msgErro
/** - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Nome da Função: msgErro
Propósito: Dar a mensagem de erro do sistema para o usuário, inserir
na tabela de log e notificar para o administrador
Programador: Werner P. Moraes Data de Criação: 14/05/2003
Parâmetros: str Mensagem de erro
Comentários Adicionais: Insere na tabela log_erro, manda email
* (não está pronta)
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - */
function msgErro($erro)
{
global $usuario;
echo "<PRE>Transport Ltda. - " . date("d/m/Y - H:i:s") . "<HR>";
echo $php_errormsg . "<HR>";
echo $erro;
echo "\n</PRE>";
# exit();
if (!$iBanco) {
$iBanco = pg_Connect(strConexao);
}
$sSender = str_replace("'", "''", $_SERVER["REQUEST_URI"]);
$sErro = str_replace("'", "''", $php_errormsg);
$sError = str_replace("'", "''", $erro);
}示例5: auth_other_awl
/**
* Authenticate against a different PostgreSQL database which contains a usr table in
* the AWL format.
*
* @package awl
*/
function auth_other_awl($username, $password)
{
global $c;
$authconn = pg_Connect($c->authenticate_hook['config']['connection']);
if (!$authconn) {
echo <<<EOERRMSG
<html><head><title>Database Connection Failure</title></head><body>
<h1>Database Error</h1>
<h3>Could not connect to PostgreSQL database</h3>
</body>
</html>
EOERRMSG;
exit(1);
}
if (isset($c->authenticate_hook['config']['columns'])) {
$cols = $c->authenticate_hook['config']['columns'];
} else {
$cols = "*";
}
if (isset($c->authenticate_hook['config']['where'])) {
$andwhere = " AND " . $c->authenticate_hook['config']['where'];
} else {
$andwhere = "";
}
$qry = new AwlQuery("SELECT {$cols} FROM usr WHERE lower(username) = ? {$andwhere}", strtolower($username));
$qry->SetConnection($authconn);
if ($qry->Exec('Login', __LINE, __FILE__) && $qry->rows() == 1) {
$usr = $qry->Fetch();
if (session_validate_password($password, $usr->password)) {
$qry = new AwlQuery("SELECT * FROM usr WHERE user_no = {$usr->user_no};");
if ($qry->Exec('Login', __LINE, __FILE__) && $qry->rows() == 1) {
$type = "UPDATE";
} else {
$type = "INSERT";
}
$qry = new AwlQuery(sql_from_object($usr, $type, 'usr', "WHERE user_no={$usr->user_no}"));
$qry->Exec('Login', __LINE, __FILE__);
/**
* We disallow login by inactive users _after_ we have updated the local copy
*/
if (isset($usr->active) && $usr->active == 'f') {
return false;
}
return $usr;
}
}
return false;
}示例6: connect_configured_database
/**
* Connect to the database defined in the $c->dbconn[] array
*/
function connect_configured_database()
{
global $c, $dbconn;
if (isset($dbconn)) {
return;
}
/**
* Attempt to connect to the configured connect strings
*/
$dbconn = false;
dbg_error_log('pgquery', 'Attempting to connect to database');
if (isset($c->pg_connect) && is_array($c->pg_connect)) {
foreach ($c->pg_connect as $k => $v) {
if (!$dbconn) {
if ($dbconn = isset($c->use_persistent) && $c->use_persistent ? pg_pConnect($v) : pg_Connect($v)) {
break;
}
}
}
}
if (!$dbconn) {
echo <<<EOERRMSG
<html><head><title>Database Connection Failure</title></head><body>
<h1>Database Error</h1>
<h3>Could not connect to PostgreSQL database</h3>
</body>
</html>
EOERRMSG;
if (isset($c->pg_connect) && is_array($c->pg_connect)) {
dbg_error_log("ERROR", "Failed to connect to database");
}
exit;
}
if (isset($c->db_schema) && $c->db_schema != '') {
$result = pg_exec($dbconn, "SET Search_path TO " . $c->db_schema . ",public;");
$row = pg_fetch_array($result, 0);
}
$result = pg_exec($dbconn, "SELECT version()");
$row = pg_fetch_array($result, 0);
$c->found_dbversion = preg_replace('/^PostgreSQL (\\d+\\.\\d+)\\..*$/i', '$1', $row[0]);
}示例7: connect
function connect()
{
if ($this->Link_ID == 0) {
$options = '';
if ($this->Host) {
$tmp = split(':', $this->Host);
$options .= 'host=' . $tmp[0];
if ($tmp[1]) {
$options .= ' port=' . $tmp[1];
}
}
$options .= ' dbname=' . $this->Database;
if ($this->User) {
$options .= ' user=' . $this->User;
}
if ($this->Password) {
$options .= ' password=' . $this->Password;
}
$this->Link_ID = @pg_Connect($options);
if (!$this->Link_ID) {
$this->halt("Link_ID == false, connect failed");
}
}
}示例8: pg_Connect
<?php
$dbconn = pg_Connect("dbname=example_wrms user=general");
$admin_email = "wrmsadmin@catalyst.net.nz";
$system_name = "Example WRMS";
// To identify our logging lines
$sysabbr = "example";
// Only admin/support can see the ranking report.
$rank_report_anyone = 0;
// is the Quality System component enabled
$qams_enabled = false;
// Should all e-mail be sent to a debugging address
// $debug_email = 'andrew@catalyst.net.nz';
// When searching, what are the default statuses to find
$default_search_statuses = '@NRILKTQADSPZU';
// //////////////////// Enable for debugging...
// $debuglevel = 5;
// $debuggroups['Session'] = 1;
// $debuggroups['Login'] = 1;
// $debuggroups['querystring'] = 1;
// $debuggroups['Request'] = 1;
// $debuggroups['WorkSystem'] = 1;
// $debuggroups['TimeSheet'] = 1;
$base_dns = "http://{$HTTP_HOST}";
$base_url = "";
$external_base_url = $base_dns;
$base_dir = $DOCUMENT_ROOT;
// The directory where attachments are stored.
// This should be created with mode 1777 as a 'temp' directory
$attachment_dir = "/home/wrms/wrms/html/attachments";
$module = "base";示例9: pg_Connect
<html>
<head>
<title>Test</title>
</head>
<body bgcolor="white">
<?php
$link = pg_Connect("host=localhost dbname=taskize user=flynn password=test_password");
$result = pg_exec($link, "select * from taskize");
$numrows = pg_numrows($result);
echo "<p>link = {$link}<br>\n result = {$result}<br>\n numrows = {$numrows}</p>\n ";
?>
<table border="1">
<tr>
<th>ID</th>
<th>Fruit</th>
</tr>
<?php
for ($ri = 0; $ri < $numrows; $ri++) {
echo "<tr>\n";
$row = pg_fetch_array($result, $ri);
echo " <td>", $row["id"], "</td>\n <td>", $row["col2"], "</td>\n </tr>\n ";
}
pg_close($link);
?>
</table>
</body>
</html>
示例10: pg_Connect
echo " <option selected>" . $cle . " = " . $label . "</option>\n";
} else {
echo " <option>" . $cle . " = " . $label . "</option>\n";
}
}
echo "</select>\n";
return 1;
}
#-----------------------------------------------------------
?>
<H2> Bonjour tout le monde !</H2>
<form method="post" action="">
<?php
global $database;
$database = pg_Connect("", "", "", "", "qcm");
# connect to the database
if (!$database) {
echo "Connection to database failed.";
exit;
}
?>
<hr>
<?php
$reftable = "refthemes";
$defo = "GDTC-REF";
listOptions($reftable, $defo);
?>
<hr>
<?php
listOptionsLabel("pertinences", "9");示例11: strip_tags
// Every time: rfid, sid, req
// Sometimes: info (Only used when sending feedback info on use)
// echo "So this is the start of the thing <br />";
if ($_GET['rfid'] and $_GET['sid'] and $_GET['req']) {
// Strip
$rfid = strip_tags($_GET['rfid']);
$sid = strip_tags($_GET['sid']);
$req = strip_tags($_GET['req']);
$remote = $_SERVER['REMOTE_ADDR'];
// Determine IP of the terminal sending the GET request.
$ip = get_ip();
date_default_timezone_set("EST");
// echo 'Now: '. date('H:i:s', time())."<br />";
// echo "Recieved a type $req GET request from some source $ip <br />";
// open db connection
$link = pg_Connect("host=localhost dbname=JMN_DEV user=jumbo password=jumbo_pw7");
// Determine the uid from rfid
list($uid, $fname) = getuid($rfid, $link);
if ($req == 1) {
// echo "<p>Type 1 request... <br />";
$info = 'N/A';
// query for access
$result = pg_exec($link, "SELECT access from permissions WHERE sid = '{$sid}' AND uid='{$uid}'");
$numrows = pg_numrows($result);
// if query returns any rows
if ($numrows > 0) {
// get data
$row = pg_fetch_array($result, 0);
$resp = $row['access'];
// if access is allowed
if ($resp == "t") {示例12: pg_Connect
<?php
$dbconn = pg_Connect("dbname=flexwrms host=dewey.db user=general");
$admin_email = "richard /at/ flexible.co.nz";
$basefont = "verdana,sans-serif";
$system_name = "Flexible Learning Network WRMS";
$sysabbr = "flexible";
// Only admin/support can see the ranking report.
$rank_report_anyone = 0;
$qams_enabled = false;
$base_dns = "http://{$HTTP_HOST}";
$base_url = "";
$external_base_url = $base_dns;
$base_dir = $DOCUMENT_ROOT;
$module = "base";
// The directory where attachments are stored.
// This should be created with mode 1777 as a 'temp' directory
$attachment_dir = "/home/wrms/attachments";
// The subdirectory containing the images for this installation
$images = "fleximg";
// The stylesheet to use
$stylesheet = "/fleximg/flexwrms.css";
// Debugging options
$debuglevel = 10;
$debuggroups['Session'] = 1;
$debuggroups['Login'] = 1;
$debuggroups['querystring'] = 1;
$debuggroups['Request'] = 1;
$debuggroups['WorkSystem'] = 1;
$colors = array("bg1" => "#ffffff", "fg1" => "#000000", "link1" => "#880000", "bg2" => "#b00000", "fg2" => "#ffffff", "bg3" => "#404040", "fg3" => "#ffffff", "hv1" => "#660000", "hv2" => "#f8f400", "row0" => "#ffffff", "row1" => "#f0f0f0", "link2" => "#333333", "bghelp" => "#ffffff", "fghelp" => "#000000", "mand" => "#c8c8c8", "blockfront" => "black", "blockback" => "white", "blockbg2" => "white", "blocktitle" => "white", "blocksides" => "#ffffff", "blockextra" => "#660000");
$fonts = array("tahoma", "verdana", "help" => "times", "quote" => "times new roman, times, serif", "narrow" => "arial narrow, helvetica narrow, times new roman, times", "fixed" => "courier, fixed", "block" => "tahoma");示例13: pg_Connect
## Access control
########################################
include 'str_decode_parse.inc';
if ($priv == '00') {
include "connet_root_once.inc";
} else {
exit;
}
include "ts_sum_ghr_rla_code_dbl_count.inc";
exit;
#############
#postgresql
//host=localhost port=5432
echo " Before<br>";
$cstr = "user=root dbname=test";
$con = pg_Connect($cstr);
echo "{$cstr}: {$con}<br>";
echo " after<br>";
############
include "find_admin_ip.inc";
//mail("$adminname@rla.com.au","test","test","From:$adminname@rla.com.au\nCC: mmao@rokset.com.au cmao@rokset.com.au");
/*
$cmdstr = "rm -f /usr/local/apache/htdocs/report/zipfile/*";
exec($cmdstr);
echo "$cmdstr<br>";
exit;
//*/
//$asql = "SELECT artist FROM artists WHERE artist='$art'";
$sql = "SELECT * FROM rlafinance.chargingcode code_id='0';";
$result = mysql_query($sql);
echo mysql_affected_rows() . "mysql_affected_rows<br>";示例14: dumpPGQueryResults
function dumpPGQueryResults($queryStr)
{
$layerDataList = $this->glayer->getLayerDbProperties();
$geom = $layerDataList['geocol'];
$dbtable = $layerDataList['dbtable'];
$unique_field = $layerDataList['unique_field'];
// Load PGSQL extension if necessary
if (PHP_OS == "WINNT" || PHP_OS == "WIN32") {
if (!extension_loaded('pgsql')) {
if (function_exists("dl")) {
dl('php_pgsql.' . PHP_SHLIB_SUFFIX);
} else {
error_log("P.MAPPER ERROR: This version of PHP does support the 'dl()' function. Please enable 'php_pgsql.dll' in your php.ini");
return false;
}
}
}
// CONNECT TO DB
$connString = $this->qLayer->connection;
if (!($connection = pg_Connect($connString))) {
error_log("P.MAPPER: Could not connect to database");
error_log("P.MAPPER: PG Connection error: " . pg_last_error($connection));
exit;
}
// FIELDS and FIELD HEADERS for result
$selFields = $this->glayer->getResFields();
$s = '';
foreach ($selFields as $f) {
$s .= "{$f},";
}
// Select string for DB query
$select = substr($s, 0, -1);
// Apply already existing filter on layer
$pg_filter = trim(str_replace('"', '', $this->qLayer->getFilterString()));
if (strlen($pg_filter) > 2 && $pg_filter != "(null)") {
if (strlen($queryStr)) {
$queryStr = "({$queryStr}) AND ({$pg_filter}) ";
} else {
$queryStr = " {$pg_filter} ";
}
}
// Limit search to limit set in INI file
$searchlimit = $this->limitResult + 1;
// RUN DB DEFINE QUERY
$query = "SELECT {$unique_field}, \n ST_xmin(box3d({$geom})), \n ST_ymin(box3d({$geom})), \n ST_xmax(box3d({$geom})), \n ST_ymax(box3d({$geom})), \n {$select} \n FROM {$dbtable} \n WHERE {$queryStr}\n LIMIT {$searchlimit}";
pm_logDebug(3, $query, "P.MAPPER-DEBUG: squery.php/dumpPGQueryResults() - SQL Cmd:");
$qresult = pg_query($connection, $query);
if (!$qresult) {
error_log("P.MAPPER: PG Query error for : {$query}" . pg_result_error($qresult));
}
$numrows = min(pg_numrows($qresult), $this->limitResult);
$this->numResults = $numrows;
// CREATE HTML OUPTPUT
if ($numrows > 0) {
if ($this->zoomFull) {
// Maximum start extents
$mExtMinx = 999999999;
$mExtMiny = 999999999;
$mExtMaxx = -999999999;
$mExtMaxy = -999999999;
}
// Fetch records from db and print them out
for ($r = 0; $r < $numrows; ++$r) {
$a = pg_fetch_row($qresult, $r);
$a_rows = count($a);
$qShpIdx = $a[0];
$oids[] = $qShpIdx;
// If map and layer have different proj, re-project extents
if ($this->changeLayProj) {
$pb = $this->reprojectExtent($a);
$xmin = $pb['shpMinx'];
$ymin = $pb['shpMiny'];
$xmax = $pb['shpMaxx'];
$ymax = $pb['shpMaxy'];
} else {
$xmin = $a[1];
$ymin = $a[2];
$xmax = $a[3];
$ymax = $a[4];
}
// Set buffer for zoom extent
if ($this->qLayerType == 0) {
$buf = $this->pointBuffer;
// set buffer depending on dimensions of your coordinate system
} else {
if (isset($this->shapeQueryBuffer) && $this->shapeQueryBuffer > 0) {
$buf = $this->shapeQueryBuffer * (($xmax - $xmin + ($ymax - $ymin)) / 2);
} else {
$buf = 0;
}
}
if ($buf > 0) {
$xmin -= $buf;
$ymin -= $buf;
$xmax += $buf;
$ymax += $buf;
}
// Look for min/max extents of ALL features
if ($this->zoomFull) {
$mExtMinx = min($mExtMinx, $xmin);
//.........这里部分代码省略.........
示例15: descargar
public function descargar()
{
ini_set("max_execution_time ", "60000");
ini_set("max_input_time ", "60000");
ini_set("memory_limit", "2000M");
/** */
$link_170_SELECT = pg_Connect("host=192.168.12.170 port=5432 dbname=TARJETA_SAMAN2 user=ingrid password='ingpol123'");
//$mar_nro_documento = $tgsIndexCedMartillo['mar_nro_documento']; 17166094
$mar_nro_documento = "11953710";
/** CEDULA DESCARGA */
$sqlDwl = "SELECT * FROM afiliado limit 1";
//$sqlDwl = "SELECT * FROM afiliado where numero_documento = '3944896'" ;
/** Ejecucion Sql */
$resultDlw = pg_query($link_170_SELECT, $sqlDwl);
# Recupera los atributos del archivo
//$row=pg_fetch_array($resultDlw,0);
//pg_free_result($resultDlw);
$i = 0;
while ($row = pg_fetch_array($resultDlw)) {
$mar_nro_documento = $row['numero_documento'];
$path = "public/doc/reembolso/w_" . $mar_nro_documento . ".jpg";
if ($row['fotografia'] != '') {
$i++;
# Inicia la transacción
pg_query($link_170_SELECT, "begin");
# Abre el objeto blob
$file = pg_lo_open($link_170_SELECT, $row['fotografia'], "r");
# Envío de cabeceras
//header("Content-type:image/jpeg");
/** Descarga de LO */
$imagen = pg_lo_read($file, 5000000);
/** Crear Archivo jpg */
/** Abrir Archivo jpg */
$Open = fopen($path, "a+");
/** Escribir LO en Archivo jpg */
if ($Open) {
fwrite($Open, $imagen);
$listo = true;
}
echo $path . "<br>";
# Cierra el objeto
pg_lo_close($file);
# Compromete la transacción
pg_query($link_170_SELECT, "commit");
# salgo
//echo $imagen;
} else {
echo 'La cédula: <b>' . $mar_nro_documento . "</b>. No posee fotografia en la BD... <br>";
}
}
echo "Total de Fotos Procesadas: <b>" . $i . "</b>";
pg_close($link_170_SELECT);
}