cucinato Thu Nov 22 06:04:04 2001 EDT
Modified files:
/phpdoc/it/functions oci8.xml
Log:
Finished CDATA update
Index: phpdoc/it/functions/oci8.xml
diff -u phpdoc/it/functions/oci8.xml:1.18 phpdoc/it/functions/oci8.xml:1.19
--- phpdoc/it/functions/oci8.xml:1.18 Wed Nov 21 16:56:21 2001
+++ phpdoc/it/functions/oci8.xml Thu Nov 22 06:04:04 2001
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
- <!-- EN-Revision: 1.35 Maintainer: cucinato Status: ready -->
+ <!-- EN-Revision: 1.36 Maintainer: cucinato Status: ready -->
<reference id="ref.oci8">
<title>Funzioni Oracle 8</title>
<titleabbrev>OCI8</titleabbrev>
@@ -97,21 +97,21 @@
</note>
<para>
<example>
- <title>OCI Hints</title>
+ <title>Trucchi OCI</title>
<programlisting role="php">
<![CDATA[
<?php
// by [EMAIL PROTECTED]
-// Use option: OCI_DEFAULT for execute command to delay execution
+// Usare l'opzione OCI_DEFAULT nel comando execute per ritardare l'esicuzione
OCIExecute($stmt, OCI_DEFAULT);
-// for retrieve data use (after fetch):
+// per ricevere i dati utilizzare (dopo il fetch):
$result = OCIResult($stmt, $n);
if (is_object ($result)) $result = $result->load();
-// For INSERT or UPDATE statement use:
+// come comandi INSERT o UPDATE usare:
$sql = "insert into table (field1, field2) values (field1 = 'value',
field2 = empty_clob()) returning field2 into :field2";
@@ -132,27 +132,29 @@
would from the commands line.
<example>
<title>Using Stored Procedures</title>
- <programlisting role="php">
-<?php
+ <programlisting role="php">
+<![CDATA[
+<?php
// by [EMAIL PROTECTED]
$sth = OCIParse ( $dbh, "begin sp_newaddress( :address_id, '$firstname',
'$lastname', '$company', '$address1', '$address2', '$city', '$state',
'$postalcode', '$country', :error_code );end;" );
-// This calls stored procedure sp_newaddress, with :address_id being an
-// in/out variable and :error_code being an out variable.
-// Then you do the binding:
+// Questo codice richiama la stord procedure sp_newaddress, dove :address_id �
+// una variabile in/out e :error_code � una variabile out.
+// Quindi si effettua il binding:
OCIBindByName ( $sth, ":address_id", $addr_id, 10 );
OCIBindByName ( $sth, ":error_code", $errorcode, 10 );
OCIExecute ( $sth );
-?>
+?>
+]]>
</programlisting>
</example>
</para>
</partintro>
-
+
<refentry id="function.ocidefinebyname">
<refnamediv>
<refname>OCIDefineByName</refname>
@@ -190,14 +192,15 @@
<example>
<title>OCIDefineByName</title>
<programlisting>
-<?php
+<![CDATA[
+<?php
/* OCIDefineByPos example [EMAIL PROTECTED] (980219) */
$conn = OCILogon("scott","tiger");
$stmt = OCIParse($conn,"select empno, ename from emp");
-/* the define MUST be done BEFORE ociexecute! */
+/* il define DEVE essere eseguito PRIMA di ociexecute! */
OCIDefineByName($stmt,"EMPNO",$empno);
OCIDefineByName($stmt,"ENAME",$ename);
@@ -212,6 +215,7 @@
OCIFreeStatement($stmt);
OCILogoff($conn);
?>
+]]>
</programlisting>
</example>
</refsect1>
@@ -259,13 +263,14 @@
(Character-File), OCI_B_CLOB (Character-LOB), OCI_B_BLOB
(Binary-LOB) e OCI_B_ROWID (ROWID).
</para>
- <example>
- <title>OCIDefineByName</title>
- <programlisting>
-<?php
+ <example>
+ <title>OCIDefineByName</title>
+ <programlisting>
+<![CDATA[
+<?php
/* OCIBindByPos example [EMAIL PROTECTED] (980221)
- inserts 3 records into emp, and uses the ROWID for updating the
- records just after the insert.
+ inserisce 3 tuple in emp, e usa ROWID per aggiornare le
+ tuple subito dopo l'inserimento.
*/
$conn = OCILogon("scott","tiger");
@@ -312,8 +317,9 @@
OCILogoff($conn);
?>
- </programlisting>
- </example>
+]]>
+ </programlisting>
+ </example>
<warning>
<para>
It is a bad idea to use magic quotes and
@@ -363,8 +369,9 @@
<example>
<title>OCILogon</title>
<programlisting>
-<?php
-print "<HTML><PRE>";
+<![CDATA[
+<?php
+print "<HTML><PRE>";
$db = "";
$c1 = ocilogon("scott","tiger",$db);
@@ -410,7 +417,7 @@
ociexecute($stmt,OCI_DEFAULT);
echo $conn."----selecting\n\n";
while (ocifetch($stmt))
- echo $conn." <".ociresult($stmt,"TEST").">\n\n";
+ echo $conn." <".ociresult($stmt,"TEST").">\n\n";
echo $conn."----done\n\n";
}
@@ -441,8 +448,12 @@
drop_table($c1);
-print "</PRE></HTML>";
-?></programlisting></example></para>
+print "</PRE></HTML>";
+?>
+]]>
+ </programlisting>
+ </example>
+ </para>
<simpara>
Vedere anche <function>OCIPLogon</function> e
<function>OCINLogon</function>.</simpara>
@@ -462,9 +473,9 @@
<funcdef>int <function>OCIPLogon</function></funcdef>
<paramdef>string <parameter>username</parameter></paramdef>
<paramdef>string <parameter>password</parameter></paramdef>
- <paramdef>string
+ <paramdef>string
<parameter><optional>db</optional></parameter>
- </paramdef>
+ </paramdef>
</funcprototype>
</funcsynopsis>
<para>
@@ -496,7 +507,7 @@
<funcdef>int <function>OCINLogon</function></funcdef>
<paramdef>string <parameter>username</parameter></paramdef>
<paramdef>string <parameter>password</parameter></paramdef>
- <paramdef>string
+ <paramdef>string
<parameter><optional>db</optional></parameter>
</paramdef>
</funcprototype>
@@ -524,8 +535,9 @@
<example>
<title>OCINLogon</title>
<programlisting>
-<?php
-print "<HTML><PRE>";
+<![CDATA[
+<?php
+print "<HTML><PRE>";
$db = "";
$c1 = ocilogon("scott","tiger",$db);
@@ -572,7 +584,7 @@
ociexecute($stmt,OCI_DEFAULT);
echo $conn."----selecting\n\n";
while (ocifetch($stmt))
- echo $conn." <".ociresult($stmt,"TEST").">\n\n";
+ echo $conn." <".ociresult($stmt,"TEST").">\n\n";
echo $conn."----done\n\n";
}
@@ -602,8 +614,11 @@
drop_table($c1);
-print "</PRE></HTML>";
-?></programlisting></example>
+print "</PRE></HTML>";
+?>
+]]>
+ </programlisting>
+ </example>
</para>
<simpara>
Vedere anche <function>OCILogon</function> e
@@ -642,7 +657,7 @@
<funcprototype>
<funcdef>int <function>OCIExecute</function></funcdef>
<paramdef>int <parameter>statement</parameter></paramdef>
- <paramdef>int
+ <paramdef>int
<parameter><optional>mode</optional></parameter>
</paramdef>
</funcprototype>
@@ -711,7 +726,7 @@
<funcprototype>
<funcdef>string <function>OCINewDescriptor</function></funcdef>
<paramdef>int <parameter>connection</parameter></paramdef>
- <paramdef>int
+ <paramdef>int
<parameter><optional>type</optional></parameter>
</paramdef>
</funcprototype>
@@ -724,25 +739,26 @@
associati al descrittore, per i BFILE esiste solo il
metodo load. Vedere i suggerimenti nel secondo esempio.
</para>
- <example>
- <title>OCINewDescriptor</title>
- <programlisting>
-<?php
- /* This script is designed to be called from a HTML form.
- * It expects $user, $password, $table, $where, and $commitsize
- * to be passed in from the form. The script then deletes
- * the selected rows using the ROWID and commits after each
- * set of $commitsize rows. (Use with care, there is no rollback)
+ <example>
+ <title>OCINewDescriptor</title>
+ <programlisting>
+<![CDATA[
+<?php
+ /* Questo codice deve essere richiamato da un form HTML.
+ * Richiede che $user, $password, $table, $where, e $commitsize
+ * siano passati dalla form. Il codice quindi cancella
+ * le tuple selezionate usando ROWID ed esegue un commit ogni
+ * $commitsize righe. (Usare con attenzione, non si pu� fare rollback)
*/
$conn = OCILogon($user, $password);
$stmt = OCIParse($conn,"select rowid from $table $where");
$rowid = OCINewDescriptor($conn,OCI_D_ROWID);
- OCIDefineByName($stmt,"ROWID",&$rowid);
+ OCIDefineByName($stmt,"ROWID",&$rowid);
OCIExecute($stmt);
while ( OCIFetch($stmt) ) {
$nrows = OCIRowCount($stmt);
$delete = OCIParse($conn,"delete from $table where ROWID = :rid");
- OCIBindByName($delete,":rid",&$rowid,-1,OCI_B_ROWID);
+ OCIBindByName($delete,":rid",&$rowid,-1,OCI_B_ROWID);
OCIExecute($delete);
print "$nrows\n";
if ( ($nrows % $commitsize) == 0 ) {
@@ -754,29 +770,31 @@
OCIFreeStatement($stmt);
OCILogoff($conn);
?>
+]]>
</programlisting>
<programlisting>
-<?php
- /* This script demonstrates file upload to LOB columns
- * The formfield used for this example looks like this
- * <form action="upload.php3" method="post" enctype="multipart/form-data">
- * <input type="file" name="lob_upload">
+<![CDATA[
+<?php
+ /* Questo codice dimostra l'upload di file verso campi LOB.
+ * Il form usato per questo esempio � del tipo seguente:
+ * <form action="upload.php3" method="post" enctype="multipart/form-data">
+ * <input type="file" name="lob_upload">
* ...
*/
if(!isset($lob_upload) || $lob_upload == 'none'){
?>
-<form action="upload.php3" method="post" enctype="multipart/form-data">
-Upload file: <input type="file" name="lob_upload"><br>
-<input type="submit" value="Upload"> - <input type="reset">
-</form>
-<?php
+<form action="upload.php3" method="post" enctype="multipart/form-data">
+Upload file: <input type="file" name="lob_upload"><br>
+<input type="submit" value="Upload"> - <input type="reset">
+</form>
+<?php
} else {
- // $lob_upload contains the temporary filename of the uploaded file
+ // $lob_upload contiene il nome del file temporaneo
$conn = OCILogon($user, $password);
$lob = OCINewDescriptor($conn, OCI_D_LOB);
$stmt = OCIParse($conn,"insert into $table (id, the_blob)
values(my_seq.NEXTVAL, EMPTY_BLOB()) returning the_blob into
:the_blob");
- OCIBindByName($stmt, ':the_blob', &$lob, -1, OCI_B_BLOB);
+ OCIBindByName($stmt, ':the_blob', &$lob, -1, OCI_B_BLOB);
OCIExecute($stmt, OCI_DEFAULT);
if($lob->savefile($lob_upload)){
OCICommit($conn);
@@ -789,11 +807,44 @@
OCILogoff($conn);
}
?>
- </programlisting>
- </example>
+]]>
+ </programlisting>
+ </example>
+ <example>
+ <title>OCINewDescriptor</title>
+ <programlisting>
+<![CDATA[
+<?php
+ /* Chiamatai di una stored procedure PL/SQLs che contiene clobs come parametri
+ * di input (PHP 4 >= 4.0.6).
+ * La signature della stored prodedure PL/SQL d'esempio �:
+ *
+ * PROCEDURE save_data
+ * Argument Name Type In/Out Default?
+ * ------------------------------ ----------------------- ------ --------
+ * KEY NUMBER(38) IN
+ * DATA CLOB IN
+ *
+ */
+
+ $conn = OCILogon($user, $password);
+ $stmt = OCIParse($conn, "begin save_data(:key, :data); end;");
+ $clob = OCINewDescriptor($conn, OCI_D_LOB);
+ OCIBindByName($stmt, ':key', $key);
+ OCIBindByName($stmt, ':data', $clob, -1, OCI_B_CLOB);
+ $clob->WriteTemporary($data);
+ OCIExecute($stmt, OCI_DEFAULT);
+ OCICommit($conn);
+ $clob->close();
+ $clob->free();
+ OCIFreeStatement($stmt);
+?>
+]]>
+ </programlisting>
+ </example>
</refsect1>
</refentry>
-
+
<refentry id="function.ocirowcount">
<refnamediv>
<refname>OCIRowCount</refname>
@@ -815,24 +866,28 @@
<example>
<title>OCIRowCount</title>
<programlisting>
-<?php
- print "<HTML><PRE>";
+<![CDATA[
+<?php
+ print "<HTML><PRE>";
$conn = OCILogon("scott","tiger");
$stmt = OCIParse($conn,"create table emp2 as select * from emp");
OCIExecute($stmt);
- print OCIRowCount($stmt) . " rows inserted.<BR>";
+ print OCIRowCount($stmt) . " rows inserted.<BR>";
OCIFreeStatement($stmt);
$stmt = OCIParse($conn,"delete from emp2");
OCIExecute($stmt);
- print OCIRowCount($stmt) . " rows deleted.<BR>";
+ print OCIRowCount($stmt) . " rows deleted.<BR>";
OCICommit($conn);
OCIFreeStatement($stmt);
$stmt = OCIParse($conn,"drop table emp2");
OCIExecute($stmt);
OCIFreeStatement($stmt);
OCILogOff($conn);
- print "</PRE></HTML>";
-?> </programlisting></example>
+ print "</PRE></HTML>";
+?>
+]]>
+ </programlisting>
+ </example>
</para>
</refsect1>
</refentry>
@@ -855,19 +910,20 @@
<para>
<function>OCINumCols</function> restituisce il numero di campi contenuti in
un'istruzione SQL
- </para>
- <example>
- <title>OCINumCols</title>
- <programlisting>
-<?php
- print "<HTML><PRE>\n";
+ </para>
+ <example>
+ <title>OCINumCols</title>
+ <programlisting>
+<![CDATA[
+<?php
+ print "<HTML><PRE>\n";
$conn = OCILogon("scott", "tiger");
$stmt = OCIParse($conn,"select * from emp");
OCIExecute($stmt);
while ( OCIFetch($stmt) ) {
print "\n";
$ncols = OCINumCols($stmt);
- for ( $i = 1; $i <= $ncols; $i++ ) {
+ for ( $i = 1; $i <= $ncols; $i++ ) {
$column_name = OCIColumnName($stmt,$i);
$column_value = OCIResult($stmt,$i);
print $column_name . ': ' . $column_value . "\n";
@@ -876,9 +932,10 @@
}
OCIFreeStatement($stmt);
OCILogoff($conn);
- print "</PRE>";
- print "</HTML>\n";
-?>
+ print "</PRE>";
+ print "</HTML>\n";
+ ?>
+]]>
</programlisting>
</example>
</refsect1>
@@ -1001,7 +1058,8 @@
<example>
<title>OCIFetchStatement</title>
<programlisting>
-<?php
+<![CDATA[
+<?php
/* OCIFetchStatement example [EMAIL PROTECTED] (990624) */
$conn = OCILogon("scott","tiger");
@@ -1012,36 +1070,37 @@
$nrows = OCIFetchStatement($stmt,$results);
if ( $nrows > 0 ) {
- print "<TABLE BORDER=\"1\">\n";
- print "<TR>\n";
+ print "<TABLE BORDER=\"1\">\n";
+ print "<TR>\n";
while ( list( $key, $val ) = each( $results ) ) {
- print "<TH>$key</TH>\n";
+ print "<TH>$key</TH>\n";
}
- print "</TR>\n";
+ print "</TR>\n";
- for ( $i = 0; $i < $nrows; $i++ ) {
+ for ( $i = 0; $i < $nrows; $i++ ) {
reset($results);
- print "<TR>\n";
+ print "<TR>\n";
while ( $column = each($results) ) {
$data = $column['value'];
- print "<TD>$data[$i]</TD>\n";
+ print "<TD>$data[$i]</TD>\n";
}
- print "</TR>\n";
+ print "</TR>\n";
}
- print "</TABLE>\n";
+ print "</TABLE>\n";
} else {
- echo "No data found<BR>\n";
+ echo "No data found<BR>\n";
}
-print "$nrows Records Selected<BR>\n";
+print "$nrows Records Selected<BR>\n";
OCIFreeStatement($stmt);
OCILogoff($conn);
?>
+]]>
</programlisting>
</example>
</refsect1>
</refentry>
-
+
<refentry id="function.ocicolumnisnull">
<refnamediv>
<refname>OCIColumnIsNULL</refname>
@@ -1088,33 +1147,35 @@
<example>
<title>OCIColumnName</title>
<programlisting>
-<?php
- print "<HTML><PRE>\n";
+<![CDATA[
+<?php
+ print "<HTML><PRE>\n";
$conn = OCILogon("scott", "tiger");
$stmt = OCIParse($conn,"select * from emp");
OCIExecute($stmt);
- print "<TABLE BORDER=\"1\">";
- print "<TR>";
- print "<TH>Name</TH>";
- print "<TH>Type</TH>";
- print "<TH>Length</TH>";
- print "</TR>";
+ print "<TABLE BORDER=\"1\">";
+ print "<TR>";
+ print "<TH>Name</TH>";
+ print "<TH>Type</TH>";
+ print "<TH>Length</TH>";
+ print "</TR>";
$ncols = OCINumCols($stmt);
- for ( $i = 1; $i <= $ncols; $i++ ) {
+ for ( $i = 1; $i <= $ncols; $i++ ) {
$column_name = OCIColumnName($stmt,$i);
$column_type = OCIColumnType($stmt,$i);
$column_size = OCIColumnSize($stmt,$i);
- print "<TR>";
- print "<TD>$column_name</TD>";
- print "<TD>$column_type</TD>";
- print "<TD>$column_size</TD>";
- print "</TR>";
+ print "<TR>";
+ print "<TD>$column_name</TD>";
+ print "<TD>$column_type</TD>";
+ print "<TD>$column_size</TD>";
+ print "</TR>";
}
OCIFreeStatement($stmt);
OCILogoff($conn);
- print "</PRE>";
- print "</HTML>\n";
+ print "</PRE>";
+ print "</HTML>\n";
?>
+]]>
</programlisting>
</example>
</para>
@@ -1150,34 +1211,36 @@
<example>
<title>OCIColumnSize</title>
<programlisting>
-<?php
- print "<HTML><PRE>\n";
+<![CDATA[
+<?php
+ print "<HTML><PRE>\n";
$conn = OCILogon("scott", "tiger");
$stmt = OCIParse($conn,"select * from emp");
OCIExecute($stmt);
- print "<TABLE BORDER=\"1\">";
- print "<TR>";
- print "<TH>Name</TH>";
- print "<TH>Type</TH>";
- print "<TH>Length</TH>";
- print "</TR>";
+ print "<TABLE BORDER=\"1\">";
+ print "<TR>";
+ print "<TH>Name</TH>";
+ print "<TH>Type</TH>";
+ print "<TH>Length</TH>";
+ print "</TR>";
$ncols = OCINumCols($stmt);
- for ( $i = 1; $i <= $ncols; $i++ ) {
+ for ( $i = 1; $i <= $ncols; $i++ ) {
$column_name = OCIColumnName($stmt,$i);
$column_type = OCIColumnType($stmt,$i);
$column_size = OCIColumnSize($stmt,$i);
- print "<TR>";
- print "<TD>$column_name</TD>";
- print "<TD>$column_type</TD>";
- print "<TD>$column_size</TD>";
- print "</TR>";
+ print "<TR>";
+ print "<TD>$column_name</TD>";
+ print "<TD>$column_type</TD>";
+ print "<TD>$column_size</TD>";
+ print "</TR>";
}
- print "</TABLE>";
+ print "</TABLE>";
OCIFreeStatement($stmt);
OCILogoff($conn);
- print "</PRE>";
- print "</HTML>\n";
-?>
+ print "</PRE>";
+ print "</HTML>\n";
+ ?>
+]]>
</programlisting>
</example>
</para>
@@ -1207,38 +1270,40 @@
<function>OCIColumnType</function> restituisce il tipo del campo
corrispondente alla posizione (1 = primo campo)
specificata.
- </simpara>
+ </simpara>
<para>
<example>
<title>OCIColumnType</title>
<programlisting>
-<?php
- print "<HTML><PRE>\n";
+<![CDATA[
+<?php
+ print "<HTML><PRE>\n";
$conn = OCILogon("scott", "tiger");
$stmt = OCIParse($conn,"select * from emp");
OCIExecute($stmt);
- print "<TABLE BORDER=\"1\">";
- print "<TR>";
- print "<TH>Name</TH>";
- print "<TH>Type</TH>";
- print "<TH>Length</TH>";
- print "</TR>";
+ print "<TABLE BORDER=\"1\">";
+ print "<TR>";
+ print "<TH>Name</TH>";
+ print "<TH>Type</TH>";
+ print "<TH>Length</TH>";
+ print "</TR>";
$ncols = OCINumCols($stmt);
- for ( $i = 1; $i <= $ncols; $i++ ) {
+ for ( $i = 1; $i <= $ncols; $i++ ) {
$column_name = OCIColumnName($stmt,$i);
$column_type = OCIColumnType($stmt,$i);
$column_size = OCIColumnSize($stmt,$i);
- print "<TR>";
- print "<TD>$column_name</TD>";
- print "<TD>$column_type</TD>";
- print "<TD>$column_size</TD>";
- print "</TR>";
+ print "<TR>";
+ print "<TD>$column_name</TD>";
+ print "<TD>$column_type</TD>";
+ print "<TD>$column_size</TD>";
+ print "</TR>";
}
OCIFreeStatement($stmt);
OCILogoff($conn);
- print "</PRE>";
- print "</HTML>\n";
+ print "</PRE>";
+ print "</HTML>\n";
?>
+]]>
</programlisting>
</example>
</para>
@@ -1268,14 +1333,16 @@
<example>
<title>OCIServerVersion</title>
<programlisting>
-<?php
+<![CDATA[
+<?php
$conn = OCILogon("scott","tiger");
print "Server Version: " . OCIServerVersion($conn);
OCILogOff($conn);
?>
+]]>
</programlisting>
</example>
- </para>
+ </para>
</refsect1>
</refentry>
@@ -1311,19 +1378,21 @@
<example>
<title>Code examples</title>
<programlisting>
-<?php
- print "<HTML><PRE>";
+<![CDATA[
+<?php
+ print "<HTML><PRE>";
$conn = OCILogon("scott","tiger");
$sql = "delete from emp where deptno = 10";
$stmt = OCIParse($conn,$sql);
if ( OCIStatementType($stmt) == "DELETE" ) {
- die "You are not allowed to delete from this table<BR>";
+ die "You are not allowed to delete from this table<BR>";
}
OCILogoff($conn);
- print "</PRE></HTML>";
+ print "</PRE></HTML>";
?>
+]]>
</programlisting>
</example>
</para>
@@ -1353,18 +1422,19 @@
<example>
<title>Using a REF CURSOR from a stored procedure</title>
<programlisting>
-<?php
+<![CDATA[
+<?php
// suppose your stored procedure info.output returns a ref cursor in :data
$conn = OCILogon("scott","tiger");
$curs = OCINewCursor($conn);
$stmt = OCIParse($conn,"begin info.output(:data); end;");
-ocibindbyname($stmt,"data",&$curs,-1,OCI_B_CURSOR);
+ocibindbyname($stmt,"data",&$curs,-1,OCI_B_CURSOR);
ociexecute($stmt);
ociexecute($curs);
-while (OCIFetchInto($curs,&$data)) {
+while (OCIFetchInto($curs,&$data)) {
var_dump($data);
}
@@ -1372,6 +1442,7 @@
OCIFreeCursor($curs);
OCILogoff($conn);
?>
+]]>
</programlisting>
</example>
</para>
@@ -1379,39 +1450,41 @@
<example>
<title>Using a REF CURSOR in a select statement</title>
<programlisting>
-<?php
-print "<HTML><BODY>";
+<![CDATA[
+<?php
+print "<HTML><BODY>";
$conn = OCILogon("scott","tiger");
$count_cursor = "CURSOR(select count(empno) num_emps from emp " .
"where emp.deptno = dept.deptno) as EMPCNT from dept";
$stmt = OCIParse($conn,"select deptno,dname,$count_cursor");
ociexecute($stmt);
-print "<TABLE BORDER=\"1\">";
-print "<TR>";
-print "<TH>DEPT NAME</TH>";
-print "<TH>DEPT #</TH>";
-print "<TH># EMPLOYEES</TH>";
-print "</TR>";
+print "<TABLE BORDER=\"1\">";
+print "<TR>";
+print "<TH>DEPT NAME</TH>";
+print "<TH>DEPT #</TH>";
+print "<TH># EMPLOYEES</TH>";
+print "</TR>";
while (OCIFetchInto($stmt,&$data,OCI_ASSOC)) {
- print "<TR>";
+ print "<TR>";
$dname = $data["DNAME"];
$deptno = $data["DEPTNO"];
- print "<TD>$dname</TD>";
- print "<TD>$deptno</TD>";
+ print "<TD>$dname</TD>";
+ print "<TD>$deptno</TD>";
ociexecute($data[ "EMPCNT" ]);
while (OCIFetchInto($data[ "EMPCNT" ],&$subdata,OCI_ASSOC)) {
$num_emps = $subdata["NUM_EMPS"];
- print "<TD>$num_emps</TD>";
+ print "<TD>$num_emps</TD>";
}
- print "</TR>";
+ print "</TR>";
}
-print "</TABLE>";
-print "</BODY></HTML>";
+print "</TABLE>";
+print "</BODY></HTML>";
OCIFreeStatement($stmt);
OCILogoff($conn);
?>
+]]>
</programlisting>
</example>
</para>
@@ -1531,8 +1604,8 @@
array associativo. In questo array, <parameter>code</parameter>
dà il codice d'errora oracle e <parameter>message</parameter>
dà la stringa d'errore.
- </simpara>
- </refsect1>
+ </simpara>
+</refsect1>
</refentry>
<refentry id="function.ociinternaldebug">
