cvs: phpdoc-he /reference/sqlite/functions sqlite-array-query.xml sqlite-column.xml sqlite-libencoding.xml sqlite-libversion.xml sqlite-udf-decode-binary.xml sqlite-udf-encode-binary.xml

[email protected] ("Noam Giladi") Thu, 31 Jul 2003 04:14:56 -0000
Newsgroups php.doc.he
Message-ID <cvsnoam1059624896@cvsserver>
noam		Thu Jul 31 00:14:56 2003 EDT

  Modified files:              
    /phpdoc-he/reference/sqlite/functions	sqlite-array-query.xml 
                                         	sqlite-column.xml 
                                         	sqlite-libencoding.xml 
                                         	sqlite-libversion.xml 
                                         	sqlite-udf-decode-binary.xml 
                                         	sqlite-udf-encode-binary.xml 
  Log:
  end of sqlite
noam-20030731001456.txt (text/plain, 19 KB)
Index: phpdoc-he/reference/sqlite/functions/sqlite-array-query.xml
diff -u phpdoc-he/reference/sqlite/functions/sqlite-array-query.xml:1.2 phpdoc-he/reference/sqlite/functions/sqlite-array-query.xml:1.3
--- phpdoc-he/reference/sqlite/functions/sqlite-array-query.xml:1.2	Mon Jul 28 07:30:58 2003
+++ phpdoc-he/reference/sqlite/functions/sqlite-array-query.xml	Thu Jul 31 00:14:56 2003
@@ -1,31 +1,38 @@
-<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.2 $ -->
+<?xml version="1.0" encoding="window-1255"?>
 <refentry id="function.sqlite-array-query">
- <refnamediv>
-  <refname>sqlite_array_query</refname>
-  <refpurpose>Execute a query against a given database and returns an array.</refpurpose>
- </refnamediv>
- <refsect1>
-  <title>Description</title>
-  <methodsynopsis>
-   <type>array</type><methodname>sqlite_array_query</methodname>
-   <methodparam><type>resource</type><parameter>dbhandle</parameter></methodparam>
-   <methodparam><type>string</type><parameter>query</parameter></methodparam>
-   <methodparam choice="opt"><type>int</type><parameter>result_type</parameter></methodparam>
-   <methodparam choice="opt"><type>bool</type><parameter>decode_binary</parameter></methodparam>
-  </methodsynopsis>
-  <para>
-   <function>sqlite_array_query</function> is similar to calling
-   <function>sqlite_query</function> and then
-   <function>sqlite_fetch_array</function> for each row of the result set
-   and storing it into an array, as shown in the example below.  Calling
-   <function>sqlite_array_query</function> is significantly faster than
-   using such a script.
-  </para>
-  <example>
-   <title><function>sqlite_array_query</function> implemented yourself</title>
-   <programlisting role="php">
-<![CDATA[
+	<refnamediv>
+		<refname>sqlite_array_query</refname>
+		<refpurpose>äôåð÷öéä îáöòú ùàéìúä îåì îñã ðúåðéí ðúåï, åîçæéøä  îòøê.</refpurpose>
+	</refnamediv>
+	<refsect1>
+		<title>úéàåø</title>
+		<methodsynopsis>
+			<type>array</type>
+			<methodname>sqlite_array_query</methodname>
+			<methodparam>
+				<type>resource</type>
+				<parameter>dbhandle</parameter>
+			</methodparam>
+			<methodparam>
+				<type>string</type>
+				<parameter>query</parameter>
+			</methodparam>
+			<methodparam choice="opt">
+				<type>int</type>
+				<parameter>result_type</parameter>
+			</methodparam>
+			<methodparam choice="opt">
+				<type>bool</type>
+				<parameter>decode_binary</parameter>
+			</methodparam>
+		</methodsynopsis>
+		<para>
+			<function>sqlite_array_query</function>ãåîä ì÷øàéä ìôåð÷öéä<function>sqlite_query</function>åàæ ìôåð÷öéä<function>sqlite_fetch_array</function>ìëì ùåøä îùåøåú äúåöàä, åàéçñåï äúùåáåú áúåê îòøê áãåâîä ìãåâîä ìîèä.÷øéàä ìôåð÷öéä
+   <function>sqlite_array_query</function>îäéøä áöåøä îùîòåúéú îùéîåù áùéèä äð"ì.</para>
+		<example>
+			<title>
+				<function>sqlite_array_query</function>î÷áéìä ì-</title>
+			<programlisting role="php"><![CDATA[
 <?php
 $q = sqlite_query($dbhandle, "SELECT * from foo LIMIT 100");
 $rows = array();
@@ -33,24 +40,18 @@
     $rows[] = $r;
 }
 ?>
-]]>
-   </programlisting>
-  </example>
-  <tip>
-   <para>
-    <function>sqlite_array_query</function> is best suited to queries
-    returning 45 rows or less.  If you have more data than that, it is
-    recommended that you write your scripts to use
-    <function>sqlite_unbuffered_query</function> instead for more optimal
-    performance.
+]]></programlisting>
+		</example>
+		<tip>
+			<para>
+				<function>sqlite_array_query</function>îúàéîä áîéåçã ìùàéìúåú ùîçæéøåú òã 45 ùåøåú, ìùàéìåúåú ùîçæéøåú éåúø ðúåðéí îåîåìõ ìëúåá ñ÷øéôè ñôöéôé ìùéôåø áéöåòéí, úåê ëãé ùéîåù á- 
+    <function>sqlite_unbuffered_query</function>.
    </para>
