PHP pg_field_table函数代码示例

 public static function castResult($result, array $a, Stub $stub, $isNested)
 {
     $a['num rows'] = pg_num_rows($result);
     $a['status'] = pg_result_status($result);
     if (isset(self::$resultStatus[$a['status']])) {
         $a['status'] = new ConstStub(self::$resultStatus[$a['status']], $a['status']);
     }
     $a['command-completion tag'] = pg_result_status($result, PGSQL_STATUS_STRING);
     if (-1 === $a['num rows']) {
         foreach (self::$diagCodes as $k => $v) {
             $a['error'][$k] = pg_result_error_field($result, $v);
         }
     }
     $a['affected rows'] = pg_affected_rows($result);
     $a['last OID'] = pg_last_oid($result);
     $fields = pg_num_fields($result);
     for ($i = 0; $i < $fields; ++$i) {
         $field = array('name' => pg_field_name($result, $i), 'table' => sprintf('%s (OID: %s)', pg_field_table($result, $i), pg_field_table($result, $i, true)), 'type' => sprintf('%s (OID: %s)', pg_field_type($result, $i), pg_field_type_oid($result, $i)), 'nullable' => (bool) pg_field_is_null($result, $i), 'storage' => pg_field_size($result, $i) . ' bytes', 'display' => pg_field_prtlen($result, $i) . ' chars');
         if (' (OID: )' === $field['table']) {
             $field['table'] = null;
         }
         if ('-1 bytes' === $field['storage']) {
             $field['storage'] = 'variable size';
         } elseif ('1 bytes' === $field['storage']) {
             $field['storage'] = '1 byte';
         }
         if ('1 chars' === $field['display']) {
             $field['display'] = '1 char';
         }
         $a['fields'][] = new EnumStub($field);
     }
     return $a;
 }

