Delicious Bookmark this on Delicious Share on Facebook SlashdotSlashdot It! Digg! Digg



PHP : Function Reference : Sybase Functions : sybase_set_message_handler

sybase_set_message_handler

Sets the handler called when a server message is raised (PHP 4 >= 4.3.0, PHP 5)
bool sybase_set_message_handler ( callback handler [, resource connection] )

sybase_set_message_handler() sets a user function to handle messages generated by the server. You may specify the name of a global function, or use an array to specify an object reference and a method name.

Parameters

handler

The handler expects five arguments in the following order: message number, severity, state, line number and description. The first four are integers. The last is a string. If the function returns FALSE, PHP generates an ordinary error message.

connection

Return Values

Returns TRUE on success or FALSE on failure.

ChangeLog

Version Description
4.3.5 The connection parameter was added.

Examples

Example 2526. sybase_set_message_handler() callback function

<?php
   
function msg_handler($msgnumber, $severity, $state, $line, $text)
   {
       
var_dump($msgnumber, $severity, $state, $line, $text);
   }

   
sybase_set_message_handler('msg_handler');
?>


Example 2527. sybase_set_message_handler() callback to a class

<?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'));
?>


Example 2528. sybase_set_message_handler() unhandled messages

<?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');
?>


Notes

Note:

This function is only available using the CT library interface to Sybase, and not the DB library.

Code Examples / Notes » sybase_set_message_handler

19-jun-2003 10:23

You can check for Showplan messages using this callback. Showplan message numbers go from 6201 through 6292 (at least here, on SQL Server/11.0.3.3).
select error, description from master..sysmessages where error between 6201 and 6292


Change Language


Follow Navioo On Twitter
sybase_affected_rows
sybase_close
sybase_connect
sybase_data_seek
sybase_deadlock_retry_count
sybase_fetch_array
sybase_fetch_assoc
sybase_fetch_field
sybase_fetch_object
sybase_fetch_row
sybase_field_seek
sybase_free_result
sybase_get_last_message
sybase_min_client_severity
sybase_min_error_severity
sybase_min_message_severity
sybase_min_server_severity
sybase_num_fields
sybase_num_rows
sybase_pconnect
sybase_query
sybase_result
sybase_select_db
sybase_set_message_handler
sybase_unbuffered_query
eXTReMe Tracker