-  </tip>
-  <para>
-   See also <function>sqlite_query</function>,
-   <function>sqlite_fetch_array</function>, and 
-   <function>sqlite_fetch_string</function>.
+		</tip>
+		<para>øàä âí<function>sqlite_query</function>,
+   <function>sqlite_fetch_array</function>å<function>sqlite_fetch_string</function>.
   </para>
- </refsect1>
+	</refsect1>
 </refentry>
 <!-- Keep this comment at the end of the file
  Local variables:
Index: phpdoc-he/reference/sqlite/functions/sqlite-column.xml
diff -u phpdoc-he/reference/sqlite/functions/sqlite-column.xml:1.2 phpdoc-he/reference/sqlite/functions/sqlite-column.xml:1.3
--- phpdoc-he/reference/sqlite/functions/sqlite-column.xml:1.2	Mon Jul 28 07:30:58 2003
+++ phpdoc-he/reference/sqlite/functions/sqlite-column.xml	Thu Jul 31 00:14:56 2003
@@ -1,30 +1,39 @@
 <?xml version="1.0" encoding="WINDOWS-1255"?>
-<!-- $Revision: 1.2 $ -->
 <refentry id="function.sqlite-column">
-<refnamediv>
- <refname>sqlite_column</refname>
- <refpurpose>Fetches a column from the current row of a result set.</refpurpose>
-</refnamediv>
- <refsect1>
-  <title>úéàåø</title> 
-  <methodsynopsis>
-   <type>mixed</type><methodname>sqlite_column</methodname>
-   <methodparam><type>resource</type><parameter>result</parameter></methodparam>
-   <methodparam><type>mixed</type><parameter>index_or_name</parameter></methodparam>
-   <methodparam choice="opt"><type>bool</type><parameter>decode_binary</parameter></methodparam>
-  </methodsynopsis>
-  <para>
+	<refnamediv>
+		<refname>sqlite_column</refname>
+		<refpurpose>äôåð÷öéä îçæéøä òîåãä îñåéîú, îäùåøä äòëùåéú, áðúåðéí.</refpurpose>
+	</refnamediv>
+	<refsect1>
+		<title>úéàåø</title>
+		<methodsynopsis>
+			<type>mixed</type>
+			<methodname>sqlite_column</methodname>
+			<methodparam>
+				<type>resource</type>
+				<parameter>result</parameter>
+			</methodparam>
+			<methodparam>
+				<type>mixed</type>
+				<parameter>index_or_name</parameter>
+			</methodparam>
+			<methodparam choice="opt">
+				<type>bool</type>
+				<parameter>decode_binary</parameter>
+			</methodparam>
+		</methodsynopsis>
+		<para>
 îáéàä àú ùí äòîåãä <parameter>index_or_name</parameter> àå àú äîñôø äñéãåøé ùìä îäùåøä äðåëçéú ùì èáìú äúåöàåú.
 äãâì äáðàøé îúô÷ã áàåúä öåøä ëîå áôåð÷öéä  
 <function>sqlite_fetch_array</function>.
   </para>
