本文整理汇总了PHP中pg_field_type函数的典型用法代码示例。如果您正苦于以下问题:PHP pg_field_type函数的具体用法?PHP pg_field_type怎么用?PHP pg_field_type使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了pg_field_type函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: castResult
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;
}
开发者ID:JesseDarellMoore,项目名称:CS499,代码行数:33,代码来源:PgSqlCaster.php
示例2: PG_QueryStart
function PG_QueryStart($SQL, &$aFields, &$link, &$Errors)
{
$gMyHOST = "127.0.0.1";
$gMyDB = "osm";
$gMyUSER = "osm";
$gMyPASS = "insertPassword";
$Errors = "";
$result = false;
$conn_string = "host={$gMyHOST} port=5432 dbname={$gMyDB} user={$gMyUSER} password={$gMyPASS}";
$link = pg_connect($conn_string);
if ($link === false) {
$Errors .= "Impossibile connettersi a '{$gMyHOST}' come '{$gMyUSER}'";
} else {
$result = pg_query($SQL);
if ($result === false) {
$Errors .= ($Errors[0] ? "" : "<br>") . "Errore durante la query '{$SQL}': " . pg_last_error();
} else {
$nFields = pg_num_fields($result);
for ($ind = 0; $ind < $nFields; $ind++) {
$aFields[$ind] = array(pg_field_name($result, $ind), pg_field_type($result, $ind));
}
}
}
return $result;
}
开发者ID:napo,项目名称:osm-italy-stats,代码行数:25,代码来源:DB_Func.php
示例3: query_start
function query_start($query)
{
// For reg expressions
$query = trim($query);
// Query was an insert, delete, update, replace
if (preg_match("/^(insert|delete|update|replace)\\s+/i", $query)) {
return false;
}
// Flush cached values..
$this->flush();
// Log how the function was called
$this->func_call = "\$db->query_start(\"{$query}\")";
// Keep track of the last query for debug..
$this->last_query = $query;
// Perform the query via std pg_query function..
if (!($this->result = @pg_query($this->dbh, $query))) {
$this->print_error();
return false;
}
$this->num_queries++;
// =======================================================
// Take note of column info
$i = 0;
while ($i < @pg_num_fields($this->result)) {
$this->col_info[$i]->name = pg_field_name($this->result, $i);
$this->col_info[$i]->type = pg_field_type($this->result, $i);
$this->col_info[$i]->size = pg_field_size($this->result, $i);
$i++;
}
$this->last_result = array();
$this->num_rows = 0;
// If debug ALL queries
$this->trace || $this->debug_all ? $this->debug() : null;
return true;
}
开发者ID:aim-web-projects,项目名称:kobe-chuoh,代码行数:35,代码来源:mtdb_postgres.php
示例4: postgis_query
function postgis_query($string, $pgc = NULL)
{
$pgct = $pgc;
if ($pgc == NULL) {
$pgct = postgis_connect();
}
@($result = pg_query($pgct, $string));
if ($pgc == NULL) {
pg_close($pgct);
}
$retval = array();
if (!$result) {
return $retval;
}
$arow = array();
for ($i = 0; $i < pg_num_fields($result); $i++) {
$arow[pg_field_name($result, $i)] = pg_field_type($result, $i);
}
$retval[0] = $arow;
$ctr = 1;
while ($row = pg_fetch_row($result)) {
$arow = array();
for ($i = 0; $i < count($row); $i++) {
$arow[pg_field_name($result, $i)] = $row[$i];
}
$retval[$ctr] = $arow;
$ctr++;
}
pg_free_result($result);
return $retval;
}
开发者ID:rvaidya,项目名称:FlexGIS,代码行数:31,代码来源:helper.php
示例5: getTypes
public function getTypes()
{
$types = [];
$count = pg_num_fields($this->result);
for ($i = 0; $i < $count; $i++) {
$nativeType = pg_field_type($this->result, $i);
$types[pg_field_name($this->result, $i)] = [0 => isset(self::$types[$nativeType]) ? self::$types[$nativeType] : self::TYPE_AS_IS, 1 => $nativeType];
}
return $types;
}
开发者ID:nextras,项目名称:dbal,代码行数:10,代码来源:PgsqlResultAdapter.php
示例6: __construct
/**
* Constructor
*
* @param resource handle
*/
public function __construct($result, TimeZone $tz = NULL)
{
$fields = array();
if (is_resource($result)) {
for ($i = 0, $num = pg_num_fields($result); $i < $num; $i++) {
$fields[pg_field_name($result, $i)] = pg_field_type($result, $i);
}
}
parent::__construct($result, $fields, $tz);
}
开发者ID:melogamepay,项目名称:xp-framework,代码行数:15,代码来源:PostgreSQLResultSet.class.php
示例7: _performGetBlobFieldNames
function _performGetBlobFieldNames($result)
{
$blobFields = array();
for ($i = pg_num_fields($result) - 1; $i >= 0; $i--) {
$type = pg_field_type($result, $i);
if (strpos($type, "BLOB") !== false) {
$blobFields[] = pg_field_name($result, $i);
}
}
return $blobFields;
}
开发者ID:Sarjuuk,项目名称:DbSimple,代码行数:11,代码来源:Postgresql.php
示例8: GetFields
function GetFields()
{
$_fields = array();
$_result = pg_query($this->_Link, $this->SelectCommand);
$_num_fields = pg_num_fields($_result);
for ($i = 0; $i < $_num_fields; $i++) {
$_field = array("Name" => pg_field_name($_result, $i), "Type" => pg_field_type($_result, $i), "Not_Null" => 0);
array_push($_fields, $_field);
}
return $_fields;
}
开发者ID:skydel,项目名称:universal-online-exam,代码行数:11,代码来源:PostgreSLDataSource.php
示例9: db_getfieldslist
/**
* @param String strSQL
* @return Array
*/
public function db_getfieldslist($strSQL)
{
$res = array();
$qResult = $this->connectionObj->query($strSQL);
$fieldsNumber = $qResult->numFields();
for ($i = 0; $i < $fieldsNumber; $i++) {
$stype = pg_field_type($qResult->getQueryHandle(), $i);
$ntype = $this->getFeldTypeNumber($stype);
$res[$i] = array("fieldname" => $qResult->fieldName($i), "type" => $ntype, "is_nullable" => 0);
}
return $res;
}
开发者ID:ryanblanchard,项目名称:Dashboard,代码行数:16,代码来源:PostgreInfo.php
示例10: getColumnMeta
public function getColumnMeta($column)
{
if ($column >= $this->columnCount()) {
return false;
}
$result = array();
$result['native_type'] = pg_field_type($this->_result, $column);
$result['table'] = pg_field_table($this->_result, $column);
$result['name'] = pg_field_name($this->_result, $column);
$result['len'] = pg_field_prtlen($this->_result, $column);
$result['pdo_type'] = PDO::PARAM_STR;
return $result;
}
开发者ID:PHPcomaptibility,项目名称:PHPPDO,代码行数:13,代码来源:pgsql_statement.php
示例11: db_getfieldslist
function db_getfieldslist($strSQL)
{
global $conn;
$res=array();
$rs=db_query($strSQL,$conn);
for($i=0;$i<db_numfields($rs);$i++)
{
$stype=pg_field_type($rs,$i);
$ntype=db_fieldtypenum($stype);
$res[$i]=array("fieldname"=>db_fieldname($rs,$i),"type"=>$ntype,"is_nullable"=>0);
}
return $res;
}
开发者ID:helbertfurbino,项目名称:sgmofinanceiro,代码行数:13,代码来源:dbinfo.pg.php
示例12: getFieldData
/**
* Generates an array of objects representing field meta-data.
*
* @return array
*/
public function getFieldData() : array
{
$retval = [];
for ($i = 0, $c = $this->getFieldCount(); $i < $c; $i++) {
$retval[$i] = new \stdClass();
$retval[$i]->name = pg_field_name($this->resultID, $i);
$retval[$i]->type = pg_field_type($this->resultID, $i);
$retval[$i]->max_length = pg_field_size($this->resultID, $i);
// $retval[$i]->primary_key = (int)($fieldData[$i]->flags & 2);
// $retval[$i]->default = $fieldData[$i]->def;
}
return $retval;
}
开发者ID:titounnes,项目名称:CodeIgniter4,代码行数:18,代码来源:Result.php
示例13: __construct
public function __construct($resource)
{
if (!is_resource($resource) || is_resource($resource) && get_resource_type($resource) !== self::EXPECTED_RESOURCE_TYPE) {
throw new DatabaseException('Invalid resource type passed, expected "' . $this->expectedResource . '" and got "' . get_resource_type($resource) . '"');
}
$this->resource = $resource;
$this->count = pg_num_rows($this->resource);
// Build an array of column types
$this->fieldCount = pg_num_fields($this->resource);
for ($i = 0; $i < $this->fieldCount; ++$i) {
$this->types[$i] = [pg_field_name($this->resource, $i), pg_field_type($this->resource, $i)];
}
}
开发者ID:moberemk,项目名称:lazy-collections,代码行数:13,代码来源:PostgresResultIterator.php
示例14: __construct
public function __construct($result)
{
$this->result = $result;
$this->row = 0;
$this->max = pg_num_rows($result);
if ($this->max > 0) {
$this->types = [];
$num_fields = pg_num_fields($result);
for ($i = 0; $i < $num_fields; $i++) {
$this->types[pg_field_name($result, $i)] = pg_field_type($result, $i);
}
}
}
开发者ID:edruid,项目名称:SnakeDruid,代码行数:13,代码来源:PGDatabase.php
示例15: field_structures
/**
* Structure of our fields (type, length and null)
*
* @param resource $resource
* @return array
*/
public function field_structures($resource)
{
$result = [];
if ($resource) {
for ($i = 0; $i < pg_num_fields($resource); $i++) {
$name = pg_field_name($resource, $i);
$result[$name]['type'] = pg_field_type($resource, $i);
$result[$name]['null'] = pg_field_is_null($resource, $i);
$result[$name]['length'] = pg_field_size($resource, $i);
}
}
return $result;
}
开发者ID:volodymyr-volynets,项目名称:backend,代码行数:19,代码来源:base.php
示例16: __construct
/**
* Build a new recordset to iterate over.
*
* @param resource $result A pg_query() result object to create a recordset from.
*/
public function __construct($result)
{
$this->result = $result;
// Find out if there are any blobs.
$numfields = pg_num_fields($result);
for ($i = 0; $i < $numfields; $i++) {
$type = pg_field_type($result, $i);
if ($type == 'bytea') {
$this->blobs[] = pg_field_name($result, $i);
}
}
$this->current = $this->fetch_next();
}
开发者ID:evltuma,项目名称:moodle,代码行数:18,代码来源:pgsql_native_moodle_recordset.php
示例17: field_data
/**
* Field data
*
* Generates an array of objects containing field meta-data
*
* @access public
* @return array
*/
function field_data()
{
$retval = array();
for ($i = 0; $i < $this->num_fields(); $i++) {
$F = new stdClass();
$F->name = pg_field_name($this->result_id, $i);
$F->type = pg_field_type($this->result_id, $i);
$F->max_length = pg_field_size($this->result_id, $i);
$F->primary_key = 0;
$F->default = '';
$retval[] = $F;
}
return $retval;
}
开发者ID:ayuinc,项目名称:laboratoria-v2,代码行数:22,代码来源:postgre_result.php
示例18: fieldsMemory
function fieldsMemory($rs, $idx, $formata = false, $mostra = false, $lEncode = false)
{
$oFields = new _db_fields();
$numFields = pg_num_fields($rs);
$iTotalLinhas = pg_num_rows($rs);
for ($i = 0; $i < $numFields; $i++) {
$sValor = "";
$sFieldName = @pg_field_name($rs, $i);
$sFieldType = @pg_field_type($rs, $i);
if ($iTotalLinhas > 0) {
$sValor = trim(@pg_result($rs, $idx, $sFieldName));
}
if ($formata) {
switch ($sFieldType) {
case "date":
if ($sValor != null) {
$sValor = implode('/', array_reverse(explode("-", $sValor)));
}
break;
default:
$sValor = stripslashes($sValor);
break;
}
}
if ($mostra) {
echo $sFieldName . " => " . $sValor . " <br>";
}
if ($lEncode) {
switch ($sFieldType) {
case "bpchar":
$sValor = urlencode($sValor);
break;
case "varchar":
$sValor = urlencode($sValor);
break;
case "text":
$sValor = urlencode($sValor);
break;
}
}
$oFields->{$sFieldName} = $sValor;
}
return $oFields;
}
开发者ID:arendasistemasintegrados,项目名称:mateusleme,代码行数:44,代码来源:db_utils.php
示例19: __get
/**
* Dynamic Get Function Override
*
* @param $name
* A string containing the name of the property to get.
* @return
* Value of the property.
*/
public function __get($propertyName)
{
global $firePHP;
if ($propertyName == 'columns') {
if (!isset($this->_columns)) {
//---- Get Columns
$this->_columns = new anvilCollection();
$i = 0;
// $sql = 'SHOW COLUMNS FROM ';
while ($i < pg_num_fields($this->result)) {
$newColumn = new anvilData_postgresql_Column(pg_field_name($this->result, $i), pg_field_type($this->result, $i));
$this->_columns->add($newColumn);
$i++;
}
}
return $this->_columns;
} else {
return parent::__get($propertyName);
}
}
开发者ID:nslevkoff,项目名称:phpAnvil2,代码行数:28,代码来源:anvilData_postgresql_Recordset.class.php
示例20: factory
/**
* @param resource from pg_query() or pg_get_result()
* @param string SQL used to create this result
* @param resource from pg_connect() or pg_pconnect()
* @param boolean|string
* @return void
*/
public static function factory($result, $sql, $link, $return_objects)
{
// Detect errors, initialize values
$postgresql_result = new Database_Postgresql_Result($result, $sql, $link, $return_objects);
// No rows, nothing to transform
if ($postgresql_result->total_rows === 0) {
return $postgresql_result;
}
$booleans = FALSE;
// Create list of boolean field names
for ($i = pg_num_fields($result) - 1; $i >= 0; --$i) {
if (pg_field_type($result, $i) === 'bool') {
$booleans[] = pg_field_name($result, $i);
}
}
// No booleans to transform, regular result set is fastest
if ($booleans === FALSE) {
return $postgresql_result;
}
return new Database_Postgresql_Result_Boolean($postgresql_result, $booleans);
}
开发者ID:anqqa,项目名称:Anqh,代码行数:28,代码来源:Database_Postgresql_Result_Boolean.php
注:本文中的pg_field_type函数示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论