PHP: Hypertext Preprocessor (original) (raw)

`<?php// Create the table with:
// CREATE TABLE mytab (number_col NUMBER, varchar2_col varchar2(1),
// clob_col CLOB, date_col DATE);$conn = oci_connect("hr", "hrpwd", "localhost/XE");
if (!$conn) {
$m = oci_error();
trigger_error(htmlentities($m['message']), E_USER_ERROR);
}$stid = oci_parse($conn, "SELECT * FROM mytab");
oci_execute($stid, OCI_DESCRIBE_ONLY); // Use OCI_DESCRIBE_ONLY if not fetching rowsecho "<table border="1">\n";
echo "";
echo "Name";
echo "Type";
echo "Length";
echo "\n";$ncols = oci_num_fields($stid);

for ( i=1;i = 1; i=1;i <= ncols;ncols; ncols;i++) { columnname=ocifieldname(column_name = oci_field_name(columnname=ocifieldname(stid, i);<spanclass="katex"><spanclass="katex−mathml"><mathxmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>c</mi><mi>o</mi><mi>l</mi><mi>u</mi><mi>m</mi><msub><mi>n</mi><mi>t</mi></msub><mi>y</mi><mi>p</mi><mi>e</mi><mo>=</mo><mi>o</mi><mi>c</mi><msub><mi>i</mi><mi>f</mi></msub><mi>i</mi><mi>e</mi><mi>l</mi><msub><mi>d</mi><mi>t</mi></msub><mi>y</mi><mi>p</mi><mi>e</mi><mostretchy="false">(</mo></mrow><annotationencoding="application/x−tex">columntype=ocifieldtype(</annotation></semantics></math><spanclass="katex−html"aria−hidden="true"><spanclass="base"><spanclass="strut"style="height:0.8889em;vertical−align:−0.1944em;"><spanclass="mordmathnormal">co<spanclass="mordmathnormal"style="margin−right:0.01968em;">l<spanclass="mordmathnormal">u<spanclass="mordmathnormal">m<spanclass="mord"><spanclass="mordmathnormal">n<spanclass="msupsub"><spanclass="vlist−tvlist−t2"><spanclass="vlist−r"><spanclass="vlist"style="height:0.2806em;"><spanstyle="top:−2.55em;margin−left:0em;margin−right:0.05em;"><spanclass="pstrut"style="height:2.7em;"><spanclass="sizingreset−size6size3mtight"><spanclass="mordmathnormalmtight">t<spanclass="vlist−s"><spanclass="vlist−r"><spanclass="vlist"style="height:0.15em;"><spanclass="mordmathnormal"style="margin−right:0.03588em;">y<spanclass="mordmathnormal">p<spanclass="mordmathnormal">e<spanclass="mspace"style="margin−right:0.2778em;"><spanclass="mrel">=<spanclass="mspace"style="margin−right:0.2778em;"><spanclass="base"><spanclass="strut"style="height:1.0361em;vertical−align:−0.2861em;"><spanclass="mordmathnormal">oc<spanclass="mord"><spanclass="mordmathnormal">i<spanclass="msupsub"><spanclass="vlist−tvlist−t2"><spanclass="vlist−r"><spanclass="vlist"style="height:0.3361em;"><spanstyle="top:−2.55em;margin−left:0em;margin−right:0.05em;"><spanclass="pstrut"style="height:2.7em;"><spanclass="sizingreset−size6size3mtight"><spanclass="mordmathnormalmtight"style="margin−right:0.10764em;">f<spanclass="vlist−s"><spanclass="vlist−r"><spanclass="vlist"style="height:0.2861em;"><spanclass="mordmathnormal">i<spanclass="mordmathnormal">e<spanclass="mordmathnormal"style="margin−right:0.01968em;">l<spanclass="mord"><spanclass="mordmathnormal">d<spanclass="msupsub"><spanclass="vlist−tvlist−t2"><spanclass="vlist−r"><spanclass="vlist"style="height:0.2806em;"><spanstyle="top:−2.55em;margin−left:0em;margin−right:0.05em;"><spanclass="pstrut"style="height:2.7em;"><spanclass="sizingreset−size6size3mtight"><spanclass="mordmathnormalmtight">t<spanclass="vlist−s"><spanclass="vlist−r"><spanclass="vlist"style="height:0.15em;"><spanclass="mordmathnormal"style="margin−right:0.03588em;">y<spanclass="mordmathnormal">p<spanclass="mordmathnormal">e<spanclass="mopen">(stid,i); <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>c</mi><mi>o</mi><mi>l</mi><mi>u</mi><mi>m</mi><msub><mi>n</mi><mi>t</mi></msub><mi>y</mi><mi>p</mi><mi>e</mi><mo>=</mo><mi>o</mi><mi>c</mi><msub><mi>i</mi><mi>f</mi></msub><mi>i</mi><mi>e</mi><mi>l</mi><msub><mi>d</mi><mi>t</mi></msub><mi>y</mi><mi>p</mi><mi>e</mi><mo stretchy="false">(</mo></mrow><annotation encoding="application/x-tex">column_type = oci_field_type(</annotation></semantics></math>columntype=ocifieldtype(stid, i);<spanclass="katex"><spanclass="katex−mathml"><mathxmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>c</mi><mi>o</mi><mi>l</mi><mi>u</mi><mi>m</mi><msub><mi>n</mi><mi>t</mi></msub><mi>y</mi><mi>p</mi><mi>e</mi><mo>=</mo><mi>o</mi><mi>c</mi><msub><mi>i</mi><mi>f</mi></msub><mi>i</mi><mi>e</mi><mi>l</mi><msub><mi>d</mi><mi>t</mi></msub><mi>y</mi><mi>p</mi><mi>e</mi><mostretchy="false">(</mo></mrow><annotationencoding="application/x−tex">columntype=ocifieldtype(</annotation></semantics></math><spanclass="katex−html"aria−hidden="true"><spanclass="base"><spanclass="strut"style="height:0.8889em;vertical−align:−0.1944em;"><spanclass="mordmathnormal">co<spanclass="mordmathnormal"style="margin−right:0.01968em;">l<spanclass="mordmathnormal">u<spanclass="mordmathnormal">m<spanclass="mord"><spanclass="mordmathnormal">n<spanclass="msupsub"><spanclass="vlist−tvlist−t2"><spanclass="vlist−r"><spanclass="vlist"style="height:0.2806em;"><spanstyle="top:−2.55em;margin−left:0em;margin−right:0.05em;"><spanclass="pstrut"style="height:2.7em;"><spanclass="sizingreset−size6size3mtight"><spanclass="mordmathnormalmtight">t<spanclass="vlist−s"><spanclass="vlist−r"><spanclass="vlist"style="height:0.15em;"><spanclass="mordmathnormal"style="margin−right:0.03588em;">y<spanclass="mordmathnormal">p<spanclass="mordmathnormal">e<spanclass="mspace"style="margin−right:0.2778em;"><spanclass="mrel">=<spanclass="mspace"style="margin−right:0.2778em;"><spanclass="base"><spanclass="strut"style="height:1.0361em;vertical−align:−0.2861em;"><spanclass="mordmathnormal">oc<spanclass="mord"><spanclass="mordmathnormal">i<spanclass="msupsub"><spanclass="vlist−tvlist−t2"><spanclass="vlist−r"><spanclass="vlist"style="height:0.3361em;"><spanstyle="top:−2.55em;margin−left:0em;margin−right:0.05em;"><spanclass="pstrut"style="height:2.7em;"><spanclass="sizingreset−size6size3mtight"><spanclass="mordmathnormalmtight"style="margin−right:0.10764em;">f<spanclass="vlist−s"><spanclass="vlist−r"><spanclass="vlist"style="height:0.2861em;"><spanclass="mordmathnormal">i<spanclass="mordmathnormal">e<spanclass="mordmathnormal"style="margin−right:0.01968em;">l<spanclass="mord"><spanclass="mordmathnormal">d<spanclass="msupsub"><spanclass="vlist−tvlist−t2"><spanclass="vlist−r"><spanclass="vlist"style="height:0.2806em;"><spanstyle="top:−2.55em;margin−left:0em;margin−right:0.05em;"><spanclass="pstrut"style="height:2.7em;"><spanclass="sizingreset−size6size3mtight"><spanclass="mordmathnormalmtight">t<spanclass="vlist−s"><spanclass="vlist−r"><spanclass="vlist"style="height:0.15em;"><spanclass="mordmathnormal"style="margin−right:0.03588em;">y<spanclass="mordmathnormal">p<spanclass="mordmathnormal">e<spanclass="mopen">(stid,i); columnsize=ocifieldsize(column_size = oci_field_size(columnsize=ocifieldsize(stid, $i);

echo

"";
echo "$column_name";
echo "$column_type";
echo "$column_size";
echo "\n";
}

echo

"\n";// Outputs:
// Name Type Length
// NUMBER_COL NUMBER 22
// VARCHAR2_COL VARCHAR2 1
// CLOB_COL CLOB 4000
// DATE_COL DATE 7oci_free_statement($stid);
oci_close($conn);?>`