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     ! 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.