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] )

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

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