Return to test_fields.phpt CVS log

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

Annotation of embedaddon/php/ext/sybase_ct/tests/test_fields.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: Sybase-CT sybase_field_* functions
                      3: --SKIPIF--
                      4: <?php require('skipif.inc'); ?>
                      5: --FILE--
                      6: <?php
                      7: /* This file is part of PHP test framework for ext/sybase_ct
                      8:  *
                      9:  * $Id: test_fields.phpt 231839 2007-03-14 11:44:24Z thekid $ 
                     10:  */
                     11: 
                     12:   require('test.inc');
                     13: 
                     14:   $db= sybase_connect_ex();
                     15: 
                     16:   // Issue a query
                     17:   $q= sybase_unbuffered_query('select
                     18:     1 as "id",
                     19:     "Hello" as "caption",
                     20:     "timm" as "author",
                     21:     getdate() as "lastchange"
                     22:   ', $db, FALSE);
                     23:   var_dump($q);
                     24: 
                     25:   var_dump(sybase_num_fields($q));
                     26: 
                     27:   // Go through each field, dumping it
                     28:   while ($field= sybase_fetch_field($q)) {
                     29:     var_export($field); echo "\n";
                     30:   }
                     31:   
                     32:   // Seek to the second field and fetch it
                     33:  var_dump(sybase_field_seek($q, 1));
                     34:  var_export(sybase_fetch_field($q)); echo "\n";
                     35: 
                     36:  sybase_close($db);
                     37: ?>
                     38: --EXPECTF--
                     39: resource(%d) of type (sybase-ct result)
                     40: int(4)
                     41: stdClass::__set_state(array(
                     42:    'name' => 'id',
                     43:    'max_length' => 11,
                     44:    'column_source' => '',
                     45:    'numeric' => 1,
                     46:    'type' => 'int',
                     47: ))
                     48: stdClass::__set_state(array(
                     49:    'name' => 'caption',
                     50:    'max_length' => 5,
                     51:    'column_source' => '',
                     52:    'numeric' => 0,
                     53:    'type' => 'string',
                     54: ))
                     55: stdClass::__set_state(array(
                     56:    'name' => 'author',
                     57:    'max_length' => 4,
                     58:    'column_source' => '',
                     59:    'numeric' => 0,
                     60:    'type' => 'string',
                     61: ))
                     62: stdClass::__set_state(array(
                     63:    'name' => 'lastchange',
                     64:    'max_length' => 29,
                     65:    'column_source' => '',
                     66:    'numeric' => 0,
                     67:    'type' => 'datetime',
                     68: ))
                     69: bool(true)
                     70: stdClass::__set_state(array(
                     71:    'name' => 'caption',
                     72:    'max_length' => 5,
                     73:    'column_source' => '',
                     74:    'numeric' => 0,
                     75:    'type' => 'string',
                     76: ))