cvs: phpdoc /en/reference/sybase/functions sybase-set-message-handler.xml sybase-unbuffered-query.xml

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 <thekid@php.net> * 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>