|
Последние активные темы форума |
|
ocicolumnsize
(PHP 3>= 3.0.4, PHP 4 , PHP 5) ocicolumnsize -- Return result column size
Descriptionint ocicolumnsize ( resource stmt, mixed column ) ocicolumnsize() returns the size of the column
as given by Oracle. You can either use
the column-number (1-Based) or the column-name for the
column parameter.
Пример 1. ocicolumnsize() example
<?php
$conn
=
OCILogon
(
"scott"
,
"tiger"
);
$stmt
=
OCIParse
(
$conn
,
"select * from emp"
);
OCIExecute
(
$stmt
);
echo
"<table border=\"1\">"
;
echo
"<tr>"
;
echo
"<th>Name</th>"
;
echo
"<th>Type</th>"
;
echo
"<th>Length</th>"
;
echo
"</tr>"
;
$ncols
=
OCINumCols
(
$stmt
);
for (
$i
=
1
;
$i
<=
$ncols
;
$i
++) {
$column_name
=
OCIColumnName
(
$stmt
,
$i
);
$column_type
=
OCIColumnType
(
$stmt
,
$i
);
$column_size
=
OCIColumnSize
(
$stmt
,
$i
);
echo
"<tr>"
;
echo
"<td>$column_name</td>"
;
echo
"<td>$column_type</td>"
;
echo
"<td>$column_size</td>"
;
echo
"</tr>"
;
}
echo
"</table>"
;
OCIFreeStatement
(
$stmt
);
OCILogoff
(
$conn
);
?>
|
|
Замечание:
This function was renamed to oci_field_size()
after PHP >= 5.0.0. For downward compatibility
ocicolumnsize() can also be used.
This is deprecated, however.
|