diff options
Diffstat (limited to 'ext/mysqli/tests/mysqli_num_rows.phpt')
| -rw-r--r-- | ext/mysqli/tests/mysqli_num_rows.phpt | 86 |
1 files changed, 43 insertions, 43 deletions
diff --git a/ext/mysqli/tests/mysqli_num_rows.phpt b/ext/mysqli/tests/mysqli_num_rows.phpt index bd12ffc83b..4cc794db68 100644 --- a/ext/mysqli/tests/mysqli_num_rows.phpt +++ b/ext/mysqli/tests/mysqli_num_rows.phpt @@ -8,70 +8,70 @@ require_once('skipifconnectfailure.inc'); ?> --FILE-- <?php - require_once("connect.inc"); + require_once("connect.inc"); - $tmp = NULL; - $link = NULL; + $tmp = NULL; + $link = NULL; - if (!is_null($tmp = @mysqli_num_rows())) - printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); + if (!is_null($tmp = @mysqli_num_rows())) + printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - if (!is_null($tmp = @mysqli_num_rows($link))) - printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); + if (!is_null($tmp = @mysqli_num_rows($link))) + printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - require('table.inc'); + require('table.inc'); - function func_test_mysqli_num_rows($link, $query, $expected, $offset, $test_free = false) { + function func_test_mysqli_num_rows($link, $query, $expected, $offset, $test_free = false) { - if (!$res = mysqli_query($link, $query, MYSQLI_STORE_RESULT)) { - printf("[%03d] [%d] %s\n", $offset, mysqli_errno($link), mysqli_error($link)); - return; - } + if (!$res = mysqli_query($link, $query, MYSQLI_STORE_RESULT)) { + printf("[%03d] [%d] %s\n", $offset, mysqli_errno($link), mysqli_error($link)); + return; + } - if ($expected !== ($tmp = mysqli_num_rows($res))) - printf("[%03d] Expecting %s/%d, got %s/%d\n", $offset + 1, - gettype($expected), $expected, - gettype($tmp), $tmp); + if ($expected !== ($tmp = mysqli_num_rows($res))) + printf("[%03d] Expecting %s/%d, got %s/%d\n", $offset + 1, + gettype($expected), $expected, + gettype($tmp), $tmp); - mysqli_free_result($res); + mysqli_free_result($res); - if ($test_free && (false !== ($tmp = mysqli_num_rows($res)))) - printf("[%03d] Expecting false, got %s/%s\n", $offset + 2, gettype($tmp), $tmp); + if ($test_free && (false !== ($tmp = mysqli_num_rows($res)))) + printf("[%03d] Expecting false, got %s/%s\n", $offset + 2, gettype($tmp), $tmp); - } + } - func_test_mysqli_num_rows($link, "SELECT 1 AS a", 1, 5); - func_test_mysqli_num_rows($link, "SHOW VARIABLES LIKE '%nixnutz%'", 0, 10); - func_test_mysqli_num_rows($link, "INSERT INTO test(id, label) VALUES (100, 'z')", NULL, 15); - func_test_mysqli_num_rows($link, "SELECT id FROM test LIMIT 2", 2, 20, true); + func_test_mysqli_num_rows($link, "SELECT 1 AS a", 1, 5); + func_test_mysqli_num_rows($link, "SHOW VARIABLES LIKE '%nixnutz%'", 0, 10); + func_test_mysqli_num_rows($link, "INSERT INTO test(id, label) VALUES (100, 'z')", NULL, 15); + func_test_mysqli_num_rows($link, "SELECT id FROM test LIMIT 2", 2, 20, true); - if ($res = mysqli_query($link, 'SELECT COUNT(id) AS num FROM test')) { + if ($res = mysqli_query($link, 'SELECT COUNT(id) AS num FROM test')) { - $row = mysqli_fetch_assoc($res); - mysqli_free_result($res); + $row = mysqli_fetch_assoc($res); + mysqli_free_result($res); - func_test_mysqli_num_rows($link, "SELECT id, label FROM test", (int)$row['num'], 25); + func_test_mysqli_num_rows($link, "SELECT id, label FROM test", (int)$row['num'], 25); - } else { - printf("[030] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); - } + } else { + printf("[030] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + } - print "run_tests.php don't fool me with your 'ungreedy' expression '.+?'!\n"; + print "run_tests.php don't fool me with your 'ungreedy' expression '.+?'!\n"; - if ($res = mysqli_query($link, 'SELECT id FROM test', MYSQLI_USE_RESULT)) { + if ($res = mysqli_query($link, 'SELECT id FROM test', MYSQLI_USE_RESULT)) { - $row = mysqli_fetch_row($res); - if (0 !== ($tmp = mysqli_num_rows($res))) - printf("[031] Expecting int/0, got %s/%d\n", gettype($tmp), $tmp); + $row = mysqli_fetch_row($res); + if (0 !== ($tmp = mysqli_num_rows($res))) + printf("[031] Expecting int/0, got %s/%d\n", gettype($tmp), $tmp); - mysqli_free_result($res); + mysqli_free_result($res); - } else { - printf("[032] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); - } + } else { + printf("[032] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + } - mysqli_close($link); - print "done!"; + mysqli_close($link); + print "done!"; ?> --CLEAN-- <?php |