cvs: peardoc /ru/core db.xml
| From: | Vitaliy N. Kravchenko | Date: | Sat, 26 Jan 2002 11:47:04 +0000 |
| Subject: | cvs: peardoc /ru/core db.xml | ||
| Groups: | php.pear.cvs | ||
| Request: | Send a blank email to pear-cvs+get-2132@lists.php.net to get a copy of this message | ||
kvn Sat Jan 26 06:47:04 2002 EDT
Modified files:
/peardoc/ru/core db.xml
Log:
I think I finished...
Index: peardoc/ru/core/db.xml diff -u peardoc/ru/core/db.xml:1.4 peardoc/ru/core/db.xml:1.5 --- peardoc/ru/core/db.xml:1.4 Fri Jan 18 09:41:19 2002 +++ peardoc/ru/core/db.xml Sat Jan 26 06:47:04 2002 @@ -1,5 +1,5 @@ <?xml encoding="KOI8-R"?> -<!-- $Revision: 1.4 $ --> +<!-- $Revision: 1.5 $ --> <reference id="core.db"> <title>PEAR DB: ÕÎÉÆÉÃÉÒÏ×ÁÎÎÙÊ API ÄÌÑ ÄÏÓÔÕÐÁ Ë SQL-ÂÁÚÁÍ ÄÁÎÎÙÈ</title> @@ -11,7 +11,7 @@ abstraction layer. </simpara> </partintro> - <refentry id="core.db.dsn"> + <refentry id="core.db.tut_dsn"> <refnamediv> <refname>DSN</refname> <refpurpose>äÁÎÎÙÅ Ï ÉÓÔÏÞÎÉËÅ (data source name)</refpurpose> @@ -31,8 +31,7 @@ </member> <member> <parameter>dbsyntax</parameter>: - - Database used with regards to SQL syntax etc. + âä, ÉÓÐÏÌØÚÕÅÍÁÑ Ó ÏÐÒÅÄÅÌÅÎÎÙÍ SQL ÓÉÎÔÁËÓÉÓÏÍ. </member> <member> <parameter>protocol</parameter>: @@ -54,6 +53,11 @@ <parameter>password</parameter>: ðÁÒÏÌØ ÄÌÑ ÌÏÇÉÎÁ. </member> + <member> + <parameter>proto_opts</parameter>: + íÏÖÅÔ ÉÓÐÏÌØÚÏ×ÁÔØÓÑ Ó ÐÁÒÁÍÅÔÒÏÍ <parameter>protocol</parameter> + </member> + </simplelist> </para> <para> @@ -73,12 +77,6 @@ phptype://hostspec phptype(dbsyntax) phptype - -ôÁË ÖÅ, ÄÌÑ ÀÎÉËÓ-ÓÏËÅÔÏ×: -mysql://user:pass@unix(/path/to/socket)/db - -é ÄÌÑ ÎÅ ÓÔÁÎÄÁÒÔÎÙÈ ÐÏÒÔÏ×: -mysql://user:pass@tcp(localhost:5555)/db </programlisting> îÁ ÔÅËÕÝÉÊ ÍÏÍÅÎÔ ÐÏÄÄÅÒÖÉ×ÁÀÔÓÑ ÓÌÅÄÕÀÝÉÅ âä: @@ -96,7 +94,22 @@ fbsql -> FrontBase </programlisting> </para> - <para> + <para> + ó ÐÏÓÌÅÄÎÅÊ ×ÅÒÓÉÅÊ <classname>DB</classname>, ×Ù ÍÏÖÅÔÅ ÉÓÐÏÌØÚÏ×ÁÔØ + ÓÌÅÄÕÀÝÉÊ ÆÏÒÍÁÔ DSN +<programlisting role="url"> +phptype(syntax)://user:pass@protocol(proto_opts)/database + +ÐÒÉÍÅÒ: +óÏÅÄÉÎÅÎÉÅ Ó âä ÞÅÒÅÚ ÓÏËÅÔ +mysql://user@unix(/path/to/socket)/pear + +óÏÅÄÉÎÅÎÉÅ Ó âä ÎÁ ÎÅ ÓÔÁÎÄÁÒÔÎÙÊ ÐÏÒÔ +pgsql://user:pass@word@tcp(localhost:5555)/pear +</programlisting> + </para> + + <para> <warning id="core.db.features.warning"> <title>÷ÁÖÎÏ!</title> <para> @@ -112,7 +125,7 @@ </refsect1> </refentry> - <refentry id="core.db.connect"> + <refentry id="core.db.tut_connect"> <refnamediv> <refname>Connect</refname> <refpurpose>óÏÅÄÉÎÅÎÉÅ É ÏÔÓÏÅÄÉÎÅÎÉÅ ÏÔ âä.</refpurpose> @@ -170,7 +183,8 @@ </para> </refsect1> </refentry> - <refentry id="core.db.query"> + + <refentry id="core.db.tut_query"> <refnamediv> <refname>Query</refname> <refpurpose>÷ÙÐÏÌÎÅÎÉÅ ÚÁÐÒÏÓÏ× Ë ÂÁÚÅ ÄÁÎÎÙÈ.</refpurpose> @@ -208,7 +222,7 @@ </refsect1> </refentry> - <refentry id="core.db.fetch"> + <refentry id="core.db.tut_fetch"> <refnamediv> <refname>Fetch</refname> <refpurpose>÷ÙÂÏÒËÁ ÓÔÒÏË ÉÚ ÚÁÐÒÏÓÁ.</refpurpose> @@ -587,7 +601,7 @@ </refsect1> </refentry> - <refentry id="core.db.sequences"> + <refentry id="core.db.tut_sequences"> <refnamediv> <refname> Sequences</refname> <refpurpose>ðÏÓÌÅÄÏ×ÁÔÅÌØÎÏÓÔÉ × âä</refpurpose> @@ -619,7 +633,8 @@ </para> </refsect1> </refentry> - <refentry id="core.db.execute"> + + <refentry id="core.db.tut_execute"> <refnamediv> <refname> Execute </refname> <refpurpose>ðÏÄÇÏÔÏ×ËÁ É ÷ÙÐÏÌÎÅÎÉÅ/íÕÌØÔÉ÷ÙÐÏÌÎÅÎÉÅ</refpurpose> @@ -775,6 +790,1445 @@ </refsect2> </refsect1> </refentry> + <refentry id="core.db.connect"> + <refnamediv> + <refname>DB::connect()</refname> + <refpurpose> óÏÚÄÁÅÔ ÎÏ×ÙÊ DB ÏÂØÅËÔ ÓÏÅÄÉÎÅÎÉÑ É ÓÏÅÄÉÎÑÅÔØÓÑ Ó ÕËÁÚÁÎÎÏÊ âä. + </refpurpose> + </refnamediv> + <refsect1 id="core.db.connect.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>connect</function></funcdef> + <paramdef>string <parameter>$dsn</parameter></paramdef> + <paramdef>array + <parameter><optional>$options</optional></parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$dsn</parameter> - <parameter>data source name</parameter> + óÍ. <link linkend="core.db.tut_dsn">"DSN" ÒÁÚÄÅÌ</link> ÄÌÑ + ÄÏÐÏÌÎÉÔÅÌØÎÏÊ ÉÎÆÏÒÍÁÃÉÉ. + </para> + <para> + <parameter>$options</parameter> - üÔÏÔ ÐÁÒÁÍÅÔÒ ÉÍÅÅÔ ÔÉÐ + <parameter>boolean</parameter>, ÅÓÌÉ <parameter>$options</parameter> + ÒÁ×ÎÏ true ÓÏÅÄÉÎÅÎÉÅ ÂÕÄÅÔ ÕÓÔÏÊÞÉ×ÙÍ (persistent) (ÎÕÖÄÁÅÔØÓÑ × + ÐÏÄÄÅÒÖËÅ ÔÁËÏÇÏ ÓÏÅÄÉÎÅÎÉÑ ÂÁÚÏÊ ÄÁÎÎÙÈ). ðÏ ÕÍÏÌÞÁÎÉÀ false. + ÷ ÂÕÄÕÝÉÈ ×ÅÒÓÉÑÈ ÜÔÏÔ ÐÁÒÁÍÅÔÒ ÂÕÄÅÔ ÍÁÓÓÉ×ÏÍ É ÐÒÉÎÉÍÁÔØ ÒÁÚÎÙÅ ÏÐÃÉÉ + × ÚÁ×ÉÓÉÍÏÓÔÉ ÏÔ âä. + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - ÓÏÚÄÁÎÎÙÊ DB ÏÂßÅËÔ ÓÏÅÄÉÎÅÎÉÑ, + ÉÌÉ <classname>DB_Error</classname> ÏÂßÅËÔ ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + + <refentry id="core.db.disconnect"> + <refnamediv> + <refname>DB::disconnect()</refname> + <refpurpose>÷ÙÈÏÄÉÔ É ÏÔÓÏÅÄÉÎÑÅÔØÓÑ ÏÔ âä.</refpurpose> + </refnamediv> + + <refsect1 id="core.db.disconnect.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>boolean <function>disconnect</function></funcdef> + <paramdef></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$value</parameter> - ×ÏÚ×ÒÁÝÁÅÍÙÊ ÏÂßÅËÔ ÄÌÑ ÐÒÏ×ÅÒËÉ + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>boolean</parameter> - <parameter>true</parameter> ÅÓÌÉ + <parameter>$value</parameter> - ÏÛÉÂËÁ, + <parameter>false</parameter> ÅÓÌÉ ÎÅ ÏÐÒÅÄÅÌÅÎÁà, ËÁË ÏÛÉÂËÁ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.iswarning"> + <refnamediv> + <refname>DB::isWarning()</refname> + <refpurpose>çÏ×ÏÒÉÔ, Ñ×ÌÑÅÔØÓÑ ÌÉ ÒÅÚÕÌØÔÁÔ ÐÒÅÄÕÐÒÅÖÄÅÎÉÅÍ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.iswarning.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>boolean <function>isWarning</function></funcdef> + <paramdef>DB_Error <parameter>$value</parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ðÒÅÄÕÐÒÅÖÄÅÎÉÑ ÏÔÌÉÞÁÀÔØÓÑ ÏÔ ÏÛÉÂÏË, ÇÅÎÅÒÉÒÕÅÍÙÈ DB ÏÂßÅËÔÏÍ, + É ÎÅ ÆÁÔÁÌØÎÙ. + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>boolean</parameter> - <parameter>true</parameter> ÅÓÌÉ + <parameter>$value</parameter> ÂÙÌ <classname>DB_Error</classname> + ÏÂßÅËÔ ÍÁÒËÉÒÏ×ÁÎ ËÁË ÐÒÅÄÕÐÒÅÖÄÅÎÉÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.iserror"> + <refnamediv> + <refname>DB::isError()</refname> + <refpurpose>çÏ×ÏÒÉÔ, Ñ×ÌÑÅÔØÓÑ ÌÉ ÒÅÚÕÌØÔÁÔ ÏÛÉÂËÏÊ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.iserror.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>boolean <function>isError</function></funcdef> + <paramdef>DB_Error <parameter>$value</parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>boolean</parameter> - <parameter>true</parameter> ÅÓÌÉ + <parameter>$value</parameter> ÂÙÌ <classname>DB_Error</classname> + ÏÂßÅËÔÏÍ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.quote"> + <refnamediv> + <refname>DB::quote()</refname> + <refpurpose>ë×ÏÔÉÒÕÅÔ ËÁ×ÙÞËÁÍÉ ÓÔÒÏËÕ ÄÌÑ ÂÅÚÏÐÁÓÎÏÇÏ ÉÓÐÏÌØÚÏ×ÁÎÉÑ × +ÚÁÐÒÏÓÁÈ. </refpurpose> + </refnamediv> + <refsect1 id="core.db.quote.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>quote</function></funcdef> + <paramdef>string <parameter>$string</parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$string</parameter> - ×ÈÏÄÎÁÑ ÓÔÒÏËÁ ÄÌÑ Ë×ÏÔÉÒÏ×ÁÎÉÑ. + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - NULL, ÅÓÌÉ ÎÕÌÅ×ÁÑ ÓÔÒÏËÁ ÎÁ ×ÈÏÄÅ, + × ÐÒÏÔÉ×ÎÏÍ ÓÌÕÞÁÅ - Ë×ÏÔÉÒÏ×ÁÎÎÁÑ ÓÔÒÏËÁ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.provides"> + <refnamediv> + <refname>DB::provides()</refname> + <refpurpose>çÏ×ÏÒÉÔ, ËÁËÉÅ ÒÅÁÌÉÚÁÃÉÉ âä ÉÌÉ ÒÁÓÛÉÒÅÎÉÑ ÐÏÄÄÅÒÖÉ×ÁÀÔ + ÄÁÎÎÏÅ Ó×ÏÊÓÔ×Ï.</refpurpose> + </refnamediv> + <refsect1 id="core.db.provides.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>boolean <function>provides</function></funcdef> + <paramdef>string <parameter>$feature</parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$feature</parameter> - ÉÍÑ Ó×ÏÊÓÔ×Á (ÓÍ. ÄÏË. DB ËÌÁÓÓÁ) + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>boolean</parameter> - ÉÓÐÏÌØÚÕÅÔØÓÑ ÌÉ $feature ÄÁÎÎÏÊ + ÒÅÁÌÉÚÁÃÉÅÊ âä. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.setfetchmode"> + <refnamediv> + <refname>DB::setFetchMode()</refname> + <refpurpose>÷ÙÂÏÒ ÆÏÒÍÁÔÁ ×ÙÂÉÒÁÅÍÙÈ ÓÔÒÏË ÉÓÐÏÌØÚÕÅÍÙÊ ÐÏ ÕÍÏÌÞÁÎÉÀ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.setfetchmode.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>setFetchMode</function></funcdef> + <paramdef>integer <parameter>$fetchmode</parameter></paramdef> + <paramdef>string + <parameter><optional>$object_class</optional></parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$fetchmode</parameter> - + <parameter>DB_FETCHMODE_ORDERED</parameter>, + <parameter>DB_FETCHMODE_OBJECT</parameter> ÉÌÉ + <parameter>DB_FETCHMODE_ASSOC</parameter>, ×ÏÚÍÏÖÎÏ ÉÓÐÏÌØÚÏ×ÁÎÉÅ Ó ×ÙÒÁÖÅÎÉÅÍ OR Ó + <parameter>DB_FETCHMODE_FLIPPED</parameter>. óÍ. + <link linkend="core.db.tut_fetch">"Fetch"-ÓÅËÃÉÀ</link> + ÄÌÑ ÄÏÐÏÌÎÉÔÅÌØÎÏÊ ÉÎÆÏÒÍÁÃÉÉ. + </para> + </listitem> + <listitem> + <para> + <parameter>$object_class</parameter> - ëÌÁÓÓ, ÏÂßÅËÔ ËÏÔÏÒÏÇÏ ÂÕÄÅÔ ×ÏÚ×ÒÁÝÅÎ + ÍÅÔÏÄÏÍ fetch, ÐÒÉ ×ÙÂÏÒÅ ÐÁÒÁÍÅÔÒÁ + <parameter>DB_FETCHMODE_OBJECT</parameter>. + åÓÌÉ ÎÉËÁËÏÇÏ ËÌÁÓÓÁ ÎÅ ÚÁÄÁÎÏ, ÐÏ ÕÍÏÌÞÁÎÉÀ ÂÕÄÅÔ + ÐÒÉ×ÅÄÅÎÉÅ ÁÓÓÏÃÉÁÔÉ×ÎÏÇÏ ÍÁÓÓÉ×Á Ë ÏÂßÅËÔÕ. + üÔÏ ÔÁË ÖÅ ×ÏÚÍÏÖÎÏÓÔØ ÉÓÐÏÌØÚÏ×ÁÔØ É ÒÁÓÛÉÒÑÔØ ËÌÁÓÓ 'DB_Row'. + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - ÎÉÞÅÇÏ ÉÌÉ + <parameter>PEAR_ERROR</parameter>, + ÅÓÌÉ <parameter>$fetchmode</parameter> ÓÏÄÅÒÖÉÔ ÎÅÉÚ×ÅÓÔÎÏÅ ÚÎÁÞÅÎÉÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.prepare"> + <refnamediv> + <refname>DB::prepare()</refname> + <refpurpose>ðÏÄÇÏÔÁ×ÌÉ×ÁÅÔ ÚÁÐÒÏÓ ÄÌÑ ÍÎÏÖÅÓÔ×ÅÎÎÏÇÏ ×ÙÐÏÌÎÅÎÉÑ Ó ÐÏÍÏÛØÀ + execute(). </refpurpose> + </refnamediv> + <refsect1 id="core.db.prepare.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>resource <function>prepare</function></funcdef> + <paramdef>string <parameter>$query</parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>Prepare</function> ÔÒÅÂÕÅÔ ÏÓÎÏ×ÎÏÊ ÚÁÐÒÏÓ ËÁË ÓÔÒÏËÕ ×ÉÄÁ + "INSERT INTO numbers VALUES(?,?,?)". + ? - ÍÅÔËÉ-ÚÁÐÏÌÎÉÔÅÌÉ. ôÉÐÙ ÍÅÔÏË-ÚÁÐÏÌÎÉÔÅÌÅÊ: + <simplelist> + <member> + <parameter>?</parameter> - Ë×ÏÔÉÒÏ×ÁÎÎÏÅ ÓËÁÌÑÒÎÏÅ ÚÎÁÞÅÎÉÅ, Ô.Å. ÓÔÒÏËÉ, ÞÉÓÌÁ + </member> + <member> + <parameter>&</parameter> - ÔÒÅÂÕÅÔ ÉÍÑ ÆÁÊÌÁ, ÓÏÄÅÒÖÉÍÏÅ ÆÁÊÌÁ ÂÕÄÅÔ + ×ÎÅÓÅÎÏ × ÚÁÐÒÏÓ (Ô.Å. ÄÌÑ ÓÏÈÒÁÎÅÎÉÑ ÂÉÎÁÒÎÙÈ ÄÁÎÎÙÈ × âä). + </member> + <member> + <parameter>!</parameter> - ÚÎÁÞÅÎÉÅ ÂÕÄÅÔ ×ÎÅÓÅÎÏ 'ËÁË ÅÓÔØ' + </member> + </simplelist> + óÍ. <link linkend="core.db.tut_execute">"Execute"-ÓÅËÃÉÀ</link> + ÄÌÑ ÄÏÐ. ÉÎÆÏÒÍÁÃÉÉ. + </para> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$query</parameter> - ÚÁÐÒÏÓ ÄÌÑ ÐÏÄÇÏÔÏ×ËÉ + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>resource</parameter> - ÉÄÅÎÔÉÆÉËÁÔÏÒ ÚÁÐÒÏÓÁ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.execute"> + <refnamediv> + <refname>DB::execute()</refname> + <refpurpose>÷ÙÐÏÌÎÑÅÔ ÐÏÄÇÏÔÏ×ÌÅÎÎÙÊ SQL ÚÁÐÒÏÓ</refpurpose> + </refnamediv> + <refsect1 id="core.db.execute.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>execute</function></funcdef> + <paramdef>string <parameter>$stmt</parameter></paramdef> + <paramdef>array <parameter>$data</parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ó ÐÏÍÏÝØÀ Æ-ÃÉÉ <function>execute</function>, ÏÓÎÏ×ÎÏÊ ÐÏÄÇÏÔÏ×ÌÅÎÎÙÊ ÚÁÐÒÏÓ + ÂÕÄÅÔ ÓÏÐÏÓÔ×ÌÅÎ Ó ÄÁÎÎÙÍ $data ÍÁÓÓÉ×ÏÍ. + úÎÁÞÅÎÉÑ ÍÁÓÓÉ×Á ÂËÄÕÔ ×ÎÏÓÉÔØÓÑ × Ú×ÐÒÏÓ × ÔÁËÏÍ ÐÏÒÑÄËÅ, + × ËÏÔÏÒÏÍ ÏÎÉ ÎÁÈÏÄÑÔØÓÑ × ÍÁÓÓÉ×Å. + óÍ. <link linkend="core.db.tut_execute">"Execute"-ÓÅËÃÉÀ</link> + ÄÌÑ ÄÏÐ. ÉÎÆÏÒÍÁÃÉÉ. + </para> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$stmt</parameter> - ÉÄÅÎÔÉÆÉËÁÔÏÒ ÚÁÐÒÏÓÁ ÏÔ Æ-ÃÉÉ + <link linkend="core.db.prepare"><function>prepare</function> + </link> + </para> + </listitem> + <listitem> + <para> + <parameter>$data</parameter> - ÎÕÍÅÒÏ×ÁÎÙÊ ÍÁÓÓÉ×, ÓÏÄÅÒÖÁÝÉÊ ÄÁÎÎÙÅ + ÄÌÑ ÚÁÎÅÓÅÎÉÑ × Ú×ÐÒÏÓ. + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>resource</parameter> - ÏÂßÅËÔ ËÌÁÓÓÁ <classname>DB_Result</classname> + ÉÌÉ <classname>DB_Error</classname> ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.executemultiple"> + <refnamediv> + <refname>DB::executeMultiple()</refname> + <refpurpose>íÕÌØÔÉ×ÙÐÏÌÎÅÎÉÅ ÐÏÄÇÏÔÏ×ÌÅÎÎÏÇÏ SQL ÚÁÐÒÏÓÁ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.executemultiple.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>executeMultiple</function></funcdef> + <paramdef>string <parameter>$stmt</parameter></paramdef> + <paramdef>array <parameter>$data</parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + üÔÁ ÆÕÎËÃÉÑ ÄÅÌÁÅÔ ÍÎÏÖÅÓÔ×ÅÎÎÙÊ ×ÙÚÏ× Æ-ÃÉÉ <function>execute</function> + ÄÌÑ ÏÄÎÏÇÏ É ÔÏÇÏ ÖÅ ÉÄÅÎÔÉÆÉËÁÔÏÒÁ ÚÁÐÒÏÓÁ. + $data ÄÏÌÅÎ ÂÙÔØ ÍÁÓÓÉ×ÏÍ, ÎÕÍÅÒÏ×ÁÎÙÍ, ÉÎÄÅËÓÉÒÏ×ÁÎÎÙÍ Ó ÎÕÌÑ (0), + ïÄÉÎ ×ÙÚÏ× execute ÄÌÑ ËÁÖÄÏÊ ÓÔÒÏËÉ × ÍÁÓÓÉ×Å. + åÓÌÉ ÐÒÏÉÓÈÏÄÉÔ ÏÛÉÂËÁ × ÐÒÏÃÅÓÓÅ <function>execute</function>, + <function>executeMultiple</function> ÎÅ ÂÕÄÅÔ ×ÙÐÏÌÎÑÔØ ÏÓÔÁÌØÎÙÅ + ÚÁÐÒÏÓÙ, É ×ÅÒÎÅÔ ÏÛÉÂËÕ. + óÍ. <link linkend="core.db.tut_execute">"Execute"-section</link> + ÄÌÑ ÄÏÐ. ÉÎÆÏÒÍÁÃÉÉ. + </para> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$stmt</parameter> - ÉÄÅÎÔÉÆÉËÁÔÏÒ ÚÁÐÒÏÓÁ Æ-ÃÉÉ + <link linkend="core.db.prepare"><function>prepare</function> + </link> + </para> + </listitem> + <listitem> + <para> + <parameter>$data</parameter> - ÎÕÍÅÒÏ×ÁÎÙÊ ÍÁÓÓÉ×, ÓÏÄÅÒÖÁÝÉÊ ÄÁÎÎÙÅ + ÄÌÑ ×ÎÅÓÅÎÉÑ × ÚÁÐÒÏÓ. + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>resource</parameter> - ÏÂØÅËÔ ËÌÁÓÓÁ <classname>DB_Result</classname> + ÉÌÉ <classname>DB_Error</classname> ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.query"> + <refnamediv> + <refname>DB::query()</refname> + <refpurpose>ðÏÓÙÌÁÅÔ ÚÁÐÒÏÓ Ë ÂÁÚÅ ÄÁÎÎÙÈ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.query.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>&query</function></funcdef> + <paramdef>string <parameter>$query</parameter></paramdef> + <paramdef>array <parameter><optional>$params</optional></parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + óÍ. <link linkend="core.db.tut_query">"Query"-ÓÅËÃÉÀ</link> + ÄÌÑ ÄÏÐ. ÉÎÆÏÒÍÁÃÉÉ. + </para> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$query</parameter> - SQL ÚÁÐÒÏÓ</para> + </listitem> + <listitem> + <para> + <parameter>$params</parameter> - $params ÄÁÎÎÙÅ ÄÌÑ ÄÏÂÁ×ÌÅÎÉÑ Ë + ÚÁÐÒÏÓÕ. + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>resource</parameter> - ÏÂØÅËÔ ËÌÁÓÓÁ <classname>DB_Result</classname> + ÉÌÉ <classname>DB_Error</classname> ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.limitquery"> + <refnamediv> + <refname>DB::limitQuery()</refname> + <refpurpose>ÇÅÎÅÒÁÃÉÑ ÏÇÒÁÎÉÞÅÎÎÏÇÏ (ÌÉÍÉÔÉÒÏ×ÁÎÎÏÇÏ) ÚÁÐÒÏÓÁ + <emphasis>åëóðåòéíåîôáìøîï!</emphasis></refpurpose> + </refnamediv> + <refsect1 id="core.db.limitquery.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>&limitQuery</function></funcdef> + <paramdef>string <parameter>$query</parameter></paramdef> + <paramdef>integer <parameter>$from</parameter></paramdef> + <paramdef>integer <parameter>$count</parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$query</parameter> - SQL ÚÁÐÒÏÓ ÉÌÉ ×ÙÒÁÖÅÎÉÅ ÄÌÑ + ÐÏÄÇÏÔÏ×ËÉ. + </para> + </listitem> + <listitem> + <para> + <parameter>$from</parameter> - ÓÔÒÏËÁ Ó ËÏÔÏÒÏÊ ÎÁÞÉÎÁÔØ ×ÙÂÏÒËÕ + </para> + </listitem> + <listitem> + <para> + <parameter>$count</parameter> - ËÏÌÉÞÅÓÔ×Ï ÓÔÒÏË ÄÌÑ ×ÙÂÏÒËÉ + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>resource</parameter> - ÏÂßÅËÔ ËÌÁÓÓÁ <classname>DB_Result</classname> + ÉÌÉ <classname>DB_Error</classname> + ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.getone"> + <refnamediv> + <refname>DB::getOne()</refname> + <refpurpose>÷ÙÂÉÒÁÅÔ ÐÅÒ×ÙÊ ÓÔÏÌÂÅà ÐÅÒ×ÏÊ ÓÔÒÏËÉ ÉÚ ÚÁÐÒÏÓÁ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.getone.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>&getOne</function></funcdef> + <paramdef>string <parameter>$query</parameter></paramdef> + <paramdef>array + <parameter><optional>$params</optional></parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ÷ÙÂÉÒÁÅÔ ÐÅÒ×ÙÊ ÓÔÏÌÂÅà ÐÅÒ×ÏÊ ÓÔÒÏËÉ ÄÁÎÎÙÈ, ×ÏÚ×ÒÁÝÁÅÍÙÈ + ÉÚ ÚÁÐÒÏÓÁ. âÕÄØÔÅ ÏÓÔÏÒÏÖÎÙ ÐÒÉ ×ÙÐÏÌÎÅÎÉÉ ÚÁÐÒÏÓÁ É ÏÓ×ÏÂÏÖÄÁÊÔÅ + (free) ÒÅÓÕÒÓ ËÏÇÄÁ ÚÁËÏÎÞÉÔÅ. + </para> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$query</parameter> - SQL ÚÁÐÒÏÓ ÉÌÉ ×ÙÒÁÖÅÎÉÅ ÄÌÑ ÐÏÄÇÏÔÏ×ËÉ. + </para> + </listitem> + <listitem> + <para> + <parameter>$params</parameter> - ÅÓÌÉ ÐÒÉÓÕÄÓÔ×ÕÅÔ prepare/execute + ÂÕÄÅÔ ÉÓÐÏÌØÚÏ×ÁÎÏ Ó ÜÔÉÍ ÍÁÓÓÉ×ÏÍ ÐÒÉ ×ÙÐÏÌÎÅÎÉÉ ÐÁÒÁÍÅÔÒÏ×. + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - ×ÏÚ×ÒÁÝÅÎÏÅ ÚÎÁÞÅÎÉÅ + ÉÌÉ <classname>DB_Error</classname> ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.getrow"> + <refnamediv> + <refname>DB::getRow()</refname> + <refpurpose>÷ÙÂÉÒÁÅÔ ÐÅÒ×ÕÀ ÓÔÒÏËÕ ÉÚ ÚÁÐÒÏÓÁ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.getrow.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>&getRow</function></funcdef> + <paramdef>string <parameter>$query</parameter></paramdef> + <paramdef>array + <parameter><optional>$params</optional></parameter></paramdef> + <paramdef>integer + <parameter><optional>$fetchmode</optional></parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ÷ÙÂÉÒÁÅÔ ÐÅÒ×ÕÀ ÓÔÒÏËÕ ÄÁÎÎÙÈ, ×ÏÚ×ÒÁÝÅÎÎÙÈ ÉÚ ÚÁÐÒÏÓÁ. + âÕÄØÔÅ ÏÓÔÏÒÏÖÎÙ ÐÒÉ ×ÙÐÏÌÎÅÎÉÉ ÚÁÐÒÏÓÁ É ÏÓ×ÏÂÏÖÄÁÊÔÅ + (free) ÒÅÓÕÒÓ ËÏÇÄÁ ÚÁËÏÎÞÉÔÅ. + + </para> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$query</parameter> - SQL ÚÁÐÒÏÓ + </para> + </listitem> + <listitem> + <para> + <parameter>$params</parameter> - ÅÓÌÉ ÐÒÉÓÕÄÓÔ×ÕÅÔ prepare/execute + ÂÕÄÅÔ ÉÓÐÏÌØÚÏ×ÁÎÏ Ó ÜÔÉÍ ÍÁÓÓÉ×ÏÍ ÐÒÉ ×ÙÐÏÌÎÅÎÉÉ ÐÁÒÁÍÅÔÒÏ×. + </para> + </listitem> + <listitem> + <para> + <parameter>$fetchmode</parameter> - ÒÅÖÉÍ ×ÙÂÏÒËÉ, ÐÏ ÕÍÏÌÞÁÎÉÀ + - <parameter>DB_FETCHMODE_DEFAULT</parameter> + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - ÐÅÒ×ÕÀ ÓÔÒÏËÕ ÉÚ ÚÁÐÒÏÓÁ ËÁË ÍÁÓÓÉ×, + ÉÎÄÅËÓÉÒÕÅÍÙÊ Ó ÎÕÌÑ (0) + ÉÌÉ <classname>DB_Error</classname> ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.getcol"> + <refnamediv> + <refname>DB::getCol()</refname> + <refpurpose>÷ÙÂÉÒÁÅÔ ÅÄÉÎÉÞÎÙÊ ÓÔÏÌÂÅà ÉÚ ÚÁÐÒÏÓÁ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.getcol.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>&getCol</function></funcdef> + <paramdef>string <parameter>$query</parameter></paramdef> + <paramdef>mixed <parameter><optional>$col</optional></parameter></paramdef> + <paramdef>array + <parameter><optional>$params</optional></parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ÷ÙÂÉÒÁÅÔ ÅÄÉÎÉÞÎÙÊ ÓÔÏÌÂÅà ÉÚ ÍÎÏÖÅÓÔ×Á ÒÅÚÕÌØÔÁÔÏ× É ×ÏÚ×ÒÁÝÁÅÔ + ÉÎÄÅËÓÉÒÕÅÍÙÊ ÍÁÓÓÉ×. + </para> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$query</parameter> - SQL ÚÁÐÒÏÓ + </para> + </listitem> + <listitem> + <para> + <parameter>$col</parameter> - ËÁËÏÊ ÓÔÏÌÂÅà ×ÏÚ×ÒÁÝÁÔØ (integer [ÎÏÍÅÒ + ÓÔÏÌÂÃÁ, ÎÁÞÉÎÁÀÝÉÊÓÑ Ó 0] ÉÌÉ string [ÉÍÑ ÓÔÏÌÂÃÁ]), ÐÏ ÕÍÏÌÞÁÎÉÀ + <parameter>0</parameter> + </para> + </listitem> + <listitem> + <para> + <parameter>$params</parameter> - ÅÓÌÉ ÐÒÉÓÕÄÓÔ×ÕÅÔ prepare/execute + ÂÕÄÅÔ ÉÓÐÏÌØÚÏ×ÁÎÏ Ó ÜÔÉÍ ÍÁÓÓÉ×ÏÍ ÐÒÉ ×ÙÐÏÌÎÅÎÉÉ + ÐÁÒÁÍÅÔÒÏ×. + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - ÅÄÉÎÉÞÎÙÊ ÓÔÏÌÂÅà ÉÚ ÍÎÏÖÅÓÔ×Á + ÒÅÚÕÌØÔÁÔÏ× ËÁË ÍÁÓÓÉ×, ÉÎÄÅËÓÉÒÕÅÍÙÊ Ó 0 ÉÌÉ <classname>DB_Error</classname> ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.getassoc"> + <refnamediv> + <refname>DB::getAssoc()</refname> + <refpurpose> + ÷ÙÂÉÒÁÅÔ ÍÎÏÖÅÓÔ×Ï ÒÅÚÕÌØÔÁÔÏ× ËÁË ÁÓÓÏÃÉÁÔÉ×ÎÙÊ ÍÁÓÓÉ×, + ÉÓÐÏÌØÚÕÑ ÐÅÒ×ÙÊ ÓÔÏÌÂÅÃ, ËÁË ËÌÀÞ. + </refpurpose> + </refnamediv> + <refsect1 id="core.db.getassoc.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>array <function>&getAssoc</function></funcdef> + <paramdef>string <parameter>$query</parameter></paramdef> + <paramdef> + boolean + <parameter><optional>$force_array</optional></parameter></paramdef> + <paramdef> + array <parameter><optional>$params</optional></parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ÷ÙÂÉÒÁÅÔ ×ÓÅ ÍÎÏÖÅÓÔ×Ï ÒÅÚÕÌØÔÁÔÏ× ÚÁÐÒÏÓÁ É ×ÏÚ×ÒÁÝÁÅÔ + ÅÇÏ ËÁË ÁÓÓÏÃÉÁÔÉ×ÎÙÊ ÍÁÓÓÉ×, ÉÓÐÏÌØÚÕÑ ÐÅÒ×ÙÊ ÓÔÏÌÂÅÃ, ËÁË ËÌÀÞ. + + åÓÌÉ ÍÎÏÖÅÓÔ×Ï ÒÅÚÕÌØÔÁÔÁ ÓÏÄÅÒÖÉÔ ÂÏÌÅÅ Ä×ÕÈ ÓÔÏÌÂÃÏ×, + ÚÎÁÞÅÎÉÅ ÂÕÄÅÔ ÍÁÓÓÉ×ÏÍ ÚÎÁÞÅÎÉÊ ÏÔ ÓÔÏÌÂÃÁ 2. åÓÌÉ ÍÎÏÖÅÓÔ×Ï + ÒÅÚÕÌØÔÁÔÁ ÓÏÄÅÒÖÉÔ ÔÏÌØËÏ Ä×Á ÓÔÏÌÂÃÁ, ÔÏ ×ÏÚ×ÒÁÝÁÅÍÏÅ ÚÎÁÞÅÎÉÅ + ÂÕÄÅÔ ÓËÁÌÑÒÏÍ ÓÏ ÚÎÁÞÅÎÉÅÍ ×ÔÏÒÏÇÏ ÓÔÏÌÂÃÁ (× ÏÔÌÉÞÉÉ ÏÔ ÐÒÉÎÕÄÉÔÅÌØÎÏÇÏ + ÓÏÚÄÁÎÉÑ ÍÁÓÓÉ×Á ÐÒÉ ÐÏÍÏÝÉ ÐÁÒÁÍÅÔÒÁ $force_array). + DB error ËÏÄ ÂÕÄÅÔ ×ÏÚ×ÒÁÝÅÎ ÐÒÉ ÏÛÉÂËÅ. åÓÌÉ ÍÎÏÖÅÓÔ×Ï ÚÁÐÒÏÓÁ + ÓÏÄÅÒÖÉÔ ÍÅÎÅÅ Ä×ÕÈ ÓÔÏÌÂÃÏ×, ×ÏÚ×ÒÁÝÁÅÔØÓÑ ÐÁÒÁÍÅÔÒ-ÏÛÉÂËÁ - <parameter>DB_ERROR_TRUNCATED</parameter>. + + </para> + <para> + ðÒÉÍÅÒ ÉÓÐÏÌØÚÏ×ÁÎÉÑ: + <example> + <title>"mytable"</title> + <programlisting> + <![CDATA[ +ID TEXT DATE +---------------------- +1 'one' 944679408 +2 'two' 944679408 +3 'three' 944679408 + ]]> + </programlisting> + </example> + ëÏÇÄÁ ×ÙÚÙ×ÁÅÍ getAssoc('SELECT id,text FROM mytable') ×ÏÚ×ÒÁÔÉÔÓÑ: + <example> + <title>×ÏÚ×ÒÁÝÁÅÍÙÊ ÍÁÓÓÉ× - ×ÅÒÓÉÑ 1</title> + <programlisting> + <![CDATA[ +array( + '1' => 'one', + '2' => 'two', + '3' => 'three', + ) + ]]> + </programlisting> + </example> + ...× ÔÏ ×ÒÅÍÑ ËÁË ×ÙÚÏ× getAssoc('SELECT id,text,date FROM mytable') + ×ÏÚ×ÒÁÔÉÔ: + <example> + <title>×ÏÚ×ÒÁÝÁÅÍÙÊ ÍÁÓÓÉ× - ×ÅÒÓÉÑ 2</title> + <programlisting> + <![CDATA[ +array( + '1' => array('one', '944679408'), + '2' => array('two', '944679408'), + '3' => array('three', '944679408') + ) + ]]> + </programlisting> + </example> + </para> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$query</parameter> - the SQL query + </para> + </listitem> + <listitem> + <para> + <parameter>$force_array</parameter> - ÉÓÐÏÌØÚÕÅÔØÓÑ ÔÏÇÄÁ, ËÏÇÄÁ ÚÁÐÒÏÓ + ×ÏÚ×ÒÁÝÁÅÔ ÔÏÌØËÏ Ä×Á ÓÔÏÌÂÃÁ. åÓÌÉ true, ÚÎÁÞÅÎÉÑ ×ÏÚ×ÒÁÝÁÅÍÏÇÏ + ÍÁÓÓÉ×Á ÂÕÄÅÔ ÏÄÎÏ-ÜÌÅÍÅÎÔÎÙÊ ÍÁÓÓÉ× × ÏÔÌÉÞÉÉ ÏÔ ÓËÁÌÑÒÁ. + </para> + </listitem> + <listitem> + <para> + <parameter>$params</parameter> - ÅÓÌÉ ÐÒÉÓÕÄÓÔ×ÕÅÔ prepare/execute + ÂÕÄÅÔ ÉÓÐÏÌØÚÏ×ÁÎÏ Ó ÜÔÉÍ ÍÁÓÓÉ×ÏÍ ÐÒÉ ×ÙÐÏÌÎÅÎÉÉ + ÐÁÒÁÍÅÔÒÏ×. + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>array</parameter> - ÁÓÓÏÃÉÁÔÉ×ÎÙÊ ÍÁÓÓÉ× ËÏÔÏÒÙÊ + ×ÏÚ×ÒÁÝÁÅÔØÓÑ ÉÚ ÚÁÐÒÏÓÁ. + </para> + </listitem> + </itemizedlist> + </para> + <note> + <para> + ðÏÍÎÉÔÅ, ÞÔÏ ÆÕÎËÃÉÉ ÒÁÂÏÔÙ Ó âä × PHP ÏÂÙÞÎÏ ×ÏÚ×ÒÁÝÁÀÔ ÓÔÒÏËÏ×ÙÅ + ÚÎÁÞÅÎÉÑ ÄÌÑ ÒÅÚÕÌØÔÁÔÏ×, ×ÎÅ ÚÁ×ÉÓÉÍÏÓÔÉ ÏÔ ×ÎÕÔÒÅÎÎÉÈ ÔÉÐÏ× × âä. + </para> + </note> + </refsect1> + </refentry> + + <refentry id="core.db.getall"> + <refnamediv> + <refname>DB::getAll()</refname> + <refpurpose>÷ÙÂÉÒÁÅÔ ×ÓÅ ÓÔÒÏËÉ ÉÚ ÚÁÐÒÏÓÁ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.getall.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>&getAll</function></funcdef> + <paramdef>string <parameter>$query</parameter></paramdef> + <paramdef>array + <parameter><optional>$params</optional></parameter></paramdef> + <paramdef>integer + <parameter><optional>$fetchmode</optional></parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ðÁÒÁÍÅÔÒÙ + <itemizedlist> + <listitem> + <para> + <parameter>$query</parameter> - SQL ÚÁÐÒÏÓ + </para> + </listitem> + <listitem> + <para> + <parameter>$params</parameter> - ÅÓÌÉ ÐÒÉÓÕÄÓÔ×ÕÅÔ prepare/execute + ÂÕÄÅÔ ÉÓÐÏÌØÚÏ×ÁÎÏ Ó ÜÔÉÍ ÍÁÓÓÉ×ÏÍ ÐÒÉ ×ÙÐÏÌÎÅÎÉÉ + </para> + </listitem> + <listitem> + <para> + <parameter>$fetchmode</parameter> - ÒÅÖÉÍ ×ÙÂÏÒËÉ, ÐÏ ÕÍÏÌÞÁÎÉÀ: + <parameter>DB_FETCHMODE_DEFAULT</parameter> + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - ×ÌÏÖÅÎÎÙÊ ÍÁÓÓÉ× ÉÌÉ + <classname>DB_Error</classname> ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.affectedrows"> + <refnamediv> + <refname>DB::affectedRows()</refname> + <refpurpose>×ÏÚ×ÒÁÝÁÅÔ ËÏÌÉÞÅÓÔ×Ï ÉÚÍÅÎÅÎÎÙÈ ÓÔÒÏË ÚÁÐÒÏÓÏÍ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.affectedrows.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>affectedRows</function></funcdef> + <paramdef></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - ÞÉÓÌÏ ÓÔÒÏË ÉÌÉ + <classname>DB_Error</classname> ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.nextid"> + <refnamediv> + <refname>DB::nextId()</refname> + <refpurpose>×ÏÚ×ÒÁÝÁÅÔ ÓÌÅÄÕÀÝÅÅ Ó×ÏÂÏÄÎÏÅ éä ÐÏÓÌÅÄÏ×ÁÔÅÌØÎÏÓÔÉ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.nextid.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>nextId</function></funcdef> + <paramdef>string <parameter>$seq_name</parameter></paramdef> + <paramdef>boolean + <parameter><option>$on_demand</option></parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ðÁÒÁÍÅÔÒÙ + <itemizedlist> + <listitem> + <para> + <parameter>$seq_name</parameter> - ÉÍÑ ÐÏÓÌÅÄÏ×ÁÔÅÌØÎÏÓÔÉ. + </para> + </listitem> + <listitem> + <para> + <parameter>$ondemand</parameter> - ÅÓÌÉ true - ÐÏÓÌÅÄÏ×ÁÔÅÌØÎÏÓÔØ + ÂÕÄÅÔ Á×ÔÏÍÁÔÉÞÅÓËÉ ÓÏÚÄÁÎÁ, ÅÓÌÉ ÄÏ ÜÔÏÇÏ ÎÅ ÓÕÝÅÓÔ×Ï×ÁÌÁ. + ðÏ ÕÍÏÌÞÁÎÉÀ - <parameter>true</parameter>. + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - Ó×ÏÂÏÄÎÏÅ éä ÉÌÉ + <classname>DB_Error</classname> ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.createsequence"> + <refnamediv> + <refname>DB::createSequence()</refname> + <refpurpose>ÓÏÚÄÁÅÔ ÎÏ×ÕÀ ÐÏÓÌÅÄÏ×ÁÔÅÌØÎÏÓÔØ</refpurpose> + </refnamediv> + <refsect1 id="core.db.createsequence.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>createSequence</function></funcdef> + <paramdef>string <parameter>$seq_name</parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$seq_name</parameter> - ÉÍÑ ÐÏÓÌÅÄÏ×ÁÔÅÌØÎÏÓÔÉ. + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - ÒÅÚÕÌØÔÁÔ ÓÏÚÄÁÎÉÑ ÚÁÐÒÏÓÁ + ÉÌÉ <classname>DB_Error</classname> ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.dropsequence"> + <refnamediv> + <refname>DB::dropSequence()</refname> + <refpurpose>ÕÄÁÌÑÅÔ ÐÏÓÌÅÄÏ×ÁÔÅÌØÎÏÓÔØ</refpurpose> + </refnamediv> + <refsect1 id="core.db.dropsequence.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>dropSequence</function></funcdef> + <paramdef>string <parameter>$seq_name</parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$seq_name</parameter> - ÉÍÑ ÐÏÓÌÅÄÏ×ÁÔÅÌØÎÏÓÔÉ. + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - ÒÅÚÕÌØÔÁÔ ÕÄÁÌÅÎÉÑ ÐÏÓÌÅÄÏ×ÁÔÅÌØÎÏÓÔÉ + ÉÌÉ <classname>DB_Error</classname> ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.tableinfo"> + <refnamediv> + <refname>DB::tableInfo()</refname> + <refpurpose>×ÏÚ×ÒÁÝÁÅÔ ÍÅÔÁ-ÄÁÎÎÙÅ Ï ÒÅÚÕÌØÔÁÔÅ</refpurpose> + </refnamediv> + <refsect1 id="core.db.tableinfo.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>tableInfo</function></funcdef> + <paramdef>DB_Result <parameter>$result</parameter></paramdef> + <paramdef>mode + <parameter><optional>$mode</optional></parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$result</parameter> - ÏØßÅËÔ ÒÅÚÕÌØÔÁÔÁ ÄÌÑ ÁÎÁÌÉÚÁ. + </para> + </listitem> + <listitem> + <para> + <parameter>$mode</parameter> - ÚÁ×ÉÓÉÔ ÏÔ ÒÅÁÌÉÚÁÃÉÉ âä. + <itemizedlist> + <listitem> + <para> + FrontBase, MS-SQL, MySQL, PostgreSQL + <itemizedlist> + <listitem><para><parameter>false</parameter> (ÐÏ ÕÍÏÌÞÁÎÉÀ) + ×ÏÚ×ÒÁÝÁÅÔ ÔÁËÏÊ ÍÁÓÓÉ×: + <programlisting> + <![CDATA[ +[0]["table"] table name +[0]["name"] field name +[0]["type"] field type +[0]["len"] field length +[0]["flags"] field flags + ]]> + </programlisting> + </para> + </listitem> + <listitem><para><parameter>DB_TABLEINFO_ORDER</parameter> + ×ÏÚ×ÒÁÝÁÅÔ ÔÁËÏÊ ÍÁÓÓÉ×: + <programlisting> + <![CDATA[ +["num_fields"] number of metadata records +[0]["table"] table name +[0]["name"] field name +[0]["type"] field type +[0]["len"] field length +[0]["flags"] field flags +["order"][field name] index of field named "field name" + ]]> + </programlisting> + ðÏÓÌÅÄÎÉÊ ÉÓÐÏÌØÚÕÔØÓÑ ÅÓÌÉ ×Ù ÉÍÅÅÔÅ ÉÍÅÎÁ ÐÏÌÅÊ, Á ÎÅ ÉÎÄÅËÓÙ. + ôÅÓÔ: if (isset($result['meta']['myfield'])) { ... + </para> + </listitem> + <listitem><para><parameter>DB_TABLEINFO_ORDERTABLE</parameter> + ×ÏÚ×ÒÁÝÁÅÔ × ÏÓÎÏ×ÎÏÍ ÔÏ ÖÅ ÓÁÍÏÅe. îÏ Ó ÄÏÐÏÌÎÅÎÉÅÍ: + <programlisting> + <![CDATA[ +["ordertable"][table name][field name] index of field named "field name" + ]]> + </programlisting> + üÔÏ ÓÄÅÌÁÎÏ ÐÏÔÏÍÕ, ÞÔÏ ÅÓÌÉ ×Ù ÉÍÅÅÔÅ ÐÏÌÑ ÉÚ ÒÁÚÎÙÈ ÔÁÂÌÉà + Ó ÏÄÉÎÁËÏ×ÙÍÉ ÉÍÅÎÁÍÉ, ÏÎÉ ÚÁÍÅÝÁÀÔ ËÁÖÄÙÊ ÓÌÅÄÕÀÝÉÊ Ó ÐÁÒÁÍÅÔÒÏÍ + <parameter>DB_TABLEINFO_ORDER</parameter>. + </para> + </listitem> + </itemizedlist> + </para> + </listitem> + <listitem> + <para> + InterBase, Informix, mSQL, Oracle8, ODBC, Sybase - îÅÔ ÉÎÆÏÒÍÁÃÉÉ. + </para> + </listitem> + </itemizedlist> + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - ÒÅÚÕÌØÔÁÔ ÉÓÓÌÅÄÕÅÍÏÇÏ ÚÁÐÒÏÓÁ ÉÌÉ + <classname>DB_Error</classname> ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.getlistof"> + <refnamediv> + <refname>DB::getListOf()</refname> + <refpurpose>ÓÐÉÓÏË ×ÎÕÔÒÅÎÎÅÊ ÉÎÆÏÒÍÁÃÉÉ Ï âä.</refpurpose> + </refnamediv> + <refsect1 id="core.db.getlistof.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>getListOf</function></funcdef> + <paramdef>string <parameter>$type</parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$type</parameter> - ÔÉÐ ÚÁÐÒÁÛÉ×ÁÅÍÙÈ ÐÁÒÁÍÅÔÒÏ×, + ËÏÒÒÅËÔÎÙÅ ÚÎÁÞÅÎÉÑ ÄÌÑ $type ÚÁ×ÉÓÑÔ ÏÔ âä: + <parameter>"databases"</parameter>, <parameter>"users"</parameter>, + <parameter>"view"</parameter>, <parameter>"functions"</parameter> + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - ÚÁÐÒÁÛÉ×ÁÅÍÙÅ ÄÁÎÎÙÅ ÉÌÉ + <classname>DB_Error</classname> ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.dbresult"> + <refnamediv> + <refname>DB_Result</refname> + <refpurpose>ÓÏÄÅÒÖÉÔ ÒÅÚÕÌØÔÁÔ ×ÙÐÏÌÎÅÎÉÑ ÚÁÐÒÏÓÁ Ë âä.</refpurpose> + </refnamediv> + <refsect1 id="core.db.tut_dbresult.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <para> + óÓÙÌËÁ ÎÁ ÜËÚÅÍÐÌÑÒ ÏÂßÅËÔÁ <classname>DB_Result</classname>, ËÏÔÏÒÙÊ + ×ÏÚ×ÒÁÝÁÅÔØÓÑ ÆÕÎËÃÉÑÍÉ, ÔÁËÉÍÉ ËÁË <link linkend="core.db.query"> + <function>query</function></link> ÉÌÉ <link linkend="core.db.execute"> + <function>execute</function></link>. + ïÂØÅËÔ <classname>DB_Result</classname> ÐÒÅÄÌÁÇÁÅÔ ÒÁÚÌÉÞÎÙÅ ÆÕÎËÃÉÉ ÄÌÑ + ÄÏÓÔÕÐÁ Ë ÒÅÚÕÌØÔÁÔÕ SQLÚÁÐÒÏÓÁ Ë âä. + </para> + </refsect1> + </refentry> + + <refentry id="core.db.fetchrow"> + <refnamediv> + <refname>DB_Result::fetchRow()</refname> + <refpurpose>÷ÙÂÉÒÁÅÔ É ×ÏÚ×ÒÁÝÁÅÔ ÓÔÒÏËÕ ÄÁÎÎÙÈ</refpurpose> + </refnamediv> + <refsect1 id="core.db.fetchrow.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>fetchRow</function></funcdef> + <paramdef>integer + <parameter><optional>$fetchmode</optional></parameter> + </paramdef> + <paramdef>integer + <parameter><optional>$rownum</optional></parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$fetchmode</parameter> - ÆÏÒÍÁÔ ×ÙÂÉÒÁÅÍÙÈ ÓÔÒÏË. ðÏ ÕÍÏÌÞÁÎÉÀ - + <parameter>DB_FETCHMODE_DEFAULT</parameter>. óÍ. <link + linkend="core.db.tut_fetch">"Fetch" ÒÁÚÄÅÌ</link> ÄÌÑ ÂÏÌÅÅ ÄÅÔÁÌØÎÏÊ + ÉÎÆÏÒÍÁÃÉÉ. + </para> + <para> + <parameter>$rownum</parameter> - ÎÏÍÅÒ ÓÔÒÏËÉ ÄÌÑ ×ÙÂÏÒËÉ. ðÏ + ÕÍÏÌÞÁÎÉÀ - <parameter>null</parameter>. + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - ÍÁÓÓÉ× ÓÔÒÏËÉ ÄÁÎÎÙÈ, NULL ÅÓÌÉ ÎÅ + ÏÓÔÁÌÏÓØ ÂÏÌØÛÅ ÓÔÒÏË ÉÌÉ DB_Error ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.fetchinto"> + <refnamediv> + <refname>DB_Result::fetchInto()</refname> + <refpurpose>÷ÙÂÉÒÁÅÔ ÓÔÒÏËÕ ÄÁÎÎÙÈ × ÐÒÉÓÕÄÓÔ×ÕÀÝÕÀ ÐÅÒÅÍÅÎÎÕÀ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.fetchinto.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>fetchInto</function></funcdef> + <paramdef>mixed + <parameter>$arr</parameter> + </paramdef> + <paramdef>integer + <parameter><optional>$fetchmode</optional></parameter> + </paramdef> + <paramdef>integer + <parameter><optional>$rownum</optional></parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + óÍ. <link linkend="core.db.tut_fetch">"Fetch" ÓÅËÃÉÀ</link> ÄÌÑ ÂÏÌÅÅ + ÄÅÔÁÌØÎÏÊ ÉÎÆÏÒÍÁÃÉÉ. + </para> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$arr</parameter> - ÓÓÙÌËÁ ÎÁ ÄÁÎÎÙÅ, ÓÏÄÅÒÖÁÝÉÅÓÑ × ÓÔÒÏËÅ. + </para> + <para> + <parameter>$fetchmode</parameter> - ÆÏÒÍÁÔ ×ÙÂÏÒËÉ ÓÔÒÏË. ðÏ ÕÍÏÌÞÁÎÉÀ + - <parameter>DB_FETCHMODE_DEFAULT</parameter>. + </para> + <para> + <parameter>$rownum</parameter> - ÎÏÍÅÒ ÓÔÒÏËÉ ÄÌÑ ×ÙÂÏÒËÉ. ðÏ + ÕÍÏÌÞÁÎÉÀ - <parameter>null</parameter>. + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - DB_OK ÐÒÉ ÕÄÁÞÅ, NULL, ÅÓÌÉ + ÎÅÔ ÂÏÌØÛÅ ÓÔÒÏË ÉÌÉ DB_Error ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.numcols"> + <refnamediv> + <refname>DB_Result::numCols()</refname> + <refpurpose>÷ÏÚ×ÒÁÝÁÅÔ ËÏÌÌÉÞÅÓÔ×Ï ÓÔÏÌÂÃÏ× × ÒÅÚÕÌØÔÁÔÅ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.numcols.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>integer <function>numCols</function></funcdef> + <paramdef></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>integer</parameter> - ËÏÌÌÉÞÅÓÔ×Ï ÓÔÏÌÂÃÏ× ÉÌÉ DB_Error + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.numrows"> + <refnamediv> + <refname>DB_Result::numRows()</refname> + <refpurpose>÷ÏÚ×ÒÁÝÁÅÔ ËÏÌÌÉÞÅÓÔ×Ï ÓÔÒÏË × ÒÅÚÕÌØÔÁÔÅ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.numrows.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>integer <function>numRows</function></funcdef> + <paramdef></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>integer</parameter> - ËÏÌÌÉÞÅÓÔ×Ï ÓÔÒÏË ÉÌÉ DB_Error + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.nextresult"> + <refnamediv> + <refname>DB_Result::nextResult()</refname> + <refpurpose>÷ÏÚ×ÒÁÝÁÅÔ ÓÌÅÄÕÀÝÉÊ ÒÅÚÕÌØÔÁÔ, ÅÓÌÉ ÂÙÌ ×ÙÐÏÌÎÅÎ + ÐÁËÅÔ ÚÁÐÒÏÓÏ×</refpurpose> + </refnamediv> + <refsect1 id="core.db.nextresult.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>boolean <function>nextResult</function></funcdef> + <paramdef></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>boolean</parameter> - true ÅÓÌÉ ÎÏ×ÙÊ ÒÅÚÕÌØÔÁÔ ÐÒÉÓÕÄÓÔ×ÕÅÔ, É false - ÅÓÌÉ ÎÅÔ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.free"> + <refnamediv> + <refname>DB_Result::free()</refname> + <refpurpose>ïÓ×ÏÂÏÖÄÁÅÔ ÒÅÓÕÒÓÙ ×ÙÄÅÌÅÎÎÙÅ ÐÏÄ ÒÅÚÕÌØÔÁÔ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.free.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>free</function></funcdef> + <paramdef></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - true ÐÒÉ ÕÄÁÞÅ ÉÌÉ DB_Error ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.dberror"> + <refnamediv> + <refname>DB_Error</refname> + <refpurpose>ëÌÁÓÓ ÄÌÑ ÓÏÏÂÝÅÎÉÑ ÐÏÒÔÁÔÉ×ÎÙÈ ÓÏÏÂÝÅÎÉÊ Ï ÏÛÉÂËÅ âä.</refpurpose> + </refnamediv> + <refsect1 id="core.db.dberror.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <para> + ÷ ÓÌÕÞÁÅ ÎÅÕÄÁÞÉ, ÍÎÏÇÉÅ ÆÕÎËÃÉÉ ËÌÁÓÓÁ <classname>PEAR::DB</classname> ×ÏÚ×ÒÁÝÁÀÔ + ÏÂßÅËÔ ËÌÁÓÓÁ <classname>DB_Error</classname>. ïÂßÅËÔ ÓÏÄÅÒÖÉÔ ÉÎÆÏÒÍÁÃÉÀ Ï ÐÒÏÉÚÛÅÄÛÅÊ ÏÛÉÂËÅ. + <classname>DB_Error</classname> ÉÍÅÅÔ ÔÅ ÖÅ ÆÕÎËÃÉÉ, ÞÔÏ É + <classname>PEAR_Error</classname>. + </para> + </refsect1> + </refentry> + + <refentry id="core.db.dbwarning"> + <refnamediv> + <refname>DB_Warning</refname> + <refpurpose>ëÌÁÓÓ ÄÌÑ ÓÏÏÂÝÅÎÉÑ ÐÏÒÔÁÔÉ×ÎÙÈ ÐÒÅÄÕÐÒÅÄÉÔÅÌØÎÙÈ ÓÏÏÂÝÅÎÉÊ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.dbwarning.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <para> + <classname>PEAR::DB</classname> ÆÕÎËÃÉÑ ÍÏÖÅÔ ×ÏÚ×ÒÁÝÁÔØ + <classname>DB_Warning</classname>. + ïÂßÅËÔ ÓÏÄÅÒÖÉÔ ÉÎÆÏÒÍÁÃÉÀ Ï ÐÒÏÉÚÛÅÄÛÅÍ ÐÒÅÄÕÐÒÅÖÄÅÎÉÉ. + <classname>DB_Warning</classname> ÉÍÅÅÔ ÔÅ ÖÅ ÆÕÎËÃÉÉ, ÞÔÏ É + <classname>PEAR_Error</classname>. + </para> + </refsect1> + </refentry> + + </reference> <!-- Keep this comment at the end of the file Local variables:
Index: peardoc/ru/core/db.xml diff -u peardoc/ru/core/db.xml:1.4 peardoc/ru/core/db.xml:1.5 --- peardoc/ru/core/db.xml:1.4 Fri Jan 18 09:41:19 2002 +++ peardoc/ru/core/db.xml Sat Jan 26 06:47:04 2002 @@ -1,5 +1,5 @@ <?xml encoding="KOI8-R"?> -<!-- $Revision: 1.4 $ --> +<!-- $Revision: 1.5 $ --> <reference id="core.db"> <title>PEAR DB: ÕÎÉÆÉÃÉÒÏ×ÁÎÎÙÊ API ÄÌÑ ÄÏÓÔÕÐÁ Ë SQL-ÂÁÚÁÍ ÄÁÎÎÙÈ</title> @@ -11,7 +11,7 @@ abstraction layer. </simpara> </partintro> - <refentry id="core.db.dsn"> + <refentry id="core.db.tut_dsn"> <refnamediv> <refname>DSN</refname> <refpurpose>äÁÎÎÙÅ Ï ÉÓÔÏÞÎÉËÅ (data source name)</refpurpose> @@ -31,8 +31,7 @@ </member> <member> <parameter>dbsyntax</parameter>: - - Database used with regards to SQL syntax etc. + âä, ÉÓÐÏÌØÚÕÅÍÁÑ Ó ÏÐÒÅÄÅÌÅÎÎÙÍ SQL ÓÉÎÔÁËÓÉÓÏÍ. </member> <member> <parameter>protocol</parameter>: @@ -54,6 +53,11 @@ <parameter>password</parameter>: ðÁÒÏÌØ ÄÌÑ ÌÏÇÉÎÁ. </member> + <member> + <parameter>proto_opts</parameter>: + íÏÖÅÔ ÉÓÐÏÌØÚÏ×ÁÔØÓÑ Ó ÐÁÒÁÍÅÔÒÏÍ <parameter>protocol</parameter> + </member> + </simplelist> </para> <para> @@ -73,12 +77,6 @@ phptype://hostspec phptype(dbsyntax) phptype - -ôÁË ÖÅ, ÄÌÑ ÀÎÉËÓ-ÓÏËÅÔÏ×: -mysql://user:pass@unix(/path/to/socket)/db - -é ÄÌÑ ÎÅ ÓÔÁÎÄÁÒÔÎÙÈ ÐÏÒÔÏ×: -mysql://user:pass@tcp(localhost:5555)/db </programlisting> îÁ ÔÅËÕÝÉÊ ÍÏÍÅÎÔ ÐÏÄÄÅÒÖÉ×ÁÀÔÓÑ ÓÌÅÄÕÀÝÉÅ âä: @@ -96,7 +94,22 @@ fbsql -> FrontBase </programlisting> </para> - <para> + <para> + ó ÐÏÓÌÅÄÎÅÊ ×ÅÒÓÉÅÊ <classname>DB</classname>, ×Ù ÍÏÖÅÔÅ ÉÓÐÏÌØÚÏ×ÁÔØ + ÓÌÅÄÕÀÝÉÊ ÆÏÒÍÁÔ DSN +<programlisting role="url"> +phptype(syntax)://user:pass@protocol(proto_opts)/database + +ÐÒÉÍÅÒ: +óÏÅÄÉÎÅÎÉÅ Ó âä ÞÅÒÅÚ ÓÏËÅÔ +mysql://user@unix(/path/to/socket)/pear + +óÏÅÄÉÎÅÎÉÅ Ó âä ÎÁ ÎÅ ÓÔÁÎÄÁÒÔÎÙÊ ÐÏÒÔ +pgsql://user:pass@word@tcp(localhost:5555)/pear +</programlisting> + </para> + + <para> <warning id="core.db.features.warning"> <title>÷ÁÖÎÏ!</title> <para> @@ -112,7 +125,7 @@ </refsect1> </refentry> - <refentry id="core.db.connect"> + <refentry id="core.db.tut_connect"> <refnamediv> <refname>Connect</refname> <refpurpose>óÏÅÄÉÎÅÎÉÅ É ÏÔÓÏÅÄÉÎÅÎÉÅ ÏÔ âä.</refpurpose> @@ -170,7 +183,8 @@ </para> </refsect1> </refentry> - <refentry id="core.db.query"> + + <refentry id="core.db.tut_query"> <refnamediv> <refname>Query</refname> <refpurpose>÷ÙÐÏÌÎÅÎÉÅ ÚÁÐÒÏÓÏ× Ë ÂÁÚÅ ÄÁÎÎÙÈ.</refpurpose> @@ -208,7 +222,7 @@ </refsect1> </refentry> - <refentry id="core.db.fetch"> + <refentry id="core.db.tut_fetch"> <refnamediv> <refname>Fetch</refname> <refpurpose>÷ÙÂÏÒËÁ ÓÔÒÏË ÉÚ ÚÁÐÒÏÓÁ.</refpurpose> @@ -587,7 +601,7 @@ </refsect1> </refentry> - <refentry id="core.db.sequences"> + <refentry id="core.db.tut_sequences"> <refnamediv> <refname> Sequences</refname> <refpurpose>ðÏÓÌÅÄÏ×ÁÔÅÌØÎÏÓÔÉ × âä</refpurpose> @@ -619,7 +633,8 @@ </para> </refsect1> </refentry> - <refentry id="core.db.execute"> + + <refentry id="core.db.tut_execute"> <refnamediv> <refname> Execute </refname> <refpurpose>ðÏÄÇÏÔÏ×ËÁ É ÷ÙÐÏÌÎÅÎÉÅ/íÕÌØÔÉ÷ÙÐÏÌÎÅÎÉÅ</refpurpose> @@ -775,6 +790,1445 @@ </refsect2> </refsect1> </refentry> + <refentry id="core.db.connect"> + <refnamediv> + <refname>DB::connect()</refname> + <refpurpose> óÏÚÄÁÅÔ ÎÏ×ÙÊ DB ÏÂØÅËÔ ÓÏÅÄÉÎÅÎÉÑ É ÓÏÅÄÉÎÑÅÔØÓÑ Ó ÕËÁÚÁÎÎÏÊ âä. + </refpurpose> + </refnamediv> + <refsect1 id="core.db.connect.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>connect</function></funcdef> + <paramdef>string <parameter>$dsn</parameter></paramdef> + <paramdef>array + <parameter><optional>$options</optional></parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$dsn</parameter> - <parameter>data source name</parameter> + óÍ. <link linkend="core.db.tut_dsn">"DSN" ÒÁÚÄÅÌ</link> ÄÌÑ + ÄÏÐÏÌÎÉÔÅÌØÎÏÊ ÉÎÆÏÒÍÁÃÉÉ. + </para> + <para> + <parameter>$options</parameter> - üÔÏÔ ÐÁÒÁÍÅÔÒ ÉÍÅÅÔ ÔÉÐ + <parameter>boolean</parameter>, ÅÓÌÉ <parameter>$options</parameter> + ÒÁ×ÎÏ true ÓÏÅÄÉÎÅÎÉÅ ÂÕÄÅÔ ÕÓÔÏÊÞÉ×ÙÍ (persistent) (ÎÕÖÄÁÅÔØÓÑ × + ÐÏÄÄÅÒÖËÅ ÔÁËÏÇÏ ÓÏÅÄÉÎÅÎÉÑ ÂÁÚÏÊ ÄÁÎÎÙÈ). ðÏ ÕÍÏÌÞÁÎÉÀ false. + ÷ ÂÕÄÕÝÉÈ ×ÅÒÓÉÑÈ ÜÔÏÔ ÐÁÒÁÍÅÔÒ ÂÕÄÅÔ ÍÁÓÓÉ×ÏÍ É ÐÒÉÎÉÍÁÔØ ÒÁÚÎÙÅ ÏÐÃÉÉ + × ÚÁ×ÉÓÉÍÏÓÔÉ ÏÔ âä. + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - ÓÏÚÄÁÎÎÙÊ DB ÏÂßÅËÔ ÓÏÅÄÉÎÅÎÉÑ, + ÉÌÉ <classname>DB_Error</classname> ÏÂßÅËÔ ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + + <refentry id="core.db.disconnect"> + <refnamediv> + <refname>DB::disconnect()</refname> + <refpurpose>÷ÙÈÏÄÉÔ É ÏÔÓÏÅÄÉÎÑÅÔØÓÑ ÏÔ âä.</refpurpose> + </refnamediv> + + <refsect1 id="core.db.disconnect.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>boolean <function>disconnect</function></funcdef> + <paramdef></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$value</parameter> - ×ÏÚ×ÒÁÝÁÅÍÙÊ ÏÂßÅËÔ ÄÌÑ ÐÒÏ×ÅÒËÉ + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>boolean</parameter> - <parameter>true</parameter> ÅÓÌÉ + <parameter>$value</parameter> - ÏÛÉÂËÁ, + <parameter>false</parameter> ÅÓÌÉ ÎÅ ÏÐÒÅÄÅÌÅÎÁà, ËÁË ÏÛÉÂËÁ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.iswarning"> + <refnamediv> + <refname>DB::isWarning()</refname> + <refpurpose>çÏ×ÏÒÉÔ, Ñ×ÌÑÅÔØÓÑ ÌÉ ÒÅÚÕÌØÔÁÔ ÐÒÅÄÕÐÒÅÖÄÅÎÉÅÍ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.iswarning.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>boolean <function>isWarning</function></funcdef> + <paramdef>DB_Error <parameter>$value</parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ðÒÅÄÕÐÒÅÖÄÅÎÉÑ ÏÔÌÉÞÁÀÔØÓÑ ÏÔ ÏÛÉÂÏË, ÇÅÎÅÒÉÒÕÅÍÙÈ DB ÏÂßÅËÔÏÍ, + É ÎÅ ÆÁÔÁÌØÎÙ. + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>boolean</parameter> - <parameter>true</parameter> ÅÓÌÉ + <parameter>$value</parameter> ÂÙÌ <classname>DB_Error</classname> + ÏÂßÅËÔ ÍÁÒËÉÒÏ×ÁÎ ËÁË ÐÒÅÄÕÐÒÅÖÄÅÎÉÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.iserror"> + <refnamediv> + <refname>DB::isError()</refname> + <refpurpose>çÏ×ÏÒÉÔ, Ñ×ÌÑÅÔØÓÑ ÌÉ ÒÅÚÕÌØÔÁÔ ÏÛÉÂËÏÊ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.iserror.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>boolean <function>isError</function></funcdef> + <paramdef>DB_Error <parameter>$value</parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>boolean</parameter> - <parameter>true</parameter> ÅÓÌÉ + <parameter>$value</parameter> ÂÙÌ <classname>DB_Error</classname> + ÏÂßÅËÔÏÍ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.quote"> + <refnamediv> + <refname>DB::quote()</refname> + <refpurpose>ë×ÏÔÉÒÕÅÔ ËÁ×ÙÞËÁÍÉ ÓÔÒÏËÕ ÄÌÑ ÂÅÚÏÐÁÓÎÏÇÏ ÉÓÐÏÌØÚÏ×ÁÎÉÑ × +ÚÁÐÒÏÓÁÈ. </refpurpose> + </refnamediv> + <refsect1 id="core.db.quote.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>quote</function></funcdef> + <paramdef>string <parameter>$string</parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$string</parameter> - ×ÈÏÄÎÁÑ ÓÔÒÏËÁ ÄÌÑ Ë×ÏÔÉÒÏ×ÁÎÉÑ. + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - NULL, ÅÓÌÉ ÎÕÌÅ×ÁÑ ÓÔÒÏËÁ ÎÁ ×ÈÏÄÅ, + × ÐÒÏÔÉ×ÎÏÍ ÓÌÕÞÁÅ - Ë×ÏÔÉÒÏ×ÁÎÎÁÑ ÓÔÒÏËÁ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.provides"> + <refnamediv> + <refname>DB::provides()</refname> + <refpurpose>çÏ×ÏÒÉÔ, ËÁËÉÅ ÒÅÁÌÉÚÁÃÉÉ âä ÉÌÉ ÒÁÓÛÉÒÅÎÉÑ ÐÏÄÄÅÒÖÉ×ÁÀÔ + ÄÁÎÎÏÅ Ó×ÏÊÓÔ×Ï.</refpurpose> + </refnamediv> + <refsect1 id="core.db.provides.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>boolean <function>provides</function></funcdef> + <paramdef>string <parameter>$feature</parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$feature</parameter> - ÉÍÑ Ó×ÏÊÓÔ×Á (ÓÍ. ÄÏË. DB ËÌÁÓÓÁ) + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>boolean</parameter> - ÉÓÐÏÌØÚÕÅÔØÓÑ ÌÉ $feature ÄÁÎÎÏÊ + ÒÅÁÌÉÚÁÃÉÅÊ âä. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.setfetchmode"> + <refnamediv> + <refname>DB::setFetchMode()</refname> + <refpurpose>÷ÙÂÏÒ ÆÏÒÍÁÔÁ ×ÙÂÉÒÁÅÍÙÈ ÓÔÒÏË ÉÓÐÏÌØÚÕÅÍÙÊ ÐÏ ÕÍÏÌÞÁÎÉÀ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.setfetchmode.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>setFetchMode</function></funcdef> + <paramdef>integer <parameter>$fetchmode</parameter></paramdef> + <paramdef>string + <parameter><optional>$object_class</optional></parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$fetchmode</parameter> - + <parameter>DB_FETCHMODE_ORDERED</parameter>, + <parameter>DB_FETCHMODE_OBJECT</parameter> ÉÌÉ + <parameter>DB_FETCHMODE_ASSOC</parameter>, ×ÏÚÍÏÖÎÏ ÉÓÐÏÌØÚÏ×ÁÎÉÅ Ó ×ÙÒÁÖÅÎÉÅÍ OR Ó + <parameter>DB_FETCHMODE_FLIPPED</parameter>. óÍ. + <link linkend="core.db.tut_fetch">"Fetch"-ÓÅËÃÉÀ</link> + ÄÌÑ ÄÏÐÏÌÎÉÔÅÌØÎÏÊ ÉÎÆÏÒÍÁÃÉÉ. + </para> + </listitem> + <listitem> + <para> + <parameter>$object_class</parameter> - ëÌÁÓÓ, ÏÂßÅËÔ ËÏÔÏÒÏÇÏ ÂÕÄÅÔ ×ÏÚ×ÒÁÝÅÎ + ÍÅÔÏÄÏÍ fetch, ÐÒÉ ×ÙÂÏÒÅ ÐÁÒÁÍÅÔÒÁ + <parameter>DB_FETCHMODE_OBJECT</parameter>. + åÓÌÉ ÎÉËÁËÏÇÏ ËÌÁÓÓÁ ÎÅ ÚÁÄÁÎÏ, ÐÏ ÕÍÏÌÞÁÎÉÀ ÂÕÄÅÔ + ÐÒÉ×ÅÄÅÎÉÅ ÁÓÓÏÃÉÁÔÉ×ÎÏÇÏ ÍÁÓÓÉ×Á Ë ÏÂßÅËÔÕ. + üÔÏ ÔÁË ÖÅ ×ÏÚÍÏÖÎÏÓÔØ ÉÓÐÏÌØÚÏ×ÁÔØ É ÒÁÓÛÉÒÑÔØ ËÌÁÓÓ 'DB_Row'. + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - ÎÉÞÅÇÏ ÉÌÉ + <parameter>PEAR_ERROR</parameter>, + ÅÓÌÉ <parameter>$fetchmode</parameter> ÓÏÄÅÒÖÉÔ ÎÅÉÚ×ÅÓÔÎÏÅ ÚÎÁÞÅÎÉÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.prepare"> + <refnamediv> + <refname>DB::prepare()</refname> + <refpurpose>ðÏÄÇÏÔÁ×ÌÉ×ÁÅÔ ÚÁÐÒÏÓ ÄÌÑ ÍÎÏÖÅÓÔ×ÅÎÎÏÇÏ ×ÙÐÏÌÎÅÎÉÑ Ó ÐÏÍÏÛØÀ + execute(). </refpurpose> + </refnamediv> + <refsect1 id="core.db.prepare.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>resource <function>prepare</function></funcdef> + <paramdef>string <parameter>$query</parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>Prepare</function> ÔÒÅÂÕÅÔ ÏÓÎÏ×ÎÏÊ ÚÁÐÒÏÓ ËÁË ÓÔÒÏËÕ ×ÉÄÁ + "INSERT INTO numbers VALUES(?,?,?)". + ? - ÍÅÔËÉ-ÚÁÐÏÌÎÉÔÅÌÉ. ôÉÐÙ ÍÅÔÏË-ÚÁÐÏÌÎÉÔÅÌÅÊ: + <simplelist> + <member> + <parameter>?</parameter> - Ë×ÏÔÉÒÏ×ÁÎÎÏÅ ÓËÁÌÑÒÎÏÅ ÚÎÁÞÅÎÉÅ, Ô.Å. ÓÔÒÏËÉ, ÞÉÓÌÁ + </member> + <member> + <parameter>&</parameter> - ÔÒÅÂÕÅÔ ÉÍÑ ÆÁÊÌÁ, ÓÏÄÅÒÖÉÍÏÅ ÆÁÊÌÁ ÂÕÄÅÔ + ×ÎÅÓÅÎÏ × ÚÁÐÒÏÓ (Ô.Å. ÄÌÑ ÓÏÈÒÁÎÅÎÉÑ ÂÉÎÁÒÎÙÈ ÄÁÎÎÙÈ × âä). + </member> + <member> + <parameter>!</parameter> - ÚÎÁÞÅÎÉÅ ÂÕÄÅÔ ×ÎÅÓÅÎÏ 'ËÁË ÅÓÔØ' + </member> + </simplelist> + óÍ. <link linkend="core.db.tut_execute">"Execute"-ÓÅËÃÉÀ</link> + ÄÌÑ ÄÏÐ. ÉÎÆÏÒÍÁÃÉÉ. + </para> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$query</parameter> - ÚÁÐÒÏÓ ÄÌÑ ÐÏÄÇÏÔÏ×ËÉ + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>resource</parameter> - ÉÄÅÎÔÉÆÉËÁÔÏÒ ÚÁÐÒÏÓÁ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.execute"> + <refnamediv> + <refname>DB::execute()</refname> + <refpurpose>÷ÙÐÏÌÎÑÅÔ ÐÏÄÇÏÔÏ×ÌÅÎÎÙÊ SQL ÚÁÐÒÏÓ</refpurpose> + </refnamediv> + <refsect1 id="core.db.execute.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>execute</function></funcdef> + <paramdef>string <parameter>$stmt</parameter></paramdef> + <paramdef>array <parameter>$data</parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ó ÐÏÍÏÝØÀ Æ-ÃÉÉ <function>execute</function>, ÏÓÎÏ×ÎÏÊ ÐÏÄÇÏÔÏ×ÌÅÎÎÙÊ ÚÁÐÒÏÓ + ÂÕÄÅÔ ÓÏÐÏÓÔ×ÌÅÎ Ó ÄÁÎÎÙÍ $data ÍÁÓÓÉ×ÏÍ. + úÎÁÞÅÎÉÑ ÍÁÓÓÉ×Á ÂËÄÕÔ ×ÎÏÓÉÔØÓÑ × Ú×ÐÒÏÓ × ÔÁËÏÍ ÐÏÒÑÄËÅ, + × ËÏÔÏÒÏÍ ÏÎÉ ÎÁÈÏÄÑÔØÓÑ × ÍÁÓÓÉ×Å. + óÍ. <link linkend="core.db.tut_execute">"Execute"-ÓÅËÃÉÀ</link> + ÄÌÑ ÄÏÐ. ÉÎÆÏÒÍÁÃÉÉ. + </para> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$stmt</parameter> - ÉÄÅÎÔÉÆÉËÁÔÏÒ ÚÁÐÒÏÓÁ ÏÔ Æ-ÃÉÉ + <link linkend="core.db.prepare"><function>prepare</function> + </link> + </para> + </listitem> + <listitem> + <para> + <parameter>$data</parameter> - ÎÕÍÅÒÏ×ÁÎÙÊ ÍÁÓÓÉ×, ÓÏÄÅÒÖÁÝÉÊ ÄÁÎÎÙÅ + ÄÌÑ ÚÁÎÅÓÅÎÉÑ × Ú×ÐÒÏÓ. + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>resource</parameter> - ÏÂßÅËÔ ËÌÁÓÓÁ <classname>DB_Result</classname> + ÉÌÉ <classname>DB_Error</classname> ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.executemultiple"> + <refnamediv> + <refname>DB::executeMultiple()</refname> + <refpurpose>íÕÌØÔÉ×ÙÐÏÌÎÅÎÉÅ ÐÏÄÇÏÔÏ×ÌÅÎÎÏÇÏ SQL ÚÁÐÒÏÓÁ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.executemultiple.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>executeMultiple</function></funcdef> + <paramdef>string <parameter>$stmt</parameter></paramdef> + <paramdef>array <parameter>$data</parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + üÔÁ ÆÕÎËÃÉÑ ÄÅÌÁÅÔ ÍÎÏÖÅÓÔ×ÅÎÎÙÊ ×ÙÚÏ× Æ-ÃÉÉ <function>execute</function> + ÄÌÑ ÏÄÎÏÇÏ É ÔÏÇÏ ÖÅ ÉÄÅÎÔÉÆÉËÁÔÏÒÁ ÚÁÐÒÏÓÁ. + $data ÄÏÌÅÎ ÂÙÔØ ÍÁÓÓÉ×ÏÍ, ÎÕÍÅÒÏ×ÁÎÙÍ, ÉÎÄÅËÓÉÒÏ×ÁÎÎÙÍ Ó ÎÕÌÑ (0), + ïÄÉÎ ×ÙÚÏ× execute ÄÌÑ ËÁÖÄÏÊ ÓÔÒÏËÉ × ÍÁÓÓÉ×Å. + åÓÌÉ ÐÒÏÉÓÈÏÄÉÔ ÏÛÉÂËÁ × ÐÒÏÃÅÓÓÅ <function>execute</function>, + <function>executeMultiple</function> ÎÅ ÂÕÄÅÔ ×ÙÐÏÌÎÑÔØ ÏÓÔÁÌØÎÙÅ + ÚÁÐÒÏÓÙ, É ×ÅÒÎÅÔ ÏÛÉÂËÕ. + óÍ. <link linkend="core.db.tut_execute">"Execute"-section</link> + ÄÌÑ ÄÏÐ. ÉÎÆÏÒÍÁÃÉÉ. + </para> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$stmt</parameter> - ÉÄÅÎÔÉÆÉËÁÔÏÒ ÚÁÐÒÏÓÁ Æ-ÃÉÉ + <link linkend="core.db.prepare"><function>prepare</function> + </link> + </para> + </listitem> + <listitem> + <para> + <parameter>$data</parameter> - ÎÕÍÅÒÏ×ÁÎÙÊ ÍÁÓÓÉ×, ÓÏÄÅÒÖÁÝÉÊ ÄÁÎÎÙÅ + ÄÌÑ ×ÎÅÓÅÎÉÑ × ÚÁÐÒÏÓ. + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>resource</parameter> - ÏÂØÅËÔ ËÌÁÓÓÁ <classname>DB_Result</classname> + ÉÌÉ <classname>DB_Error</classname> ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.query"> + <refnamediv> + <refname>DB::query()</refname> + <refpurpose>ðÏÓÙÌÁÅÔ ÚÁÐÒÏÓ Ë ÂÁÚÅ ÄÁÎÎÙÈ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.query.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>&query</function></funcdef> + <paramdef>string <parameter>$query</parameter></paramdef> + <paramdef>array <parameter><optional>$params</optional></parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + óÍ. <link linkend="core.db.tut_query">"Query"-ÓÅËÃÉÀ</link> + ÄÌÑ ÄÏÐ. ÉÎÆÏÒÍÁÃÉÉ. + </para> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$query</parameter> - SQL ÚÁÐÒÏÓ</para> + </listitem> + <listitem> + <para> + <parameter>$params</parameter> - $params ÄÁÎÎÙÅ ÄÌÑ ÄÏÂÁ×ÌÅÎÉÑ Ë + ÚÁÐÒÏÓÕ. + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>resource</parameter> - ÏÂØÅËÔ ËÌÁÓÓÁ <classname>DB_Result</classname> + ÉÌÉ <classname>DB_Error</classname> ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.limitquery"> + <refnamediv> + <refname>DB::limitQuery()</refname> + <refpurpose>ÇÅÎÅÒÁÃÉÑ ÏÇÒÁÎÉÞÅÎÎÏÇÏ (ÌÉÍÉÔÉÒÏ×ÁÎÎÏÇÏ) ÚÁÐÒÏÓÁ + <emphasis>åëóðåòéíåîôáìøîï!</emphasis></refpurpose> + </refnamediv> + <refsect1 id="core.db.limitquery.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>&limitQuery</function></funcdef> + <paramdef>string <parameter>$query</parameter></paramdef> + <paramdef>integer <parameter>$from</parameter></paramdef> + <paramdef>integer <parameter>$count</parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$query</parameter> - SQL ÚÁÐÒÏÓ ÉÌÉ ×ÙÒÁÖÅÎÉÅ ÄÌÑ + ÐÏÄÇÏÔÏ×ËÉ. + </para> + </listitem> + <listitem> + <para> + <parameter>$from</parameter> - ÓÔÒÏËÁ Ó ËÏÔÏÒÏÊ ÎÁÞÉÎÁÔØ ×ÙÂÏÒËÕ + </para> + </listitem> + <listitem> + <para> + <parameter>$count</parameter> - ËÏÌÉÞÅÓÔ×Ï ÓÔÒÏË ÄÌÑ ×ÙÂÏÒËÉ + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>resource</parameter> - ÏÂßÅËÔ ËÌÁÓÓÁ <classname>DB_Result</classname> + ÉÌÉ <classname>DB_Error</classname> + ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.getone"> + <refnamediv> + <refname>DB::getOne()</refname> + <refpurpose>÷ÙÂÉÒÁÅÔ ÐÅÒ×ÙÊ ÓÔÏÌÂÅà ÐÅÒ×ÏÊ ÓÔÒÏËÉ ÉÚ ÚÁÐÒÏÓÁ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.getone.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>&getOne</function></funcdef> + <paramdef>string <parameter>$query</parameter></paramdef> + <paramdef>array + <parameter><optional>$params</optional></parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ÷ÙÂÉÒÁÅÔ ÐÅÒ×ÙÊ ÓÔÏÌÂÅà ÐÅÒ×ÏÊ ÓÔÒÏËÉ ÄÁÎÎÙÈ, ×ÏÚ×ÒÁÝÁÅÍÙÈ + ÉÚ ÚÁÐÒÏÓÁ. âÕÄØÔÅ ÏÓÔÏÒÏÖÎÙ ÐÒÉ ×ÙÐÏÌÎÅÎÉÉ ÚÁÐÒÏÓÁ É ÏÓ×ÏÂÏÖÄÁÊÔÅ + (free) ÒÅÓÕÒÓ ËÏÇÄÁ ÚÁËÏÎÞÉÔÅ. + </para> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$query</parameter> - SQL ÚÁÐÒÏÓ ÉÌÉ ×ÙÒÁÖÅÎÉÅ ÄÌÑ ÐÏÄÇÏÔÏ×ËÉ. + </para> + </listitem> + <listitem> + <para> + <parameter>$params</parameter> - ÅÓÌÉ ÐÒÉÓÕÄÓÔ×ÕÅÔ prepare/execute + ÂÕÄÅÔ ÉÓÐÏÌØÚÏ×ÁÎÏ Ó ÜÔÉÍ ÍÁÓÓÉ×ÏÍ ÐÒÉ ×ÙÐÏÌÎÅÎÉÉ ÐÁÒÁÍÅÔÒÏ×. + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - ×ÏÚ×ÒÁÝÅÎÏÅ ÚÎÁÞÅÎÉÅ + ÉÌÉ <classname>DB_Error</classname> ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.getrow"> + <refnamediv> + <refname>DB::getRow()</refname> + <refpurpose>÷ÙÂÉÒÁÅÔ ÐÅÒ×ÕÀ ÓÔÒÏËÕ ÉÚ ÚÁÐÒÏÓÁ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.getrow.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>&getRow</function></funcdef> + <paramdef>string <parameter>$query</parameter></paramdef> + <paramdef>array + <parameter><optional>$params</optional></parameter></paramdef> + <paramdef>integer + <parameter><optional>$fetchmode</optional></parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ÷ÙÂÉÒÁÅÔ ÐÅÒ×ÕÀ ÓÔÒÏËÕ ÄÁÎÎÙÈ, ×ÏÚ×ÒÁÝÅÎÎÙÈ ÉÚ ÚÁÐÒÏÓÁ. + âÕÄØÔÅ ÏÓÔÏÒÏÖÎÙ ÐÒÉ ×ÙÐÏÌÎÅÎÉÉ ÚÁÐÒÏÓÁ É ÏÓ×ÏÂÏÖÄÁÊÔÅ + (free) ÒÅÓÕÒÓ ËÏÇÄÁ ÚÁËÏÎÞÉÔÅ. + + </para> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$query</parameter> - SQL ÚÁÐÒÏÓ + </para> + </listitem> + <listitem> + <para> + <parameter>$params</parameter> - ÅÓÌÉ ÐÒÉÓÕÄÓÔ×ÕÅÔ prepare/execute + ÂÕÄÅÔ ÉÓÐÏÌØÚÏ×ÁÎÏ Ó ÜÔÉÍ ÍÁÓÓÉ×ÏÍ ÐÒÉ ×ÙÐÏÌÎÅÎÉÉ ÐÁÒÁÍÅÔÒÏ×. + </para> + </listitem> + <listitem> + <para> + <parameter>$fetchmode</parameter> - ÒÅÖÉÍ ×ÙÂÏÒËÉ, ÐÏ ÕÍÏÌÞÁÎÉÀ + - <parameter>DB_FETCHMODE_DEFAULT</parameter> + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - ÐÅÒ×ÕÀ ÓÔÒÏËÕ ÉÚ ÚÁÐÒÏÓÁ ËÁË ÍÁÓÓÉ×, + ÉÎÄÅËÓÉÒÕÅÍÙÊ Ó ÎÕÌÑ (0) + ÉÌÉ <classname>DB_Error</classname> ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.getcol"> + <refnamediv> + <refname>DB::getCol()</refname> + <refpurpose>÷ÙÂÉÒÁÅÔ ÅÄÉÎÉÞÎÙÊ ÓÔÏÌÂÅà ÉÚ ÚÁÐÒÏÓÁ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.getcol.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>&getCol</function></funcdef> + <paramdef>string <parameter>$query</parameter></paramdef> + <paramdef>mixed <parameter><optional>$col</optional></parameter></paramdef> + <paramdef>array + <parameter><optional>$params</optional></parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ÷ÙÂÉÒÁÅÔ ÅÄÉÎÉÞÎÙÊ ÓÔÏÌÂÅà ÉÚ ÍÎÏÖÅÓÔ×Á ÒÅÚÕÌØÔÁÔÏ× É ×ÏÚ×ÒÁÝÁÅÔ + ÉÎÄÅËÓÉÒÕÅÍÙÊ ÍÁÓÓÉ×. + </para> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$query</parameter> - SQL ÚÁÐÒÏÓ + </para> + </listitem> + <listitem> + <para> + <parameter>$col</parameter> - ËÁËÏÊ ÓÔÏÌÂÅà ×ÏÚ×ÒÁÝÁÔØ (integer [ÎÏÍÅÒ + ÓÔÏÌÂÃÁ, ÎÁÞÉÎÁÀÝÉÊÓÑ Ó 0] ÉÌÉ string [ÉÍÑ ÓÔÏÌÂÃÁ]), ÐÏ ÕÍÏÌÞÁÎÉÀ + <parameter>0</parameter> + </para> + </listitem> + <listitem> + <para> + <parameter>$params</parameter> - ÅÓÌÉ ÐÒÉÓÕÄÓÔ×ÕÅÔ prepare/execute + ÂÕÄÅÔ ÉÓÐÏÌØÚÏ×ÁÎÏ Ó ÜÔÉÍ ÍÁÓÓÉ×ÏÍ ÐÒÉ ×ÙÐÏÌÎÅÎÉÉ + ÐÁÒÁÍÅÔÒÏ×. + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - ÅÄÉÎÉÞÎÙÊ ÓÔÏÌÂÅà ÉÚ ÍÎÏÖÅÓÔ×Á + ÒÅÚÕÌØÔÁÔÏ× ËÁË ÍÁÓÓÉ×, ÉÎÄÅËÓÉÒÕÅÍÙÊ Ó 0 ÉÌÉ <classname>DB_Error</classname> ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.getassoc"> + <refnamediv> + <refname>DB::getAssoc()</refname> + <refpurpose> + ÷ÙÂÉÒÁÅÔ ÍÎÏÖÅÓÔ×Ï ÒÅÚÕÌØÔÁÔÏ× ËÁË ÁÓÓÏÃÉÁÔÉ×ÎÙÊ ÍÁÓÓÉ×, + ÉÓÐÏÌØÚÕÑ ÐÅÒ×ÙÊ ÓÔÏÌÂÅÃ, ËÁË ËÌÀÞ. + </refpurpose> + </refnamediv> + <refsect1 id="core.db.getassoc.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>array <function>&getAssoc</function></funcdef> + <paramdef>string <parameter>$query</parameter></paramdef> + <paramdef> + boolean + <parameter><optional>$force_array</optional></parameter></paramdef> + <paramdef> + array <parameter><optional>$params</optional></parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ÷ÙÂÉÒÁÅÔ ×ÓÅ ÍÎÏÖÅÓÔ×Ï ÒÅÚÕÌØÔÁÔÏ× ÚÁÐÒÏÓÁ É ×ÏÚ×ÒÁÝÁÅÔ + ÅÇÏ ËÁË ÁÓÓÏÃÉÁÔÉ×ÎÙÊ ÍÁÓÓÉ×, ÉÓÐÏÌØÚÕÑ ÐÅÒ×ÙÊ ÓÔÏÌÂÅÃ, ËÁË ËÌÀÞ. + + åÓÌÉ ÍÎÏÖÅÓÔ×Ï ÒÅÚÕÌØÔÁÔÁ ÓÏÄÅÒÖÉÔ ÂÏÌÅÅ Ä×ÕÈ ÓÔÏÌÂÃÏ×, + ÚÎÁÞÅÎÉÅ ÂÕÄÅÔ ÍÁÓÓÉ×ÏÍ ÚÎÁÞÅÎÉÊ ÏÔ ÓÔÏÌÂÃÁ 2. åÓÌÉ ÍÎÏÖÅÓÔ×Ï + ÒÅÚÕÌØÔÁÔÁ ÓÏÄÅÒÖÉÔ ÔÏÌØËÏ Ä×Á ÓÔÏÌÂÃÁ, ÔÏ ×ÏÚ×ÒÁÝÁÅÍÏÅ ÚÎÁÞÅÎÉÅ + ÂÕÄÅÔ ÓËÁÌÑÒÏÍ ÓÏ ÚÎÁÞÅÎÉÅÍ ×ÔÏÒÏÇÏ ÓÔÏÌÂÃÁ (× ÏÔÌÉÞÉÉ ÏÔ ÐÒÉÎÕÄÉÔÅÌØÎÏÇÏ + ÓÏÚÄÁÎÉÑ ÍÁÓÓÉ×Á ÐÒÉ ÐÏÍÏÝÉ ÐÁÒÁÍÅÔÒÁ $force_array). + DB error ËÏÄ ÂÕÄÅÔ ×ÏÚ×ÒÁÝÅÎ ÐÒÉ ÏÛÉÂËÅ. åÓÌÉ ÍÎÏÖÅÓÔ×Ï ÚÁÐÒÏÓÁ + ÓÏÄÅÒÖÉÔ ÍÅÎÅÅ Ä×ÕÈ ÓÔÏÌÂÃÏ×, ×ÏÚ×ÒÁÝÁÅÔØÓÑ ÐÁÒÁÍÅÔÒ-ÏÛÉÂËÁ - <parameter>DB_ERROR_TRUNCATED</parameter>. + + </para> + <para> + ðÒÉÍÅÒ ÉÓÐÏÌØÚÏ×ÁÎÉÑ: + <example> + <title>"mytable"</title> + <programlisting> + <![CDATA[ +ID TEXT DATE +---------------------- +1 'one' 944679408 +2 'two' 944679408 +3 'three' 944679408 + ]]> + </programlisting> + </example> + ëÏÇÄÁ ×ÙÚÙ×ÁÅÍ getAssoc('SELECT id,text FROM mytable') ×ÏÚ×ÒÁÔÉÔÓÑ: + <example> + <title>×ÏÚ×ÒÁÝÁÅÍÙÊ ÍÁÓÓÉ× - ×ÅÒÓÉÑ 1</title> + <programlisting> + <![CDATA[ +array( + '1' => 'one', + '2' => 'two', + '3' => 'three', + ) + ]]> + </programlisting> + </example> + ...× ÔÏ ×ÒÅÍÑ ËÁË ×ÙÚÏ× getAssoc('SELECT id,text,date FROM mytable') + ×ÏÚ×ÒÁÔÉÔ: + <example> + <title>×ÏÚ×ÒÁÝÁÅÍÙÊ ÍÁÓÓÉ× - ×ÅÒÓÉÑ 2</title> + <programlisting> + <![CDATA[ +array( + '1' => array('one', '944679408'), + '2' => array('two', '944679408'), + '3' => array('three', '944679408') + ) + ]]> + </programlisting> + </example> + </para> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$query</parameter> - the SQL query + </para> + </listitem> + <listitem> + <para> + <parameter>$force_array</parameter> - ÉÓÐÏÌØÚÕÅÔØÓÑ ÔÏÇÄÁ, ËÏÇÄÁ ÚÁÐÒÏÓ + ×ÏÚ×ÒÁÝÁÅÔ ÔÏÌØËÏ Ä×Á ÓÔÏÌÂÃÁ. åÓÌÉ true, ÚÎÁÞÅÎÉÑ ×ÏÚ×ÒÁÝÁÅÍÏÇÏ + ÍÁÓÓÉ×Á ÂÕÄÅÔ ÏÄÎÏ-ÜÌÅÍÅÎÔÎÙÊ ÍÁÓÓÉ× × ÏÔÌÉÞÉÉ ÏÔ ÓËÁÌÑÒÁ. + </para> + </listitem> + <listitem> + <para> + <parameter>$params</parameter> - ÅÓÌÉ ÐÒÉÓÕÄÓÔ×ÕÅÔ prepare/execute + ÂÕÄÅÔ ÉÓÐÏÌØÚÏ×ÁÎÏ Ó ÜÔÉÍ ÍÁÓÓÉ×ÏÍ ÐÒÉ ×ÙÐÏÌÎÅÎÉÉ + ÐÁÒÁÍÅÔÒÏ×. + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>array</parameter> - ÁÓÓÏÃÉÁÔÉ×ÎÙÊ ÍÁÓÓÉ× ËÏÔÏÒÙÊ + ×ÏÚ×ÒÁÝÁÅÔØÓÑ ÉÚ ÚÁÐÒÏÓÁ. + </para> + </listitem> + </itemizedlist> + </para> + <note> + <para> + ðÏÍÎÉÔÅ, ÞÔÏ ÆÕÎËÃÉÉ ÒÁÂÏÔÙ Ó âä × PHP ÏÂÙÞÎÏ ×ÏÚ×ÒÁÝÁÀÔ ÓÔÒÏËÏ×ÙÅ + ÚÎÁÞÅÎÉÑ ÄÌÑ ÒÅÚÕÌØÔÁÔÏ×, ×ÎÅ ÚÁ×ÉÓÉÍÏÓÔÉ ÏÔ ×ÎÕÔÒÅÎÎÉÈ ÔÉÐÏ× × âä. + </para> + </note> + </refsect1> + </refentry> + + <refentry id="core.db.getall"> + <refnamediv> + <refname>DB::getAll()</refname> + <refpurpose>÷ÙÂÉÒÁÅÔ ×ÓÅ ÓÔÒÏËÉ ÉÚ ÚÁÐÒÏÓÁ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.getall.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>&getAll</function></funcdef> + <paramdef>string <parameter>$query</parameter></paramdef> + <paramdef>array + <parameter><optional>$params</optional></parameter></paramdef> + <paramdef>integer + <parameter><optional>$fetchmode</optional></parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ðÁÒÁÍÅÔÒÙ + <itemizedlist> + <listitem> + <para> + <parameter>$query</parameter> - SQL ÚÁÐÒÏÓ + </para> + </listitem> + <listitem> + <para> + <parameter>$params</parameter> - ÅÓÌÉ ÐÒÉÓÕÄÓÔ×ÕÅÔ prepare/execute + ÂÕÄÅÔ ÉÓÐÏÌØÚÏ×ÁÎÏ Ó ÜÔÉÍ ÍÁÓÓÉ×ÏÍ ÐÒÉ ×ÙÐÏÌÎÅÎÉÉ + </para> + </listitem> + <listitem> + <para> + <parameter>$fetchmode</parameter> - ÒÅÖÉÍ ×ÙÂÏÒËÉ, ÐÏ ÕÍÏÌÞÁÎÉÀ: + <parameter>DB_FETCHMODE_DEFAULT</parameter> + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - ×ÌÏÖÅÎÎÙÊ ÍÁÓÓÉ× ÉÌÉ + <classname>DB_Error</classname> ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.affectedrows"> + <refnamediv> + <refname>DB::affectedRows()</refname> + <refpurpose>×ÏÚ×ÒÁÝÁÅÔ ËÏÌÉÞÅÓÔ×Ï ÉÚÍÅÎÅÎÎÙÈ ÓÔÒÏË ÚÁÐÒÏÓÏÍ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.affectedrows.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>affectedRows</function></funcdef> + <paramdef></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - ÞÉÓÌÏ ÓÔÒÏË ÉÌÉ + <classname>DB_Error</classname> ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.nextid"> + <refnamediv> + <refname>DB::nextId()</refname> + <refpurpose>×ÏÚ×ÒÁÝÁÅÔ ÓÌÅÄÕÀÝÅÅ Ó×ÏÂÏÄÎÏÅ éä ÐÏÓÌÅÄÏ×ÁÔÅÌØÎÏÓÔÉ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.nextid.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>nextId</function></funcdef> + <paramdef>string <parameter>$seq_name</parameter></paramdef> + <paramdef>boolean + <parameter><option>$on_demand</option></parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ðÁÒÁÍÅÔÒÙ + <itemizedlist> + <listitem> + <para> + <parameter>$seq_name</parameter> - ÉÍÑ ÐÏÓÌÅÄÏ×ÁÔÅÌØÎÏÓÔÉ. + </para> + </listitem> + <listitem> + <para> + <parameter>$ondemand</parameter> - ÅÓÌÉ true - ÐÏÓÌÅÄÏ×ÁÔÅÌØÎÏÓÔØ + ÂÕÄÅÔ Á×ÔÏÍÁÔÉÞÅÓËÉ ÓÏÚÄÁÎÁ, ÅÓÌÉ ÄÏ ÜÔÏÇÏ ÎÅ ÓÕÝÅÓÔ×Ï×ÁÌÁ. + ðÏ ÕÍÏÌÞÁÎÉÀ - <parameter>true</parameter>. + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - Ó×ÏÂÏÄÎÏÅ éä ÉÌÉ + <classname>DB_Error</classname> ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.createsequence"> + <refnamediv> + <refname>DB::createSequence()</refname> + <refpurpose>ÓÏÚÄÁÅÔ ÎÏ×ÕÀ ÐÏÓÌÅÄÏ×ÁÔÅÌØÎÏÓÔØ</refpurpose> + </refnamediv> + <refsect1 id="core.db.createsequence.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>createSequence</function></funcdef> + <paramdef>string <parameter>$seq_name</parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$seq_name</parameter> - ÉÍÑ ÐÏÓÌÅÄÏ×ÁÔÅÌØÎÏÓÔÉ. + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - ÒÅÚÕÌØÔÁÔ ÓÏÚÄÁÎÉÑ ÚÁÐÒÏÓÁ + ÉÌÉ <classname>DB_Error</classname> ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.dropsequence"> + <refnamediv> + <refname>DB::dropSequence()</refname> + <refpurpose>ÕÄÁÌÑÅÔ ÐÏÓÌÅÄÏ×ÁÔÅÌØÎÏÓÔØ</refpurpose> + </refnamediv> + <refsect1 id="core.db.dropsequence.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>dropSequence</function></funcdef> + <paramdef>string <parameter>$seq_name</parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$seq_name</parameter> - ÉÍÑ ÐÏÓÌÅÄÏ×ÁÔÅÌØÎÏÓÔÉ. + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - ÒÅÚÕÌØÔÁÔ ÕÄÁÌÅÎÉÑ ÐÏÓÌÅÄÏ×ÁÔÅÌØÎÏÓÔÉ + ÉÌÉ <classname>DB_Error</classname> ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.tableinfo"> + <refnamediv> + <refname>DB::tableInfo()</refname> + <refpurpose>×ÏÚ×ÒÁÝÁÅÔ ÍÅÔÁ-ÄÁÎÎÙÅ Ï ÒÅÚÕÌØÔÁÔÅ</refpurpose> + </refnamediv> + <refsect1 id="core.db.tableinfo.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>tableInfo</function></funcdef> + <paramdef>DB_Result <parameter>$result</parameter></paramdef> + <paramdef>mode + <parameter><optional>$mode</optional></parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$result</parameter> - ÏØßÅËÔ ÒÅÚÕÌØÔÁÔÁ ÄÌÑ ÁÎÁÌÉÚÁ. + </para> + </listitem> + <listitem> + <para> + <parameter>$mode</parameter> - ÚÁ×ÉÓÉÔ ÏÔ ÒÅÁÌÉÚÁÃÉÉ âä. + <itemizedlist> + <listitem> + <para> + FrontBase, MS-SQL, MySQL, PostgreSQL + <itemizedlist> + <listitem><para><parameter>false</parameter> (ÐÏ ÕÍÏÌÞÁÎÉÀ) + ×ÏÚ×ÒÁÝÁÅÔ ÔÁËÏÊ ÍÁÓÓÉ×: + <programlisting> + <![CDATA[ +[0]["table"] table name +[0]["name"] field name +[0]["type"] field type +[0]["len"] field length +[0]["flags"] field flags + ]]> + </programlisting> + </para> + </listitem> + <listitem><para><parameter>DB_TABLEINFO_ORDER</parameter> + ×ÏÚ×ÒÁÝÁÅÔ ÔÁËÏÊ ÍÁÓÓÉ×: + <programlisting> + <![CDATA[ +["num_fields"] number of metadata records +[0]["table"] table name +[0]["name"] field name +[0]["type"] field type +[0]["len"] field length +[0]["flags"] field flags +["order"][field name] index of field named "field name" + ]]> + </programlisting> + ðÏÓÌÅÄÎÉÊ ÉÓÐÏÌØÚÕÔØÓÑ ÅÓÌÉ ×Ù ÉÍÅÅÔÅ ÉÍÅÎÁ ÐÏÌÅÊ, Á ÎÅ ÉÎÄÅËÓÙ. + ôÅÓÔ: if (isset($result['meta']['myfield'])) { ... + </para> + </listitem> + <listitem><para><parameter>DB_TABLEINFO_ORDERTABLE</parameter> + ×ÏÚ×ÒÁÝÁÅÔ × ÏÓÎÏ×ÎÏÍ ÔÏ ÖÅ ÓÁÍÏÅe. îÏ Ó ÄÏÐÏÌÎÅÎÉÅÍ: + <programlisting> + <![CDATA[ +["ordertable"][table name][field name] index of field named "field name" + ]]> + </programlisting> + üÔÏ ÓÄÅÌÁÎÏ ÐÏÔÏÍÕ, ÞÔÏ ÅÓÌÉ ×Ù ÉÍÅÅÔÅ ÐÏÌÑ ÉÚ ÒÁÚÎÙÈ ÔÁÂÌÉà + Ó ÏÄÉÎÁËÏ×ÙÍÉ ÉÍÅÎÁÍÉ, ÏÎÉ ÚÁÍÅÝÁÀÔ ËÁÖÄÙÊ ÓÌÅÄÕÀÝÉÊ Ó ÐÁÒÁÍÅÔÒÏÍ + <parameter>DB_TABLEINFO_ORDER</parameter>. + </para> + </listitem> + </itemizedlist> + </para> + </listitem> + <listitem> + <para> + InterBase, Informix, mSQL, Oracle8, ODBC, Sybase - îÅÔ ÉÎÆÏÒÍÁÃÉÉ. + </para> + </listitem> + </itemizedlist> + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - ÒÅÚÕÌØÔÁÔ ÉÓÓÌÅÄÕÅÍÏÇÏ ÚÁÐÒÏÓÁ ÉÌÉ + <classname>DB_Error</classname> ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.getlistof"> + <refnamediv> + <refname>DB::getListOf()</refname> + <refpurpose>ÓÐÉÓÏË ×ÎÕÔÒÅÎÎÅÊ ÉÎÆÏÒÍÁÃÉÉ Ï âä.</refpurpose> + </refnamediv> + <refsect1 id="core.db.getlistof.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>getListOf</function></funcdef> + <paramdef>string <parameter>$type</parameter></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$type</parameter> - ÔÉÐ ÚÁÐÒÁÛÉ×ÁÅÍÙÈ ÐÁÒÁÍÅÔÒÏ×, + ËÏÒÒÅËÔÎÙÅ ÚÎÁÞÅÎÉÑ ÄÌÑ $type ÚÁ×ÉÓÑÔ ÏÔ âä: + <parameter>"databases"</parameter>, <parameter>"users"</parameter>, + <parameter>"view"</parameter>, <parameter>"functions"</parameter> + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - ÚÁÐÒÁÛÉ×ÁÅÍÙÅ ÄÁÎÎÙÅ ÉÌÉ + <classname>DB_Error</classname> ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.dbresult"> + <refnamediv> + <refname>DB_Result</refname> + <refpurpose>ÓÏÄÅÒÖÉÔ ÒÅÚÕÌØÔÁÔ ×ÙÐÏÌÎÅÎÉÑ ÚÁÐÒÏÓÁ Ë âä.</refpurpose> + </refnamediv> + <refsect1 id="core.db.tut_dbresult.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <para> + óÓÙÌËÁ ÎÁ ÜËÚÅÍÐÌÑÒ ÏÂßÅËÔÁ <classname>DB_Result</classname>, ËÏÔÏÒÙÊ + ×ÏÚ×ÒÁÝÁÅÔØÓÑ ÆÕÎËÃÉÑÍÉ, ÔÁËÉÍÉ ËÁË <link linkend="core.db.query"> + <function>query</function></link> ÉÌÉ <link linkend="core.db.execute"> + <function>execute</function></link>. + ïÂØÅËÔ <classname>DB_Result</classname> ÐÒÅÄÌÁÇÁÅÔ ÒÁÚÌÉÞÎÙÅ ÆÕÎËÃÉÉ ÄÌÑ + ÄÏÓÔÕÐÁ Ë ÒÅÚÕÌØÔÁÔÕ SQLÚÁÐÒÏÓÁ Ë âä. + </para> + </refsect1> + </refentry> + + <refentry id="core.db.fetchrow"> + <refnamediv> + <refname>DB_Result::fetchRow()</refname> + <refpurpose>÷ÙÂÉÒÁÅÔ É ×ÏÚ×ÒÁÝÁÅÔ ÓÔÒÏËÕ ÄÁÎÎÙÈ</refpurpose> + </refnamediv> + <refsect1 id="core.db.fetchrow.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>fetchRow</function></funcdef> + <paramdef>integer + <parameter><optional>$fetchmode</optional></parameter> + </paramdef> + <paramdef>integer + <parameter><optional>$rownum</optional></parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$fetchmode</parameter> - ÆÏÒÍÁÔ ×ÙÂÉÒÁÅÍÙÈ ÓÔÒÏË. ðÏ ÕÍÏÌÞÁÎÉÀ - + <parameter>DB_FETCHMODE_DEFAULT</parameter>. óÍ. <link + linkend="core.db.tut_fetch">"Fetch" ÒÁÚÄÅÌ</link> ÄÌÑ ÂÏÌÅÅ ÄÅÔÁÌØÎÏÊ + ÉÎÆÏÒÍÁÃÉÉ. + </para> + <para> + <parameter>$rownum</parameter> - ÎÏÍÅÒ ÓÔÒÏËÉ ÄÌÑ ×ÙÂÏÒËÉ. ðÏ + ÕÍÏÌÞÁÎÉÀ - <parameter>null</parameter>. + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - ÍÁÓÓÉ× ÓÔÒÏËÉ ÄÁÎÎÙÈ, NULL ÅÓÌÉ ÎÅ + ÏÓÔÁÌÏÓØ ÂÏÌØÛÅ ÓÔÒÏË ÉÌÉ DB_Error ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.fetchinto"> + <refnamediv> + <refname>DB_Result::fetchInto()</refname> + <refpurpose>÷ÙÂÉÒÁÅÔ ÓÔÒÏËÕ ÄÁÎÎÙÈ × ÐÒÉÓÕÄÓÔ×ÕÀÝÕÀ ÐÅÒÅÍÅÎÎÕÀ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.fetchinto.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>fetchInto</function></funcdef> + <paramdef>mixed + <parameter>$arr</parameter> + </paramdef> + <paramdef>integer + <parameter><optional>$fetchmode</optional></parameter> + </paramdef> + <paramdef>integer + <parameter><optional>$rownum</optional></parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + óÍ. <link linkend="core.db.tut_fetch">"Fetch" ÓÅËÃÉÀ</link> ÄÌÑ ÂÏÌÅÅ + ÄÅÔÁÌØÎÏÊ ÉÎÆÏÒÍÁÃÉÉ. + </para> + <para> + ðÁÒÁÍÅÔÒ + <itemizedlist> + <listitem> + <para> + <parameter>$arr</parameter> - ÓÓÙÌËÁ ÎÁ ÄÁÎÎÙÅ, ÓÏÄÅÒÖÁÝÉÅÓÑ × ÓÔÒÏËÅ. + </para> + <para> + <parameter>$fetchmode</parameter> - ÆÏÒÍÁÔ ×ÙÂÏÒËÉ ÓÔÒÏË. ðÏ ÕÍÏÌÞÁÎÉÀ + - <parameter>DB_FETCHMODE_DEFAULT</parameter>. + </para> + <para> + <parameter>$rownum</parameter> - ÎÏÍÅÒ ÓÔÒÏËÉ ÄÌÑ ×ÙÂÏÒËÉ. ðÏ + ÕÍÏÌÞÁÎÉÀ - <parameter>null</parameter>. + </para> + </listitem> + </itemizedlist> + </para> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - DB_OK ÐÒÉ ÕÄÁÞÅ, NULL, ÅÓÌÉ + ÎÅÔ ÂÏÌØÛÅ ÓÔÒÏË ÉÌÉ DB_Error ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.numcols"> + <refnamediv> + <refname>DB_Result::numCols()</refname> + <refpurpose>÷ÏÚ×ÒÁÝÁÅÔ ËÏÌÌÉÞÅÓÔ×Ï ÓÔÏÌÂÃÏ× × ÒÅÚÕÌØÔÁÔÅ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.numcols.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>integer <function>numCols</function></funcdef> + <paramdef></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>integer</parameter> - ËÏÌÌÉÞÅÓÔ×Ï ÓÔÏÌÂÃÏ× ÉÌÉ DB_Error + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.numrows"> + <refnamediv> + <refname>DB_Result::numRows()</refname> + <refpurpose>÷ÏÚ×ÒÁÝÁÅÔ ËÏÌÌÉÞÅÓÔ×Ï ÓÔÒÏË × ÒÅÚÕÌØÔÁÔÅ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.numrows.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>integer <function>numRows</function></funcdef> + <paramdef></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>integer</parameter> - ËÏÌÌÉÞÅÓÔ×Ï ÓÔÒÏË ÉÌÉ DB_Error + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.nextresult"> + <refnamediv> + <refname>DB_Result::nextResult()</refname> + <refpurpose>÷ÏÚ×ÒÁÝÁÅÔ ÓÌÅÄÕÀÝÉÊ ÒÅÚÕÌØÔÁÔ, ÅÓÌÉ ÂÙÌ ×ÙÐÏÌÎÅÎ + ÐÁËÅÔ ÚÁÐÒÏÓÏ×</refpurpose> + </refnamediv> + <refsect1 id="core.db.nextresult.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>boolean <function>nextResult</function></funcdef> + <paramdef></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>boolean</parameter> - true ÅÓÌÉ ÎÏ×ÙÊ ÒÅÚÕÌØÔÁÔ ÐÒÉÓÕÄÓÔ×ÕÅÔ, É false - ÅÓÌÉ ÎÅÔ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.free"> + <refnamediv> + <refname>DB_Result::free()</refname> + <refpurpose>ïÓ×ÏÂÏÖÄÁÅÔ ÒÅÓÕÒÓÙ ×ÙÄÅÌÅÎÎÙÅ ÐÏÄ ÒÅÚÕÌØÔÁÔ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.free.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>free</function></funcdef> + <paramdef></paramdef> + </funcprototype> + </funcsynopsis> + <para> + ÷ÏÚ×ÒÁÝÁÅÔ + <itemizedlist> + <listitem> + <para> + <parameter>mixed</parameter> - true ÐÒÉ ÕÄÁÞÅ ÉÌÉ DB_Error ÐÒÉ ÏÛÉÂËÅ. + </para> + </listitem> + </itemizedlist> + </para> + </refsect1> + </refentry> + + <refentry id="core.db.dberror"> + <refnamediv> + <refname>DB_Error</refname> + <refpurpose>ëÌÁÓÓ ÄÌÑ ÓÏÏÂÝÅÎÉÑ ÐÏÒÔÁÔÉ×ÎÙÈ ÓÏÏÂÝÅÎÉÊ Ï ÏÛÉÂËÅ âä.</refpurpose> + </refnamediv> + <refsect1 id="core.db.dberror.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <para> + ÷ ÓÌÕÞÁÅ ÎÅÕÄÁÞÉ, ÍÎÏÇÉÅ ÆÕÎËÃÉÉ ËÌÁÓÓÁ <classname>PEAR::DB</classname> ×ÏÚ×ÒÁÝÁÀÔ + ÏÂßÅËÔ ËÌÁÓÓÁ <classname>DB_Error</classname>. ïÂßÅËÔ ÓÏÄÅÒÖÉÔ ÉÎÆÏÒÍÁÃÉÀ Ï ÐÒÏÉÚÛÅÄÛÅÊ ÏÛÉÂËÅ. + <classname>DB_Error</classname> ÉÍÅÅÔ ÔÅ ÖÅ ÆÕÎËÃÉÉ, ÞÔÏ É + <classname>PEAR_Error</classname>. + </para> + </refsect1> + </refentry> + + <refentry id="core.db.dbwarning"> + <refnamediv> + <refname>DB_Warning</refname> + <refpurpose>ëÌÁÓÓ ÄÌÑ ÓÏÏÂÝÅÎÉÑ ÐÏÒÔÁÔÉ×ÎÙÈ ÐÒÅÄÕÐÒÅÄÉÔÅÌØÎÙÈ ÓÏÏÂÝÅÎÉÊ.</refpurpose> + </refnamediv> + <refsect1 id="core.db.dbwarning.desc"> + <title>ïÐÉÓÁÎÉÅ</title> + <para> + <classname>PEAR::DB</classname> ÆÕÎËÃÉÑ ÍÏÖÅÔ ×ÏÚ×ÒÁÝÁÔØ + <classname>DB_Warning</classname>. + ïÂßÅËÔ ÓÏÄÅÒÖÉÔ ÉÎÆÏÒÍÁÃÉÀ Ï ÐÒÏÉÚÛÅÄÛÅÍ ÐÒÅÄÕÐÒÅÖÄÅÎÉÉ. + <classname>DB_Warning</classname> ÉÍÅÅÔ ÔÅ ÖÅ ÆÕÎËÃÉÉ, ÞÔÏ É + <classname>PEAR_Error</classname>. + </para> + </refsect1> + </refentry> + + </reference> <!-- Keep this comment at the end of the file Local variables: