diff options
| author | Lorry Tar Creator <lorry-tar-importer@baserock.org> | 2013-03-14 05:42:27 +0000 |
|---|---|---|
| committer | <> | 2013-04-03 16:25:08 +0000 |
| commit | c4dd7a1a684490673e25aaf4fabec5df138854c4 (patch) | |
| tree | 4d57c44caae4480efff02b90b9be86f44bf25409 /ext/mysql/tests/mysql_field_seek.phpt | |
| download | php2-master.tar.gz | |
Imported from /home/lorry/working-area/delta_php2/php-5.4.13.tar.bz2.HEADphp-5.4.13master
Diffstat (limited to 'ext/mysql/tests/mysql_field_seek.phpt')
| -rw-r--r-- | ext/mysql/tests/mysql_field_seek.phpt | 142 |
1 files changed, 142 insertions, 0 deletions
diff --git a/ext/mysql/tests/mysql_field_seek.phpt b/ext/mysql/tests/mysql_field_seek.phpt new file mode 100644 index 0000000..7e8b313 --- /dev/null +++ b/ext/mysql/tests/mysql_field_seek.phpt @@ -0,0 +1,142 @@ +--TEST-- +mysql_field_seek() +--SKIPIF-- +<?php +require_once('skipif.inc'); +require_once('skipifconnectfailure.inc'); +?> +--FILE-- +<?php +include "connect.inc"; + +$tmp = NULL; +$link = NULL; + +if (!is_null($tmp = @mysql_field_seek())) + printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); + +if (!is_null($tmp = @mysql_field_seek($link))) + printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); + +require('table.inc'); +if (!$res = mysql_query("SELECT id, label FROM test ORDER BY id LIMIT 1", $link)) { + printf("[003] [%d] %s\n", mysql_errno($link), mysql_error($link)); +} + +var_dump(mysql_field_seek($res, -1)); +var_dump(mysql_fetch_field($res)); +var_dump(mysql_field_seek($res, 0)); +var_dump(mysql_fetch_field($res)); +var_dump(mysql_field_seek($res, 1)); +var_dump(mysql_fetch_field($res)); +var_dump(mysql_field_seek($res, 2)); +var_dump(mysql_fetch_field($res)); + +mysql_free_result($res); + +var_dump(mysql_field_seek($res, 0)); + +mysql_close($link); +print "done!"; +?> +--CLEAN-- +<?php +require_once("clean_table.inc"); +?> +--EXPECTF-- +Warning: mysql_field_seek(): Field -1 is invalid for MySQL result index %d in %s on line %d +bool(false) +object(stdClass)#%d (13) { + [%u|b%"name"]=> + %unicode|string%(2) "id" + [%u|b%"table"]=> + %unicode|string%(4) "test" + [%u|b%"def"]=> + %unicode|string%(0) "" + [%u|b%"max_length"]=> + int(1) + [%u|b%"not_null"]=> + int(1) + [%u|b%"primary_key"]=> + int(1) + [%u|b%"multiple_key"]=> + int(0) + [%u|b%"unique_key"]=> + int(0) + [%u|b%"numeric"]=> + int(1) + [%u|b%"blob"]=> + int(0) + [%u|b%"type"]=> + %unicode|string%(3) "int" + [%u|b%"unsigned"]=> + int(0) + [%u|b%"zerofill"]=> + int(0) +} +bool(true) +object(stdClass)#%d (13) { + [%u|b%"name"]=> + %unicode|string%(2) "id" + [%u|b%"table"]=> + %unicode|string%(4) "test" + [%u|b%"def"]=> + %unicode|string%(0) "" + [%u|b%"max_length"]=> + int(1) + [%u|b%"not_null"]=> + int(1) + [%u|b%"primary_key"]=> + int(1) + [%u|b%"multiple_key"]=> + int(0) + [%u|b%"unique_key"]=> + int(0) + [%u|b%"numeric"]=> + int(1) + [%u|b%"blob"]=> + int(0) + [%u|b%"type"]=> + %unicode|string%(3) "int" + [%u|b%"unsigned"]=> + int(0) + [%u|b%"zerofill"]=> + int(0) +} +bool(true) +object(stdClass)#%d (13) { + [%u|b%"name"]=> + %unicode|string%(5) "label" + [%u|b%"table"]=> + %unicode|string%(4) "test" + [%u|b%"def"]=> + %unicode|string%(0) "" + [%u|b%"max_length"]=> + int(1) + [%u|b%"not_null"]=> + int(0) + [%u|b%"primary_key"]=> + int(0) + [%u|b%"multiple_key"]=> + int(0) + [%u|b%"unique_key"]=> + int(0) + [%u|b%"numeric"]=> + int(0) + [%u|b%"blob"]=> + int(0) + [%u|b%"type"]=> + %unicode|string%(6) "string" + [%u|b%"unsigned"]=> + int(0) + [%u|b%"zerofill"]=> + int(0) +} + +Warning: mysql_field_seek(): Field %d is invalid for MySQL result index %d in %s on line %d +bool(false) +bool(false) + +Warning: mysql_field_seek(): %d is not a valid MySQL result resource in %s on line %d +bool(false) +done! |