Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:15929
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
	s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding;
	b=U/6x1vOJDd0xuyTeVWCgolXEaKw7q54XccP6ExePHlSPJB3S2zJaTg5jtrdZIHz/9lQpz9YOsOJm/65Hfml+z3wK+S7LotvM3yVvn1sxFvSKpQbJ54gpwwKP/PB/4xtg0OWeg8xqGz1ZOUSkDo5lj7hEmne1EpyoNnH30wqovEw=
Message-ID: <fbb0d11d05040907335fb22875@mail.gmail.com>
Date: Sat, 9 Apr 2005 10:33:32 -0400
Reply-To: Dan Scott <denials@gmail.com>
To: internals@lists.php.net
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Subject: PDO proposal: add PDOStatement::nextResult() method to support stored procedures
From: denials@gmail.com (Dan Scott)

Wez et al:

I've been writing a chapter on database programming with PHP, using
PDO, and ran across a scenario that has not yet been fulfilled by the
PDO API. Many databases (Apache Derby, DB2, Microsoft SQL Server,
MySQL 5, and PostgreSQL to a certain extent) support stored procedures
that can return multiple result sets. Database APIs typically set the
result set pointer to the first row of the first result set returned,
allow the application to iterate through the rows, and provide some
method to request the second result set from the database server.

In ODBC, for example, you would call SQLFetch() to iterate through the
rows of the first result set, then call SQLNextResult() to request the
next result set.

In the PHP realm, Unified ODBC defines odbc_next_result(); mssql
defines mssql_next_result(); PEAR::DB defines DB_Result:nextResult().

PDO, however, currently provides no means of working with the second
or subsequent result sets returned from a call to a stored procedure.

To build on the established naming practice from existing database
extensions, I propose that the PDO interface define the standard
method:
/* {{{ proto bool PDOStatement::nextResult(void)
Requests the next result set from the database
*/

Thanks,
Dan

Note: somewhat confusingly, mysqli defines mysqli_next_result(), but
this is used to retrieve the results of a multi-query... a very
different thing, and not something I advocate adding to PDO. They
might have trouble disambiguating that from the stored procedure case
when MySQL 5 reaches production status.