本文整理汇总了PHP中oci_field_size函数的典型用法代码示例。如果您正苦于以下问题:PHP oci_field_size函数的具体用法?PHP oci_field_size怎么用?PHP oci_field_size使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了oci_field_size函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: field_data
public function field_data()
{
$retval = array();
for ($c = 1, $fieldCount = $this->num_fields(); $c <= $fieldCount; $c++) {
$F = new stdClass();
$F->name = oci_field_name($this->stmt_id, $c);
$F->type = oci_field_type($this->stmt_id, $c);
$F->max_length = oci_field_size($this->stmt_id, $c);
$retval[] = $F;
}
return $retval;
}
开发者ID:pepegarcia,项目名称:publicidadoficialdemo-1,代码行数:12,代码来源:oci8_result.php
示例2: getFields
/**
* Returns an array of fields according to columns in the result.
*
* @return \Bitrix\Main\Entity\ScalarField[]
*/
public function getFields()
{
if ($this->resultFields == null) {
$this->resultFields = array();
if (is_resource($this->resource)) {
$numFields = oci_num_fields($this->resource);
if ($numFields > 0 && $this->connection) {
$helper = $this->connection->getSqlHelper();
for ($i = 1; $i <= $numFields; $i++) {
$name = oci_field_name($this->resource, $i);
$type = oci_field_type($this->resource, $i);
$parameters = array("precision" => oci_field_precision($this->resource, $i), "scale" => oci_field_scale($this->resource, $i), "size" => oci_field_size($this->resource, $i));
$this->resultFields[$name] = $helper->getFieldByColumnType($name, $type, $parameters);
}
}
}
}
return $this->resultFields;
}
开发者ID:Satariall,项目名称:izurit,代码行数:24,代码来源:oracleresult.php
示例3: _FetchField
function _FetchField($fieldOffset = -1)
{
global $QUERCUS;
$fld = new ADOFieldObject();
if (!empty($QUERCUS)) {
$fld->name = oci_field_name($this->_queryID, $fieldOffset);
$fld->type = oci_field_type($this->_queryID, $fieldOffset);
$fld->max_length = oci_field_size($this->_queryID, $fieldOffset);
//if ($fld->name == 'VAL6_NUM_12_4') $fld->type = 'NUMBER';
switch ($fld->type) {
case 'string':
$fld->type = 'VARCHAR';
break;
case 'real':
$fld->type = 'NUMBER';
break;
}
} else {
$fieldOffset += 1;
$fld->name = oci_field_name($this->_queryID, $fieldOffset);
$fld->type = oci_field_type($this->_queryID, $fieldOffset);
$fld->max_length = oci_field_size($this->_queryID, $fieldOffset);
}
switch ($fld->type) {
case 'NUMBER':
$p = oci_field_precision($this->_queryID, $fieldOffset);
$sc = oci_field_scale($this->_queryID, $fieldOffset);
if ($p != 0 && $sc == 0) {
$fld->type = 'INT';
}
$fld->scale = $p;
break;
case 'CLOB':
case 'NCLOB':
case 'BLOB':
$fld->max_length = -1;
break;
}
return $fld;
}
开发者ID:ceryxSeidor,项目名称:ProyectoPruebaWSV2,代码行数:40,代码来源:adodb-oci8quercus.inc.php
示例4: _getColumnMeta
private function _getColumnMeta($stmt, $columnIndex = 0)
{
$meta['name'] = \strtoupper(oci_field_name($stmt, $columnIndex + 1));
$meta['len'] = oci_field_size($stmt, $columnIndex + 1);
$type = oci_field_type($stmt, $columnIndex + 1);
$rType = 'C';
if ($type == "VARCHAR") {
$rType = 'C';
} elseif ($type == "CHAR") {
$rType = 'C';
} elseif ($type == "NUMBER") {
$rType = 'N';
} elseif ($type == "DATE") {
$rType = 'D';
} elseif ($type == "TIMESTAMP") {
$rType = 'D';
} elseif ($type == "BLOB") {
$rType = 'O';
} elseif ($type == "CLOB") {
$rType = 'O';
}
$meta['type'] = $rType;
return $meta;
}
开发者ID:joshuacoddingyou,项目名称:php,代码行数:24,代码来源:platform.php
示例5: FieldSize
public function FieldSize($statement, $field)
{
return oci_field_size($statement, $field);
}
开发者ID:Zniel,项目名称:fl_crtlpanel_self_dev,代码行数:4,代码来源:pm_oracle.class.php
示例6: getColumnsMeta
/**
* Returns metadata for all columns in a result set.
*
* @return array
*/
public function getColumnsMeta()
{
$count = oci_num_fields($this->resultSet);
$meta = array();
for ($i = 1; $i <= $count; $i++) {
// items 'name' and 'table' are required
$meta[] = array('name' => oci_field_name($this->resultSet, $i), 'table' => NULL, 'type' => oci_field_type($this->resultSet, $i), 'size' => oci_field_size($this->resultSet, $i), 'scale' => oci_field_scale($this->resultSet, $i), 'precision' => oci_field_precision($this->resultSet, $i));
}
return $meta;
}
开发者ID:laiello,项目名称:webuntucms,代码行数:15,代码来源:oracle.php
示例7: getField
public function getField($field)
{
set_error_handler(static::getErrorHandler());
$name = oci_field_name($this->resource, $field);
$precision = oci_field_precision($this->resource, $field);
$scale = oci_field_scale($this->resource, $field);
$size = oci_field_size($this->resource, $field);
$rawType = oci_field_type_raw($this->resource, $field);
$type = oci_field_type($this->resource, $field);
$value = oci_field_is_null($this->resource, $field) ? null : oci_result($this->resource, $field);
$field = new Oci8Field($name, $value, $size, $precision, $scale, $type, $rawType);
restore_error_handler();
return $field;
}
开发者ID:jpina,项目名称:oci8,代码行数:14,代码来源:Oci8Statement.php
示例8: get_columns
public function get_columns($stmt = null)
{
$stmt = is_null($stmt) ? $this->__cur : $stmt;
$cols = array();
$ncol = oci_num_fields($stmt);
for ($i = 1; $i <= $ncol; $i++) {
$cols[] = array('native_type' => oci_field_type($stmt, $i), 'flags' => array(), 'name' => oci_field_name($stmt, $i), 'len' => oci_field_size($stmt, $i), 'pdo_type' => oci_field_type_raw($stmt, $i));
}
return $cols;
}
开发者ID:spinit,项目名称:osy,代码行数:10,代码来源:DboOci.php
示例9: getColumnMeta
/**
* Returns metadata for a column in a result set.
*
* @param int #column The 0-indexed column in the result set.
* @return array Returns an associative array representing the metadata for a single column
*/
public function getColumnMeta($column)
{
if (!is_int($column)) {
throw new OCIException($this->setErrorInfo('0A000', '9999', "Invalid Column type specfied: {$column}. Expecting an int."));
}
$column++;
return ['native_type' => oci_field_type($this->stmt, $column), 'driver:decl_type' => oci_field_type_raw($this->stmt, $column), 'name' => oci_field_name($this->stmt, $column), 'len' => oci_field_size($this->stmt, $column), 'precision' => oci_field_precision($this->stmt, $column)];
}
开发者ID:mickael83,项目名称:Laravel-OracleDB,代码行数:14,代码来源:OCIStatement.php
示例10: columnData
public function columnData()
{
if (empty($this->query)) {
return false;
}
$columns = array();
for ($i = 1, $c = $this->num_fields(); $i <= $c; $i++) {
$field = new stdClass();
$field->name = oci_field_name($this->query, $i);
$field->type = oci_field_type($this->query, $i);
$field->maxLength = oci_field_size($this->query, $i);
$columns[] = $field;
}
return $columns;
}
开发者ID:bytemtek,项目名称:znframework,代码行数:15,代码来源:Oci8.php
示例11: getColumnMeta
/**
* Returns metadata for a column in a result set.
* The array returned by this function is patterned after that
* returned by \PDO::getColumnMeta(). It includes the following
* elements:
* native_type
* driver:decl_type
* flags
* name
* table
* len
* precision
* pdo_type
*
* @param int $column The 0-indexed column in the result set.
* @return array An associative array containing the above metadata values
* for a single column.
*/
public function getColumnMeta($column)
{
// Columns in oci8 are 1-based; add 1 if it's a number
if (is_numeric($column)) {
$column++;
}
$meta = array();
$meta['native_type'] = oci_field_type($this->sth, $column);
$meta['driver:decl_type'] = oci_field_type_raw($this->sth, $column);
$meta['flags'] = array();
$meta['name'] = oci_field_name($this->sth, $column);
$meta['table'] = null;
$meta['len'] = oci_field_size($this->sth, $column);
$meta['precision'] = oci_field_precision($this->sth, $column);
$meta['pdo_type'] = null;
$meta['is_null'] = oci_field_is_null($this->sth, $column);
return $meta;
}
开发者ID:snelg,项目名称:pdo-via-oci8,代码行数:36,代码来源:Statement.php
示例12: getColumnMeta
public static function getColumnMeta($index, $sql)
{
if ($sql && $index >= 0) {
$newmeta = array();
$newmeta["name"] = oci_field_name($sql, $index + 1);
$newmeta["native_type"] = oci_field_type($sql, $index + 1);
$newmeta["len"] = oci_field_size($sql, $index + 1);
return $newmeta;
}
return false;
}
开发者ID:Russell-IO,项目名称:php-syslog-ng,代码行数:11,代码来源:jqGridOracle.php
示例13: getColumnMeta
public function getColumnMeta($column)
{
if ($column >= $this->columnCount()) {
return false;
}
$column++;
$result = array();
$result['native_type'] = oci_field_type($this->_result, $column);
if (oci_field_is_null($this->_result, $column)) {
$result['flags'] = 'is_null';
}
$result['name'] = oci_field_name($this->_result, $column);
$result['len'] = oci_field_size($this->_result, $column);
$result['precision'] = oci_field_precision($this->_result, $column) . '.' . oci_field_scale($this->_result, $column);
$result['pdo_type'] = PDO::PARAM_STR;
return $result;
}
开发者ID:Deepab23,项目名称:clinic,代码行数:17,代码来源:oci_statement.php
示例14: getColumnLength
/**
* Returns the length of the specified column
*
* @access public
* @param integer $Column
* @return integer
*/
function getColumnLength($iColumn)
{
if ((is_int($iColumn) or is_string($iColumn)) && $iColumn < oci_num_fields($id)) {
$id = $this->curs_id ? $this->curs_id : $this->stmt_id;
if (is_int($iColumn)) {
$iColumn++;
return oci_field_size($id, $iColumn);
} else {
return false;
}
} else {
if ($this->db_debug) {
log_message('error', 'Class CI_DB_oci10_result ' . "\t" . 'Method ' . __METHOD__ . ' ' . PHP_EOL . "\t\t" . 'Wrong parameter ' . $iColumn . '. Nb Max COlumns : ' . oci_num_fields($id) . PHP_EOL . " Connexion data " . PHP_EOL . " username : " . $this->username . PHP_EOL . " hostname : " . $this->hostname . PHP_EOL . " database : " . $this->database . PHP_EOL . " dbdriver : " . $this->dbdriver . PHP_EOL . " dbprefix : " . $this->dbprefix . PHP_EOL . " port : " . $this->port);
return $this->display_error('db_wrong_parameter', $iColumn);
}
return false;
}
}
开发者ID:rotac,项目名称:ci_package-abstraction,代码行数:25,代码来源:oci10_result.php
示例15: columnData
public function columnData($col = '')
{
if (empty($this->query)) {
return false;
}
$columns = [];
$count = $this->numFields();
for ($i = 1; $i <= $count; $i++) {
$fieldName = oci_field_name($this->query, $i);
$columns[$fieldName] = new \stdClass();
$columns[$fieldName]->name = $fieldName;
$columns[$fieldName]->type = oci_field_type($this->query, $i);
$columns[$fieldName]->maxLength = oci_field_size($this->query, $i);
$columns[$fieldName]->primaryKey = NULL;
$columns[$fieldName]->default = NULL;
}
if (isset($columns[$col])) {
return $columns[$col];
}
return $columns;
}
开发者ID:znframework,项目名称:znframework,代码行数:21,代码来源:Oracle.php
示例16: oracleMetadata
function oracleMetadata(&$db)
{
$id = $db->Query_ID;
$META = new stdClass();
#echo "SQL=".$db->LastSQL."<br>";
#echo "Columnas =".OCINumcols($id)."<br>";
$META->cols = array();
for ($ix = 1; $ix <= OCINumcols($id); $ix++) {
$col = oci_field_name($id, $ix);
$type = oci_field_type_raw($id, $ix);
$presicion = oci_field_precision($id, $ix);
$escala = oci_field_scale($id, $ix);
$standarType = MetaStandardType("Oracle", $type, $escala);
$META->colsbyname["{$col}"] = new stdClass();
$META->colsbyname["{$col}"]->{"type"} = $standarType;
$META->colsbyname["{$col}"]->{"precision"} = $presicion;
$META->colsbyname["{$col}"]->{"scale"} = $escala;
$META->colsbyname["{$col}"]->{"size"} = oci_field_size($id, $ix);
$META->colsbyname["{$col}"]->{"is_null"} = oci_field_is_null($id, $ix);
$META->colsbyname["{$col}"]->{"type_raw"} = $type;
$META->cols[$ix - 1] = new stdClass();
$META->cols[$ix - 1]->{"type"} = $standarType;
$META->cols[$ix - 1]->{"precision"} = $presicion;
$META->cols[$ix - 1]->{"scale"} = $escala;
$META->cols[$ix - 1]->{"size"} = oci_field_size($id, $ix);
$META->cols[$ix - 1]->{"is_null"} = oci_field_is_null($id, $ix);
$META->cols[$ix - 1]->{"type_raw"} = $type;
//if($db->Debug)
#echo"<b>[$col]</b>:"
#.$META->colsbyname["$col"]->type
#.' '.$META->colsbyname["$col"]->size
#.' Presicion='.$META->colsbyname["$col"]->precision
#.' Ecala='.$META->colsbyname["$col"]->scale
#.' '.$META->colsbyname["$col"]->is_null
#.' type='.$META->colsbyname["$col"]->type_raw
#.' '."<br>\n";
}
return $META;
}
开发者ID:santo-s,项目名称:do_sql.js,代码行数:39,代码来源:metadato_4.php
示例17: getColumnMeta
public function getColumnMeta($column)
{
if ($column >= $this->columnCount()) {
return false;
}
$column++;
$result = array('native_type' => oci_field_type($this->_result, $column), 'name' => oci_field_name($this->_result, $column), 'len' => oci_field_size($this->_result, $column), 'precision' => oci_field_precision($this->_result, $column) . '.' . oci_field_scale($this->_result, $column), 'pdo_type' => EhrlichAndreas_Pdo_Abstract::PARAM_STR);
if (oci_field_is_null($this->_result, $column)) {
$result['flags'] = 'is_null';
}
return $result;
}
开发者ID:ehrlichandreas,项目名称:ehrlichandreas1-pdo,代码行数:12,代码来源:Statement.php
示例18: metadata
public function metadata($tablename = null)
{
$ncols = oci_num_fields($this->statement);
if ($ncols) {
$column_names = array();
$column_types = array();
$column_sizes = array();
for ($i = 1; $i <= $ncols; $i++) {
$column_names[$i] = oci_field_name($this->statement, $i);
}
for ($i = 1; $i <= $ncols; $i++) {
$column_types[$i] = oci_field_type($this->statement, $i);
}
for ($i = 1; $i <= $ncols; $i++) {
$column_sizes[$i] = oci_field_size($this->statement, $i);
}
return new OracleMetadata($column_names, $column_types, $column_sizes, $this->rows(), $tablename);
} else {
throw new Exception('No metadata to fetch');
}
}
开发者ID:Evan-github,项目名称:oracle-oci-helper,代码行数:21,代码来源:oracle-oci-helper.php
示例19: oci_field_size
public static function oci_field_size($connection, $statement, $fieldNumber) {
self::checkOCIExtension('oci_field_size');
$size = @oci_field_size($statement, $fieldNumber);
if ($size === FALSE) {
$error = self::oci_error($statement);
throw new IllegalStateException(t(
"Could not retrieve field's (field number: %fieldNumber) size: %error",
array('%fieldNumber' => $fieldNumber, '%error' => t($error['message']))));
}
return $size;
}
开发者ID:reisystems-india,项目名称:GovDashboard-Community,代码行数:13,代码来源:OCIImplHelper.php
示例20: _FetchField
/**
* Get column information in the Recordset object.
* fetchField() can be used in order to obtain information about fields
* in a certain query result. If the field offset isn't specified, the next
* field that wasn't yet retrieved by fetchField() is retrieved
*
* @return object containing field information
*/
function _FetchField($fieldOffset = -1)
{
$fld = new ADOFieldObject();
$fieldOffset += 1;
$fld->name = oci_field_name($this->_queryID, $fieldOffset);
if (ADODB_ASSOC_CASE == ADODB_ASSOC_CASE_LOWER) {
$fld->name = strtolower($fld->name);
}
$fld->type = oci_field_type($this->_queryID, $fieldOffset);
$fld->max_length = oci_field_size($this->_queryID, $fieldOffset);
switch ($fld->type) {
case 'NUMBER':
$p = oci_field_precision($this->_queryID, $fieldOffset);
$sc = oci_field_scale($this->_queryID, $fieldOffset);
if ($p != 0 && $sc == 0) {
$fld->type = 'INT';
}
$fld->scale = $p;
break;
case 'CLOB':
case 'NCLOB':
case 'BLOB':
$fld->max_length = -1;
break;
}
return $fld;
}
开发者ID:advancingdesign,项目名称:ADOdb,代码行数:35,代码来源:adodb-oci8.inc.php
注:本文中的oci_field_size函数示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论