File:
[ELWIX - Embedded LightWeight unIX -] /
embedaddon /
php /
ext /
mysqli /
tests /
mysqli_result_references.phpt
Revision
1.1.1.1 (vendor branch):
download - view:
text,
annotated -
select for diffs -
revision graph
Tue Feb 21 23:47:58 2012 UTC (12 years, 6 months ago) by
misho
Branches:
php,
MAIN
CVS tags:
v5_4_3elwix,
v5_4_29p0,
v5_4_29,
v5_4_20p0,
v5_4_20,
v5_4_17p0,
v5_4_17,
v5_3_10,
HEAD
php
--TEST--
References to result sets
--SKIPIF--
<?php
require_once('skipif.inc');
require_once('skipifemb.inc');
require_once('skipifconnectfailure.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 2")) ||
!($res = mysqli_store_result($link)))
printf("[001] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
$idx = 0;
while ($row = mysqli_fetch_assoc($res)) {
/* mysqlnd: force seperation - create copies */
$references[$idx] = array(
'id' => &$row['id'],
'label' => $row['label'] . '');
$references[$idx++]['id'] += 0;
}
mysqli_close($link);
mysqli_data_seek($res, 0);
while ($row = mysqli_fetch_assoc($res)) {
/* mysqlnd: force seperation - create copies */
$references[$idx] = array(
'id' => &$row['id'],
'label' => $row['label'] . '');
$references[$idx++]['id'] += 0;
}
mysqli_free_result($res);
if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
printf("[002] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
$host, $user, $db, $port, $socket);
if (!(mysqli_real_query($link, "SELECT id, label FROM test ORDER BY id ASC LIMIT 2")) ||
!($res = mysqli_use_result($link)))
printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
while ($row = mysqli_fetch_assoc($res)) {
/* mysqlnd: force seperation - create copies*/
$references[$idx] = array(
'id' => &$row['id'],
'label' => $row['label'] . '');
$references[$idx]['id2'] = &$references[$idx]['id'];
$references[$idx]['id'] += 1;
$references[$idx++]['id2'] += 1;
}
$references[$idx++] = &$res;
mysqli_free_result($res);
@debug_zval_dump($references);
if (!(mysqli_real_query($link, "SELECT id, label FROM test ORDER BY id ASC LIMIT 1")) ||
!($res = mysqli_use_result($link)))
printf("[004] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
$tmp = array();
while ($row = mysqli_fetch_assoc($res)) {
$tmp[] = $row;
}
$tmp = unserialize(serialize($tmp));
debug_zval_dump($tmp);
mysqli_free_result($res);
mysqli_close($link);
print "done!";
?>
--CLEAN--
<?php
require_once("clean_table.inc");
?>
--EXPECTF--
array(7) refcount(2){
[0]=>
array(2) refcount(1){
[%u|b%"id"]=>
long(1) refcount(1)
[%u|b%"label"]=>
%unicode|string%(1) "a" refcount(1)
}
[1]=>
array(2) refcount(1){
[%u|b%"id"]=>
long(2) refcount(1)
[%u|b%"label"]=>
%unicode|string%(1) "b" refcount(1)
}
[2]=>
array(2) refcount(1){
[%u|b%"id"]=>
long(1) refcount(1)
[%u|b%"label"]=>
%unicode|string%(1) "a" refcount(1)
}
[3]=>
array(2) refcount(1){
[%u|b%"id"]=>
long(2) refcount(1)
[%u|b%"label"]=>
%unicode|string%(1) "b" refcount(1)
}
[4]=>
array(3) refcount(1){
[%u|b%"id"]=>
&long(3) refcount(2)
[%u|b%"label"]=>
%unicode|string%(1) "a" refcount(1)
[%u|b%"id2"]=>
&long(3) refcount(2)
}
[5]=>
array(3) refcount(1){
[%u|b%"id"]=>
&long(4) refcount(2)
[%u|b%"label"]=>
%unicode|string%(1) "b" refcount(1)
[%u|b%"id2"]=>
&long(4) refcount(2)
}
[6]=>
&object(mysqli_result)#2 (5) refcount(2){
[%u|b%"current_field"]=>
NULL refcount(1)
[%u|b%"field_count"]=>
NULL refcount(1)
[%u|b%"lengths"]=>
NULL refcount(1)
[%u|b%"num_rows"]=>
NULL refcount(1)
[%u|b%"type"]=>
NULL refcount(1)
}
}
array(1) refcount(2){
[0]=>
array(2) refcount(1){
[%u|b%"id"]=>
%unicode|string%(1) "1" refcount(1)
[%u|b%"label"]=>
%unicode|string%(1) "a" refcount(1)
}
}
done!
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>