-  <para>
+		<para>
 äùúîù áôåð÷öéä àí àúä î÷áì úåöàåú òí äøáä òîåãåú, àå áî÷øä åéù ìê òîåãåú òí äøáä ðåúðéí áëì òîåãä.
   </para>
-  <para>
+		<para>
    øàä âí <function>sqlite_fetch_string</function>.
   </para>
- </refsect1>
+	</refsect1>
 </refentry>
 <!-- Keep this comment at the end of the file
  Local variables:
Index: phpdoc-he/reference/sqlite/functions/sqlite-libencoding.xml
diff -u phpdoc-he/reference/sqlite/functions/sqlite-libencoding.xml:1.2 phpdoc-he/reference/sqlite/functions/sqlite-libencoding.xml:1.3
--- phpdoc-he/reference/sqlite/functions/sqlite-libencoding.xml:1.2	Mon Jul 28 07:30:58 2003
+++ phpdoc-he/reference/sqlite/functions/sqlite-libencoding.xml	Thu Jul 31 00:14:56 2003
@@ -1,9 +1,8 @@
 <?xml version="1.0" encoding="WINDOWS-1255"?>
-<!-- $Revision: 1.2 $ -->
 <refentry id="function.sqlite-libencoding">
 	<refnamediv>
 		<refname>sqlite_libencoding</refname>
-		<refpurpose>Returns the encoding of the linked SQLite library.</refpurpose>
+		<refpurpose> äôå÷öéä îçæéøä àú ä÷éãåã , ùì ñôøééú SQLite, äî÷åùøú.</refpurpose>
 	</refnamediv>
 	<refsect1>
 		<title>_____</title>
@@ -12,37 +11,20 @@
 			<methodname>sqlite_libencoding</methodname>
 			<void/>
 		</methodsynopsis>
-		<para>
-   The SQLite library may be compiled in either ISO-8859-1 or UTF-8
-   compatible modes.  This function allows you to determine which encoding
-   scheme is used by your version of the library.
-  </para>
+		<para>àôùø ì÷îôì àú ñôøééú ä SQLITE áùðé ÷éãåãéí ùåðéí ,
+ISO-8859-1 àå UTF-8.
+  äôåð÷öéä îçæéøä àú ä÷éãåã ùáå ÷åããä äñôøééä.</para>
 		<warning>
-			<para>
-    The default PHP distribution builds libsqlite in ISO-8859-1 encoding
-    mode.  However, this is a misnomer; rather than handling ISO-8859-1, it
-    operates according to your current locale settings for string
-    comparisons and sort ordering.  So, rather than ISO-8859-1, you should
-    think of it as being '8-bit' instead.
+			<para>÷éãåã áøéøú äîçãì ùì PHP äåà ISO-8859-1 .  àáì  áîöéàåú äîòøëú ôåòìú ò"ô ä÷éãåã äî÷åîé ùìä áòðééï îçøåæåú åîéåðéí. ëê ùòãéó ìäúééçñ ìîòøëú ôùåè  ëîòøëú îáåññú  '8-bit' .
    </para>
 		</warning>
-		<para>
-   When compiled with UTF-8 support, sqlite handles encoding and decoding
-   of UTF-8 multi-byte character sequences, but does not yet do a complete
-   job when working with the data (no normalization is performed for
-   example), and some comparison operations may still not be carried out
-   correctly.
-  </para>
+		<para>âí á÷éîôåì ìúîéëä á÷éãåã UTF-8, éúëðå áòéåú áëì îéðé àåôøöéåú ùì äùååàä.</para>
 		<warning>
