+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forumdisplay.php?fid=28)
+--- Forum: CodeIgniter 4 Feature Requests (https://forum.codeigniter.com/forumdisplay.php?fid=29)
+--- Thread: Multi ResultSet store procedure: introducing next ResultSet method (/showthread.php?tid=80685)
Multi ResultSet store procedure: introducing next ResultSet method - webpd - 12-02-2021
Hi,
I need a possibility to access to next resultset when I'm calling a store procedure that return a multiple resultset.
I sudgest to insert into system/Database/BaseResult.php this method:
abstract protected function nextResultset(): bool;
This method return false if there aren't other resultset
Then in each DB driver that implements this class is necessary to implement this method.
For example in SQLSRV/Result.php:
public function nextResultset(): bool
{
$this->resultObject=[];
$this->resultArray=[];
return sqlsrv_next_result($this->resultID) ?? false;
}
For example in MySQLi/Result.php:
public function nextResultset(): bool
{
$this->resultObject=[];
$this->resultArray=[];
return $this->resultID->next_result() ?? false;
}
Is possible to insert this method in next release?
Thanks
Andrea