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
|
--TEST--
Sybase-CT unbuffered query
--SKIPIF--
<?php require('skipif.inc'); ?>
--FILE--
<?php
/* This file is part of PHP test framework for ext/sybase_ct
*
* $Id: test_unbuffered_query.phpt,v 1.3.6.1 2007/05/22 11:33:36 thekid Exp $
*/
require('test.inc');
$db= sybase_connect_ex();
var_dump($db);
// Test #1: num_rows
$q= sybase_unbuffered_query('select name from master..systypes', $db);
var_dump($q);
$i= 0;
while ($r= sybase_fetch_assoc($q)) {
$i++;
}
var_dump($i, sybase_num_rows($q), $i == sybase_num_rows($q), $q);
sybase_free_result($q);
var_dump($q);
// Test #2: after sybase_free_result, this should be an invalid resource
var_dump(FALSE == sybase_num_rows($q));
// Test #3: Seeking
$q= sybase_unbuffered_query('select name from master..systypes', $db);
var_dump($q);
$j= 0;
sybase_data_seek($q, 4);
while ($r= sybase_fetch_assoc($q)) {
$j++;
}
var_dump($i, $j, $i - $j);
sybase_close($db);
?>
--EXPECTF--
resource(%d) of type (sybase-ct link)
resource(%d) of type (sybase-ct result)
int(%d)
int(%d)
bool(true)
resource(%d) of type (sybase-ct result)
resource(%d) of type (Unknown)
Warning: sybase_num_rows(): %d is not a valid Sybase result resource in %stest_unbuffered_query.php on line %d
bool(true)
resource(%d) of type (sybase-ct result)
int(%d)
int(%d)
int(4)
|
