Return to bug_47588.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / pdo_dblib / tests

Annotation of embedaddon/php/ext/pdo_dblib/tests/bug_47588.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: PDO_DBLIB: Quoted field names
                      3: --SKIPIF--
                      4: <?php
                      5: if (!extension_loaded('pdo_dblib')) die('skip not loaded');
                      6: require dirname(__FILE__) . '/config.inc';
                      7: ?>
                      8: --FILE--
                      9: <?php
                     10: require dirname(__FILE__) . '/config.inc';
                     11: 
                     12: $db->query('CREATE TABLE "Test Table" ("My Field" int, "Another Field" varchar(32) not null default \'test_string\')');
                     13: $db->query('INSERT INTO "Test Table" ("My Field") values(1)');
                     14: $db->query('INSERT INTO "Test Table" ("My Field") values(2)');
                     15: $db->query('INSERT INTO "Test Table" ("My Field") values(3)');
                     16: $rs = $db->query('SELECT * FROM "Test Table"');
                     17: var_dump($rs->fetchAll(PDO::FETCH_ASSOC));
                     18: $db->query('DROP TABLE "Test Table"');
                     19: echo "Done.\n";
                     20: ?>
                     21: --EXPECT--
                     22: array(3) {
                     23:   [0]=>
                     24:   array(2) {
                     25:     ["My Field"]=>
                     26:     string(1) "1"
                     27:     ["Another Field"]=>
                     28:     string(11) "test_string"
                     29:   }
                     30:   [1]=>
                     31:   array(2) {
                     32:     ["My Field"]=>
                     33:     string(1) "2"
                     34:     ["Another Field"]=>
                     35:     string(11) "test_string"
                     36:   }
                     37:   [2]=>
                     38:   array(2) {
                     39:     ["My Field"]=>
                     40:     string(1) "3"
                     41:     ["Another Field"]=>
                     42:     string(11) "test_string"
                     43:   }
                     44: }
                     45: Done.