1--TEST-- 2mysql_result() 3--SKIPIF-- 4<?php 5require_once('skipif.inc'); 6require_once('skipifconnectfailure.inc'); 7?> 8--FILE-- 9<?php 10require_once("connect.inc"); 11 12$tmp = NULL; 13$link = NULL; 14 15// string mysql_result ( resource result, int row [, mixed field] ) 16 17if (!is_null($tmp = @mysql_result())) 18 printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); 19 20if (!is_null($tmp = @mysql_result($link))) 21 printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); 22 23require_once('table.inc'); 24if (!$res = mysql_query("SELECT id, label, id AS _id, CONCAT(label, 'a') _label, NULL as _foo FROM test _test ORDER BY id ASC LIMIT 1", $link)) { 25 printf("[003] [%d] %s\n", mysql_errno($link), mysql_error($link)); 26} 27 28var_dump(mysql_result($res, -1)); 29var_dump(mysql_result($res, 2)); 30 31var_dump(mysql_result($res, 0, -1)); 32var_dump(mysql_result($res, 0, 500)); 33 34print "valid fields\n"; 35var_dump(mysql_result($res, 0)); 36var_dump(mysql_result($res, 0, 1)); 37 38var_dump(mysql_result($res, 0, 'id')); 39var_dump(mysql_result($res, 0, '_test.id')); 40var_dump(mysql_result($res, 0, 'label')); 41var_dump(mysql_result($res, 0, '_test.label')); 42print "some invalid fields\n"; 43var_dump(mysql_result($res, 0, 'unknown')); 44var_dump(mysql_result($res, 0, '_test.')); 45var_dump(mysql_result($res, 0, chr(0))); 46var_dump(mysql_result($res, 0, '_test.' . chr(0))); 47print "_id\n"; 48var_dump(mysql_result($res, 0, '_id')); 49print "_label\n"; 50var_dump(mysql_result($res, 0, '_label')); 51print "_foo\n"; 52var_dump(mysql_result($res, 0, '_foo')); 53var_dump(mysql_result($res, 0, 'test.id')); 54var_dump(mysql_result($res, 0, 'test.label')); 55 56mysql_free_result($res); 57 58var_dump(mysql_result($res, 0)); 59 60mysql_close($link); 61print "done!"; 62?> 63--CLEAN-- 64<?php 65require_once("clean_table.inc"); 66?> 67--EXPECTF-- 68Warning: mysql_result(): Unable to jump to row -1 on MySQL result index %d in %s on line %d 69bool(false) 70 71Warning: mysql_result(): Unable to jump to row 2 on MySQL result index %d in %s on line %d 72bool(false) 73 74Warning: mysql_result(): Bad column offset specified in %s on line %d 75bool(false) 76 77Warning: mysql_result(): Bad column offset specified in %s on line %d 78bool(false) 79valid fields 80%unicode|string%(1) "1" 81%unicode|string%(1) "a" 82%unicode|string%(1) "1" 83%unicode|string%(1) "1" 84%unicode|string%(1) "a" 85%unicode|string%(1) "a" 86some invalid fields 87 88Warning: mysql_result(): unknown not found in MySQL result index %d in %s on line %d 89bool(false) 90 91Warning: mysql_result(): _test. not found in MySQL result index %d in %s on line %d 92bool(false) 93 94Warning: mysql_result(): not found in MySQL result index %d in %s on line %d 95bool(false) 96 97Warning: mysql_result(): _test. not found in MySQL result index %d in %s on line %d 98bool(false) 99_id 100%unicode|string%(1) "1" 101_label 102string(2) "aa" 103_foo 104NULL 105 106Warning: mysql_result(): test.id not found in MySQL result index %d in %s on line %d 107bool(false) 108 109Warning: mysql_result(): test.label not found in MySQL result index %d in %s on line %d 110bool(false) 111 112Warning: mysql_result(): %d is not a valid MySQL result resource in %s on line %d 113bool(false) 114done! 115