xref: /php-src/ext/pdo_odbc/tests/pdoodbc_002.phpt (revision d6a0b3af) 
1--TEST--
2PDO_mysql connect through PDO::connect
3--EXTENSIONS--
4PDO_odbc
5--SKIPIF--
6<?php
7require 'ext/pdo/tests/pdo_test.inc';
8PDOTest::skip();
9?>
10--FILE--
11<?php
12
13require 'ext/pdo/tests/pdo_test.inc';
14$config = PDOTest::get_config(__DIR__ . "/common.phpt");
15$db = PdoOdbc::connect($config['ENV']['PDOTEST_DSN'], $config['ENV']['PDOTEST_USER'], $config['ENV']['PDOTEST_PASS']);
16if (!$db instanceof PdoOdbc) {
17    echo "Wrong class type. Should be PdoOdbc but is " . get_class($db) . "\n";
18}
19
20$db->exec('CREATE TABLE pdoodbc_002(id INT NOT NULL PRIMARY KEY, name VARCHAR(10))');
21$db->exec("INSERT INTO pdoodbc_002 VALUES(1, 'A'), (2, 'B'), (3, 'C')");
22
23foreach ($db->query('SELECT name FROM pdoodbc_002') as $row) {
24    var_dump($row);
25}
26
27echo "Fin.";
28?>
29--CLEAN--
30<?php
31require 'ext/pdo/tests/pdo_test.inc';
32$db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
33$db->exec("DROP TABLE IF EXISTS pdoodbc_002");
34?>
35--EXPECT--
36array(2) {
37  ["name"]=>
38  string(1) "A"
39  [0]=>
40  string(1) "A"
41}
42array(2) {
43  ["name"]=>
44  string(1) "B"
45  [0]=>
46  string(1) "B"
47}
48array(2) {
49  ["name"]=>
50  string(1) "C"
51  [0]=>
52  string(1) "C"
53}
54Fin.
55