Annotation of embedaddon/php/ext/mysqli/tests/mysqli_data_seek.phpt, revision 1.1
1.1 ! misho 1: --TEST--
! 2: mysqli_data_seek()
! 3: --SKIPIF--
! 4: <?php
! 5: require_once('skipif.inc');
! 6: require_once('skipifemb.inc');
! 7: require_once('skipifconnectfailure.inc');
! 8: ?>
! 9: --FILE--
! 10: <?php
! 11: require_once("connect.inc");
! 12:
! 13: $tmp = NULL;
! 14: $link = NULL;
! 15:
! 16: if (NULL !== ($tmp = @mysqli_data_seek()))
! 17: printf("[001] Expecting NULL/NULL, got %s/%s\n", gettype($tmp), $tmp);
! 18:
! 19: if (NULL !== ($tmp = @mysqli_data_seek($link)))
! 20: printf("[002] Expecting NULL/NULL, got %s/%s\n", gettype($tmp), $tmp);
! 21:
! 22: if (NULL !== ($tmp = @mysqli_data_seek($link, $link)))
! 23: printf("[003] Expecting NULL/NULL, got %s/%s\n", gettype($tmp), $tmp);
! 24:
! 25: require('table.inc');
! 26: if (!$res = mysqli_query($link, 'SELECT * FROM test ORDER BY id LIMIT 4', MYSQLI_STORE_RESULT))
! 27: printf("[004] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
! 28:
! 29: if (true !== ($tmp = mysqli_data_seek($res, 3)))
! 30: printf("[005] Expecting boolean/true, got %s/%s\n", gettype($tmp), $tmp);
! 31:
! 32: $row = mysqli_fetch_assoc($res);
! 33: if (4 != $row['id'])
! 34: printf("[006] Expecting record 4/d, got record %s/%s\n", $row['id'], $row['label']);
! 35:
! 36: if (true !== ($tmp = mysqli_data_seek($res, 0)))
! 37: printf("[007] Expecting boolean/true, got %s/%s\n", gettype($tmp), $tmp);
! 38:
! 39: $row = mysqli_fetch_assoc($res);
! 40: if (1 != $row['id'])
! 41: printf("[008] Expecting record 1/a, got record %s/%s\n", $row['id'], $row['label']);
! 42:
! 43: if (false !== ($tmp = mysqli_data_seek($res, 4)))
! 44: printf("[009] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);
! 45:
! 46: if (false !== ($tmp = mysqli_data_seek($res, -1)))
! 47: printf("[010] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);
! 48:
! 49: mysqli_free_result($res);
! 50:
! 51: if (!$res = mysqli_query($link, 'SELECT * FROM test ORDER BY id', MYSQLI_USE_RESULT))
! 52: printf("[011] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
! 53:
! 54: if (false !== ($tmp = mysqli_data_seek($res, 3)))
! 55: printf("[012] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);
! 56:
! 57: mysqli_free_result($res);
! 58:
! 59: if (NULL !== ($tmp = mysqli_data_seek($res, 1)))
! 60: printf("[013] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
! 61:
! 62: mysqli_close($link);
! 63:
! 64: print "done!";
! 65: ?>
! 66: --CLEAN--
! 67: <?php
! 68: require_once("clean_table.inc");
! 69: ?>
! 70: --EXPECTF--
! 71: Warning: mysqli_data_seek(): Function cannot be used with MYSQL_USE_RESULT in %s on line %d
! 72:
! 73: Warning: mysqli_data_seek(): Couldn't fetch mysqli_result in %s on line %d
! 74: done!
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>