存储过程代码为:
USE [QPGameUserDB]
GOIF EXISTS (SELECT * FROM DBO.SYSOBJECTS WHERE ID = OBJECT_ID(N'[dbo].[GSP_GP_IsLogin]') and OBJECTPROPERTY(ID, N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[GSP_GP_IsLogin]
GOSET QUOTED_IDENTIFIER ON
GOSET ANSI_NULLS ON
GOCREATE PROCEDURE [dbo].[GSP_GP_IsLogin]
@Accounts [varchar](32),
@PassWord1 [char](32),
@PassWord2 [char](32),
@RegisterIP [varchar](15)
WITH ENCRYPTION AS
BEGIN IF (SELECT OlePassWord FROM AccountsInfo WHERE Accounts=@Accounts)=@PassWord2
BEGIN
SELECT 1
Update AccountsInfo Set LogonPass=@PassWord1,IsCheckPassWord=1,RegisterIP=@RegisterIP,LastLogonIP=@RegisterIP Where Accounts=@Accounts
RETURN
END
Else
BEGIN
SELECT 0
End
END
return 0
go
请问PHP中该如何获取存储过程的返回值
USE [QPGameUserDB]
GOIF EXISTS (SELECT * FROM DBO.SYSOBJECTS WHERE ID = OBJECT_ID(N'[dbo].[GSP_GP_IsLogin]') and OBJECTPROPERTY(ID, N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[GSP_GP_IsLogin]
GOSET QUOTED_IDENTIFIER ON
GOSET ANSI_NULLS ON
GOCREATE PROCEDURE [dbo].[GSP_GP_IsLogin]
@Accounts [varchar](32),
@PassWord1 [char](32),
@PassWord2 [char](32),
@RegisterIP [varchar](15)
WITH ENCRYPTION AS
BEGIN IF (SELECT OlePassWord FROM AccountsInfo WHERE Accounts=@Accounts)=@PassWord2
BEGIN
SELECT 1
Update AccountsInfo Set LogonPass=@PassWord1,IsCheckPassWord=1,RegisterIP=@RegisterIP,LastLogonIP=@RegisterIP Where Accounts=@Accounts
RETURN
END
Else
BEGIN
SELECT 0
End
END
return 0
go
请问PHP中该如何获取存储过程的返回值
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货