-			<para>
-    It is not recommended that you use PHP in a web-server configuration
-    with a version of the SQLite library compiled with UTF-8 support, since
-    libsqlite will abort the process if it detects a problem with the
-    UTF-8 encoding.
+			<para>ìà îîåìõ ìäùúîù  PHP áúöåøú ùøú òí sqlite î÷åôì á÷éãåã UTF-8, áâìì ùëì áòéä ùúöåõ áâìì ä÷éãåã, úâøåí ìòöéøú äúäìéê ùøõ ò"é
+     libsqlite .
    </para>
 		</warning>
-		<para>
-   See also <function>sqlite_libversion</function>.
+		<para>øàä âí<function>sqlite_libversion</function>.
   </para>
 	</refsect1>
 </refentry>
Index: phpdoc-he/reference/sqlite/functions/sqlite-libversion.xml
diff -u phpdoc-he/reference/sqlite/functions/sqlite-libversion.xml:1.1 phpdoc-he/reference/sqlite/functions/sqlite-libversion.xml:1.2
--- phpdoc-he/reference/sqlite/functions/sqlite-libversion.xml:1.1	Mon Jul 28 05:40:20 2003
+++ phpdoc-he/reference/sqlite/functions/sqlite-libversion.xml	Thu Jul 31 00:14:56 2003
@@ -1,23 +1,23 @@
 <?xml version="1.0" encoding="WINDOWS-1255"?>
-<!-- $Revision: 1.1 $ -->
 <refentry id="function.sqlite-libversion">
- <refnamediv>
-  <refname>sqlite_libversion</refname>
-  <refpurpose>Returns the version of the linked SQLite library.</refpurpose>
- </refnamediv>
- <refsect1>
-  <title>úéàåø</title> 
-  <methodsynopsis>
-   <type>string</type><methodname>sqlite_libversion</methodname>
-   <void/>
-  </methodsynopsis>
-  <para>
-   Returns the version of the linked SQLite library as a string.
+	<refnamediv>
+		<refname>sqlite_libversion</refname>
+		<refpurpose>äôåð÷öéä îçæéøä, àú äâéøñä, ùì ñôøééú sqlite äî÷åùøú</refpurpose>
+	</refnamediv>
+	<refsect1>
+		<title>úéàåø</title>
+		<methodsynopsis>
+			<type>string</type>
+			<methodname>sqlite_libversion</methodname>
+			<void/>
+		</methodsynopsis>
+		<para>
+		äôåð÷öéä îçæéøä àú äâéøñä ùì ñôøééú  áúåø îçøåæúSQLITE
   </para>
-  <para>
-   See also <function>sqlite_libencoding</function>.
+		<para>
+  øàä âí <function>sqlite_libencoding</function>.
   </para>
- </refsect1>
+	</refsect1>
 </refentry>
 <!-- Keep this comment at the end of the file
  Local variables:
Index: phpdoc-he/reference/sqlite/functions/sqlite-udf-decode-binary.xml
diff -u phpdoc-he/reference/sqlite/functions/sqlite-udf-decode-binary.xml:1.1 phpdoc-he/reference/sqlite/functions/sqlite-udf-decode-binary.xml:1.2
--- phpdoc-he/reference/sqlite/functions/sqlite-udf-decode-binary.xml:1.1	Mon Jul 28 05:40:20 2003
+++ phpdoc-he/reference/sqlite/functions/sqlite-udf-decode-binary.xml	Thu Jul 31 00:14:56 2003
@@ -1,36 +1,30 @@
 <?xml version="1.0" encoding="WINDOWS-1255"?>
-<!-- $Revision: 1.1 $ -->
+<!-- $Revision: 1.2 $ -->
 <refentry id="function.sqlite-udf-decode-binary">
