goba Fri Mar 29 13:33:26 2002 EDT
Modified files:
/phpdoc/hu/functions oci8.xml
Log:
Absolutely up to date translation, ready for the readers
Index: phpdoc/hu/functions/oci8.xml
diff -u phpdoc/hu/functions/oci8.xml:1.5 phpdoc/hu/functions/oci8.xml:1.6
--- phpdoc/hu/functions/oci8.xml:1.5 Fri Mar 29 09:48:23 2002
+++ phpdoc/hu/functions/oci8.xml Fri Mar 29 13:33:26 2002
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- EN-Revision: 1.44 Maintainer: goba Status: half translated -->
+<!-- EN-Revision: 1.45 Maintainer: goba Status: ready -->
<reference id="ref.oci8">
<title>Oracle 8 f�ggv�nyek</title>
<titleabbrev>OCI8</titleabbrev>
@@ -647,7 +647,7 @@
<refentry id="function.ociexecute">
<refnamediv>
<refname>OCIExecute</refname>
- <refpurpose>Execute a statement</refpurpose>
+ <refpurpose>Parancs futtat�sa</refpurpose>
</refnamediv>
<refsect1>
<title>Le�r�s</title>
@@ -657,12 +657,13 @@
<methodparam
choice="opt"><type>int</type><parameter>mode</parameter></methodparam>
</methodsynopsis>
<para>
- <function>OCIExecute</function> executes a previously parsed
- statement. (see <function>OCIParse</function>). The optional
- <parameter>mode</parameter> allows you to specify the
- execution-mode (default is OCI_COMMIT_ON_SUCCESS). If you don't
- want statements to be committed automatically specify OCI_DEFAULT as
- your mode.
+ Az <function>OCIExecute</function> futtat egy kor�bban feldolgozott
+ parancsot. (L�sd az <function>OCIParse</function> f�ggv�nyt.)
+ Az opcion�lis <parameter>mode</parameter> param�terrel tudod
+ be�ll�tani a v�grehajt�s m�dj�t. Az alap�rtelmez�s az
+ OCI_COMMIT_ON_SUCCESS. Ha nem szeretn�d, hogy a parancs
+ r�gt�n egy tranzakci� v�grehajt�st is v�gezzen, add meg
+ az OCI_DEFAULT m�dot.
</para>
<para>
&return.success;
@@ -673,7 +674,7 @@
<refentry id="function.ocicommit">
<refnamediv>
<refname>OCICommit</refname>
- <refpurpose>Commits outstanding transactions</refpurpose>
+ <refpurpose>F�gg�ben l�v� tranzakci�k v�grehajt�sa</refpurpose>
</refnamediv>
<refsect1>
<title>Le�r�s</title>
@@ -682,8 +683,9 @@
<methodparam><type>int</type><parameter>connection</parameter></methodparam>
</methodsynopsis>
<para>
- <function>OCICommit</function> commits all outstanding statements
- for Oracle connection <parameter>connection</parameter>.
+ Az <function>OCICommit</function> minden a
+ <parameter>connection</parameter> Oracle kapcsolaton
+ f�gg�ben l�v� tranzakci�t v�grehajt.
</para>
</refsect1>
</refentry>
@@ -691,7 +693,7 @@
<refentry id="function.ocirollback">
<refnamediv>
<refname>OCIRollback</refname>
- <refpurpose>Rolls back outstanding transactions</refpurpose>
+ <refpurpose>F�gg�ben l�v� tranzakci�k visszavon�sa</refpurpose>
</refnamediv>
<refsect1>
<title>Le�r�s</title>
@@ -700,8 +702,9 @@
<methodparam><type>int</type><parameter>connection</parameter></methodparam>
</methodsynopsis>
<para>
- <function>OCIRollback</function> rolls back all outstanding
- statements for Oracle connection <parameter>connection</parameter>.
+ Az <function>OCIRollback</function> minden a
+ <parameter>connection</parameter> Oracle kapcsolaton
+ f�gg�ben l�v� tranzakci�t visszavon.
</para>
</refsect1>
</refentry>
@@ -710,7 +713,7 @@
<refnamediv>
<refname>OCINewDescriptor</refname>
<refpurpose>
- Initialize a new empty descriptor LOB/FILE (LOB is default)
+ Egy �j �res LOB vagy FILE le�r�t hoz l�tre
</refpurpose>
</refnamediv>
<refsect1>
@@ -721,42 +724,44 @@
<methodparam
choice="opt"><type>int</type><parameter>type</parameter></methodparam>
</methodsynopsis>
<para>
- <function>OCINewDescriptor</function> Allocates storage to hold
- descriptors or LOB locators. Valid values for the valid
- <parameter>type</parameter> are OCI_D_FILE, OCI_D_LOB, OCI_D_ROWID.
- For LOB descriptors, the methods load, save, and savefile are
- associated with the descriptor, for BFILE only the load method
- exists. See the second example usage hints.
+ Az <function>OCINewDescriptor</function> t�rter�letet foglal
+ le le�r�k vagy LOB lok�torok t�rol�s�ra. A
+ <parameter>type</parameter> lehets�ges �rt�kei OCI_D_FILE,
+ OCI_D_LOB �s OCI_D_ROWID. LOB le�r�k eset�n a a load, save
+ �s savefile met�dusokat haszn�lhatod, a BFILE csak a
+ load met�dust t�mogatja. L�sd a m�sodik p�lda haszn�lati
+ tippjeit.
</para>
<example>
<title>OCINewDescriptor</title>
<programlisting>
<![CDATA[
-<?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)
+<?php
+ /* Ez a program �rlapb�l t�rt�n� megh�v�shoz k�sz�lt.
+ * A $felhasznalo, $jelszo, $tabla, $where �s $commitmeret
+ * �rt�keket v�rja az �rlapb�l. A program let�rli a kiv�lasztott
+ * sorokat a ROWID felhaszn�l�sval, �s minden $commitmeret sor
+ * ut�n egy tranzakci� v�grehajt�st eszk�z�l. Haszn�ld �vatosan,
+ * a m�veletek nem visszavonhat�ak.
*/
- $conn = OCILogon($user, $password);
- $stmt = OCIParse($conn,"select rowid from $table $where");
+ $conn = OCILogon($felhasznalo, $jelszo);
+ $stmt = OCIParse($conn,"select rowid from $tabla $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");
+ while ( OCIFetch($stmt) ) {
+ $sorokszama = OCIRowCount($stmt);
+ $delete = OCIParse($conn,"delete from $tabla where ROWID = :rid");
OCIBindByName($delete,":rid",&$rowid,-1,OCI_B_ROWID);
- OCIExecute($delete);
- print "$nrows\n";
- if ( ($nrows % $commitsize) == 0 ) {
- OCICommit($conn);
- }
+ OCIExecute($delete);
+ print "$sorokszama\n";
+ if ( ($sorokszama % $commitmeret) == 0 ) {
+ OCICommit($conn);
+ }
}
- $nrows = OCIRowCount($stmt);
- print "$nrows deleted...\n";
- OCIFreeStatement($stmt);
+ $sorokszama = OCIRowCount($stmt);
+ print "$sorokszama sor t�r�lve...\n";
+ OCIFreeStatement($stmt);
OCILogoff($conn);
?>
]]>
@@ -764,32 +769,37 @@
<programlisting>
<![CDATA[
<?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">
+ /* Ez a program LOB mez�be �llom�ny felt�lt�st mutat be.
+ * Az �rlapmez�, amit a p�lda felt�telez a k�vetkez�:
+ * <form action="upload.php" 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">
+<form action="upload.php" method="post" enctype="multipart/form-data">
Upload file: <input type="file" name="lob_upload"><br>
-<input type="submit" value="Upload"> - <input type="reset">
+<input type="submit" value="Felt�lt�s"> - <input type="reset">
</form>
<?php
} else {
- // $lob_upload contains the temporary filename of the uploaded file
- $conn = OCILogon($user, $password);
+
+ // $lob_upload tartalmazza a felt�lt�tt file ideiglenes �llom�ny nev�t
+
+ // l�sd m�g az �llom�ny felt�lt�sr�l sz�l� r�szt biztons�gos
+ // file felt�lt�s p�ld�k �rdek�ben
+
+ $conn = OCILogon($felhasznalo, $jelszo);
$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);
+ $stmt = OCIParse($conn,"insert into $tabla (id, a_blob)
+ values(my_seq.NEXTVAL, EMPTY_BLOB()) returning a_blob into :a_blob");
+ OCIBindByName($stmt, ':a_blob', &$lob, -1, OCI_B_BLOB);
OCIExecute($stmt, OCI_DEFAULT);
if($lob->savefile($lob_upload)){
OCICommit($conn);
- echo "Blob successfully uploaded\n";
+ echo "A Blob felt�lt�se sikeres\n";
}else{
- echo "Couldn't upload Blob\n";
+ echo "Nem siker�lt felt�lteni a Blobot\n";
}
OCIFreeDesc($lob);
OCIFreeStatement($stmt);
@@ -804,24 +814,23 @@
<programlisting>
<![CDATA[
<?php
- /* Calling PL/SQL stored procedures which contain clobs as input
- * parameters (PHP 4 >= 4.0.6).
- * Example PL/SQL stored procedure signature is:
+ /* PL/SQL t�rolt elj�r�sok h�v�sa, amik clobs bemeneti param�tereket
+ * tartalmaznak (PHP 4 >= 4.0.6).
*
- * PROCEDURE save_data
- * Argument Name Type In/Out Default?
- * ------------------------------ ----------------------- ------ --------
- * KEY NUMBER(38) IN
- * DATA CLOB IN
+ * PROCEDURE adat_mentes
+ * Argumentum neve T�pus KI/BE Alap�rt�k
+ * ------------------------------ ----------------------- ------ ---------
+ * KULCS NUMBER(38) BE
+ * ADAT CLOB BE
*
*/
- $conn = OCILogon($user, $password);
- $stmt = OCIParse($conn, "begin save_data(:key, :data); end;");
+ $conn = OCILogon($felhasznalo, $jelszo);
+ $stmt = OCIParse($conn, "begin adat_mentes(:kulcs, :adat); end;");
$clob = OCINewDescriptor($conn, OCI_D_LOB);
- OCIBindByName($stmt, ':key', $key);
- OCIBindByName($stmt, ':data', $clob, -1, OCI_B_CLOB);
- $clob->WriteTemporary($data);
+ OCIBindByName($stmt, ':kulcs', $kulcs);
+ OCIBindByName($stmt, ':adat', $clob, -1, OCI_B_CLOB);
+ $clob->WriteTemporary($adat);
OCIExecute($stmt, OCI_DEFAULT);
OCICommit($conn);
$clob->close();
@@ -837,7 +846,7 @@
<refentry id="function.ocirowcount">
<refnamediv>
<refname>OCIRowCount</refname>
- <refpurpose>Gets the number of affected rows</refpurpose>
+ <refpurpose>Az �rintett sorok sz�ma</refpurpose>
</refnamediv>
<refsect1>
<title>Le�r�s</title>
@@ -846,9 +855,10 @@
<methodparam><type>int</type><parameter>statement</parameter></methodparam>
</methodsynopsis>
<para>
- <function>OCIRowCount</function> returns the number of rows affected
- for eg update-statements. This function will not tell you the number
- of rows that a select will return!</para>
+ Az <function>OCIRowCount</function> visszaadja az �rintett sorok
+ sz�m�t p�ld�ul egy update parancs ut�n. Ez a f�ggv�ny nem adja
+ vissza a select lek�rdez�s �ltal visszaadott sorok sz�m�t!
+ </para>
<para>
<example>
<title>OCIRowCount</title>
@@ -857,16 +867,16 @@
<?php
print "<HTML><PRE>";
$conn = OCILogon("scott","tiger");
- $stmt = OCIParse($conn,"create table emp2 as select * from emp");
+ $stmt = OCIParse($conn,"create table dolgozok2 as select * from dolgozok");
OCIExecute($stmt);
- print OCIRowCount($stmt) . " rows inserted.<BR>";
+ print OCIRowCount($stmt) . " sor beillesztve.<BR>";
OCIFreeStatement($stmt);
- $stmt = OCIParse($conn,"delete from emp2");
+ $stmt = OCIParse($conn,"delete from dolgozok2");
OCIExecute($stmt);
- print OCIRowCount($stmt) . " rows deleted.<BR>";
+ print OCIRowCount($stmt) . " sor t�r�lve.<BR>";
OCICommit($conn);
OCIFreeStatement($stmt);
- $stmt = OCIParse($conn,"drop table emp2");
+ $stmt = OCIParse($conn,"drop table dolgozok2");
OCIExecute($stmt);
OCIFreeStatement($stmt);
OCILogOff($conn);
@@ -883,7 +893,7 @@
<refnamediv>
<refname>OCINumCols</refname>
<refpurpose>
- Return the number of result columns in a statement
+ Az eredm�nyoszlopok sz�ma egy eredm�nyt�bl�ban
</refpurpose>
</refnamediv>
<refsect1>
@@ -893,32 +903,32 @@
<methodparam><type>int</type><parameter>stmt</parameter></methodparam>
</methodsynopsis>
<para>
- <function>OCINumCols</function> returns the number of columns in a
- statement
+ Az <function>OCINumCols</function> visszaadja az eredm�nyt�bla
+ oszlopainak a sz�m�t.
</para>
<example>
<title>OCINumCols</title>
<programlisting>
<![CDATA[
<?php
- print "<HTML><PRE>\n";
+ print "<HTML><PRE>\n";
$conn = OCILogon("scott", "tiger");
- $stmt = OCIParse($conn,"select * from emp");
+ $stmt = OCIParse($conn,"select * from dolgozok");
OCIExecute($stmt);
while ( OCIFetch($stmt) ) {
- print "\n";
+ print "\n";
$ncols = OCINumCols($stmt);
for ( $i = 1; $i <= $ncols; $i++ ) {
- $column_name = OCIColumnName($stmt,$i);
- $column_value = OCIResult($stmt,$i);
- print $column_name . ': ' . $column_value . "\n";
+ $oszlop_neve = OCIColumnName($stmt,$i);
+ $mezo_erteke = OCIResult($stmt,$i);
+ print $oszlop_neve . ': ' . $mezo_erteke . "\n";
}
print "\n";
}
- OCIFreeStatement($stmt);
- OCILogoff($conn);
+ OCIFreeStatement($stmt);
+ OCILogoff($conn);
print "</PRE>";
- print "</HTML>\n";
+ print "</HTML>\n";
?>
]]>
</programlisting>
@@ -929,7 +939,7 @@
<refentry id="function.ociresult">
<refnamediv>
<refname>OCIResult</refname>
- <refpurpose>Returns column value for fetched row</refpurpose>
+ <refpurpose>Mez� �rt�k�nek visszaad�sa lek�rdezett sorb�l</refpurpose>
</refnamediv>
<refsect1>
<title>Le�r�s</title>
@@ -939,11 +949,11 @@
<methodparam><type>mixed</type><parameter>column</parameter></methodparam>
</methodsynopsis>
<para>
- <function>OCIResult</function> returns the data for column
- <parameter>column</parameter> in the current row (see
- <function>OCIFetch</function>).<function>OCIResult</function> will
- return everything as strings except for abstract types (ROWIDs,
- LOBs and FILEs).
+ Az <function>OCIResult</function> a <parameter>column</parameter>
+ oszlopban l�v� adatot adja vissza az aktu�lis sorban. L�sd az
+ <function>OCIFetch</function> f�ggv�nyt. Az <function>OCIResult</function>
+ mindent karaktersorozatk�nt ad vissza, kiv�ve az absztrakt
+ adatt�pusokat (ROWID, LOB �s FILE t�pusok).
</para>
</refsect1>
</refentry>
@@ -951,7 +961,7 @@
<refentry id="function.ocifetch">
<refnamediv>
<refname>OCIFetch</refname>
- <refpurpose>Fetches the next row into result-buffer</refpurpose>
+ <refpurpose>A k�vetkez� eredm�ny sor lek�rdez�se</refpurpose>
</refnamediv>
<refsect1>
<title>Le�r�s</title>
@@ -960,8 +970,9 @@
<methodparam><type>int</type><parameter>statement</parameter></methodparam>
</methodsynopsis>
<para>
- <function>OCIFetch</function> fetches the next row (for SELECT
- statements) into the internal result-buffer.
+ Az <function>OCIFetch</function> lek�rdezi a k�vetkez� eredm�nyt�bla
+ sort, �s egy bels� eredm�ny bufferbe helyezi. SELECT parancsok
+ eredm�nyt�bl�j�n haszn�lhat�.
</para>
</refsect1>
</refentry>
@@ -969,7 +980,7 @@
<refentry id="function.ocifetchinto">
<refnamediv>
<refname>OCIFetchInto</refname>
- <refpurpose>Fetches the next row into result-array</refpurpose>
+ <refpurpose>A k�vetkez� sor lek�rdez�se t�mbbe</refpurpose>
</refnamediv>
<refsect1>
<title>Le�r�s</title>
@@ -980,32 +991,31 @@
<methodparam
choice="opt"><type>int</type><parameter>mode</parameter></methodparam>
</methodsynopsis>
<para>
- <function>OCIFetchInto</function> fetches the next row (for SELECT
- statements) into the <parameter>result</parameter> array.
- <function>OCIFetchInto</function> will overwrite the previous
- content of <parameter>result</parameter>. By default
- <parameter>result</parameter> will contain a zero-based array of all
- columns that are not &null;.
+ Az <function>OCIFetchInto</function> lek�rdezi a k�vetkez� sort, �s
+ a <parameter>result</parameter> t�mbbe t�lti be. SELECT parancsok
+ eredm�nyt�bl�j�n haszn�lhat�. A f�ggv�ny fel�l�rja a
+ <parameter>result</parameter> kor�bbi tartalm�t, ha volt ilyen.
+ Alap�rtelmez�sben a <parameter>result</parameter> egy sz�mindexes
+ t�mb lesz minden mez��rt�kkel, ami nem &null;.
</para>
<para>
- The <parameter>mode</parameter> parameter allows you to change the
- default behaviour. You can specify more than one flag by simply
- adding them up (eg OCI_ASSOC+OCI_RETURN_NULLS). The known flags
- are:
+ A <parameter>mode</parameter> param�terrel tudod szab�lyozni
+ a result szerkezet�t �s tartalm�t. T�bb opci�t is megadhatsz,
+ egyszer� �sszead�ssal, p�ld�ul �rhatod, hogy
+ OCI_ASSOC + OCI_RETURN_NULLS. A haszn�lhat� opci�k:
<simplelist>
<member>
- <literal>OCI_ASSOC</literal> Return an associative array.
+ <literal>OCI_ASSOC</literal> Asszociat�v t�mb form�tum.
</member>
<member>
- <literal>OCI_NUM</literal> Return an numbered array starting with
- zero. (DEFAULT)
+ <literal>OCI_NUM</literal> Sz�mindexes t�mb form�tum (alap�rtelmez�s).
</member>
<member>
- <literal>OCI_RETURN_NULLS</literal> Return empty columns.
+ <literal>OCI_RETURN_NULLS</literal> A &null; �rt�k� mez�k visszaad�sa.
</member>
<member>
- <literal>OCI_RETURN_LOBS</literal> Return the value of a LOB
- instead of the descriptor.
+ <literal>OCI_RETURN_LOBS</literal> A LOB �rt�k visszaad�sa a
+ le�r� helyett.
</member>
</simplelist>
</para>
@@ -1015,7 +1025,7 @@
<refentry id="function.ocifetchstatement">
<refnamediv>
<refname>OCIFetchStatement</refname>
- <refpurpose>Fetch all rows of result data into an array.</refpurpose>
+ <refpurpose>Miden eredm�nysor lek�rdez�se egy t�mbbe</refpurpose>
</refnamediv>
<refsect1>
<title>Le�r�s</title>
@@ -1025,47 +1035,46 @@
<methodparam><type>array
&</type><parameter>variable</parameter></methodparam>
</methodsynopsis>
<para>
- <function>OCIFetchStatement</function> fetches all the rows from a
- result into a user-defined array.
- <function>OCIFetchStatement</function> returns the number of rows
- fetched.
+ Az <function>OCIFetchStatement</function> lek�rdezi az �sszes eredm�nysort,
+ �s egy PHP t�mbbe helyezi. A f�ggv�ny a lekr�dezett sorok sz�m�val t�r
+ vissza.
</para>
<example>
<title>OCIFetchStatement</title>
<programlisting>
<![CDATA[
<?php
-/* OCIFetchStatement example [EMAIL PROTECTED] (990624) */
+/* OCIFetchStatement p�lda - [EMAIL PROTECTED] (990624) */
$conn = OCILogon("scott","tiger");
-$stmt = OCIParse($conn,"select * from emp");
+$stmt = OCIParse($conn,"select * from dolgozok");
OCIExecute($stmt);
-$nrows = OCIFetchStatement($stmt,$results);
-if ( $nrows > 0 ) {
+$sorokszama = OCIFetchStatement($stmt, $tabla);
+if ( $sorokszama > 0 ) {
print "<TABLE BORDER=\"1\">\n";
print "<TR>\n";
- while ( list( $key, $val ) = each( $results ) ) {
- print "<TH>$key</TH>\n";
+ while ( list( $kulcs, $ertek ) = each( $tabla ) ) {
+ print "<TH>$kulcs</TH>\n";
}
print "</TR>\n";
- for ( $i = 0; $i < $nrows; $i++ ) {
- reset($results);
+ for ( $i = 0; $i < $sorokszama; $i++ ) {
+ reset($tabla);
print "<TR>\n";
- while ( $column = each($results) ) {
- $data = $column['value'];
- print "<TD>$data[$i]</TD>\n";
+ while ( $mezo = each($tabla) ) {
+ $adat = $mezo['value'];
+ print "<TD>$adat[$i]</TD>\n";
}
print "</TR>\n";
}
print "</TABLE>\n";
} else {
- echo "No data found<BR>\n";
+ echo "Nincs adat a t�bl�ban<BR>\n";
}
-print "$nrows Records Selected<BR>\n";
+print "$sorokszama sort siker�lt lek�rdezni<BR>\n";
OCIFreeStatement($stmt);
OCILogoff($conn);
@@ -1079,7 +1088,7 @@
<refentry id="function.ocicolumnisnull">
<refnamediv>
<refname>OCIColumnIsNULL</refname>
- <refpurpose>test whether a result column is &null;</refpurpose>
+ <refpurpose>&null; �rt�k� mez� azonos�t�sa</refpurpose>
</refnamediv>
<refsect1>
<title>Le�r�s</title>
@@ -1089,11 +1098,11 @@
<methodparam><type>mixed</type><parameter>column</parameter></methodparam>
</methodsynopsis>
<para>
- <function>OCIColumnIsNULL</function> returns &true; if the returned
- column <parameter>column</parameter> in the result from the
- statement <parameter>stmt</parameter> is &null;. You can either use
- the column-number (1-Based) or the column-name for the
- <parameter>col</parameter> parameter.
+ Az <function>OCIColumnIsNULL</function> &true; �rt�ket ad vissza, ha
+ a visszaadott <parameter>column</parameter> mez� az
+ <parameter>stmt</parameter> eredm�nyt�bl�j�ban &null; �rt�k�.
+ Haszn�lhatod az oszlop sorsz�mot (1-t�l sz�mozva), vagy
+ az oszlop nev�t a <parameter>col</parameter> param�terben.
</para>
</refsect1>
</refentry>
@@ -1101,7 +1110,7 @@
<refentry id="function.ocicolumnname">
<refnamediv>
<refname>OCIColumnName</refname>
- <refpurpose>Returns the name of a column.</refpurpose>
+ <refpurpose>Oszlop neve egy eredm�nyt�bl�ban</refpurpose>
</refnamediv>
<refsect1>
<title>Le�r�s</title>
@@ -1111,8 +1120,10 @@
<methodparam><type>int</type><parameter>col</parameter></methodparam>
</methodsynopsis>
<simpara>
- <function>OCIColumnName</function> returns the name of the column
- corresponding to the column number (1-based) that is passed in.
+ Az <function>OCIColumnName</function> visszaadja a
+ <parameter>col</parameter> param�terben megadott oszlop
+ nev�t. A <parameter>col</parameter> egy sorsz�m, a sz�moz�s
+ 1-t�l kezd�dik.
</simpara>
<para>
<example>
@@ -1122,25 +1133,26 @@
<?php
print "<HTML><PRE>\n";
$conn = OCILogon("scott", "tiger");
- $stmt = OCIParse($conn,"select * from emp");
+ $stmt = OCIParse($conn,"select * from dolgozok");
OCIExecute($stmt);
print "<TABLE BORDER=\"1\">";
print "<TR>";
- print "<TH>Name</TH>";
- print "<TH>Type</TH>";
- print "<TH>Length</TH>";
+ print "<TH>N�v</TH>";
+ print "<TH>T�pus</TH>";
+ print "<TH>M�ret</TH>";
print "</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);
+ $oszlopszam = OCINumCols($stmt);
+ for ( $i = 1; $i <= $oszlopszam; $i++ ) {
+ $oszlopnev = OCIColumnName($stmt,$i);
+ $oszloptipus = OCIColumnType($stmt,$i);
+ $oszlopmeret = OCIColumnSize($stmt,$i);
print "<TR>";
- print "<TD>$column_name</TD>";
- print "<TD>$column_type</TD>";
- print "<TD>$column_size</TD>";
+ print "<TD>$oszlopnev</TD>";
+ print "<TD>$oszloptipus</TD>";
+ print "<TD>$oszlopmeret</TD>";
print "</TR>";
}
+ print "</TABLE>\n";
OCIFreeStatement($stmt);
OCILogoff($conn);
print "</PRE>";
@@ -1151,9 +1163,9 @@
</example>
</para>
<simpara>
- See also <function>OCINumCols</function>,
- <function>OCIColumnType</function>,
- and <function>OCIColumnSize</function>.
+ L�sd m�g <function>OCINumCols</function>,
+ <function>OCIColumnType</function>
+ �s <function>OCIColumnSize</function>.
</simpara>
</refsect1>
</refentry>
@@ -1161,7 +1173,7 @@
<refentry id="function.ocicolumnsize">
<refnamediv>
<refname>OCIColumnSize</refname>
- <refpurpose>return result column size</refpurpose>
+ <refpurpose>Oszlop m�rete egy eredm�nyt�bl�ban</refpurpose>
</refnamediv>
<refsect1>
<title>Le�r�s</title>
@@ -1171,10 +1183,10 @@
<methodparam><type>mixed</type><parameter>column</parameter></methodparam>
</methodsynopsis>
<para>
- <function>OCIColumnSize</function> 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
- <parameter>col</parameter> parameter.
+ Az <function>OCIColumnSize</function> az Oracle �ltal visszaadott
+ oszlop m�rettel t�r vissza. Haszn�lhatod az oszlop sorsz�mot
+ (1-t�l sz�mozva), vagy az oszlop nev�t a
+ <parameter>col</parameter> param�terben.
</para>
<para>
<example>
@@ -1184,26 +1196,26 @@
<?php
print "<HTML><PRE>\n";
$conn = OCILogon("scott", "tiger");
- $stmt = OCIParse($conn,"select * from emp");
+ $stmt = OCIParse($conn,"select * from dolgozok");
OCIExecute($stmt);
print "<TABLE BORDER=\"1\">";
print "<TR>";
- print "<TH>Name</TH>";
- print "<TH>Type</TH>";
- print "<TH>Length</TH>";
+ print "<TH>N�v</TH>";
+ print "<TH>T�pus</TH>";
+ print "<TH>M�ret</TH>";
print "</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);
+ $oszlopszam = OCINumCols($stmt);
+ for ( $i = 1; $i <= $oszlopszam; $i++ ) {
+ $oszlopnev = OCIColumnName($stmt,$i);
+ $oszloptipus = OCIColumnType($stmt,$i);
+ $oszlopmeret = OCIColumnSize($stmt,$i);
print "<TR>";
- print "<TD>$column_name</TD>";
- print "<TD>$column_type</TD>";
- print "<TD>$column_size</TD>";
+ print "<TD>$oszlopnev</TD>";
+ print "<TD>$oszloptipus</TD>";
+ print "<TD>$oszlopmeret</TD>";
print "</TR>";
}
- print "</TABLE>";
+ print "</TABLE>\n";
OCIFreeStatement($stmt);
OCILogoff($conn);
print "</PRE>";
@@ -1214,8 +1226,8 @@
</example>
</para>
<simpara>
- See also <function>OCINumCols</function>,
- <function>OCIColumnName</function>, and
+ L�sd m�g <function>OCINumCols</function>,
+ <function>OCIColumnName</function> �s
<function>OCIColumnSize</function>.
</simpara>
</refsect1>
@@ -1224,7 +1236,7 @@
<refentry id="function.ocicolumntype">
<refnamediv>
<refname>OCIColumnType</refname>
- <refpurpose>Returns the data type of a column.</refpurpose>
+ <refpurpose>Oszlop adatt�pusa egy eredm�nyt�bl�ban</refpurpose>
</refnamediv>
<refsect1>
<title>Le�r�s</title>
@@ -1234,9 +1246,8 @@
<methodparam><type>int</type><parameter>col</parameter></methodparam>
</methodsynopsis>
<simpara>
- <function>OCIColumnType</function> returns the data type of the
- column corresponding to the column number (1-based) that is passed
- in.
+ Az <function>OCIColumnType</function> az adott sorsz�m� (1-t�l
+ sz�mozva) oszlop adatt�pus�t adja vissza.
</simpara>
<para>
<example>
@@ -1246,25 +1257,26 @@
<?php
print "<HTML><PRE>\n";
$conn = OCILogon("scott", "tiger");
- $stmt = OCIParse($conn,"select * from emp");
+ $stmt = OCIParse($conn,"select * from dolgozok");
OCIExecute($stmt);
print "<TABLE BORDER=\"1\">";
print "<TR>";
- print "<TH>Name</TH>";
- print "<TH>Type</TH>";
- print "<TH>Length</TH>";
+ print "<TH>N�v</TH>";
+ print "<TH>T�pus</TH>";
+ print "<TH>M�ret</TH>";
print "</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);
+ $oszlopszam = OCINumCols($stmt);
+ for ( $i = 1; $i <= $oszlopszam; $i++ ) {
+ $oszlopnev = OCIColumnName($stmt,$i);
+ $oszloptipus = OCIColumnType($stmt,$i);
+ $oszlopmeret = OCIColumnSize($stmt,$i);
print "<TR>";
- print "<TD>$column_name</TD>";
- print "<TD>$column_type</TD>";
- print "<TD>$column_size</TD>";
+ print "<TD>$oszlopnev</TD>";
+ print "<TD>$oszloptipus</TD>";
+ print "<TD>$oszlopmeret</TD>";
print "</TR>";
}
+ print "</TABLE>\n";
OCIFreeStatement($stmt);
OCILogoff($conn);
print "</PRE>";
@@ -1275,9 +1287,9 @@
</example>
</para>
<simpara>
- See also <function>OCINumCols</function>,
- <function>OCIColumnName</function>,
- and <function>OCIColumnSize</function>.
+ L�sd m�g <function>OCINumCols</function>,
+ <function>OCIColumnName</function> �s
+ <function>OCIColumnSize</function>.
</simpara>
</refsect1>
</refentry>
@@ -1285,8 +1297,7 @@
<refentry id="function.ociserverversion">
<refnamediv>
<refname>OCIServerVersion</refname>
- <refpurpose>Return a string containing server version
- information.</refpurpose>
+ <refpurpose>Szerver verzi� inform�ci� visszaad�sa</refpurpose>
</refnamediv>
<refsect1>
<title>Le�r�s</title>
@@ -1301,7 +1312,7 @@
<![CDATA[
<?php
$conn = OCILogon("scott","tiger");
- print "Server Version: " . OCIServerVersion($conn);
+ print "Szerver verzi�: " . OCIServerVersion($conn);
OCILogOff($conn);
?>
]]>
@@ -1314,7 +1325,7 @@
<refentry id="function.ocistatementtype">
<refnamediv>
<refname>OCIStatementType</refname>
- <refpurpose>Return the type of an OCI statement.</refpurpose>
+ <refpurpose>OCI parancs t�pus�t adja vissza</refpurpose>
</refnamediv>
<refsect1>
<title>Le�r�s</title>
@@ -1323,33 +1334,33 @@
<methodparam><type>int</type><parameter>stmt</parameter></methodparam>
</methodsynopsis>
<para>
- <function>OCIStatementType</function> returns one of the following
- values:
+ Az <function>OCIStatementType</function> a parancs t�pus�t adja
+ vissza. A k�vetkez�k a lehets�ges visszat�r�si �rt�kek:
<orderedlist>
- <listitem><simpara> "SELECT"</simpara></listitem>
- <listitem><simpara> "UPDATE"</simpara></listitem>
- <listitem><simpara> "DELETE"</simpara></listitem>
- <listitem><simpara> "INSERT"</simpara></listitem>
- <listitem><simpara> "CREATE"</simpara></listitem>
- <listitem><simpara> "DROP"</simpara></listitem>
- <listitem><simpara> "ALTER"</simpara></listitem>
- <listitem><simpara> "BEGIN"</simpara></listitem>
- <listitem><simpara> "DECLARE"</simpara></listitem>
- <listitem><simpara> "UNKNOWN"</simpara></listitem>
+ <listitem><simpara>"SELECT"</simpara></listitem>
+ <listitem><simpara>"UPDATE"</simpara></listitem>
+ <listitem><simpara>"DELETE"</simpara></listitem>
+ <listitem><simpara>"INSERT"</simpara></listitem>
+ <listitem><simpara>"CREATE"</simpara></listitem>
+ <listitem><simpara>"DROP"</simpara></listitem>
+ <listitem><simpara>"ALTER"</simpara></listitem>
+ <listitem><simpara>"BEGIN"</simpara></listitem>
+ <listitem><simpara>"DECLARE"</simpara></listitem>
+ <listitem><simpara>"UNKNOWN"</simpara></listitem>
</orderedlist></para>
<para>
<example>
- <title>Code examples</title>
+ <title><function>OCIStatementType</function> p�ld�k</title>
<programlisting>
<![CDATA[
<?php
print "<HTML><PRE>";
$conn = OCILogon("scott","tiger");
- $sql = "delete from emp where deptno = 10";
+ $sql = "delete from dolgozok where reszleg = 10";
$stmt = OCIParse($conn,$sql);
if ( OCIStatementType($stmt) == "DELETE" ) {
- die "You are not allowed to delete from this table<BR>";
+ die "Nincs jogod t�r�lni ebb�l a t�bl�b�l<BR>";
}
OCILogoff($conn);
@@ -1366,7 +1377,7 @@
<refnamediv>
<refname>OCINewCursor</refname>
<refpurpose>
- Return a new cursor (Statement-Handle) - use to bind ref-cursors.
+ �j kurzor (parancs eredm�ny kezel�) megnyit�sa
</refpurpose>
</refnamediv>
<refsect1>
@@ -1376,31 +1387,32 @@
<methodparam><type>int</type><parameter>conn</parameter></methodparam>
</methodsynopsis>
<para>
- <function>OCINewCursor</function> allocates a new statement handle
- on the specified connection.
+ Az <function>OCINewCursor</function> egy �j eredm�nyt�bla kezel�
+ kurzort nyit meg a megadott kapcsolaton.
</para>
<para>
<example>
- <title>Using a REF CURSOR from a stored procedure</title>
+ <title>REF CURSOR haszn�lata egy t�rolt elj�r�sb�l</title>
<programlisting>
<![CDATA[
<?php
-// suppose your stored procedure info.output returns a ref cursor in :data
+// feltessz�k, hogy az info.kimenet t�rolt elj�r�sod egy "ref cursor"-t
+// ad vissza az :adat-ban
$conn = OCILogon("scott","tiger");
-$curs = OCINewCursor($conn);
-$stmt = OCIParse($conn,"begin info.output(:data); end;");
+$kurzor = OCINewCursor($conn);
+$stmt = OCIParse($conn,"begin info.kimenet(:adat); end;");
-ocibindbyname($stmt,"data",&$curs,-1,OCI_B_CURSOR);
+ocibindbyname($stmt,"adat", &$kurzor, -1, OCI_B_CURSOR);
ociexecute($stmt);
-ociexecute($curs);
+ociexecute($kurzor);
-while (OCIFetchInto($curs,&$data)) {
- var_dump($data);
+while (OCIFetchInto($kurzor, &$adat)) {
+ var_dump($adat);
}
OCIFreeStatement($stmt);
-OCIFreeCursor($curs);
+OCIFreeCursor($kurzor);
OCILogoff($conn);
?>
]]>
@@ -1409,34 +1421,35 @@
</para>
<para>
<example>
- <title>Using a REF CURSOR in a select statement</title>
+ <title>REF CURSOR haszn�lata select parancsban</title>
<programlisting>
<![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");
+$szamlalo_kurzor =
+ "CURSOR(select count(dolgozoid) dolgozo_szam from dolgozok " .
+ "where dolgozok.reszleg = reszleg.reszlegid) as DSZAM from reszleg";
+$stmt = OCIParse($conn,"select reszlegid,rnev,$szamlalo_kurzor");
ociexecute($stmt);
print "<TABLE BORDER=\"1\">";
print "<TR>";
-print "<TH>DEPT NAME</TH>";
-print "<TH>DEPT #</TH>";
-print "<TH># EMPLOYEES</TH>";
+print "<TH>R�SZLEG N�V</TH>";
+print "<TH>R�SZLEG SZ�M</TH>";
+print "<TH>DOLGOZ�K SZ�MA</TH>";
print "</TR>";
-while (OCIFetchInto($stmt,&$data,OCI_ASSOC)) {
+while (OCIFetchInto($stmt, &$adat, OCI_ASSOC)) {
print "<TR>";
- $dname = $data["DNAME"];
- $deptno = $data["DEPTNO"];
- 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>";
+ $rnev = $adat["RNEV"];
+ $rszam = $adat["RESZLEGID"];
+ print "<TD>$rnev</TD>";
+ print "<TD>$rszam</TD>";
+ ociexecute($adat["DSZAM"]);
+ while (OCIFetchInto($adat["DSZAM"], &$reszadat, OCI_ASSOC)) {
+ $dszam = $reszadat["DOLGOZO_SZAM"];
+ print "<TD>$dszam</TD>";
}
print "</TR>";
}
@@ -1456,7 +1469,7 @@
<refnamediv>
<refname>OCIFreeStatement</refname>
<refpurpose>
- Free all resources associated with a statement.
+ Parancshoz rendelt er�forr�sok felszabad�t�sa
</refpurpose>
</refnamediv>
<refsect1>
@@ -1466,8 +1479,8 @@
<methodparam><type>int</type><parameter>stmt</parameter></methodparam>
</methodsynopsis>
<para>
- <function>OCIFreeStatement</function> returns &true; if successful,
- or &false; if unsuccessful.
+ Az <function>OCIFreeStatement</function> &true; �rt�ket ad siker,
+ &false; �rt�ket ad kudarc eset�n.
</para>
</refsect1>
</refentry>
@@ -1476,7 +1489,7 @@
<refnamediv>
<refname>OCIFreeCursor</refname>
<refpurpose>
- Free all resources associated with a cursor.
+ Kurzorhoz rendelt er�forr�sok felszabad�t�sa
</refpurpose>
</refnamediv>
<refsect1>
@@ -1486,8 +1499,8 @@
<methodparam><type>int</type><parameter>stmt</parameter></methodparam>
</methodsynopsis>
<para>
- <function>OCIFreeCursor</function> returns &true; if successful, or
- &false; if unsuccessful.
+ Az <function>OCIFreeCursor</function> &true; �rt�ket ad siker,
+ &false; �rt�ket ad kudarc eset�n.
</para>
</refsect1>
</refentry>
@@ -1495,7 +1508,7 @@
<refentry id="function.ocifreedesc">
<refnamediv>
<refname>OCIFreeDesc</refname>
- <refpurpose>Deletes a large object descriptor.</refpurpose>
+ <refpurpose>Felszabad�t egy LOB le�r�t</refpurpose>
</refnamediv>
<refsect1>
<title>Le�r�s</title>
@@ -1504,8 +1517,8 @@
<methodparam><type>object</type><parameter>lob</parameter></methodparam>
</methodsynopsis>
<para>
- <function>OCIFreeDesc</function> returns &true; if successful, or
- &false; if unsuccessful.
+ Az <function>OCIFreeDesc</function> &true; �rt�ket ad siker,
+ &false; �rt�ket ad kudarc eset�n.
</para>
</refsect1>
</refentry>
@@ -1513,7 +1526,7 @@
<refentry id="function.ociparse">
<refnamediv>
<refname>OCIParse</refname>
- <refpurpose>Parse a query and return a statement</refpurpose>
+ <refpurpose>SQL lek�rdez�s feldolgoz�sa, parancs visszaad�sa</refpurpose>
</refnamediv>
<refsect1>
<title>Le�r�s</title>
@@ -1523,19 +1536,21 @@
<methodparam><type>string</type><parameter>query</parameter></methodparam>
</methodsynopsis>
<simpara>
- <function>OCIParse</function> parses the
- <parameter>query</parameter> using <parameter>conn</parameter>.
- It returns the statement identity if the query is valid, &false; if
- not. The <parameter>query</parameter> can be any valid SQL
- statement or PL/SQL block.
+ Az <function>OCIParse</function> feldolgozz a
+ <parameter>query</parameter> param�terben megadott SQL
+ lek�rdez�st a <parameter>conn</parameter> kapcsolaton.
+ A parancs azonos�t�val t�r vissza, ha a lek�rdez�s
+ �rv�nyes volt, &false; �rt�ket ad egy�bk�nt. A
+ <parameter>query</parameter> param�tert b�rmilyen
+ �rv�nyes SQL parancs vagy PL/SQL blokk lehet.
</simpara>
</refsect1>
</refentry>
+
<refentry id="function.ocierror">
<refnamediv>
<refname>OCIError</refname>
- <refpurpose>Return the last error of stmt|conn|global.
- If no error happened returns &false;.
+ <refpurpose>A legut�bbi parancs / kapcsolat / �ltal�nos hiba visszaad�sa
</refpurpose>
</refnamediv>
<refsect1>
@@ -1545,14 +1560,13 @@
<methodparam
choice="opt"><type>int</type><parameter>stmt|conn|global</parameter></methodparam>
</methodsynopsis>
<simpara>
- <function>OCIError</function> returns the last error found. If
- the optional <parameter>stmt|conn|global</parameter> is not
- provided, the last error encountered is returned. If no error is
- found, <function>OCIError</function> returns
- &false;. <function>OCIError</function> returns the error as an
- associative array. In this array, <parameter>code</parameter>
- consists the oracle error code and <parameter>message</parameter>
- the oracle errorstring.
+ Az <function>OCIError</function> a legut�bbi hib�t adja vissza. Ha
+ az opcion�lis <parameter>stmt|conn|global</parameter> param�tert nem
+ adod meg, a legut�bbi hib�t kapod. Ha nem volt hiba, &false; �rt�ket
+ kapsz. Az <function>OCIError</function> egy asszociat�v t�mbben adja
+ vissza a hib�t. Ebben a t�mbben a <parameter>code</parameter>
+ az Oracle hibak�d, a <parameter>message</parameter> az Oracle
+ hiba�zenet karaktersorozat.
</simpara>
</refsect1>
</refentry>
@@ -1561,8 +1575,7 @@
<refnamediv>
<refname>OCIInternalDebug</refname>
<refpurpose>
- Enables or disables internal debug output. By default it is
- disabled
+ A bels� debug kimenet enged�lyez�se / letilt�sa
</refpurpose>
</refnamediv>
<refsect1>
@@ -1572,9 +1585,10 @@
<methodparam><type>int</type><parameter>onoff</parameter></methodparam>
</methodsynopsis>
<simpara>
- <function>OCIInternalDebug</function> enables internal debug
- output. Set <parameter>onoff</parameter> to 0 to turn debug
- output off, 1 to turn it on.
+ Az <function>OCIInternalDebug</function> enged�lyezi a
+ bels� debug kimenetet ha az <parameter>onoff</parameter>
+ param�tert 1 �rt�kre �ll�tod. Tilt�sra a 0 �rt�kkel van
+ lehet�s�g.
</simpara>
</refsect1>
</refentry>
@@ -1582,7 +1596,7 @@
<refentry id="function.ocicancel">
<refnamediv>
<refname>OCICancel</refname>
- <refpurpose>Cancel reading from cursor</refpurpose>
+ <refpurpose>Kurzorral olvas�s befejez�se</refpurpose>
</refnamediv>
<refsect1>
<title>Le�r�s</title>
@@ -1591,8 +1605,8 @@
<methodparam><type>int</type><parameter>stmt</parameter></methodparam>
</methodsynopsis>
<simpara>
- If you do not want read more data from a cursor, then call
- <function>OCICancel</function>.
+ Ha nem szeretn�l t�bb adatot olvasni egy kurzorral,
+ h�vd meg ezt a f�gg�nyt.
</simpara>
</refsect1>
</refentry>
@@ -1600,7 +1614,7 @@
<refentry id="function.ocisetprefetch">
<refnamediv>
<refname>OCISetPrefetch</refname>
- <refpurpose>sets number of rows to be prefetched</refpurpose>
+ <refpurpose>Az el�zetesen leh�vott sorok sz�m�nak be�ll�t�sa</refpurpose>
</refnamediv>
<refsect1>
<title>Le�r�s</title>
@@ -1610,7 +1624,8 @@
<methodparam><type>int</type><parameter>rows</parameter></methodparam>
</methodsynopsis>
<simpara>
- Sets the number of top level rows to be prefetched. The default value is 1 row.
+ Be�ll�tja az el�zetesen leh�vott sorok sz�m�t. Az alap�rtelmez�s
+ 1 sor.
</simpara>
</refsect1>
</refentry>
