summaryrefslogtreecommitdiff
path: root/ext/sybase_ct/tests/test_fields.phpt
blob: cda606ab21151267c7e02e695c03b72f31fcdf37 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
--TEST--
Sybase-CT sybase_field_* functions
--SKIPIF--
<?php require('skipif.inc'); ?>
--FILE--
<?php
/* This file is part of PHP test framework for ext/sybase_ct
 *
 * $Id$ 
 */

  require('test.inc');

  $db= sybase_connect_ex();

  // Issue a query
  $q= sybase_unbuffered_query('select
    1 as "id",
    "Hello" as "caption",
    "timm" as "author",
    getdate() as "lastchange"
  ', $db, FALSE);
  var_dump($q);

  var_dump(sybase_num_fields($q));

  // Go through each field, dumping it
  while ($field= sybase_fetch_field($q)) {
    var_export($field); echo "\n";
  }
  
  // Seek to the second field and fetch it
 var_dump(sybase_field_seek($q, 1));
 var_export(sybase_fetch_field($q)); echo "\n";

 sybase_close($db);
?>
--EXPECTF--
resource(%d) of type (sybase-ct result)
int(4)
class stdClass {
  %s $name = 'id';
  %s $max_length = 11;
  %s $column_source = '';
  %s $numeric = 1;
  %s $type = 'int';
}
class stdClass {
  %s $name = 'caption';
  %s $max_length = 5;
  %s $column_source = '';
  %s $numeric = 0;
  %s $type = 'string';
}
class stdClass {
  %s $name = 'author';
  %s $max_length = 4;
  %s $column_source = '';
  %s $numeric = 0;
  %s $type = 'string';
}
class stdClass {
  %s $name = 'lastchange';
  %s $max_length = 29;
  %s $column_source = '';
  %s $numeric = 0;
  %s $type = 'datetime';
}
bool(true)
class stdClass {
  %s $name = 'caption';
  %s $max_length = 5;
  %s $column_source = '';
  %s $numeric = 0;
  %s $type = 'string';
}