History log of /PHP-7.0/ext/pdo/pdo_stmt.c (Results 301 – 325 of 364)
Revision (<<< Hide revision tags) (Show revision tags >>>) Date Author Comments
# e3ba31e8 06-Feb-2005 Wez Furlong

better handling of pdo-level errors


# b2126a84 06-Feb-2005 Wez Furlong

This will probably fix PECL Bug #3273


# 64e8c310 05-Feb-2005 Edin Kadribasic

Return lobs as strings for now


# 15e75420 05-Feb-2005 Wez Furlong

pass param type to quoter functions


# 6ddbfa07 21-Jan-2005 Wez Furlong

Revise query parser so that it can rewrite from one bind syntax to another.
Expose it as PDO_API. No drivers utilize this feature yet.


# a39d50c9 19-Jan-2005 Wez Furlong

don't propogate an unspecified length to the driver.
Drivers will used a 0 length as a hint that the parameter is an in-out or out
parameter.


# a536e31f 19-Jan-2005 Wez Furlong

leak/segv less


# 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


1...<<1112131415