Gecko [ www.foryou-vip.com ]

Name	Size	Permission	Date
bug_34630.phpt	1.54 KB	-rw-rw-r--	2022-10-31 11:36
bug_34687.phpt	784 B	-rw-rw-r--	2022-10-31 11:36
bug_35671.phpt	1.03 KB	-rw-rw-r--	2022-10-31 11:36
bug_36428.phpt	908 B	-rw-rw-r--	2022-10-31 11:36
bug_36798.phpt	1.05 KB	-rw-rw-r--	2022-10-31 11:36
bug_38253.phpt	1.32 KB	-rw-rw-r--	2022-10-31 11:36
bug_38394.phpt	1.2 KB	-rw-rw-r--	2022-10-31 11:36
bug_39398.phpt	853 B	-rw-rw-r--	2022-10-31 11:36
bug_39656.phpt	1.18 KB	-rw-rw-r--	2022-10-31 11:36
bug_40285.phpt	766 B	-rw-rw-r--	2022-10-31 11:36
bug_42917.phpt	954 B	-rw-rw-r--	2022-10-31 11:36
bug_43130.phpt	1.74 KB	-rw-rw-r--	2022-10-31 11:36
bug_43139.phpt	1.03 KB	-rw-rw-r--	2022-10-31 11:36
bug_43663.phpt	780 B	-rw-rw-r--	2022-10-31 11:36
bug_44159.phpt	1.49 KB	-rw-rw-r--	2022-10-31 11:36
bug_44173.phpt	1.92 KB	-rw-rw-r--	2022-10-31 11:36
bug_44409.phpt	1.11 KB	-rw-rw-r--	2022-10-31 11:36
bug_44861.phpt	2.34 KB	-rw-rw-r--	2022-10-31 11:36
bug_47769.phpt	782 B	-rw-rw-r--	2022-10-31 11:36
bug_50458.phpt	755 B	-rw-rw-r--	2022-10-31 11:36
bug_52098.phpt	1.42 KB	-rw-rw-r--	2022-10-31 11:36
bug_60665.phpt	1.13 KB	-rw-rw-r--	2022-10-31 11:36
bug_61292.phpt	999 B	-rw-rw-r--	2022-10-31 11:36
bug_64172.phpt	1.65 KB	-rw-rw-r--	2022-10-31 11:36
bug_65946.phpt	1.44 KB	-rw-rw-r--	2022-10-31 11:36
bug_69356.phpt	2.24 KB	-rw-rw-r--	2022-10-31 11:36
bug_71447.phpt	2.09 KB	-rw-rw-r--	2022-10-31 11:36
bug_71885.phpt	1.37 KB	-rw-rw-r--	2022-10-31 11:36
bug_72788.phpt	840 B	-rw-rw-r--	2022-10-31 11:36
bug_73234.phpt	975 B	-rw-rw-r--	2022-10-31 11:36
bug_77849.phpt	654 B	-rw-rw-r--	2022-10-31 11:36
bug_77849_2.phpt	361 B	-rw-rw-r--	2022-10-31 11:36
debug_emulated_prepares.phpt	1.67 KB	-rw-rw-r--	2022-10-31 11:36
pdo.inc	124 B	-rw-rw-r--	2022-10-31 11:36
pdo_001.phpt	1.02 KB	-rw-rw-r--	2022-10-31 11:36
pdo_002.phpt	1015 B	-rw-rw-r--	2022-10-31 11:36
pdo_003.phpt	1.18 KB	-rw-rw-r--	2022-10-31 11:36
pdo_004.phpt	1.06 KB	-rw-rw-r--	2022-10-31 11:36
pdo_005.phpt	2.86 KB	-rw-rw-r--	2022-10-31 11:36
pdo_006.phpt	1.35 KB	-rw-rw-r--	2022-10-31 11:36
pdo_007.phpt	1.22 KB	-rw-rw-r--	2022-10-31 11:36
pdo_008.phpt	929 B	-rw-rw-r--	2022-10-31 11:36
pdo_009.phpt	2.44 KB	-rw-rw-r--	2022-10-31 11:36
pdo_010.phpt	2.56 KB	-rw-rw-r--	2022-10-31 11:36
pdo_011.phpt	5.21 KB	-rw-rw-r--	2022-10-31 11:36
pdo_012.phpt	1.81 KB	-rw-rw-r--	2022-10-31 11:36
pdo_013.phpt	1.68 KB	-rw-rw-r--	2022-10-31 11:36
pdo_014.phpt	2.14 KB	-rw-rw-r--	2022-10-31 11:36
pdo_015.phpt	1.98 KB	-rw-rw-r--	2022-10-31 11:36
pdo_016.phpt	3.89 KB	-rw-rw-r--	2022-10-31 11:36
pdo_016a.phpt	3.89 KB	-rw-rw-r--	2022-10-31 11:36
pdo_017.phpt	1.97 KB	-rw-rw-r--	2022-10-31 11:36
pdo_018.phpt	8.48 KB	-rw-rw-r--	2022-10-31 11:36
pdo_019.phpt	1.44 KB	-rw-rw-r--	2022-10-31 11:36
pdo_020.phpt	1.07 KB	-rw-rw-r--	2022-10-31 11:36
pdo_021.phpt	1.57 KB	-rw-rw-r--	2022-10-31 11:36
pdo_022.phpt	1.82 KB	-rw-rw-r--	2022-10-31 11:36
pdo_023.phpt	2.15 KB	-rw-rw-r--	2022-10-31 11:36
pdo_024.phpt	1.24 KB	-rw-rw-r--	2022-10-31 11:36
pdo_025.phpt	2.07 KB	-rw-rw-r--	2022-10-31 11:36
pdo_026.phpt	2.1 KB	-rw-rw-r--	2022-10-31 11:36
pdo_027.phpt	768 B	-rw-rw-r--	2022-10-31 11:36
pdo_028.phpt	1012 B	-rw-rw-r--	2022-10-31 11:36
pdo_029.phpt	2.3 KB	-rw-rw-r--	2022-10-31 11:36
pdo_030.phpt	2.53 KB	-rw-rw-r--	2022-10-31 11:36
pdo_031.phpt	1.2 KB	-rw-rw-r--	2022-10-31 11:36
pdo_032.phpt	1.58 KB	-rw-rw-r--	2022-10-31 11:36
pdo_033.phpt	1.16 KB	-rw-rw-r--	2022-10-31 11:36
pdo_034.phpt	1.58 KB	-rw-rw-r--	2022-10-31 11:36
pdo_035.phpt	484 B	-rw-rw-r--	2022-10-31 11:36
pdo_036.phpt	608 B	-rw-rw-r--	2022-10-31 11:36
pdo_037.phpt	392 B	-rw-rw-r--	2022-10-31 11:36
pdo_038.phpt	1.12 KB	-rw-rw-r--	2022-10-31 11:36
pdo_drivers_basic.phpt	310 B	-rw-rw-r--	2022-10-31 11:36
pdo_drivers_error.phpt	447 B	-rw-rw-r--	2022-10-31 11:36
pdo_dsn_containing_credentials.phpt	1.31 KB	-rw-rw-r--	2022-10-31 11:36
pdo_test.inc	1.9 KB	-rw-rw-r--	2022-10-31 11:36
pdorow.phpt	309 B	-rw-rw-r--	2022-10-31 11:36
pecl_bug_5217.phpt	802 B	-rw-rw-r--	2022-10-31 11:36
pecl_bug_5772.phpt	760 B	-rw-rw-r--	2022-10-31 11:36
pecl_bug_5809.phpt	796 B	-rw-rw-r--	2022-10-31 11:36

