2 Sybase-CT server message handler
4 <?php require('skipif.inc'); ?>
7 /* This file is part of PHP test framework for ext/sybase_ct
14 // {{{ bool sybase_msg_handler(int msgnumber, int severity, int state, int line, string text)
15 // Handles server messages
16 function user_message_handler($msgnumber, $severity, $state, $line, $text) {
18 case 0: // print message
19 printf("!!! %s\n", trim($text));
22 case 174: // The function 'GETDATE' requires 0 arguments.
23 case 11021: // Function GETDATE invoked with wrong number or type of argument(s)
24 printf("*** Caught '%s'\n", trim($text));
27 printf("Cannot handle message #%d\n", $msgnumber);
28 return FALSE; // Indicate we can't handle this
32 sybase_set_messagehandler_ex('user_message_handler');
33 $db= sybase_connect_ex();
34 sybase_min_server_severity(0);
37 var_dump(sybase_select_ex($db, 'select getdate(NULL)'));
38 var_dump(sybase_select_ex($db, 'print "Hi"'));
41 var_dump(sybase_select_ex($db, 'use NULL'));
42 var_dump(sybase_select_ex($db, 'select convert(datetime, "notadate")'));
48 >>> Query: select getdate(NULL)
57 Cannot handle message #156
59 Warning: sybase_query(): Sybase: Server message: Incorrect syntax near the keyword 'NULL'.
60 (severity 15, procedure N/A) in %s on line %d
63 >>> Query: select convert(datetime, "notadate")
64 Cannot handle message #249
66 Warning: sybase_query(): Sybase: Server message: Syntax error during explicit conversion of VARCHAR value 'notadate' to a DATETIME field.
67 (severity 16, procedure N/A) in %s on line %d