1--TEST-- 2Sybase-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$ 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-- 39resource(%d) of type (sybase-ct result) 40int(4) 41stdClass::__set_state(array( 42 'name' => 'id', 43 'max_length' => 11, 44 'column_source' => '', 45 'numeric' => 1, 46 'type' => 'int', 47)) 48stdClass::__set_state(array( 49 'name' => 'caption', 50 'max_length' => 5, 51 'column_source' => '', 52 'numeric' => 0, 53 'type' => 'string', 54)) 55stdClass::__set_state(array( 56 'name' => 'author', 57 'max_length' => 4, 58 'column_source' => '', 59 'numeric' => 0, 60 'type' => 'string', 61)) 62stdClass::__set_state(array( 63 'name' => 'lastchange', 64 'max_length' => 29, 65 'column_source' => '', 66 'numeric' => 0, 67 'type' => 'datetime', 68)) 69bool(true) 70stdClass::__set_state(array( 71 'name' => 'caption', 72 'max_length' => 5, 73 'column_source' => '', 74 'numeric' => 0, 75 'type' => 'string', 76)) 77