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

From: Date: Thu, 31 Jul 2003 04:14:56 +0000
Subject: 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
Groups: php.doc.he 
Request: Send a blank email to doc-he+get-209@lists.php.net to get a copy of this message
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

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:
« previous php.doc.he (#209) next »