sander Wed Mar 26 08:53:02 2003 EDT
Modified files:
/phpdoc/en/reference/sybase/functions
sybase-set-message-handler.xml
sybase-unbuffered-query.xml
Log:
Patch by Timm Friebe <[EMAIL PROTECTED]>
* Added some examples to sybase-set-message-handler.xml
* Corrected the statement "will fail" to "will produce a warning"
and added an example to sybase-unbuffered-query.xml
Index: phpdoc/en/reference/sybase/functions/sybase-set-message-handler.xml
diff -u phpdoc/en/reference/sybase/functions/sybase-set-message-handler.xml:1.1
phpdoc/en/reference/sybase/functions/sybase-set-message-handler.xml:1.2
--- phpdoc/en/reference/sybase/functions/sybase-set-message-handler.xml:1.1 Fri
Feb 7 19:57:14 2003
+++ phpdoc/en/reference/sybase/functions/sybase-set-message-handler.xml Wed Mar 26
08:53:01 2003
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.1 $ -->
+<!-- $Revision: 1.2 $ -->
<refentry id="function.sybase-set-message-handler">
<refnamediv>
<refname>sybase_set_message_handler</refname>
@@ -26,6 +26,55 @@
<para>
&return.success;
</para>
+ <example>
+ <title><function>sybase_set_message_handler</function> callback function</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+ function msg_handler($msgnumber, $severity, $state, $line, $text) {
+ var_dump($msgnumber, $severity, $state, $line, $text);
+ }
+
+ sybase_set_message_handler('msg_handler');
+?>
+]]>
+ </programlisting>
+ </example>
+ <example>
+ <title><function>sybase_set_message_handler</function> callback to a
class</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+ class Sybase {
+ function handler($msgnumber, $severity, $state, $line, $text) {
+ var_dump($msgnumber, $severity, $state, $line, $text);
+ }
+ }
+
+ $sybase= new Sybase();
+ sybase_set_message_handler(array($sybase, 'handler'));
+?>
+]]>
+ </programlisting>
+ </example>
+ <example>
+ <title><function>sybase_set_message_handler</function> unhandled messages</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+ // Return FALSE from this function to indicate you can't handle
+ // this. The error is printed out as a warning, the way you're used
+ // to it if there is no handler installed.
+ function msg_handler($msgnumber, $severity, $state, $line, $text) {
+ if (257 == $msgnumber) return FALSE;
+ var_dump($msgnumber, $severity, $state, $line, $text);
+ }
+
+ sybase_set_message_handler('msg_handler');
+?>
+]]>
+ </programlisting>
+ </example>
</refsect1>
</refentry>
Index: phpdoc/en/reference/sybase/functions/sybase-unbuffered-query.xml
diff -u phpdoc/en/reference/sybase/functions/sybase-unbuffered-query.xml:1.1
phpdoc/en/reference/sybase/functions/sybase-unbuffered-query.xml:1.2
--- phpdoc/en/reference/sybase/functions/sybase-unbuffered-query.xml:1.1 Fri
Feb 7 19:57:14 2003
+++ phpdoc/en/reference/sybase/functions/sybase-unbuffered-query.xml Wed Mar 26
08:53:01 2003
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.1 $ -->
+<!-- $Revision: 1.2 $ -->
<refentry id="function.sybase-unbuffered-query">
<refnamediv>
<refname>sybase_unbuffered_query</refname>
@@ -36,13 +36,38 @@
of rows if all result sets have been read. To Sybase, the number of rows
is not known and is therefore computed by the client implementation.
</para>
- <para>
- It is not possible to fire up another query directly after starting an
- unbuffered query and only if all rows have been read or the
- remainding rows have been cancelled. This can be acheived by using
- <function>sybase_free_result</function> on the return value of
- <function>sybase_unbuffered_query</function>.
+ <note>
+ <para>
+ If you don't read all of the resultsets prior to executing the next query,
+ PHP will raise a warning and cancel all of the pending results. To get rid of
+ this, use <function>sybase_free_result</function> which will cancel pending
+ results of an unbuffered query.
+ </para>
+ </note>
+ <para>
+ The optional <parameter>store_result</parameter> can be FALSE to indicate
+ the resultsets should'nt be fetched into memory, thus minimizing memory usage
+ which is particularily interesting with very large resultsets.
</para>
+ <example>
+ <title><function>sybase_unbuffered_query</function></title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+ $dbh= sybase_connect('SYBASE', '', '');
+ $q= sybase_unbuffered_query('select firstname, lastname from huge_table',
$dbh, FALSE);
+ sybase_data_seek($q, 10000);
+ $i= 0;
+ while ($row= sybase_fetch_row($q)) {
+ echo $row[0].' '.$row[0];
+ if ($i++ > 40000) break;
+ }
+ sybase_free_result($q);
+ sybase_close($dbh);
+?>
+]]>
+ </programlisting>
+ </example>
</refsect1>
</refentry>
--
PHP Documentation Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
