Support the ongoing development of Laravel.io →
posted 9 years ago
Database
Last updated 1 year ago.
0

This is a bad way but works for me ... It has 2 input values and 2 output

		$var1= 'data1;
		$var2 = 'data2';
		$out1 = ''; // output 1 
		$out2 = ''; // output 2

		$db = DB::connection()->getPdo();

		$stmt = $db->prepare("EXEC dbo.ur_st_name ?,?,?,? ");
		
		$stmt->bindParam(1, $var1);
		$stmt->bindParam(2, $var2);
		$stmt->bindParam(3, $out1);
		$stmt->bindParam(4, $out2);

		$stmt->execute();

		$search = array();
		//dd($stmt);		
		do {
		    $search = $stmt->fetchAll(PDO::FETCH_ASSOC);
		} while ($stmt->nextRowset());

              dd($search); // to see the result
Last updated 1 year ago.
0

Thank you rafahoiro,

You put me in the right way, above all ;)

0

Sign in to participate in this thread!

Eventy

Your banner here too?

gin93r gin93r Joined 3 Apr 2014

Moderators

We'd like to thank these amazing companies for supporting us

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

© 2024 Laravel.io - All rights reserved.