MySql procedure

This public forum is for user-to-user discussions of PHPMaker. Note that this is not support forum.
Post Reply
Boca
User
Posts: 30

MySql procedure

Post by Boca »

Hello guys,
How do I run a MySql procedure in Server Event / Login Page / Page Render?
I tried $ result = ew_Execute ("CALL procedure ()") and it gives error.
thankful


mobhar
User
Posts: 11660

Post by mobhar »

Please post the error message for more discussion.


Boca
User
Posts: 30

Post by Boca »

$query = "CALL atu_historico()";
$result = ew_Execute($query) or die("Erro SQL: " . $query);

 Erro SQL: CALL atu_historico()

mobhar
User
Posts: 11660

Post by mobhar »

Change this code:
$result = ew_Execute($query) or die("Erro SQL: " . $query);

to:
$result = Conn()->Execute($query) or die("Erro SQL: " . $query);


Boca
User
Posts: 30

Post by Boca »

The same error


Post Reply