Call a Procedure with PHP

Question

Question

Flávio Lúcio Na... · Nov 17, 2019

Hello everyone,

I am searching, but i cannot find a way to call a Procedure in Caché with PHP. Using .NET we have the Intersystems.Data.CacheClient.CacheCommand and we make a call in a Procedure. How i can do the same in PHP?

Regards,
Flávio

Discussion (5)1

Log in or sign up to continue

Evgeny Shvarov · Nov 18, 2019

Hi @Flávio Lúcio Naves Júnior !

Have you seen the IRIS PHP module and Caché PHP modules?

I don't see Classmethod API call there but there is 'xecute' command, so you can call the procedure.

Also check the related article by @Sergey Kamenev

And this is open source, so you can add it if you want.

1 0

score 1 · Answer 1 · 2019-11-18T03:40:43-05:00

I faced a similar issue some years back.

As PHP is so close to web servers I decided to use a WebsService to call the ClassMethod aka Procedure.
It was easy on both ends and I could avoid the ODBC module (at that time only 32bit)

score 0 · Answer 2 · 2019-11-25T11:29:03-05:00

Hi Robert,

Do you know some article who teach how to create the Web Service to make a call? The Caché PHP module, didn't work for me, because works only locally.

Regards,
Flávio.

score 0 · Answer 3 · 2019-11-25T12:27:00-05:00

sorry. this was done by a PHP developer back in 2008/2009.

the <Caché side was default from the wizard.

I have no idea about the details anymore.

score 1 · Answer 4 · 2019-11-18T05:47:14-05:00

Robert Cemper · Nov 18, 2019

Great stuff!

just a few years to late for me but good for future projects

1 0