csu3_am335x/EVSE/GPL/php-8.1.12/ext/mysqli/tests/mysqli_result_references.phpt

--TEST--
References to result sets
--EXTENSIONS--
mysqli
--SKIPIF--
<?php
require_once('skipifconnectfailure.inc');
?>
--INI--
opcache.enable=0
--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 separation - 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 separation - 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 separation - 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){
    ["id"]=>
    reference refcount(1) {
      int(1)
    }
    ["label"]=>
    string(1) "a" refcount(%d)
  }
  [1]=>
  array(2) refcount(1){
    ["id"]=>
    reference refcount(1) {
      int(2)
    }
    ["label"]=>
    string(1) "b" refcount(%d)
  }
  [2]=>
  array(2) refcount(1){
    ["id"]=>
    reference refcount(1) {
      int(1)
    }
    ["label"]=>
    string(1) "a" refcount(%d)
  }
  [3]=>
  array(2) refcount(1){
    ["id"]=>
    reference refcount(1) {
      int(2)
    }
    ["label"]=>
    string(1) "b" refcount(%d)
  }
  [4]=>
  array(3) refcount(1){
    ["id"]=>
    reference refcount(2) {
      int(3)
    }
    ["label"]=>
    string(1) "a" refcount(%d)
    ["id2"]=>
    reference refcount(2) {
      int(3)
    }
  }
  [5]=>
  array(3) refcount(1){
    ["id"]=>
    reference refcount(2) {
      int(4)
    }
    ["label"]=>
    string(1) "b" refcount(%d)
    ["id2"]=>
    reference refcount(2) {
      int(4)
    }
  }
  [6]=>
  reference refcount(2) {
    object(mysqli_result)#2 (0) refcount(1){
    }
  }
}
array(1) refcount(2){
  [0]=>
  array(2) refcount(1){
    ["id"]=>
    string(1) "1" interned
    ["label"]=>
    string(1) "a" interned
  }
}
done!