summaryrefslogtreecommitdiff
path: root/ext/mysql/tests/mysql_fetch_field.phpt
diff options
context:
space:
mode:
authorOndřej Surý <ondrej@sury.org>2010-01-07 13:31:53 +0100
committerOndřej Surý <ondrej@sury.org>2010-01-07 13:31:53 +0100
commit0fab6db7cac8d2be99579dd049f812a8ff98e74f (patch)
tree91f01b0d06916c78262404096bfd466b8e95e5b5 /ext/mysql/tests/mysql_fetch_field.phpt
parentd3a8757891280dc6650ca7eead67830c794b0e7b (diff)
downloadphp-0fab6db7cac8d2be99579dd049f812a8ff98e74f.tar.gz
Imported Upstream version 5.3.1upstream/5.3.1
Diffstat (limited to 'ext/mysql/tests/mysql_fetch_field.phpt')
-rw-r--r--ext/mysql/tests/mysql_fetch_field.phpt277
1 files changed, 85 insertions, 192 deletions
diff --git a/ext/mysql/tests/mysql_fetch_field.phpt b/ext/mysql/tests/mysql_fetch_field.phpt
index c46335f9d..65c44edc5 100644
--- a/ext/mysql/tests/mysql_fetch_field.phpt
+++ b/ext/mysql/tests/mysql_fetch_field.phpt
@@ -39,13 +39,13 @@ require_once('skipifconnectfailure.inc');
if (!$res = mysql_query("SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 1", $link)) {
printf("[005] [%d] %s\n", mysql_errno($link), mysql_error($link));
}
- if (false !== ($tmp = mysql_fetch_field($res, PHP_INT_MAX * 2)))
- printf("[006] Expecting boolean/false got %s/%s\n", gettype($tmp), $tmp);
+ if (false !== ($tmp = mysql_fetch_field($res, PHP_INT_MAX - 1)))
+ printf("[006] Expecting boolean/false got %s/%s\n", gettype($tmp), var_export($tmp, true));
mysql_free_result($res);
if (false !== ($tmp = mysql_fetch_field($res)))
- printf("[007] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);
+ printf("[007] Expecting boolean/false, got %s/%s\n", gettype($tmp), var_export($tmp, true));
$types = array(
'BIT' => array(1, 'int'),
@@ -124,189 +124,81 @@ require_once('skipifconnectfailure.inc');
printf("[017] [%d] %s\n", mysql_errno($link), mysql_error($link));
}
$res = mysql_list_fields($db, 'test');
- while ($tmp = mysql_fetch_field($res))
- if ($tmp->name == 'id')
+ $found = false;
+ while ($tmp = mysql_fetch_field($res)) {
+ if ($tmp->name == 'id') {
+ printf("Fetch field from mysql_list_fields result set.\n");
+ $found = true;
var_dump($tmp);
+ }
+ }
+ if (!$found)
+ printf("[018] mysqli_list_fields result set processing has failed.\n");
mysql_free_result($res);
mysql_close($link);
print "done!";
?>
+--CLEAN--
+<?php
+require_once("clean_table.inc");
+?>
--EXPECTF--
object(stdClass)#%d (13) {
- ["name"]=>
- string(2) "ID"
- ["table"]=>
- string(4) "TEST"
- ["def"]=>
- string(0) ""
- ["max_length"]=>
- int(1)
- ["not_null"]=>
- int(1)
- ["primary_key"]=>
- int(1)
- ["multiple_key"]=>
- int(0)
- ["unique_key"]=>
- int(0)
- ["numeric"]=>
- int(1)
- ["blob"]=>
- int(0)
- ["type"]=>
- string(3) "int"
- ["unsigned"]=>
- int(0)
- ["zerofill"]=>
- int(0)
-}
-object(stdClass)#%d (13) {
- ["name"]=>
- string(5) "label"
- ["table"]=>
- string(4) "TEST"
- ["def"]=>
- string(0) ""
- ["max_length"]=>
- int(1)
- ["not_null"]=>
- int(0)
- ["primary_key"]=>
- int(0)
- ["multiple_key"]=>
- int(0)
- ["unique_key"]=>
- int(0)
- ["numeric"]=>
- int(0)
- ["blob"]=>
- int(0)
- ["type"]=>
- string(6) "string"
- ["unsigned"]=>
- int(0)
- ["zerofill"]=>
- int(0)
-}
-bool(false)
-
-Warning: mysql_fetch_field(): Bad field offset in %s on line %d
-
-Warning: mysql_fetch_field(): %d is not a valid MySQL result resource in %s on line %d
-object(stdClass)#%d (13) {
- ["name"]=>
- string(2) "id"
- ["table"]=>
- string(4) "test"
- ["def"]=>
- string(0) ""
- ["max_length"]=>
- int(1)
- ["not_null"]=>
- int(0)
- ["primary_key"]=>
- int(0)
- ["multiple_key"]=>
- int(0)
- ["unique_key"]=>
- int(0)
- ["numeric"]=>
- int(1)
- ["blob"]=>
- int(0)
- ["type"]=>
- string(3) "int"
- ["unsigned"]=>
- int(0)
- ["zerofill"]=>
- int(0)
-}
-object(stdClass)#%d (13) {
- ["name"]=>
- string(2) "id"
- ["table"]=>
- string(4) "test"
- ["def"]=>
- string(1) "1"
- ["max_length"]=>
- int(0)
- ["not_null"]=>
- int(0)
- ["primary_key"]=>
- int(0)
- ["multiple_key"]=>
- int(0)
- ["unique_key"]=>
- int(0)
- ["numeric"]=>
- int(1)
- ["blob"]=>
- int(0)
- ["type"]=>
- string(3) "int"
- ["unsigned"]=>
- int(0)
- ["zerofill"]=>
- int(0)
-}
-done!
---UEXPECTF--
-object(stdClass)#%d (13) {
- [u"name"]=>
- unicode(2) "ID"
- [u"table"]=>
- unicode(4) "TEST"
- [u"def"]=>
- unicode(0) ""
- [u"max_length"]=>
+ [%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"not_null"]=>
+ [%u|b%"not_null"]=>
int(1)
- [u"primary_key"]=>
+ [%u|b%"primary_key"]=>
int(1)
- [u"multiple_key"]=>
+ [%u|b%"multiple_key"]=>
int(0)
- [u"unique_key"]=>
+ [%u|b%"unique_key"]=>
int(0)
- [u"numeric"]=>
+ [%u|b%"numeric"]=>
int(1)
- [u"blob"]=>
+ [%u|b%"blob"]=>
int(0)
- [u"type"]=>
- unicode(3) "int"
- [u"unsigned"]=>
+ [%u|b%"type"]=>
+ %unicode|string%(3) "int"
+ [%u|b%"unsigned"]=>
int(0)
- [u"zerofill"]=>
+ [%u|b%"zerofill"]=>
int(0)
}
object(stdClass)#%d (13) {
- [u"name"]=>
- unicode(5) "label"
- [u"table"]=>
- unicode(4) "TEST"
- [u"def"]=>
- unicode(0) ""
- [u"max_length"]=>
+ [%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"not_null"]=>
+ [%u|b%"not_null"]=>
int(0)
- [u"primary_key"]=>
+ [%u|b%"primary_key"]=>
int(0)
- [u"multiple_key"]=>
+ [%u|b%"multiple_key"]=>
int(0)
- [u"unique_key"]=>
+ [%u|b%"unique_key"]=>
int(0)
- [u"numeric"]=>
+ [%u|b%"numeric"]=>
int(0)
- [u"blob"]=>
+ [%u|b%"blob"]=>
int(0)
- [u"type"]=>
- unicode(6) "string"
- [u"unsigned"]=>
+ [%u|b%"type"]=>
+ %unicode|string%(6) "string"
+ [%u|b%"unsigned"]=>
int(0)
- [u"zerofill"]=>
+ [%u|b%"zerofill"]=>
int(0)
}
bool(false)
@@ -315,59 +207,60 @@ Warning: mysql_fetch_field(): Bad field offset in %s on line %d
Warning: mysql_fetch_field(): %d is not a valid MySQL result resource in %s on line %d
object(stdClass)#%d (13) {
- [u"name"]=>
- unicode(2) "id"
- [u"table"]=>
- unicode(4) "test"
- [u"def"]=>
- unicode(0) ""
- [u"max_length"]=>
+ [%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"not_null"]=>
+ [%u|b%"not_null"]=>
int(0)
- [u"primary_key"]=>
+ [%u|b%"primary_key"]=>
int(0)
- [u"multiple_key"]=>
+ [%u|b%"multiple_key"]=>
int(0)
- [u"unique_key"]=>
+ [%u|b%"unique_key"]=>
int(0)
- [u"numeric"]=>
+ [%u|b%"numeric"]=>
int(1)
- [u"blob"]=>
+ [%u|b%"blob"]=>
int(0)
- [u"type"]=>
- unicode(3) "int"
- [u"unsigned"]=>
+ [%u|b%"type"]=>
+ %unicode|string%(3) "int"
+ [%u|b%"unsigned"]=>
int(0)
- [u"zerofill"]=>
+ [%u|b%"zerofill"]=>
int(0)
}
+Fetch field from mysql_list_fields result set.
object(stdClass)#%d (13) {
- [u"name"]=>
- unicode(2) "id"
- [u"table"]=>
- unicode(4) "test"
- [u"def"]=>
- unicode(1) "1"
- [u"max_length"]=>
+ [%u|b%"name"]=>
+ %unicode|string%(2) "id"
+ [%u|b%"table"]=>
+ %unicode|string%(4) "test"
+ [%u|b%"def"]=>
+ %unicode|string%(1) "1"
+ [%u|b%"max_length"]=>
int(0)
- [u"not_null"]=>
+ [%u|b%"not_null"]=>
int(0)
- [u"primary_key"]=>
+ [%u|b%"primary_key"]=>
int(0)
- [u"multiple_key"]=>
+ [%u|b%"multiple_key"]=>
int(0)
- [u"unique_key"]=>
+ [%u|b%"unique_key"]=>
int(0)
- [u"numeric"]=>
+ [%u|b%"numeric"]=>
int(1)
- [u"blob"]=>
+ [%u|b%"blob"]=>
int(0)
- [u"type"]=>
- unicode(3) "int"
- [u"unsigned"]=>
+ [%u|b%"type"]=>
+ %unicode|string%(3) "int"
+ [%u|b%"unsigned"]=>
int(0)
- [u"zerofill"]=>
+ [%u|b%"zerofill"]=>
int(0)
}
done!