Simple example
CREATE PROCEDURE [dbo].[InsertLoginInPHP]
@login as nvarchar(50), @password as nvarchar(50), @resultOK as int, @resultnot as int
AS
BEGIN
SET @resultOK = 10
SET @resultnot = 1
IF 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
and In php
$query = ("EXECUTE InsertLogin :login, :password");
$query_stored = $conn->prepare($query);
$query_stored->bindvalue(':login', $login);
$query_stored->bindvalue(':password', $password);
$query_stored->execute();
How can I get return value ( @resultnot or @resultOK ) in php? And How can I get and use return value in JSON? Like this
json_encode(array('status'=>'Ok','return'=>$query_sotored[resultOK])));