function aff_table($res)
{
    echo "<table border=\"1px\" witdh='50%'>";
    echo "<tr>";
    for ($i = 0; $i < pg_num_fields($res); $i++) {
        echo "<th>" . pg_field_name($res, $i) . "</th>";
    }
    echo "</tr>";
    for ($i = 0; $i < pg_num_rows($res); $i++) {
        echo "<tr>";
        for ($j = 0; $j < pg_num_fields($res); $j++) {
            if (pg_field_type($res, $j) == "bytea") {
                $table = pg_field_table($res, 0);
                echo "<td><img width='60%' src='photo.php?table=" . $table . "&id=" . pg_field_name($res, 0) . "&valeur=" . pg_fetch_result($res, $i, 0) . "&champ=" . pg_field_name($res, $j) . "'></td>";
            } else {
                echo "<td>" . pg_fetch_result($res, $i, $j) . "</td>";
            }
        }
        echo "</tr>";
    }
    echo "</table>";
}

 /**
  * Returns information about a table or a result set
  *
  * NOTE: only supports 'table' and 'flags' if <var>$result</var>
  * is a table name.
  *
  * @param object|string  $result  MDB2_result object from a query or a
  *                                 string containing the name of a table.
  *                                 While this also accepts a query result
  *                                 resource identifier, this behavior is
  *                                 deprecated.
  * @param int            $mode    a valid tableInfo mode
  *
  * @return array  an associative array with the information requested.
  *                 A MDB2_Error object on failure.
  *
  * @see MDB2_Driver_Common::tableInfo()
  */
 function tableInfo($result, $mode = null)
 {
     if (is_string($result)) {
         return parent::tableInfo($result, $mode);
     }
     $db =& $this->getDBInstance();
     if (PEAR::isError($db)) {
         return $db;
     }
     $resource = MDB2::isResultCommon($result) ? $result->getResource() : $result;
     if (!is_resource($resource)) {
         return $db->raiseError(MDB2_ERROR_NEED_MORE_DATA, null, null, 'Could not generate result resource', __FUNCTION__);
     }
     if ($db->options['portability'] & MDB2_PORTABILITY_FIX_CASE) {
         if ($db->options['field_case'] == CASE_LOWER) {
             $case_func = 'strtolower';
         } else {
             $case_func = 'strtoupper';
         }
     } else {
         $case_func = 'strval';
     }
     $count = @pg_num_fields($resource);
     $res = array();
     if ($mode) {
         $res['num_fields'] = $count;
     }
     $db->loadModule('Datatype', null, true);
     for ($i = 0; $i < $count; $i++) {
         $res[$i] = array('table' => function_exists('pg_field_table') ? @pg_field_table($resource, $i) : '', 'name' => $case_func(@pg_field_name($resource, $i)), 'type' => @pg_field_type($resource, $i), 'length' => @pg_field_size($resource, $i), 'flags' => '');
         $mdb2type_info = $db->datatype->mapNativeDatatype($res[$i]);
         if (PEAR::isError($mdb2type_info)) {
             return $mdb2type_info;
         }
         $res[$i]['mdb2type'] = $mdb2type_info[0][0];
         if ($mode & MDB2_TABLEINFO_ORDER) {
             $res['order'][$res[$i]['name']] = $i;
         }
         if ($mode & MDB2_TABLEINFO_ORDERTABLE) {
             $res['ordertable'][$res[$i]['table']][$res[$i]['name']] = $i;
         }
     }
     return $res;
 }

 /**
  * Returns metadata for all columns in a result set.
  *
  * @return array
  */
 public function getColumnsMeta()
 {
     $hasTable = version_compare(PHP_VERSION, '5.2.0', '>=');
     $count = pg_num_fields($this->resultSet);
     $meta = array();
     for ($i = 0; $i < $count; $i++) {
         // items 'name' and 'table' are required
         $meta[] = array('name' => pg_field_name($this->resultSet, $i), 'table' => $hasTable ? pg_field_table($this->resultSet, $i) : NULL, 'type' => pg_field_type($this->resultSet, $i), 'size' => pg_field_size($this->resultSet, $i), 'prtlen' => pg_field_prtlen($this->resultSet, $i));
     }
     return $meta;
 }

 public function getColumnsMeta()
 {
     $hasTable = version_compare(PHP_VERSION, '5.2.0', '>=');
     $count = pg_num_fields($this->resultSet);
     $res = array();
     for ($i = 0; $i < $count; $i++) {
         $row = array('name' => pg_field_name($this->resultSet, $i), 'table' => $hasTable ? pg_field_table($this->resultSet, $i) : NULL, 'nativetype' => pg_field_type($this->resultSet, $i));
         $row['fullname'] = $row['table'] ? $row['table'] . '.' . $row['name'] : $row['name'];
         $res[] = $row;
     }
     return $res;
 }

 function getFieldInfo($stack = 0)
 {
     $fields = array();
     $tables = array();
     $num_fields = pg_num_fields($this->result[$stack]);
     for ($i = 0; $i < $num_fields; $i++) {
         $f = new StdClass();
         $f->name = pg_field_name($this->result[$stack], $i);
         $f->table = pg_field_table($this->result[$stack], $i);
         $f->type = pg_field_type($this->result[$stack], $i);
         $f->blob = 0;
         $f->pkey = 0;
         $f->ukey = 0;
         $f->mkey = 0;
         $f->numeric = substr($f->type, 0, 3) == 'int' ? 1 : 0;
         if (!isset($tables[$f->table])) {
             $tables[$f->table] = array();
         }
         $tables[$f->table][] = "'" . $f->name . "'";
         $fields[] = $f;
     }
     $this->getFieldMetaInfo($fields, $tables);
     $this->getFieldConstraints($fields, $tables);
     return $fields;
 }

 public function FieldTable($fNo, $o = false)
 {
     return pg_field_table($this->ds, $fNo, $o);
 }

 protected function _table_name($field)
 {
     return pg_field_table($this->_result, $field);
 }

 /**
  * Returns metadata for all columns in a result set.
  * @return array
  */
 public function getResultColumns()
 {
     $count = pg_num_fields($this->resultSet);
     $columns = array();
     for ($i = 0; $i < $count; $i++) {
         $row = array('name' => pg_field_name($this->resultSet, $i), 'table' => pg_field_table($this->resultSet, $i), 'nativetype' => pg_field_type($this->resultSet, $i));
         $row['fullname'] = $row['table'] ? $row['table'] . '.' . $row['name'] : $row['name'];
         $columns[] = $row;
     }
     return $columns;
 }

 function pg_fetch_field($result, $file_number)
 {
     $pg_to_php = array('bit' => 'bit', 'boolean' => 'bool', 'box' => 'box', 'character' => 'bpchar', 'char' => 'bpchar', 'bytea' => 'bytea', 'cidr' => 'cidr', 'circle' => 'circle', 'date' => 'date', 'daterange' => 'daterange', 'real' => 'float4', 'double precision' => 'float8', 'inet' => 'inet', 'smallint' => 'int2', 'smallserial' => 'int2', 'integer' => 'int4', 'serial' => 'int4', 'int4range' => 'int4range', 'bigint' => 'int8', 'bigserial' => 'int8', 'int8range' => 'int8range', 'interval' => 'interval', 'json' => 'json', 'lseg' => 'lseg', 'macaddr' => 'macaddr', 'money' => 'money', 'decimal' => 'numeric', 'numeric' => 'numeric', 'numrange' => 'numrange', 'path' => 'path', 'point' => 'point', 'polygon' => 'polygon', 'text' => 'text', 'time' => 'time', 'time without time zone' => 'time', 'timestamp' => 'timestamp', 'timestamp without time zone' => 'timestamp', 'timestamp with time zone' => 'timestamptz', 'time with time zone' => 'timetz', 'tsquery' => 'tsquery', 'tsrange' => 'tsrange', 'tstzrange' => 'tstzrange', 'tsvector' => 'tsvector', 'uuid' => 'uuid', 'bit varying' => 'varbit', 'character varying' => 'varchar', 'varchar' => 'varchar', 'xml' => 'xml');
     $arr['name'] = pg_field_name($result, $field_number);
     $arr['table'] = pg_field_table($result, $field_number);
     $arr['max_length'] = pg_field_size($result, $field_number);
     $arr['not_null'] = @pg_field_is_null($result, $field_number, $arr['name']);
     $arr['primary_key'] = -1;
     $arr['unique_key '] = -1;
     $arr['multiple_key'] = -1;
     $arr['numeric'] = -1;
     $arr['blob'] = -1;
     $arr['type'] = $pg_to_php[pg_field_type($result, $file_number)];
     $arr['unsigned'] = -1;
     $arr['zerofill'] = -1;
     return (object) $arr;
 }

 public function fetch_field_direct($offset)
 {
     if ($this->field_count <= $offset || 0 > $offset) {
         return false;
     }
     $type = pg_field_type($this->result, $offset);
     $info = new stdClass();
     $info->name = pg_field_name($this->result, $offset);
     $info->table = pg_field_table($this->result, $offset);
     $info->type = self::$field_types[$type];
     $info->def = null;
     $info->flags = 0;
     if ('bytea' === $type) {
         $field->flags |= 16;
     }
     # BLOB
     /*
     		NOT_NULL_FLAG = 1
     		PRI_KEY_FLAG = 2
     		UNIQUE_KEY_FLAG = 4
     		BLOB_FLAG = 16
     		UNSIGNED_FLAG = 32
     		ZEROFILL_FLAG = 64
     		BINARY_FLAG = 128
     		ENUM_FLAG = 256
     		AUTO_INCREMENT_FLAG = 512
     		TIMESTAMP_FLAG = 1024
     		SET_FLAG = 2048
     		NUM_FLAG = 32768
     		PART_KEY_FLAG = 16384
     		GROUP_FLAG = 32768
     		UNIQUE_FLAG = 65536
     */
     //		$info->orgname  = $info->name;
     //		$info->orgtable = $info->table;
     return $info;
     /*
     		$info->max_length = pg_field_size($this->result, $offset);
     		$info->max_length = pg_field_prtlen($this->result, $offset);
     		decimals   The number of decimals used
     */
 }

    $qtext = $qtext . " LIMIT {$query_limit}";
}
$qtext = $qtext . ";";
//echo $post;
echo $qtext . "\n";
//echo $post . "\n" . $qtext . "\n";
$pgc = postgis_connect();
@($result = pg_query($pgc, $qtext));
pg_close($pgc);
if (!$result) {
    echo '<?xml version="1.0"?>
  <query_result result="ERROR" reason="Error performing query: Query failed in database."/>';
    die;
}
$xml = new SimpleXMLElement("<query_result/>");
$xml->addAttribute("table", pg_field_table($result, 0));
$xml->addAttribute("token", $query_token);
if ($query_limit == "0") {
    $xml->addAttribute("result", "FIELDS");
    for ($i = 0; $i < pg_num_fields($result); $i++) {
        $field = $xml->addChild("field");
        $field->addAttribute("name", pg_field_name($result, $i));
        $field->addAttribute("type", pg_field_type($result, $i));
    }
} else {
    $xml->addAttribute("result", "ROWS");
}
while ($row = pg_fetch_row($result)) {
    $rowXML = $xml->addChild("row");
    for ($i = 0; $i < count($row); $i++) {
        $field = $rowXML->addChild("field", $row[$i]);

 function getFieldInfo($stack = 0)
 {
     $fields = array();
     $tables = array();
     $num_fields = pg_num_fields($this->result[$stack]);
     for ($i = 0; $i < $num_fields; $i++) {
         $f = new StdClass();
         $f->name = pg_field_name($this->result[$stack], $i);
         $f->table = pg_field_table($this->result[$stack], $i);
         $f->type = pg_field_type($this->result[$stack], $i);
         $f->blob = 0;
         $f->pkey = 0;
         $f->ukey = 0;
         $f->mkey = 0;
         //$f->zerofill = ($meta->flags & ZEROFILL_FLAG) ? 1 : 0;
         //$f->unsigned = ($meta->flags & UNSIGNED_FLAG) ? 1 : 0;
         //$f->autoinc = ($meta->flags & AUTO_INCREMENT_FLAG) ? 1 : 0;
         $f->numeric = substr($f->type, 0, 3) == 'int' ? 1 : 0;
         /*if ($meta->flags & ENUM_FLAG)
         			$f->type = 'enum';
         		else if ($meta->flags & SET_FLAG)
         			$f->type = 'set';
         		else if ($meta->flags & BINARY_FLAG)
         			$f->type = 'binary';
         		else if ($meta->type < 10)
         			$f->type = 'numeric';
         		else
         			$f->type = 'char';
         		if ($f->type == 'enum' || $f->type == 'set')
         			$f->list = $this->getFieldValues($f->table, $f->name);
         		 */
         if (!isset($tables[$f->table])) {
             $tables[$f->table] = array();
         }
         $tables[$f->table][] = "'" . $f->name . "'";
         $fields[] = $f;
     }
     $this->getFieldMetaInfo($fields, $tables);
     $this->getFieldConstraints($fields, $tables);
     return $fields;
 }

echo "<center><h1>Votre requête : " . $req . "</h1>";
$query = pg_query($dbconn, $req);
if (!$query) {
    die("Erreur dans la requete : " . $req);
}
echo "<table border=\"1px\" witdh='50%'>";
echo "<tr>";
for ($i = 0; $i < pg_num_fields($query); $i++) {
    echo "<th>" . pg_field_name($query, $i) . "</th>";
}
echo "</tr>";
for ($i = 0; $i < pg_num_rows($query); $i++) {
    echo "<tr>";
    for ($j = 0; $j < pg_num_fields($query); $j++) {
        if (pg_field_type($query, $j) == "bytea") {
            $table = pg_field_table($query, 0);
            echo "<td><img width='60%' src='photo.php?table=" . $table . "&id=" . pg_field_name($query, 0) . "&valeur=" . pg_fetch_result($query, $i, 0) . "&champ=" . pg_field_name($query, $j) . "'></td>";
        } else {
            echo "<td>" . pg_fetch_result($query, $i, $j) . "</td>";
        }
    }
    echo "</tr>";
}
echo "</table>";
pg_free_result($query);
pg_close($dbconn);
?>
			<a href="formulaire.html"> Retour au formulaire</a><br/>
		</center>
	</body>
</html>

 function fieldTable($rs, $off_set_field)
 {
     if ($this->bd->sgdb == 'MySQL') {
         return mysql_field_table($rs, $off_set_field);
     } else {
         return pg_field_table($rs, $off_set_field);
     }
 }