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
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community