Call Stored Procedure SQL and Pass Value

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

Call Stored Procedure SQL and Pass Value

Post by Fakiro82 »

Hi,
How can I call stored procedure (SQL Database) and pass value in PhpMaker from custom button or in another way?
Now, my code is this:

    $OrderID = $_GET['OrderId'];
$CustomerCode = $_GET['CustomerCode'];
$params = array(
array($OrderID, SQLSRV_PARAM_IN),
array($CustomerCode, SQLSRV_PARAM_IN)
);
$SQL = "{CALL My_Insert(?,?)}";

but not works.

Thank you,
Andrea


arbei
User
Posts: 9292

Post by arbei »


Post Reply