derick Fri Jun 20 14:57:15 2003 EDT Modified files: /phpdoc/en/reference/sqlite/functions sqlite-array-query.xml sqlite-busy-timeout.xml sqlite-changes.xml sqlite-close.xml sqlite-column.xml sqlite-create-function.xml sqlite-current.xml sqlite-error-string.xml sqlite-escape-string.xml sqlite-fetch-array.xml sqlite-fetch-string.xml sqlite-last-error.xml sqlite-last-insert-rowid.xml sqlite-libencoding.xml sqlite-libversion.xml sqlite-next.xml sqlite-num-fields.xml sqlite-open.xml sqlite-popen.xml sqlite-query.xml sqlite-register-aggregate.xml sqlite-rewind.xml sqlite-seek.xml sqlite-unbuffered-query.xml Log: - Fixed tags and indenting
Index: phpdoc/en/reference/sqlite/functions/sqlite-array-query.xml diff -u phpdoc/en/reference/sqlite/functions/sqlite-array-query.xml:1.2 phpdoc/en/reference/sqlite/functions/sqlite-array-query.xml:1.3 --- phpdoc/en/reference/sqlite/functions/sqlite-array-query.xml:1.2 Fri Jun 20 14:49:38 2003 +++ phpdoc/en/reference/sqlite/functions/sqlite-array-query.xml Fri Jun 20 14:57:15 2003 @@ -1,54 +1,50 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.2 $ --> - <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>db</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"> +<!-- $Revision: 1.3 $ --> +<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>db</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[<?php $q = sqlite_query($database, "SELECT * from foo LIMIT 100"); $rows = array(); while ($r = sqlite_fetch_array($q)) { - $rows[] = $r; + $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. - </para> - </tip> - </refsect1> - </refentry> - - - - + </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. + </para> + </tip> + </refsect1> +</refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml Index: phpdoc/en/reference/sqlite/functions/sqlite-busy-timeout.xml diff -u phpdoc/en/reference/sqlite/functions/sqlite-busy-timeout.xml:1.1 phpdoc/en/reference/sqlite/functions/sqlite-busy-timeout.xml:1.2 --- phpdoc/en/reference/sqlite/functions/sqlite-busy-timeout.xml:1.1 Fri Jun 20 13:31:55 2003 +++ phpdoc/en/reference/sqlite/functions/sqlite-busy-timeout.xml Fri Jun 20 14:57:15 2003 @@ -1,35 +1,31 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.1 $ --> - <refentry id="function.sqlite-busy-timeout"> - <refnamediv><refname>sqlite_busy_timeout</refname> - <refpurpose>Set busy timeout duration, or disable busy handlers</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <methodsynopsis> - <type>void</type><function>sqlite_busy_timeout</function> - <methodparam><type>resource</type><parameter>database</parameter></methodparam> - <methodparam><type>int</type><parameter>milliseconds</parameter></methodparam> - </methodsynopsis> - <para> - Set the maximum time that sqlite will wait for a - <parameter>database</parameter> - to become ready for use to <parameter>milliseconds</parameter>. - If <parameter>milliseconds</parameter> is <literal>0</literal>, busy - handlers will be disabled and sqlite will return immediately with a - <literal>SQLITE_BUSY</literal> status code if another process/thread has - the database locked for an update. - </para> - <para> - PHP sets the default busy timeout to be 60 seconds when the database is - opened. - </para> - </refsect1> - </refentry> - - - - +<!-- $Revision: 1.2 $ --> +<refentry id="function.sqlite-busy-timeout"> + <refnamediv><refname>sqlite_busy_timeout</refname> + <refpurpose>Set busy timeout duration, or disable busy handlers</refpurpose> + </refnamediv> + <refsect1> + <title>Description</title> + <methodsynopsis> + <type>void</type><methodname>sqlite_busy_timeout</methodname> + <methodparam><type>resource</type><parameter>database</parameter></methodparam> + <methodparam><type>int</type><parameter>milliseconds</parameter></methodparam> + </methodsynopsis> + <para> + Set the maximum time that sqlite will wait for a + <parameter>database</parameter> + to become ready for use to <parameter>milliseconds</parameter>. + If <parameter>milliseconds</parameter> is <literal>0</literal>, busy + handlers will be disabled and sqlite will return immediately with a + <literal>SQLITE_BUSY</literal> status code if another process/thread has + the database locked for an update. + </para> + <para> + PHP sets the default busy timeout to be 60 seconds when the database is + opened. + </para> + </refsect1> +</refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml Index: phpdoc/en/reference/sqlite/functions/sqlite-changes.xml diff -u phpdoc/en/reference/sqlite/functions/sqlite-changes.xml:1.2 phpdoc/en/reference/sqlite/functions/sqlite-changes.xml:1.3 --- phpdoc/en/reference/sqlite/functions/sqlite-changes.xml:1.2 Fri Jun 20 14:49:38 2003 +++ phpdoc/en/reference/sqlite/functions/sqlite-changes.xml Fri Jun 20 14:57:15 2003 @@ -1,22 +1,22 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.2 $ --> - <refentry id="function.sqlite-changes"> - <refnamediv> - <refname>sqlite_changes</refname> - <refpurpose>Returns the number of rows that were changed by the most recent SQL statement</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <methodsynopsis> - <type>int</type><function>sqlite_changes</function> - <methodparam><type>resource</type><parameter>db</parameter></methodparam> - </methodsynopsis> - <para> - Returns the numbers of rows that were changed by the most recent SQL - statement executed against the database <parameter>db</parameter>. - </para> - </refsect1> - </refentry> +<!-- $Revision: 1.3 $ --> +<refentry id="function.sqlite-changes"> + <refnamediv> + <refname>sqlite_changes</refname> + <refpurpose>Returns the number of rows that were changed by the most recent SQL statement</refpurpose> + </refnamediv> + <refsect1> + <title>Description</title> + <methodsynopsis> + <type>int</type><methodname>sqlite_changes</methodname> + <methodparam><type>resource</type><parameter>db</parameter></methodparam> + </methodsynopsis> + <para> + Returns the numbers of rows that were changed by the most recent SQL + statement executed against the database <parameter>db</parameter>. + </para> + </refsect1> +</refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml Index: phpdoc/en/reference/sqlite/functions/sqlite-close.xml diff -u phpdoc/en/reference/sqlite/functions/sqlite-close.xml:1.1 phpdoc/en/reference/sqlite/functions/sqlite-close.xml:1.2 --- phpdoc/en/reference/sqlite/functions/sqlite-close.xml:1.1 Fri Jun 20 13:31:55 2003 +++ phpdoc/en/reference/sqlite/functions/sqlite-close.xml Fri Jun 20 14:57:15 2003 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.1 $ --> +<!-- $Revision: 1.2 $ --> <refentry id="function.sqlite-close"> <refnamediv> <refname>sqlite_close</refname> @@ -7,10 +7,10 @@ </refnamediv> <refsect1> <title>Description</title> - <methodsynopsis> - <type>void</type><function>sqlite_close</function> - <methodparam><type>resource</type><parameter>database</parameter></methodparam> - </methodsynopsis> + <methodsynopsis> + <type>void</type><methodname>sqlite_close</methodname> + <methodparam><type>resource</type><parameter>database</parameter></methodparam> + </methodsynopsis> <para> Closes the given <parameter>database</parameter> handle. If the database was persistent, it will be closed and removed from the @@ -22,8 +22,6 @@ </para> </refsect1> </refentry> - - <!-- Keep this comment at the end of the file Local variables: mode: sgml Index: phpdoc/en/reference/sqlite/functions/sqlite-column.xml diff -u phpdoc/en/reference/sqlite/functions/sqlite-column.xml:1.1 phpdoc/en/reference/sqlite/functions/sqlite-column.xml:1.2 --- phpdoc/en/reference/sqlite/functions/sqlite-column.xml:1.1 Fri Jun 20 13:31:55 2003 +++ phpdoc/en/reference/sqlite/functions/sqlite-column.xml Fri Jun 20 14:57:15 2003 @@ -1,35 +1,32 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.1 $ --> - - <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>Description</title> - <methodsynopsis> - <type>mixed</type><function>sqlite_column</function> - <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> - Fetches the value of a column named <parameter>index_or_name</parameter> - (if it is a string), or of the ordinal column numbered - <parameter>index_or_name</parameter> (if it is an integer) from the - current row of the query result handle <parameter>result</parameter>. - The decode binary flag operates in the same way as described under - <function>sqlite_fetch_array</function>. - </para> - <para> - Use this function when you are iterating a large result set with many - columns, or with columns that contain large amounts of data. - </para> - </refsect1> - </refentry> - - +<!-- $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>Description</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> + Fetches the value of a column named <parameter>index_or_name</parameter> + (if it is a string), or of the ordinal column numbered + <parameter>index_or_name</parameter> (if it is an integer) from the + current row of the query result handle <parameter>result</parameter>. + The decode binary flag operates in the same way as described under + <function>sqlite_fetch_array</function>. + </para> + <para> + Use this function when you are iterating a large result set with many + columns, or with columns that contain large amounts of data. + </para> + </refsect1> +</refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml Index: phpdoc/en/reference/sqlite/functions/sqlite-create-function.xml diff -u phpdoc/en/reference/sqlite/functions/sqlite-create-function.xml:1.2 phpdoc/en/reference/sqlite/functions/sqlite-create-function.xml:1.3 --- phpdoc/en/reference/sqlite/functions/sqlite-create-function.xml:1.2 Fri Jun 20 14:49:38 2003 +++ phpdoc/en/reference/sqlite/functions/sqlite-create-function.xml Fri Jun 20 14:57:15 2003 @@ -1,46 +1,45 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.2 $ --> - +<!-- $Revision: 1.3 $ --> <refentry id="function.sqlite-create-function"> <refnamediv> <refname>sqlite_create_function</refname> <refpurpose>Registers a "regular" User Defined Function for use in SQL statements</refpurpose> </refnamediv> - <refsect1> - <title>Description</title> - <methodsynopsis> - <type>bool</type><function>sqlite_create_function</function> - <methodparam><type>resource</type><parameter>db</parameter></methodparam> - <methodparam><type>string</type><parameter>function_name</parameter></methodparam> - <methodparam><type>mixed</type><parameter>callback</parameter></methodparam> - <methodparam choice="opt"><type>int</type><parameter>num_args</parameter></methodparam> - </methodsynopsis> - <para> - <function>sqlite_create_function</function> allows you to register a PHP - function with SQLite as an <acronym>UDF</acronym> (User Defined - Function), so that it can be called from within your SQL - statements. - </para> - <para> - <parameter>db</parameter> specifies the database handle that you wish to - extend, <parameter>function_name</parameter> specifies the name of the - function that you will use in your SQL statements, - <parameter>callback</parameter> is any valid PHP callback to specify a - PHP function that should be called to handle the SQL function. - The optional parameter <parameter>num_args</parameter> is used as a hint - by the SQLite expression parser/evaluator. It is recommended that you - specifiy a value if your function will only ever accept a fixed number of - parameters. - </para> - <para> - The UDF can be used in any SQL statement that can call functions, such as - SELECT and UPDATE statements and also in triggers. - </para> - - <para> - <example> - <title><function>sqlite_create_function</function> example</title> - <programlisting role="php"> + <refsect1> + <title>Description</title> + <methodsynopsis> + <type>bool</type><methodname>sqlite_create_function</methodname> + <methodparam><type>resource</type><parameter>db</parameter></methodparam> + <methodparam><type>string</type><parameter>function_name</parameter></methodparam> + <methodparam><type>mixed</type><parameter>callback</parameter></methodparam> + <methodparam choice="opt"><type>int</type><parameter>num_args</parameter></methodparam> + </methodsynopsis> + <para> + <function>sqlite_create_function</function> allows you to register a PHP + function with SQLite as an <acronym>UDF</acronym> (User Defined + Function), so that it can be called from within your SQL + statements. + </para> + <para> + <parameter>db</parameter> specifies the database handle that you wish to + extend, <parameter>function_name</parameter> specifies the name of the + function that you will use in your SQL statements, + <parameter>callback</parameter> is any valid PHP callback to specify a + PHP function that should be called to handle the SQL function. + The optional parameter <parameter>num_args</parameter> is used as a hint + by the SQLite expression parser/evaluator. It is recommended that you + specifiy a value if your function will only ever accept a fixed number of + parameters. + </para> + <para> + The UDF can be used in any SQL statement that can call functions, such as + SELECT and UPDATE statements and also in triggers. + </para> + + <para> + <example> + <title><function>sqlite_create_function</function> example</title> + <programlisting role="php"> <![CDATA[ <?php function md5_and_reverse($string) { @@ -51,63 +50,61 @@ $rows = sqlite_array_query($db, 'SELECT md5rev(filename) from files'); ?>]]> - </programlisting> - </example> - </para> - <para> - In this example, we have a function that calculates the md5 sum of a - string, and then reverses it. When the SQL statement executes, it - returns the value of the filename transformed by our function. The data - returned in <parameter>$rows</parameter> contains the processed result. - </para> - <para> - The beauty of this technique is that you do not need to process the - result using a foreach() loop after you have queried for the data. - </para> - - <para> - PHP registers a special function named <literal>php</literal> when the - database is first opened. The php function can be used to call any PHP - function without having to register it first. - </para> - <para> - <example> - <title>Example of using the PHP function</title> - <programlisting role="php"> + </programlisting> + </example> + </para> + <para> + In this example, we have a function that calculates the md5 sum of a + string, and then reverses it. When the SQL statement executes, it + returns the value of the filename transformed by our function. The data + returned in <parameter>$rows</parameter> contains the processed result. + </para> + <para> + The beauty of this technique is that you do not need to process the + result using a foreach() loop after you have queried for the data. + </para> + + <para> + PHP registers a special function named <literal>php</literal> when the + database is first opened. The php function can be used to call any PHP + function without having to register it first. + </para> + <para> + <example> + <title>Example of using the PHP function</title> + <programlisting role="php"> <![CDATA[ <?php $rows = sqlite_array_query($db, "SELECT php('md5', filename) from files"); ?>]]> - </programlisting> - <para> - This example will call the <function>md5</function> on each - <literal>filename</literal> column in the database and return the result - into <parameter>$rows</parameter> - </para> - </example> - </para> - <note> - <para> - For performance reasons, PHP will not automatically encode/decode binary - data passed to and from your UDF's. You need to manually encode/decode - the parameters and return values if you need to process binary data in - this way. - </para> - </note> - <tip> - <para> - It is not recommended to use UDF's to handle processesing of - binary data, unless high performance is not a key requirement of your - application. - </para> - </tip> + </programlisting> <para> - See also <function>sqlite_register_aggregate</function>. - </para> - </refsect1> - </refentry> - - + This example will call the <function>md5</function> on each + <literal>filename</literal> column in the database and return the result + into <parameter>$rows</parameter> + </para> + </example> + </para> + <note> + <para> + For performance reasons, PHP will not automatically encode/decode binary + data passed to and from your UDF's. You need to manually encode/decode + the parameters and return values if you need to process binary data in + this way. + </para> + </note> + <tip> + <para> + It is not recommended to use UDF's to handle processesing of + binary data, unless high performance is not a key requirement of your + application. + </para> + </tip> + <para> + See also <function>sqlite_register_aggregate</function>. + </para> + </refsect1> +</refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml Index: phpdoc/en/reference/sqlite/functions/sqlite-current.xml diff -u phpdoc/en/reference/sqlite/functions/sqlite-current.xml:1.2 phpdoc/en/reference/sqlite/functions/sqlite-current.xml:1.3 --- phpdoc/en/reference/sqlite/functions/sqlite-current.xml:1.2 Fri Jun 20 14:49:38 2003 +++ phpdoc/en/reference/sqlite/functions/sqlite-current.xml Fri Jun 20 14:57:15 2003 @@ -1,6 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.2 $ --> - +<!-- $Revision: 1.3 $ --> <refentry id="function.sqlite-current"> <refnamediv> <refname>sqlite_current</refname> @@ -35,10 +34,6 @@ </para> </refsect1> </refentry> - - - - <!-- Keep this comment at the end of the file Local variables: mode: sgml Index: phpdoc/en/reference/sqlite/functions/sqlite-error-string.xml diff -u phpdoc/en/reference/sqlite/functions/sqlite-error-string.xml:1.2 phpdoc/en/reference/sqlite/functions/sqlite-error-string.xml:1.3 --- phpdoc/en/reference/sqlite/functions/sqlite-error-string.xml:1.2 Fri Jun 20 14:49:38 2003 +++ phpdoc/en/reference/sqlite/functions/sqlite-error-string.xml Fri Jun 20 14:57:15 2003 @@ -1,6 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.2 $ --> - +<!-- $Revision: 1.3 $ --> <refentry id="function.sqlite-error-string"> <refnamediv> <refname>sqlite_error_string</refname> @@ -22,9 +21,6 @@ </para> </refsect1> </refentry> - - - <!-- Keep this comment at the end of the file Local variables: mode: sgml Index: phpdoc/en/reference/sqlite/functions/sqlite-escape-string.xml diff -u phpdoc/en/reference/sqlite/functions/sqlite-escape-string.xml:1.2 phpdoc/en/reference/sqlite/functions/sqlite-escape-string.xml:1.3 --- phpdoc/en/reference/sqlite/functions/sqlite-escape-string.xml:1.2 Fri Jun 20 14:49:38 2003 +++ phpdoc/en/reference/sqlite/functions/sqlite-escape-string.xml Fri Jun 20 14:57:15 2003 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.2 $ --> +<!-- $Revision: 1.3 $ --> <refentry id="function.sqlite-escape-string"> <refnamediv> <refname>sqlite_escape_string</refname> @@ -41,8 +41,6 @@ </warning> </refsect1> </refentry> - - <!-- Keep this comment at the end of the file Local variables: mode: sgml Index: phpdoc/en/reference/sqlite/functions/sqlite-fetch-array.xml diff -u phpdoc/en/reference/sqlite/functions/sqlite-fetch-array.xml:1.2 phpdoc/en/reference/sqlite/functions/sqlite-fetch-array.xml:1.3 --- phpdoc/en/reference/sqlite/functions/sqlite-fetch-array.xml:1.2 Fri Jun 20 14:49:38 2003 +++ phpdoc/en/reference/sqlite/functions/sqlite-fetch-array.xml Fri Jun 20 14:57:15 2003 @@ -46,8 +46,6 @@ </para> </refsect1> </refentry> - - <!-- Keep this comment at the end of the file Local variables: mode: sgml Index: phpdoc/en/reference/sqlite/functions/sqlite-fetch-string.xml diff -u phpdoc/en/reference/sqlite/functions/sqlite-fetch-string.xml:1.1 phpdoc/en/reference/sqlite/functions/sqlite-fetch-string.xml:1.2 --- phpdoc/en/reference/sqlite/functions/sqlite-fetch-string.xml:1.1 Fri Jun 20 13:31:55 2003 +++ phpdoc/en/reference/sqlite/functions/sqlite-fetch-string.xml Fri Jun 20 14:57:15 2003 @@ -1,32 +1,29 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.1 $ --> - - <refentry id="function.sqlite-fetch-string"> - <refnamediv> - <refname>sqlite_fetch_string</refname> - <refpurpose>Fetches first column of a result set as a string.</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <methodsynopsis> - <type>string</type><methodname>sqlite_fetch_string</methodname> - <methodparam><type>resource</type><parameter>result</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_fetch_string</function> is identical to - <function>sqlite_fetch_array</function> except that it returns the value - of the first column of the rowset. - </para> - <para> - This is the most optimial way to retrieve data when you are only - interested in the values from a single column of data. - </para> - </refsect1> - </refentry> - - +<!-- $Revision: 1.2 $ --> +<refentry id="function.sqlite-fetch-string"> + <refnamediv> + <refname>sqlite_fetch_string</refname> + <refpurpose>Fetches first column of a result set as a string.</refpurpose> + </refnamediv> + <refsect1> + <title>Description</title> + <methodsynopsis> + <type>string</type><methodname>sqlite_fetch_string</methodname> + <methodparam><type>resource</type><parameter>result</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_fetch_string</function> is identical to + <function>sqlite_fetch_array</function> except that it returns the value + of the first column of the rowset. + </para> + <para> + This is the most optimial way to retrieve data when you are only + interested in the values from a single column of data. + </para> + </refsect1> +</refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml Index: phpdoc/en/reference/sqlite/functions/sqlite-last-error.xml diff -u phpdoc/en/reference/sqlite/functions/sqlite-last-error.xml:1.2 phpdoc/en/reference/sqlite/functions/sqlite-last-error.xml:1.3 --- phpdoc/en/reference/sqlite/functions/sqlite-last-error.xml:1.2 Fri Jun 20 14:49:38 2003 +++ phpdoc/en/reference/sqlite/functions/sqlite-last-error.xml Fri Jun 20 14:57:15 2003 @@ -1,6 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.2 $ --> - +<!-- $Revision: 1.3 $ --> <refentry id="function.sqlite-last-error"> <refnamediv> <refname>sqlite_last_error</refname> @@ -21,8 +20,6 @@ </para> </refsect1> </refentry> - - <!-- Keep this comment at the end of the file Local variables: mode: sgml Index: phpdoc/en/reference/sqlite/functions/sqlite-last-insert-rowid.xml diff -u phpdoc/en/reference/sqlite/functions/sqlite-last-insert-rowid.xml:1.2 phpdoc/en/reference/sqlite/functions/sqlite-last-insert-rowid.xml:1.3 --- phpdoc/en/reference/sqlite/functions/sqlite-last-insert-rowid.xml:1.2 Fri Jun 20 14:49:38 2003 +++ phpdoc/en/reference/sqlite/functions/sqlite-last-insert-rowid.xml Fri Jun 20 14:57:15 2003 @@ -1,6 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.2 $ --> - +<!-- $Revision: 1.3 $ --> <refentry id="function.sqlite-last-insert-rowid"> <refnamediv> <refname>sqlite_last_insert_rowid</refname> Index: phpdoc/en/reference/sqlite/functions/sqlite-libencoding.xml diff -u phpdoc/en/reference/sqlite/functions/sqlite-libencoding.xml:1.2 phpdoc/en/reference/sqlite/functions/sqlite-libencoding.xml:1.3 --- phpdoc/en/reference/sqlite/functions/sqlite-libencoding.xml:1.2 Fri Jun 20 14:49:38 2003 +++ phpdoc/en/reference/sqlite/functions/sqlite-libencoding.xml Fri Jun 20 14:57:15 2003 @@ -1,6 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.2 $ --> - +<!-- $Revision: 1.3 $ --> <refentry id="function.sqlite-libencoding"> <refnamediv> <refname>sqlite_libencoding</refname> @@ -10,6 +9,7 @@ <title>Description</title> <methodsynopsis> <type>string</type><methodname>sqlite_libencoding</methodname> + <void/> </methodsynopsis> <para> The SQLite library may be compiled in either ISO-8859-1 or UTF-8 Index: phpdoc/en/reference/sqlite/functions/sqlite-libversion.xml diff -u phpdoc/en/reference/sqlite/functions/sqlite-libversion.xml:1.2 phpdoc/en/reference/sqlite/functions/sqlite-libversion.xml:1.3 --- phpdoc/en/reference/sqlite/functions/sqlite-libversion.xml:1.2 Fri Jun 20 14:49:38 2003 +++ phpdoc/en/reference/sqlite/functions/sqlite-libversion.xml Fri Jun 20 14:57:15 2003 @@ -1,6 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.2 $ --> - +<!-- $Revision: 1.3 $ --> <refentry id="function.sqlite-libversion"> <refnamediv> <refname>sqlite_libversion</refname> @@ -10,6 +9,7 @@ <title>Description</title> <methodsynopsis> <type>string</type><methodname>sqlite_libversion</methodname> + <void/> </methodsynopsis> <para> Returns the version of the linked SQLite library as a string. Index: phpdoc/en/reference/sqlite/functions/sqlite-next.xml diff -u phpdoc/en/reference/sqlite/functions/sqlite-next.xml:1.2 phpdoc/en/reference/sqlite/functions/sqlite-next.xml:1.3 --- phpdoc/en/reference/sqlite/functions/sqlite-next.xml:1.2 Fri Jun 20 14:49:38 2003 +++ phpdoc/en/reference/sqlite/functions/sqlite-next.xml Fri Jun 20 14:57:15 2003 @@ -1,6 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.2 $ --> - +<!-- $Revision: 1.3 $ --> <refentry id="function.sqlite-next"> <refnamediv> <refname>sqlite_next</refname> Index: phpdoc/en/reference/sqlite/functions/sqlite-num-fields.xml diff -u phpdoc/en/reference/sqlite/functions/sqlite-num-fields.xml:1.2 phpdoc/en/reference/sqlite/functions/sqlite-num-fields.xml:1.3 --- phpdoc/en/reference/sqlite/functions/sqlite-num-fields.xml:1.2 Fri Jun 20 14:49:38 2003 +++ phpdoc/en/reference/sqlite/functions/sqlite-num-fields.xml Fri Jun 20 14:57:15 2003 @@ -1,6 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.2 $ --> - +<!-- $Revision: 1.3 $ --> <refentry id="function.sqlite-num-fields"> <refnamediv> <refname>sqlite_num_fields</refname> @@ -17,9 +16,6 @@ </para> </refsect1> </refentry> - - - <!-- Keep this comment at the end of the file Local variables: mode: sgml Index: phpdoc/en/reference/sqlite/functions/sqlite-open.xml diff -u phpdoc/en/reference/sqlite/functions/sqlite-open.xml:1.3 phpdoc/en/reference/sqlite/functions/sqlite-open.xml:1.4 --- phpdoc/en/reference/sqlite/functions/sqlite-open.xml:1.3 Fri Jun 20 14:49:38 2003 +++ phpdoc/en/reference/sqlite/functions/sqlite-open.xml Fri Jun 20 14:57:15 2003 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.3 $ --> +<!-- $Revision: 1.4 $ --> <refentry id="function.sqlite-open"> <refnamediv> <refname>sqlite_open</refname> @@ -98,7 +98,6 @@ </para> </refsect1> </refentry> - <!-- Keep this comment at the end of the file Local variables: mode: sgml Index: phpdoc/en/reference/sqlite/functions/sqlite-popen.xml diff -u phpdoc/en/reference/sqlite/functions/sqlite-popen.xml:1.2 phpdoc/en/reference/sqlite/functions/sqlite-popen.xml:1.3 --- phpdoc/en/reference/sqlite/functions/sqlite-popen.xml:1.2 Fri Jun 20 14:49:38 2003 +++ phpdoc/en/reference/sqlite/functions/sqlite-popen.xml Fri Jun 20 14:57:15 2003 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.2 $ --> +<!-- $Revision: 1.3 $ --> <refentry id="function.sqlite-popen"> <refnamediv> <refname>sqlite_popen</refname> @@ -51,7 +51,6 @@ </para> </refsect1> </refentry> - <!-- Keep this comment at the end of the file Local variables: mode: sgml Index: phpdoc/en/reference/sqlite/functions/sqlite-query.xml diff -u phpdoc/en/reference/sqlite/functions/sqlite-query.xml:1.2 phpdoc/en/reference/sqlite/functions/sqlite-query.xml:1.3 --- phpdoc/en/reference/sqlite/functions/sqlite-query.xml:1.2 Fri Jun 20 14:49:38 2003 +++ phpdoc/en/reference/sqlite/functions/sqlite-query.xml Fri Jun 20 14:57:15 2003 @@ -1,6 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.2 $ --> - +<!-- $Revision: 1.3 $ --> <refentry id="function.sqlite-query"> <refnamediv> <refname>sqlite_query</refname> @@ -71,8 +70,6 @@ </para> </refsect1> </refentry> - - <!-- Keep this comment at the end of the file Local variables: mode: sgml Index: phpdoc/en/reference/sqlite/functions/sqlite-register-aggregate.xml diff -u phpdoc/en/reference/sqlite/functions/sqlite-register-aggregate.xml:1.2 phpdoc/en/reference/sqlite/functions/sqlite-register-aggregate.xml:1.3 --- phpdoc/en/reference/sqlite/functions/sqlite-register-aggregate.xml:1.2 Fri Jun 20 14:49:38 2003 +++ phpdoc/en/reference/sqlite/functions/sqlite-register-aggregate.xml Fri Jun 20 14:57:15 2003 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.2 $ --> +<!-- $Revision: 1.3 $ --> <refentry id="function.sqlite-register-aggregate"> <refnamediv> <refname>sqlite_register_aggregate</refname> @@ -7,7 +7,7 @@ <refsect1> <title>Description</title> <methodsynopsis> - <type>bool</type><function>sqlite_register_aggregate</function> + <type>bool</type><methodname>sqlite_register_aggregate</methodname> <methodparam><type>resource</type><parameter>db</parameter></methodparam> <methodparam><type>string</type><parameter>function_name</parameter></methodparam> <methodparam><type>mixed</type><parameter>step_func</parameter></methodparam> @@ -106,9 +106,6 @@ </para> </refsect1> </refentry> - - - <!-- Keep this comment at the end of the file Local variables: mode: sgml Index: phpdoc/en/reference/sqlite/functions/sqlite-rewind.xml diff -u phpdoc/en/reference/sqlite/functions/sqlite-rewind.xml:1.2 phpdoc/en/reference/sqlite/functions/sqlite-rewind.xml:1.3 --- phpdoc/en/reference/sqlite/functions/sqlite-rewind.xml:1.2 Fri Jun 20 14:49:38 2003 +++ phpdoc/en/reference/sqlite/functions/sqlite-rewind.xml Fri Jun 20 14:57:15 2003 @@ -1,6 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.2 $ --> - +<!-- $Revision: 1.3 $ --> <refentry id="function.sqlite-rewind"> <refnamediv> <refname>sqlite_rewind</refname> @@ -28,8 +27,6 @@ </para> </refsect1> </refentry> - - <!-- Keep this comment at the end of the file Local variables: mode: sgml Index: phpdoc/en/reference/sqlite/functions/sqlite-seek.xml diff -u phpdoc/en/reference/sqlite/functions/sqlite-seek.xml:1.2 phpdoc/en/reference/sqlite/functions/sqlite-seek.xml:1.3 --- phpdoc/en/reference/sqlite/functions/sqlite-seek.xml:1.2 Fri Jun 20 14:49:38 2003 +++ phpdoc/en/reference/sqlite/functions/sqlite-seek.xml Fri Jun 20 14:57:15 2003 @@ -1,6 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.2 $ --> - +<!-- $Revision: 1.3 $ --> <refentry id="function.sqlite-seek"> <refnamediv> <refname>sqlite_seek</refname> @@ -30,8 +29,6 @@ </para> </refsect1> </refentry> - - <!-- Keep this comment at the end of the file Local variables: mode: sgml Index: phpdoc/en/reference/sqlite/functions/sqlite-unbuffered-query.xml diff -u phpdoc/en/reference/sqlite/functions/sqlite-unbuffered-query.xml:1.2 phpdoc/en/reference/sqlite/functions/sqlite-unbuffered-query.xml:1.3 --- phpdoc/en/reference/sqlite/functions/sqlite-unbuffered-query.xml:1.2 Fri Jun 20 14:49:38 2003 +++ phpdoc/en/reference/sqlite/functions/sqlite-unbuffered-query.xml Fri Jun 20 14:57:15 2003 @@ -1,6 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.2 $ --> - +<!-- $Revision: 1.3 $ --> <refentry id="function.sqlite-unbuffered-query"> <refnamediv> <refname>sqlite_unbuffered_query</refname> @@ -38,9 +37,6 @@ </note> </refsect1> </refentry> - - - <!-- Keep this comment at the end of the file Local variables: mode: sgml
-- PHP Documentation Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php