Rename

--TEST--
PDO Common: PDO::FETCH_BOUND w/o :
--SKIPIF--
<?php
if (!extension_loaded('pdo')) die('skip');
$dir = getenv('REDIR_TEST_DIR');
if (false == $dir) die('skip no driver');
require_once $dir . 'pdo_test.inc';
if (!strncasecmp(getenv('PDOTEST_DSN'), 'oci', strlen('oci'))) die('skip not relevant for oci driver - cannot reexecute after closing cursors without reparse');
PDOTest::skip();
?>
--FILE--
<?php
if (getenv('REDIR_TEST_DIR') === false) putenv('REDIR_TEST_DIR='.__DIR__ . '/../../pdo/tests/');
require_once getenv('REDIR_TEST_DIR') . 'pdo_test.inc';
$db = PDOTest::factory();

if ($db->getAttribute(PDO::ATTR_DRIVER_NAME) == 'mysql') {
	$db->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);
}

$db->exec('CREATE TABLE test(idx int NOT NULL PRIMARY KEY, txt VARCHAR(20))');
$db->exec('INSERT INTO test VALUES(0, \'String0\')');
$db->exec('INSERT INTO test VALUES(1, \'String1\')');
$db->exec('INSERT INTO test VALUES(2, \'String2\')');

$stmt1 = $db->prepare('SELECT COUNT(idx) FROM test');
$stmt2 = $db->prepare('SELECT idx, txt FROM test ORDER by idx');

