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 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119
|
--TEST--
References to result sets - mysqlnd (no copies but references)
--SKIPIF--
<?php
require_once('skipif.inc');
require_once('skipifemb.inc');
require_once('skipifconnectfailure.inc');
require_once('connect.inc');
if (!$IS_MYSQLND)
die("skip Test for mysqlnd only");
if ((version_compare(PHP_VERSION, '5.9.9', '>') == 1))
die("skip (TODO) PHP 6.0 has a difference debug_zval_dump output format");
?>
<?php require_once('skipifemb.inc'); ?>
--FILE--
<?php
require_once('connect.inc');
require_once('table.inc');
$references = array();
if (!(mysqli_real_query($link, "SELECT id, label FROM test ORDER BY id ASC LIMIT 1")) ||
!($res = mysqli_store_result($link)))
printf("[001] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
$idx = 0;
while ($row = mysqli_fetch_assoc($res)) {
/* will overwrite itself */
$references[$idx]['row_ref'] = &$row;
$references[$idx]['row_copy'] = $row;
$references[$idx]['id_ref'] = &$row['id'];
$references[$idx++]['id_copy'] = $row['id'];
}
debug_zval_dump($references);
mysqli_free_result($res);
if (!(mysqli_real_query($link, "SELECT id, label FROM test ORDER BY id ASC LIMIT 2")) ||
!($res = mysqli_use_result($link)))
printf("[002] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
$rows = array();
for ($i = 0; $i < 2; $i++) {
$rows[$i] = mysqli_fetch_assoc($res);
$references[$idx]['row_ref'] = &$rows[$i];
$references[$idx]['row_copy'] = $rows[$i];
$references[$idx]['id_ref'] = &$rows[$i]['id'];
$references[$idx]['id_copy'] = $rows[$i]['id'];
/* enforce separation */
$references[$idx]['id_copy_mod']= $rows[$i]['id'] + 0;
}
mysqli_free_result($res);
debug_zval_dump($references);
print "done!";
?>
--EXPECTF--
array(1) refcount(2){
[0]=>
array(4) refcount(1){
[%u|b%"row_ref"]=>
&NULL refcount(2)
[%u|b%"row_copy"]=>
array(2) refcount(1){
[%u|b%"id"]=>
%unicode|string%(1) "1" refcount(2)
[%u|b%"label"]=>
%unicode|string%(1) "a" refcount(2)
}
[%u|b%"id_ref"]=>
%unicode|string%(1) "1" refcount(1)
[%u|b%"id_copy"]=>
%unicode|string%(1) "1" refcount(1)
}
}
array(2) refcount(2){
[0]=>
array(4) refcount(1){
[%u|b%"row_ref"]=>
&NULL refcount(2)
[%u|b%"row_copy"]=>
array(2) refcount(1){
[%u|b%"id"]=>
%unicode|string%(1) "1" refcount(1)
[%u|b%"label"]=>
%unicode|string%(1) "a" refcount(1)
}
[%u|b%"id_ref"]=>
%unicode|string%(1) "1" refcount(1)
[%u|b%"id_copy"]=>
%unicode|string%(1) "1" refcount(1)
}
[1]=>
array(5) refcount(1){
[%u|b%"row_ref"]=>
&array(2) refcount(2){
[%u|b%"id"]=>
&%unicode|string%(1) "2" refcount(2)
[%u|b%"label"]=>
%unicode|string%(1) "b" refcount(2)
}
[%u|b%"row_copy"]=>
array(2) refcount(1){
[%u|b%"id"]=>
%unicode|string%(1) "2" refcount(1)
[%u|b%"label"]=>
%unicode|string%(1) "b" refcount(2)
}
[%u|b%"id_ref"]=>
&%unicode|string%(1) "2" refcount(2)
[%u|b%"id_copy"]=>
%unicode|string%(1) "2" refcount(1)
[%u|b%"id_copy_mod"]=>
long(2) refcount(1)
}
}
done!
|