Question Re: How to get server messages in PHP Api? in Technology Q&A

How to get server messages in PHP Api?

former_SQLA_member1694966 — Mon, 08 Jan 2024 08:47:55 GMT

Hello, I have a PHP Api which executes various procedures in a Sql Anywhere 17 database. In some of the procedures "messages" are output via the "messsage" function. Is there a way to read these messages in PHP and display them in the frontend? I use the SqlAnywhere PHP extension.

I have already tried to solve it via the system procedure "sa_server_messages()" but unfortunately it is not possible to recognize which connection/user triggered the message.

P.s. I don't want to change the procedures with the messages because they are also used in a desktop application.

Re: How to get server messages in PHP Api?

chris_keating — Mon, 08 Jan 2024 11:58:23 GMT

The procedure sa_server_messages only applies to messages written to the server console.

It sounds like you want message ... to client. This is available in embedded SQL and ODBC requiring a message callback to be registered.

For more information, see MESSAGE STATEMENT.

Re: How to get server messages in PHP Api?

VolkerBarth — Tue, 09 Jan 2024 02:42:45 GMT

Chris, I wonder whether the PHP API (which presumably is based on the SA C API, which offers the sqlany_register_callback() function) does support/offer those callbacks, too?

Re: How to get server messages in PHP Api?

chris_keating — Tue, 09 Jan 2024 09:42:12 GMT

Based on the PHP driver source in %sqlany17%\\SDK\\PHP, I am not able to find any invocations of sqlany_register_callback in the PHP driver implementation.

Re: How to get server messages in PHP Api?

former_SQLA_member1694966 — Fri, 12 Jan 2024 02:17:52 GMT

Chris, so it is not possible to get these messages via PHP cause its not implemented in the driver right. Any ideas how i can provide those messages for users in a web application? Maybe i should add the message(s) as a result set to the procedure.

Re: How to get server messages in PHP Api?

VolkerBarth — Fri, 12 Jan 2024 04:15:47 GMT

so it is not possible to get these messages via PHP cause its not implemented in the driver right.

Well, technically the driver's source code is available in the SQL Anywhere installation (see Chris's comment), so in case you are familiar with C and PHP programming, you might be able to enhance the driver to add an according callback facility. My knowledge of PHP is rather limited, so I can't tell whether this is doable and how difficult this would be - AFAIK, PHP itself does support callback functions, and the underlying SQL Anywhere C API does provide that according sqlany_register_callback with type CALLBACK_MESSAGE, so there should be chances it will work.

That being said, it is probably way easier to enhance your stored procedures with according result sets...