How to call SQL Server stored procedure in Laravel with out parameter

Question

My problem is to call a stored procedure in SQL Server - Framework Laravel

I read the following post Laravel Model SQL Server: Get Output Parameters from Stored Procedure

But that did not work!

My stored procedure is:

ALTER PROCEDURE GetUsers1 
    @namein VARCHAR(10),
    @idn INT,
    @emailin VARCHAR(50),
    @Xout INT OUTPUT
AS
BEGIN
    SELECT * 
    FROM dbo.users 
    WHERE name = @namein 
      AND id = @idn 
      AND email = @emailin

    SELECT @Xout = @@ROWCOUNT
END

how to get Xout Parameter in Laravel or PHP?

Luis Gabriel Chavez Ramos · Accepted Answer · 2020-07-02 00:39:04Z

1

        $namein = 'namein';       
        $idn = 1;
        $emailin = 'emailin';
        $Xout = 1;        
       
        DB::statement('CALL GetUsers1 (?, ?, ?, ?, @Xout);',
            array(
                $TParCategoriaFk,
                $Exito,
                $ResultadoJson,
                $Mensaje
            )
        );
        $results = DB::select('select @Xout as Xout');
        
        echo($results[0]->Xout);

answered Jul 2, 2020 at 0:39

Luis Gabriel Chavez Ramos

172 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to call SQL Server stored procedure in Laravel with out parameter

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related