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: