简单示例 p>
CREATE PROCEDURE [dbo]。[InsertLoginInPHP ]
@login为nvarchar(50),@ password为nvarchar(50),@ resultOK为int,@ resultnot为int
AS
BEGIN
SET @resultOK = 10
SET @resultnot = 1
如果EXISTS(SELECT * FROM Users WHERE Login = @login)
BEGIN
SELECT @resultnot as return // 1
END
ELSE
BEGIN
INSERT INTO Users(Login,Password)VALUES(@ login,@ password)
SELECT @resultOK as return // 10
END
END
code> pre>
and in php strong> p >
$ query =(“EXECUTE InsertLogin:login,:password”);
$ query_stored = $ conn-> prepare($ query);
$ query_stored-> bindvalue (':login',$ login);
$ query_stored-> bindvalue(':password',$ password);
$ query_stored-> execute();
code> pre>
如何在php中获取返回值(@resultnot或@resultOK)? strong >
如何在JSON中获取和使用返回值? strong>
这个 p>
json_encode(array('status'=>' 好的','return'=> $ query_sotored [resultOK])));
code> pre>
div>