xref: /php-src/ext/pdo/tests/pdo_027.phpt (revision f4a5db3e)
1--TEST--
2PDO Common: PDO::FETCH_LAZY
3--EXTENSIONS--
4pdo
5--SKIPIF--
6<?php
7$dir = getenv('REDIR_TEST_DIR');
8if (false == $dir) die('skip no driver');
9require_once $dir . 'pdo_test.inc';
10PDOTest::skip();
11?>
12--FILE--
13<?php
14if (getenv('REDIR_TEST_DIR') === false) putenv('REDIR_TEST_DIR='.__DIR__ . '/../../pdo/tests/');
15require_once getenv('REDIR_TEST_DIR') . 'pdo_test.inc';
16$db = PDOTest::factory();
17
18$db->exec('create table test027 (id int, name varchar(10))');
19$db->exec("INSERT INTO test027 (id,name) VALUES(1,'test1')");
20$db->exec("INSERT INTO test027 (id,name) VALUES(2,'test2')");
21
22foreach ($db->query("SELECT * FROM test027", PDO::FETCH_LAZY) as $v) {
23    echo "lazy: " . $v->id.$v->name."\n";
24}
25echo "End\n";
26?>
27--CLEAN--
28<?php
29require_once getenv('REDIR_TEST_DIR') . 'pdo_test.inc';
30$db = PDOTest::factory();
31PDOTest::dropTableIfExists($db, "test027");
32?>
33--EXPECT--
34lazy: 1test1
35lazy: 2test2
36End
37