ALTER PROC [dbo]. [AAA]
(
@AgencyID int,--Reseller ID
@AdminID INT--settlement operator ID (Administrator ID)
)
As
Begin
Select Top 5 * from Tusers
Return 5
End
$dbh = DB::connection()-getpdo(); $stmt = prepare("EXEC aaa?,?" $DBH ); //web_pagencybalance_single $a = 1; $b = 2; $stmt,bindparam(1, $a, \PDO::param_int); $stmt,bindparam(2, $b, \PDO::param_int); $stmt, execute(); $s = $stmt-fetchall(\PDO::fetch_assoc); //$s = $stmt->query ("select @r");//->fetchall (\PDO::FETCH_ASSOC); print_r($c); print_r($s); Results-------------------------------------------------------------------------------0Array ([0] = = Array ([UserID] = 7518 [UserName] = 12345678544 [Pass] = 4297f44b13955235245b2497399d7a93 [Twopassword] = 4297f44b13955235245b2497399d7a93 [Nickname] = 121123 [Logoid] = 0 [LogoFileMD5] = [Token] = [Onlineflag] + 0 [Disabled] = 0 [Sex] = 0 [Isrobot] + 0 [Agencyid] + 1 [agencyname] + Admin [Salt] = [Ismodifytwopassword] = 0 [Bindalipay] = [Bindalipayname] = [Isbindalipay] + 0) [1] = A Rray ([UserID] = 34946 [UserName] = 15618478590 [Pass] = d41d8cd98f00b204e9800998ecf8427e [Twopassword] = = d41d8cd98f00b204e9800998ecf8427e [Nickname] = test111 [Logoid] = 0 [LogoFileMD5] = [Token] [Onlineflag] + 0 [Disabled] + 0 [Sex] = 0 [Isrobot] = 0 [Agencyid] + 1 [agencyname] + admin [Salt] = [Ismo Difytwopassword] = 0 [Bindalipay] = [Bindalipayname] = [Isbindalipay] = 0) [2] = = Array ([UserID] =&G T 43016 [UserName] = 43016 [Pass] = 972dd7e894fe7fbc5844bc66d02e66c3 [Twopassword] = 972dd7e894fe7fbc5844bc66d02e66c3 [NickName] =& Gt 43016 [Logoid] = 0 [LogoFileMD5] = [Token] + [Onlineflag] = 0 [Disabled] = 0 [Sex] = 0 [Isrobot] = > 0 [Agencyid] = 0 [Agencyname] = daili0001 [Salt] = [Ismodifytwopassword] + 0 [Bindalipay] = [Bind Alipayname] = [Isbindalipay] + 0) [3] = = Array ([UserID] = 51894 [UserName] = 13061767771 [Pass] => ; 3333333 [Twopassword] = 3333333 [nickname] + Reese ' s [logoid] = 0 [LogoFileMD5] = [Token] = [Onlinefla G] + 0 [Disabled] = 0 [Sex] = 0 [Isrobot] = 0 [Agencyid] + 1 [agencyname] + admin [Salt] = [is Modifytwopassword] = 1 [Bindalipay] = [Bindalipayname] = [Isbindalipay] = 0) [4] = = Array ([UserID] = > 53492 [UserName] = 53492 [Pass] = f7ad15746f953382379000261beba6a0 [Twopassword] = f7ad15746f953382379000261beba6a0 [Nickname] + 53492 [logoid] + 0 [LogoFileMD5] = [Token] [Onlineflag] = 0 [Disabled] + 0 [Sex] + 0 [IsR Obot] + 0 [Agencyid] = 0 [Agencyname] = daili0001 [Salt] = [Ismodifytwopassword] = 0 [Bindalipay] => ; [Bindalipayname] [Isbindalipay] = 0))
Laravel calls SQL Server stored procedures