History log of /PHP-5.5/ext/pdo/pdo_stmt.c (Results 226 – 250 of 282)
Revision (<<< Hide revision tags) (Show revision tags >>>) Date Author Comments
# 544d6187 19-Jan-2005 Wez Furlong

proto bool PDOStatement::nextRowset()

Advances to the next rowset in a multi-rowset statement handle. Returns true if
it succeded, false otherwise


# a9d98544 18-Jan-2005 Wez Furlong

Allow drivers to select bind emulation on a per statement basis


# 8b35436c 18-Jan-2005 Wez Furlong

remove error and hook up rowCount


# 37ea5fbe 17-Jan-2005 Wez Furlong

Tidy up driver specific method handling


# dd842e4b 12-Jan-2005 Wez Furlong

API support for scrollable cursors


# 076bc75c 12-Jan-2005 Wez Furlong

add theoretical support for returning ints as ints and bools as bools.
individual drivers need to support returning data in these formats.


# 6e0d8dd0 07-Jan-2005 Wez Furlong

implement SQLSTATE style error codes.
Allow drivers to add methods to dbh and stmt objects
(note that we can't use a class, because the use only sees the PDO class).
Clarify the api sligh

implement SQLSTATE style error codes.
Allow drivers to add methods to dbh and stmt objects
(note that we can't use a class, because the use only sees the PDO class).
Clarify the api slightly:
PDO::exec() is used for one-shot queries that don't return rows
PDO::query() is a convenience function for returning a rowset without
having to go through the steps of preparing and executing.

show more ...


# 73186934 27-Dec-2004 Wez Furlong

more get_method signature changes


Revision tags: php-5.0.3, php-4.3.10, SQLITE_4_3_20041227, php-5.0.3RC2, php-4.3.10RC2, php-5.0.3RC1, php-4.3.10RC1
# dbd71759 28-Oct-2004 Marcus Boerger

- TSRM Fix


# 35b00ffd 27-Oct-2004 Wez Furlong

Synopsis:

PDOStatement::setFetchMode()
reset default fetch() mode for a statement to PDO_FETCH_BOTH

PDOStatement::setFetchMode(PDO_FETCH_NUM)
PDOStatement::setFetchM

Synopsis:

PDOStatement::setFetchMode()
reset default fetch() mode for a statement to PDO_FETCH_BOTH

PDOStatement::setFetchMode(PDO_FETCH_NUM)
PDOStatement::setFetchMode(PDO_FETCH_ASSOC)
PDOStatement::setFetchMode(PDO_FETCH_BOTH)
PDOStatement::setFetchMode(PDO_FETCH_OBJ)
set default fetch() mode for a statement.

PDOStatement::setFetchMode(PDO_FETCH_COLUMN, int colno)
set default fetch() mode to retrieve colno-th column on each fetch() call.

PDOStatement::setFetchMode(PDO_FETCH_CLASS, string classname [, array ctor args])
set default fetch() mode to create an instance of classname,
calling it's ctor, passing the optional ctor args.
The names of the columns in the result set will be used as property names on
the object instance. PPP rules apply.

[NOTE: calling ctor is not yet implemented]
[TODO: this might crash PHP for persistent PDO handles]

PDOStatement::setFetchMode(PDO_FETCH_INTO, object obj)
Similar to PDO_FETCH_CLASS, except that each iteration will update the
supplied object properties.

[TODO: this might crash PHP for persistent PDO handles]

The default fetch() mode is used when no parameters are passed to
PDOStatement::fetch(). When using a statement in an iterator context,
PDOStatement::fetch() is called implicitly on each iteration.

object PDO::queryAndIterate(string sql, <PDOStatement::setFetchMode args>)
This is semantically equivalent to:

$stmt = $pdo->prepare($sql);
$stmt->execute();
$stmt->setFetchMode($args);
return $stmt;


Example/Intended usage:

/* fetch an array with numeric and string keys */
foreach ($pdo->queryAndIterate("select NAME, VALUE from test") as $row) {
debug_zval_dump($row);
}

/* fetch the value of column 1 into $row on each iteration */
foreach ($pdo->queryAndIterate("select NAME, VALUE from test",
PDO_FETCH_COLUMN, 1) as $row) {
debug_zval_dump($row); // string(3) "foo"
}

/* create a new instance of class Foo on each iteration */
foreach ($pdo->queryAndIterate("select NAME, VALUE from test",
PDO_FETCH_CLASS, 'Foo') as $row) {
debug_zval_dump($row);
/*
Object(Foo)#4 (2) refcount(2){
["NAME"]=>
string(12) "foo220051429" refcount(2)
["VALUE"]=>
string(12) "bar789825748" refcount(2)
}
*/
}

etc.

show more ...


Revision tags: PRE_NEW_VM_GEN_PATCH
# eb0cd48d 26-Sep-2004 Wez Furlong

Add rough cut at fetching meta data.


Revision tags: php-5.0.2, php-4.3.9, php-5.0.2RC1, php-4.3.9RC3, PRE_ZEND_VM_DISPATCH_PATCH, php-4.3.9RC2, php-5.0.1, php-5.0.1RC2, php-4.3.9RC1, php-5.0.1RC1, RELEASE_0_1
# 0d002664 19-Jul-2004 Wez Furlong

Implement empty-string-to-null conversion option for oracle compat.
This can be enabled using:
$dbh->setAttribute(PDO_ATTR_ORACLE_NULLS, true);


Revision tags: php-5.0.0RC4, php-5.0.0, php-4.3.8
# 905fbfd8 12-Jul-2004 Ilia Alshanetsky

Added missing constant and correct bound column retrieval. When bound
columns are specified only return status (TRUE/FALSE) indicator.


# 41b639ff 09-Jul-2004 Ilia Alshanetsky

Fixed function proto.


# 2ba792cd 05-Jul-2004 Ilia Alshanetsky

Don't use alloca() where it can reached by the users.


# f9139589 15-Jun-2004 Ard Biesheuvel

Un-revert param index fix


# e48d1272 15-Jun-2004 Ard Biesheuvel

Revert (at Wez's request)


# 1d7a4ed4 13-Jun-2004 Ard Biesheuvel

Report param binding error


# 50ac5db2 12-Jun-2004 Ard Biesheuvel

Added double param type
Added param struct initialiser
Reversed param parsing order (long <=> string)


Revision tags: php-5.0.0RC3, php-5.0.0RC3RC2, php-4.3.7, php-5.0.0RC3RC1
# d2a8d5a8 25-May-2004 Wez Furlong

get/set attributes for statements


# 7a87af33 25-May-2004 Wez Furlong

Some definitions for cursors.
Define a mechanism for driver-specific attributes.
Use a refcount for the stmt structure.


# cf75eb8a 25-May-2004 Ilia Alshanetsky

Cleanup.


# 402de24f 25-May-2004 Ilia Alshanetsky

One more leak down.


# b7ecaca1 25-May-2004 Ilia Alshanetsky

More leak fixes.


# 0c762dff 25-May-2004 Ilia Alshanetsky

More possible leak fixes (Thanks Tony).


12345678910>>...12