$stmt1->execute();
var_dump($stmt1->fetchColumn());
$stmt1 = null;

$stmt2->execute();
$cont = $stmt2->fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_UNIQUE);
var_dump($cont);

echo "===WHILE===\n";

$stmt2->bindColumn('idx', $idx);
$stmt2->bindColumn('txt', $txt);
$stmt2->execute();

while($stmt2->fetch(PDO::FETCH_BOUND)) {
	var_dump(array($idx=>$txt));
}

echo "===ALONE===\n";

$stmt3 = $db->prepare('SELECT txt FROM test WHERE idx=:inp');
$stmt3->bindParam('inp', $idx); /* by foreign name */

$stmt4 = $db->prepare('SELECT idx FROM test WHERE txt=:txt');
$stmt4->bindParam('txt', $txt);  /* using same name */

foreach($cont as $idx => $txt)
{
	var_dump(array($idx=>$txt));
	var_dump($stmt3->execute());

if ($idx == 0) {
		/* portability-wise, you may only bindColumn()s
		 * after execute() has been called at least once */
		$stmt3->bindColumn('txt', $col1);
	}
	var_dump($stmt3->fetch(PDO::FETCH_BOUND));
	$stmt3->closeCursor();

var_dump($stmt4->execute());
	if ($idx == 0) {
		/* portability-wise, you may only bindColumn()s
		 * after execute() has been called at least once */
		$stmt4->bindColumn('idx', $col2);
	}
	var_dump($stmt4->fetch(PDO::FETCH_BOUND));
	$stmt4->closeCursor();
	var_dump(array($col2=>$col1));
}

echo "===REBIND/SAME===\n";

$stmt4->bindColumn('idx', $col1);

foreach($cont as $idx => $txt)
{
	var_dump(array($idx=>$txt));
	var_dump($stmt3->execute());
	var_dump($stmt3->fetch(PDO::FETCH_BOUND));
	$stmt3->closeCursor();
	var_dump($col1);
	var_dump($stmt4->execute());
	var_dump($stmt4->fetch(PDO::FETCH_BOUND));
	$stmt4->closeCursor();
	var_dump($col1);
}

echo "===REBIND/CONFLICT===\n";

$stmt2->bindColumn('idx', $col1);
$stmt2->bindColumn('txt', $col1);
$stmt2->execute();

while($stmt2->fetch(PDO::FETCH_BOUND))
{
	var_dump($col1);
}

?>
--EXPECT--
string(1) "3"
array(3) {
  [0]=>
  string(7) "String0"
  [1]=>
  string(7) "String1"
  [2]=>
  string(7) "String2"
}
===WHILE===
array(1) {
  [0]=>
  string(7) "String0"
}
array(1) {
  [1]=>
  string(7) "String1"
}
array(1) {
  [2]=>
  string(7) "String2"
}
===ALONE===
array(1) {
  [0]=>
  string(7) "String0"
}
bool(true)
bool(true)
bool(true)
bool(true)
array(1) {
  [0]=>
  string(7) "String0"
}
array(1) {
  [1]=>
  string(7) "String1"
}
bool(true)
bool(true)
bool(true)
bool(true)
array(1) {
  [1]=>
  string(7) "String1"
}
array(1) {
  [2]=>
  string(7) "String2"
}
bool(true)
bool(true)
bool(true)
bool(true)
array(1) {
  [2]=>
  string(7) "String2"
}
===REBIND/SAME===
array(1) {
  [0]=>
  string(7) "String0"
}
bool(true)
bool(true)
string(7) "String0"
bool(true)
bool(true)
string(1) "0"
array(1) {
  [1]=>
  string(7) "String1"
}
bool(true)
bool(true)
string(7) "String1"
bool(true)
bool(true)
string(1) "1"
array(1) {
  [2]=>
  string(7) "String2"
}
bool(true)
bool(true)
string(7) "String2"
bool(true)
bool(true)
string(1) "2"
===REBIND/CONFLICT===
string(7) "String0"
string(7) "String1"
string(7) "String2"