1--TEST-- 2mysqli_stmt_get_result() - seeking 3--EXTENSIONS-- 4mysqli 5--SKIPIF-- 6<?php 7require_once 'skipifconnectfailure.inc'; 8?> 9--FILE-- 10<?php 11 require 'table.inc'; 12 13 if (!$stmt = mysqli_stmt_init($link)) 14 printf("[001] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 15 16 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id ASC LIMIT 3")) 17 printf("[002] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 18 19 if (!mysqli_stmt_execute($stmt)) 20 printf("[003] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 21 22 if (!is_object($res = mysqli_stmt_get_result($stmt)) || 'mysqli_result' != get_class($res)) { 23 printf("[004] Expecting object/mysqli_result got %s/%s, [%d] %s\n", 24 gettype($res), $res, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 25 } 26 27 if (3 !== $res->num_rows) 28 printf("[005] Expecting 3 rows, got %s/%s rows\n", gettype($res->num_rows), $res->num_rows); 29 30 if (2 !== $res->field_count) 31 printf("[006] Expecting 2 fields, got %s/%s rows\n", gettype($res->field_count), $res->field_count); 32 33 if (0 !== $res->current_field) 34 printf("[006] Expecting offset 0, got %s/%s rows\n", gettype($res->current_field), $res->current_field); 35 36 for ($i = 2; $i > 0; $i--) { 37 if (!$res->data_seek($i)) 38 printf("[007] Cannot seek to position %d, [%d] %s\n", 39 $i, mysqli_stmt_errno($stmt), $stmt->error); 40 $row = $res->fetch_array(MYSQLI_BOTH); 41 if (($row[0] !== $row['id']) || ($row[0] !== $i + 1)) { 42 printf("[008] Record looks wrong, dumping data\n"); 43 var_dump($row); 44 } else { 45 unset($row[0]); 46 unset($row['id']); 47 } 48 if ($row[1] !== $row['label']) { 49 printf("[009] Record looks wrong, dumping data\n"); 50 var_dump($row); 51 } else { 52 unset($row[1]); 53 unset($row['label']); 54 } 55 if (!empty($row)) { 56 printf("[010] Not empty, dumping unexpected data\n"); 57 var_dump($row); 58 } 59 } 60 61 try { 62 $res->data_seek(-1); 63 } catch (\ValueError $e) { 64 echo $e->getMessage() . \PHP_EOL; 65 } 66 67 if (false !== ($tmp = $res->data_seek($res->num_rows + 1))) 68 printf("[012] Expecting boolean/false got %s/%s\n", gettype($tmp), $tmp); 69 70 for ($i = 0; $i < 100; $i++) { 71 /* intentionally out of range! */ 72 $pos = mt_rand(-1, 4); 73 try { 74 $tmp = @mysqli_data_seek($res, $pos); 75 if (($pos >= 0 && $pos < 3)) { 76 if (true !== $tmp) 77 printf("[015] Expecting boolan/true got %s/%s\n", gettype($tmp), $tmp); 78 $row = $res->fetch_array(MYSQLI_NUM); 79 if ($row[0] !== $pos + 1) 80 printf("[016] Expecting id = %d for pos %d got %s/%s\n", 81 $pos + 1, $pos, gettype($row[0]), $row[0]); 82 } else { 83 if (false !== $tmp) 84 printf("[014] Expecting boolan/false got %s/%s\n", gettype($tmp), $tmp); 85 } 86 } catch (\ValueError $e) { /* Suppress because RANDOM */} 87 } 88 89 mysqli_stmt_close($stmt); 90 91 if (true !== ($tmp = mysqli_data_seek($res, 0))) 92 printf("[015] Expecting boolan/true got %s/%s\n", gettype($tmp), $tmp); 93 94 if (!is_array($row = $res->fetch_array(MYSQLI_NUM))) 95 printf("[016] Expecting array got %s/%s\n", gettype($tmp), $tmp); 96 97 mysqli_free_result($res); 98 99 try { 100 mysqli_data_seek($res, 0); 101 } catch (Error $exception) { 102 echo $exception->getMessage() . "\n"; 103 } 104 105 try { 106 $res->fetch_array(MYSQLI_NUM); 107 } catch (Error $exception) { 108 echo $exception->getMessage() . "\n"; 109 } 110 111 mysqli_close($link); 112 113 try { 114 mysqli_data_seek($res, 0); 115 } catch (Error $exception) { 116 echo $exception->getMessage() . "\n"; 117 } 118 119 try { 120 $res->fetch_array(MYSQLI_NUM); 121 } catch (Error $exception) { 122 echo $exception->getMessage() . "\n"; 123 } 124 125 print "done!"; 126?> 127--CLEAN-- 128<?php 129 require_once 'clean_table.inc'; 130?> 131--EXPECT-- 132mysqli_result::data_seek(): Argument #1 ($offset) must be greater than or equal to 0 133mysqli_result object is already closed 134mysqli_result object is already closed 135mysqli_result object is already closed 136mysqli_result object is already closed 137done! 138