sql server - PDO dblib get result from stored procedure -
I have problems in getting results from the stored procedure on MSSQL Server 2012. PHP 5.4.34, dblib, PDO Using CentOS Aianaiti:
$ this- & gt; PDO = new PDO ( 'Dibibi: host = 88.88) I am on my dev where I use everything sqlsrv extension for PHP is fine. .88.88; dbname = dbName ', $ connection [to' login '], $ connection [']);
or call the process:
$ sqlStr = "DECLARE @price decimal (15, 4), @ Aryuestiel Tinint, @ Ar_mess varchar (1000 ), @act_list char (16), @act_list_poradi smallint; EXEC [dba]. [Get_price] @arg_id_cust = ?, @arg_cislo_nomenklatury = ?, @arg_mnozstvi = ?, @ Arg_id_mj = ?, @typ_param =?, @ value = @ Price OUTPUT, @ resutl = @resutl OUTPUT, @err_message = @err_message OUTPUT, @act_list = @act_list Output, @act_list_poradi = @act_list_poradi OUTPUT; SELECT as @price "; $ Sth = $ this- & gt; Kppso- & gt; Ready ($ sqlStr); If ($ sth) {$ sth- & gt; Bindamparam (1, $ idCust); $ Sth- & gt; Baidam Parm (2, $ idNomen); $ Sth- & gt; Bind Parm (3, $ KS); $ Sth- & gt; Baidumparam (4, $ MJ); $ Sth- & gt; Binduparam (5, $ param); $ Res = $ sth- & gt; carry about (); } And (throwing the new exception ('Chaabi statement');} $ res is true, but the $ sth-> fetch () return is incorrect and no error is ommited. Thanks for any help
Comments
Post a Comment