- <refnamediv>
-  <refname>sqlite_udf_decode_binary</refname>
-  <refpurpose>Decode binary data passed as parameters to an UDF.</refpurpose>
- </refnamediv>
- <refsect1>
-  <title>úéàåø</title>
-  <methodsynopsis>
-   <type>string</type><methodname>sqlite_udf_decode_binary</methodname>
-   <methodparam><type>string</type><parameter>data</parameter></methodparam>
-  </methodsynopsis>
-  <para>
-   <function>sqlite_udf_decode_binary</function> decodes the binary encoding
-   that was applied to the parameter by either
-   <function>sqlite_udf_encode_binary</function> or
-   <function>sqlite_escape_string</function>.
+	<refnamediv>
+		<refname>sqlite_udf_decode_binary</refname>
+		<refpurpose>äôåð÷öéä îôòðçú ðúåðéí áéðàøééí, ùîåòáøéí ìôåð÷öéåú îùúîù àéùéåú UDF.</refpurpose>
+	</refnamediv>
+	<refsect1>
+		<title>úéàåø</title>
+		<methodsynopsis>
+			<type>string</type>
+			<methodname>sqlite_udf_decode_binary</methodname>
+			<methodparam>
+				<type>string</type>
+				<parameter>data</parameter>
+			</methodparam>
+		</methodsynopsis>
+		<para>
+			<function>sqlite_udf_decode_binary</function> îôòðçú ðúåðéí áéðàøééí î÷åããéí ù÷åããå ò"é  àçú îäôåð÷öéåú decodes    <function>sqlite_udf_encode_binary</function>àå<function>sqlite_escape_string</function>.
   </para>
-  <para>
-   You must call this function on parameters passed to your UDF if you need
-   them to handle binary data, as the binary encoding employed by PHP will
-   obscure the content and of the parameter in its natural, non-coded form.
-  </para>
-  <para>
-   PHP does not perform this encode/decode operation automatically as it would
-   severely impact performance if it did.
-  </para>
-  <para>
-   <example>
-    <title>binary-safe max_length aggregation function example</title>
-    <programlisting role="php">
-<![CDATA[
+		<para>áùéîåù áðúåðéí áéðàøééí ,ùîåçæøéí îôåð÷öéåú UDF, , çééáéí ì÷øåà ìôåð÷öéä äæàú, îàçø å PHP ìà úòùä àú äòáåãä áöåøä îéèáéú.</para>
+		<para>
+   PHP ìà îáöòú ÷éãåã åôéòðåç àåèåîèéú, ëãé ìîðåò ôâéòä ááéöåòéí.</para>
+		<para>
+			<example>
+				<title>binary-safe max_length aggregation function example</title>
+				<programlisting role="php"><![CDATA[
 <?php
 $data = array(
    'one',
@@ -67,16 +61,13 @@
 var_dump(sqlite_array_query($db, 'SELECT max_len(a) from strings'));
 
 ?>
-]]>
-    </programlisting>
-   </example>
-  </para>
-  <para>
-   See also <function>sqlite_udf_encode_binary</function>, 
-   <function>sqlite_create_function</function> and
-   <function>sqlite_create_aggregate</function>.
+]]></programlisting>
+			</example>
+		</para>
+		<para>øàä âí<function>sqlite_udf_encode_binary</function>, 
+   <function>sqlite_create_function</function>å<function>sqlite_create_aggregate</function>.
   </para>
- </refsect1>
+	</refsect1>
 </refentry>
 <!-- Keep this comment at the end of the file
  Local variables:
Index: phpdoc-he/reference/sqlite/functions/sqlite-udf-encode-binary.xml
diff -u phpdoc-he/reference/sqlite/functions/sqlite-udf-encode-binary.xml:1.1 phpdoc-he/reference/sqlite/functions/sqlite-udf-encode-binary.xml:1.2
--- phpdoc-he/reference/sqlite/functions/sqlite-udf-encode-binary.xml:1.1	Mon Jul 28 05:40:20 2003
+++ phpdoc-he/reference/sqlite/functions/sqlite-udf-encode-binary.xml	Thu Jul 31 00:14:56 2003
@@ -1,45 +1,33 @@
 <?xml version="1.0" encoding="WINDOWS-1255"?>
-<!-- $Revision: 1.1 $ -->
 <refentry id="function.sqlite-udf-encode-binary">
- <refnamediv>
-  <refname>sqlite_udf_encode_binary</refname>
-  <refpurpose>Encode binary data before returning it from an UDF.</refpurpose>
- </refnamediv>
- <refsect1>
-  <title>úéàåø</title>
-  <methodsynopsis>
-   <type>string</type><methodname>sqlite_udf_encode_binary</methodname>
-   <methodparam><type>string</type><parameter>data</parameter></methodparam>
-  </methodsynopsis>
-  <para>
-   <function>sqlite_udf_encode_binary</function> applies a binary encoding
-   to the <parameter>data</parameter> so that it can be safely returned from
-   queries (since the underlying libsqlite API is not binary safe).
+	<refnamediv>
+		<refname>sqlite_udf_encode_binary</refname>
+		<refpurpose> äôåð÷öéä î÷ããú ðúåðéí áéðàøééí, ìôðé ùäéà îçæéøä àåúí îôåð÷öéåú îùúîù àéùéåú UDF.</refpurpose>
+	</refnamediv>
+	<refsect1>
+		<title>úéàåø</title>
+		<methodsynopsis>
+			<type>string</type>
+			<methodname>sqlite_udf_encode_binary</methodname>
+			<methodparam>
+				<type>string</type>
+				<parameter>data</parameter>
+			</methodparam>
+		</methodsynopsis>
+		<para>
+			<function>sqlite_udf_encode_binary</function>îééùîú ÷éãåã áéðàøé ìðúåðéí, ëê ùäí éçæøå áöåøä áèåçä îäùàéìúä, îä ùìà ÷åøä àåèåîèéú áñôøéåú ùì SQLITE. </para>
+		<para>àí éù ñéëåé ùäðúåðéí ùìê àéðí áèåçéí (ìîùì äí îëéìéí àú äúå NUL áàîöò äîçøåæú áî÷åí áñåôä, àå ùäöéøåó
+   <literal>0x01</literal> ðîöà áúçéìú äîçøåæú) ,àúä çééá ìäùúîù áôåð÷öéä , òì îðú ì÷ãã àú äðúåðéí ùçåæøéí îôåð÷öéåú äîùúîù äàéùéåú.</para>
+		<para>äúäìéê ìà îúáöò àåèåîèéú á PHP , ëãé ìîðåò ôâéòä ááéöåòéí.
   </para>
-  <para>
-   If there is a chance that your data might be binary unsafe (eg: it
-   contains a NUL byte in the middle rather than at the end, or if it has and
-   <literal>0x01</literal> byte as the first character) then you must
-   call this function to encode the return value from your UDF.
-  </para>
-  <para>
-   PHP does not perform this encode/decode operation automatically as it would
-   severely impact performance if it did.
-  </para>
-  <note>
-   <para>
-    Do not use <function>sqlite_escape_string</function> to quote strings
-    returned from UDF's as it will lead to double-quoting of the data.  Use
-    <function>sqlite_udf_encode_binary</function> instead!
-   </para>
-  </note>
-  <para>
-   See also <function>sqlite_udf_decode_binary</function>,
+		<note>
+			<para>àì úùúîù áôåð÷öéä<function>sqlite_escape_string</function> ìäåñéó îøëàåú ìòøëéí ùçåæøéí îôåð÷öéåú äîùúîù äàéùéåú ùìê, æä òìåì ìäåáéì ìäåñôä ëôåìä ùì îøëàåú. äùúîù áôåð÷öéä    <function>sqlite_udf_encode_binary</function>áî÷åí!.</para>
+		</note>
+		<para>øàä âí<function>sqlite_udf_decode_binary</function>,
    <function>sqlite_escape_string</function>, 
-   <function>sqlite_create_function</function> and
-   <function>sqlite_create_aggregate</function>.
+   <function>sqlite_create_function</function>å<function>sqlite_create_aggregate</function>.
   </para>
- </refsect1>
+	</refsect1>
 </refentry>
 <!-- Keep this comment at the end of the file
  Local variables: