diff options
Diffstat (limited to 'ext/mysql/tests')
78 files changed, 0 insertions, 6354 deletions
diff --git a/ext/mysql/tests/001.phpt b/ext/mysql/tests/001.phpt deleted file mode 100644 index 8782fd1252..0000000000 --- a/ext/mysql/tests/001.phpt +++ /dev/null @@ -1,36 +0,0 @@ ---TEST-- -mysql connect ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -require_once('connect.inc'); -$test = ''; - -if ($socket) - $host = sprintf("%s:%s", $host, $socket); -else if ($port) - $host = sprintf("%s:%s", $host, $port); - -/*** test mysql_connect localhost ***/ -$db = mysql_connect($host, $user, $passwd); -$test .= ($db) ? '1' : '0'; -mysql_close($db); - -/*** test mysql_connect localhost:port ***/ -$db = mysql_connect($host, $user, $passwd, true); -$test .= ($db) ? '1' : '0'; -mysql_close($db); - -var_dump($test); -print "done!"; -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -%unicode|string%(2) "11" -done! diff --git a/ext/mysql/tests/002.phpt b/ext/mysql/tests/002.phpt deleted file mode 100644 index 8f53f4d724..0000000000 --- a/ext/mysql/tests/002.phpt +++ /dev/null @@ -1,62 +0,0 @@ ---TEST-- -mysql_fetch_array ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -require_once('connect.inc'); - -if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) - printf("[001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", - $host, $user, $db, $port, $socket); - -var_dump($link); - -var_dump(mysql_query('DROP TABLE IF EXISTS test')); - -var_dump(mysql_query('CREATE TABLE test(col1 int PRIMARY KEY, col2 varchar(50), col3 char(5))')); - -var_dump(mysql_query("INSERT INTO test(col1, col2, col3) VALUES(1, 'foo', 'bar'),(2, 'foo', 'bar')")); - -var_dump($res = mysql_query('SELECT col1, col2, col3 FROM test ORDER BY col1 ASC')); - -while ($data = mysql_fetch_array($res, MYSQL_ASSOC)) { - var_dump($data); -} - -mysql_free_result($res); -mysql_close($link); - -print "done!"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -resource(%d) of type (mysql link) -bool(true) -bool(true) -bool(true) -resource(%d) of type (mysql result) -array(3) { - [%u|b%"col1"]=> - %unicode|string%(1) "1" - [%u|b%"col2"]=> - %unicode|string%(3) "foo" - [%u|b%"col3"]=> - %unicode|string%(3) "bar" -} -array(3) { - [%u|b%"col1"]=> - %unicode|string%(1) "2" - [%u|b%"col2"]=> - %unicode|string%(3) "foo" - [%u|b%"col3"]=> - %unicode|string%(3) "bar" -} -done! diff --git a/ext/mysql/tests/003.phpt b/ext/mysql/tests/003.phpt deleted file mode 100644 index 365abc20e9..0000000000 --- a/ext/mysql/tests/003.phpt +++ /dev/null @@ -1,90 +0,0 @@ ---TEST-- -mysql_fetch_object ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include_once('connect.inc'); - -class class24 { - function __construct() { - echo __METHOD__ . "\n"; - } -} - -$data = array("one", "two", "three"); - -if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) - printf("[001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", - $host, $user, $db, $port, $socket); - -if (!mysql_query('DROP TABLE IF EXISTS test', $link)) - printf("[002] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (!mysql_query("CREATE TABLE test(a varchar(10))", $link)) - printf("[003] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -foreach ($data as $str) { - if (!mysql_query(sprintf("INSERT INTO test VALUES('%s')", $str), $link)) - printf("[004 - %s] [%d] %s\n", $str, mysql_errno($link), mysql_error($link)); -} - -echo "==stdClass==\n"; -if (!$res = mysql_query("SELECT a FROM test", $link)) - printf("[005] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -while ($obj = mysql_fetch_object($res)) { - var_dump($obj); -} -mysql_free_result($res); - -echo "==class24==\n"; -if (!$res = mysql_query("SELECT a FROM test", $link)) - printf("[006] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -while ($obj = mysql_fetch_object($res, 'class24')) { - var_dump($obj); -} -mysql_free_result($res); -mysql_close($link); -print "done!"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -==stdClass== -object(stdClass)#%d (1) { - [%u|b%"a"]=> - %unicode|string%(3) "one" -} -object(stdClass)#%d (1) { - [%u|b%"a"]=> - %unicode|string%(3) "two" -} -object(stdClass)#%d (1) { - [%u|b%"a"]=> - %unicode|string%(5) "three" -} -==class24== -class24::__construct -object(class24)#%d (1) { - [%u|b%"a"]=> - %unicode|string%(3) "one" -} -class24::__construct -object(class24)#%d (1) { - [%u|b%"a"]=> - %unicode|string%(3) "two" -} -class24::__construct -object(class24)#%d (1) { - [%u|b%"a"]=> - %unicode|string%(5) "three" -} -done! diff --git a/ext/mysql/tests/bug47438.phpt b/ext/mysql/tests/bug47438.phpt deleted file mode 100644 index fa7b3e6a2b..0000000000 --- a/ext/mysql/tests/bug47438.phpt +++ /dev/null @@ -1,53 +0,0 @@ ---TEST-- -Bug #47438 (mysql_fetch_field ignores zero offset) ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -require_once('connect.inc'); - -if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) - printf("[001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", - $host, $user, $db, $port, $socket); - -mysql_select_db($db, $link); -mysql_query("DROP TABLE IF EXISTS test_47438", $link); -mysql_query("CREATE TABLE test_47438 (a INT, b INT, c INT)", $link); -mysql_query("INSERT INTO test_47438 VALUES (10, 11, 12), (20, 21, 22)", $link); -$result = mysql_query("SELECT * FROM test_47438", $link); -mysql_field_seek($result, 1); - -$i = 0; - -while($i<mysql_num_fields($result)) -{ - $meta=mysql_fetch_field($result,$i); - echo $i . "." . $meta->name . "\n"; - $i++; -} - -mysql_query("DROP TABLE IF EXISTS test_47438", $link); - -?> ---CLEAN-- -<?php -require_once('connect.inc'); - -if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) - printf("[c001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", - $host, $user, $db, $port, $socket); - -if (!mysql_select_db($db, $link) || - !mysql_query("DROP TABLE IF EXISTS test_47438", $link)) - printf("[c002] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -mysql_close($link); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -0.a -1.b -2.c diff --git a/ext/mysql/tests/bug48754.phpt b/ext/mysql/tests/bug48754.phpt deleted file mode 100644 index b461db3320..0000000000 --- a/ext/mysql/tests/bug48754.phpt +++ /dev/null @@ -1,100 +0,0 @@ ---TEST-- -Bug #48754 (mysql_close() crash php when no handle specified) ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -require_once('connect.inc'); - -function my_mysql_pconnect($host, $user, $passwd, $db, $port, $socket) { - if ($socket) - $host = sprintf("%s:%s", $host, $socket); - else if ($port) - $host = sprintf("%s:%s", $host, $port); - - if (!$link = mysql_pconnect($host, $user, $passwd, true)) { - printf("[000-a] Cannot connect using host '%s', user '%s', password '****', [%d] %s\n", - $host, $user, $passwd, - mysql_errno(), mysql_error()); - return false; - } - return $link; -} - -echo "Explicit connection on close\n"; -$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket); -$link1_thread_id = mysql_thread_id($link); -$default1_thread_id = mysql_thread_id(); -echo 'Expect same thread id for $link and default conn: '; -var_dump($link1_thread_id == $default1_thread_id); -var_dump($link); -mysql_close($link); -var_dump($link); - -// we sohuld have no default link anymore -mysql_close(); - -echo "\nClosing default link\n"; -$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket); -$link2_thread_id = mysql_thread_id($link); -$default2_thread_id = mysql_thread_id(); -echo 'Expect same thread id for $link and default conn but not the previous: '; -var_dump($link1_thread_id == $default1_thread_id && $link1_thread_id != $link2_thread_id); -var_dump($link); -mysql_close(); -var_dump($link); -mysql_close($link); -var_dump($link); - -echo "\nExplicit resource and pconnect\n"; -$link = my_mysql_pconnect($host, $user, $passwd, $db, $port, $socket); -var_dump($link); -mysql_close($link); -var_dump($link); - -// we sohuld have no default link -mysql_close(); - -echo "\nDefault link and pconnect\n"; -$link = my_mysql_pconnect($host, $user, $passwd, $db, $port, $socket); -var_dump($link); -mysql_close(); -var_dump($link); -mysql_close($link); -var_dump($link); -?> ---EXPECTF-- -Explicit connection on close - -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -Expect same thread id for $link and default conn: bool(true) -resource(%d) of type (mysql link) -resource(%d) of type (Unknown) - -Warning: mysql_close(): no MySQL-Link resource supplied in %s on line %d - -Closing default link - -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -Expect same thread id for $link and default conn but not the previous: bool(true) -resource(%d) of type (mysql link) -resource(%d) of type (mysql link) -resource(%d) of type (Unknown) - -Explicit resource and pconnect - -Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -resource(%d) of type (mysql link persistent) -resource(%d) of type (Unknown) - -Warning: mysql_close(): no MySQL-Link resource supplied in %s on line %d - -Default link and pconnect - -Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -resource(%d) of type (mysql link persistent) -resource(%d) of type (mysql link persistent) -resource(%d) of type (Unknown) diff --git a/ext/mysql/tests/bug51242.phpt b/ext/mysql/tests/bug51242.phpt deleted file mode 100644 index 6801d3021f..0000000000 --- a/ext/mysql/tests/bug51242.phpt +++ /dev/null @@ -1,39 +0,0 @@ ---TEST-- -Bug #51242 (Empty mysql.default_port does not default to 3306 anymore, but 0) ---INI-- -mysql.default_port= -mysql.default_socket=/this/does/not/really/need/to/exist ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifnotmysqlnd.inc'); - -// Specific to this bug: we need to be able to connect via TCP. We'll use -// 127.0.0.1:3306 as a (hopefully) moderately sensible default if the hostname -// is actually specified as localhost. -if ($host == 'localhost') { - $host = '127.0.0.1'; -} - -if (!@mysql_connect("$host:3306", $user, $passwd)) { - die("skip mysql not available at $host:3306"); -} -?> ---FILE-- -<?php -require_once('connect.inc'); - -if ($host == 'localhost') { - $host = '127.0.0.1'; -} - -if ($link = my_mysql_connect($host, $user, $passwd, $db, null, $socket)) { - var_dump($link); -} else { - printf("[001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", - $host, $user, $db, null, $socket); -} -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -resource(%d) of type (mysql link) diff --git a/ext/mysql/tests/bug53649.phpt b/ext/mysql/tests/bug53649.phpt deleted file mode 100644 index 7ccdf08e5f..0000000000 --- a/ext/mysql/tests/bug53649.phpt +++ /dev/null @@ -1,72 +0,0 @@ ---TEST--
-Bug #53649 (mysql_query with "load data" unable to save result set)
---SKIPIF--
-<?php
-require_once('skipif.inc');
-require_once('skipifconnectfailure.inc');
-
-if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) {
- die(sprintf("skip Connect failed, [%d] %s\n", mysqlerrno(), mysqli_error()));
-}
-
-if (!mysql_query("DROP TABLE IF EXISTS test", $link) ||
- !mysql_query("CREATE TABLE test (dump1 INT UNSIGNED NOT NULL PRIMARY KEY) ENGINE=" . $engine, $link))
- die(sprintf("skip [%d] %s\n", mysql_errno($link), mysql_error($link)));
-
-if (false === file_put_contents('bug53649.data', "1\n2\n3\n"))
- die(sprintf("skip Failed to create data file\n"));
-
-if (!mysql_query("LOAD DATA LOCAL INFILE 'bug53649.data' INTO TABLE test", $link) &&
- 1148 == mysql_errno($link))
- die("skip LOAD DATA LOAD INFILE not allowed\n");
-?>
---FILE--
-<?php
- require_once("connect.inc");
-
- if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) {
- printf("[001] Connect failed, [%d] %s\n", mysqlerrno(), mysqli_error());
- }
-
- if (!mysql_query("DROP TABLE IF EXISTS test", $link)) {
- printf("[002] [%d] %s\n", mysql_errno($link), mysql_error($link));
- }
-
- if (!mysql_query("CREATE TABLE test (dump1 INT UNSIGNED NOT NULL PRIMARY KEY) ENGINE=" . $engine, $link)) {
- printf("[003] [%d] %s\n", mysql_errno($link), mysql_error($link));
- }
-
- if (false === file_put_contents('bug53649.data', "1\n2\n3\n"))
- printf("[004] Failed to create data file\n");
-
- if (!mysql_query("SELECT 1 FROM DUAL", $link))
- printf("[005] [%d] %s\n", mysql_errno($link), mysql_error($link));
-
- if (!mysql_query("LOAD DATA LOCAL INFILE 'bug53649.data' INTO TABLE test", $link)) {
- printf("[006] [%d] %s\n", mysql_errno($link), mysql_error($link));
- echo "bug";
- } else {
- echo "done";
- }
- mysql_close($link);
-?>
---CLEAN--
-<?php
-require_once('connect.inc');
-
-if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) {
- printf("[clean] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
- $host, $user, $db, $port, $socket);
-}
-
-if (!mysql_query($link, 'DROP TABLE IF EXISTS test', $link)) {
- printf("[clean] Failed to drop old test table: [%d] %s\n", mysqli_errno($link), mysqli_error($link));
-}
-
-mysql_close($link);
-
-unlink('bug53649.data');
-?>
---EXPECTF--
-Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d
-done
diff --git a/ext/mysql/tests/bug55473.phpt b/ext/mysql/tests/bug55473.phpt deleted file mode 100644 index 7d149dc6fd..0000000000 --- a/ext/mysql/tests/bug55473.phpt +++ /dev/null @@ -1,99 +0,0 @@ ---TEST-- -Bug #5547 (mysql_pconnect leaks file descriptors on reconnect) ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -if (defined('PHP_WINDOWS_VERSION_MAJOR')) { - die("skip Test doesn't work on Windows"); -} - -if (!$IS_MYSQLND) - die("skip mysqlnd only, libmysql does not warning about server gone away"); - -if (!($output = @exec("lsof -np " . getmypid()))) - die("skip Test can't find command line tool lsof"); -?> ---INI-- -mysql.max_persistent=30 -mysql.allow_persistent=1 ---FILE-- -<?php - include "connect.inc"; - - $tmp = NULL; - $link = NULL; - - if ($socket) - $host = sprintf("%s:%s", $host, $socket); - else if ($port) - $host = sprintf("%s:%s", $host, $port); - - function connect($host, $user, $passwd) { - $conn = mysql_pconnect($host, $user, $passwd); - - if (!$conn) - die(sprintf("[001] %s\n", mysql_error())); - - if (!mysql_query("set wait_timeout=1", $conn)) - printf("[002] [%d] %s\n", mysql_errno($conn), mysql_error($conn)); - - return $conn; - } - - $conn = connect($host, $user, $passwd); - $opened_files = -1; - - for ($i = 0; $i < 4; $i++) { - /* wait while mysql closes connection */ - sleep(3); - - if (!mysql_ping($conn)) { - printf("[003] reconnect %d\n", $i); - $conn = connect($host, $user, $passwd); - } - - $r = mysql_query('select 1', $conn); - if (!$r) - printf("[004] [%d] %s\n", mysql_errno($conn), mysql_error($conn)); - - - if ($opened_files == -1) { - $opened_files = trim(exec("lsof -np " . getmypid() . " | wc -l")); - printf("[005] Setting openened files...\n"); - } else if (($tmp = trim(exec("lsof -np " . getmypid() . " | wc -l"))) != $opened_files) { - printf("[006] [%d] different number of opened_files : expected %d, got %d", $i, $opened_files, $tmp); - } else { - printf("[007] Opened files as expected\n"); - } - } - - print "done!"; -?> ---EXPECTF-- -Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Warning: mysql_ping(): MySQL server has gone away in %s on line %d -[003] reconnect 0 - -Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -[005] Setting openened files... - -Warning: mysql_ping(): MySQL server has gone away in %s on line %d -[003] reconnect 1 - -Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -[007] Opened files as expected - -Warning: mysql_ping(): MySQL server has gone away in %s on line %d -[003] reconnect 2 - -Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -[007] Opened files as expected - -Warning: mysql_ping(): MySQL server has gone away in %s on line %d -[003] reconnect 3 - -Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -[007] Opened files as expected -done! diff --git a/ext/mysql/tests/clean_table.inc b/ext/mysql/tests/clean_table.inc deleted file mode 100644 index e53245b43f..0000000000 --- a/ext/mysql/tests/clean_table.inc +++ /dev/null @@ -1,15 +0,0 @@ -<?PHP -require_once('connect.inc'); - -// connect + select_db -if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) { - printf("[clean] Cannot connect to the server using host=%s/%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", - $host, $myhost, $user, $db, $port, $socket); -} - -if (!mysql_query('DROP TABLE IF EXISTS test', $link)) { - printf("[clean] Failed to drop test table: [%d] %s\n", mysql_errno($link), mysql_error($link)); -} - -mysql_close($link); -?>
\ No newline at end of file diff --git a/ext/mysql/tests/connect.inc b/ext/mysql/tests/connect.inc deleted file mode 100644 index 0df5bc3aa0..0000000000 --- a/ext/mysql/tests/connect.inc +++ /dev/null @@ -1,82 +0,0 @@ -<?php -if (!function_exists('sys_get_temp_dir')) { - function sys_get_temp_dir() { - - if (!empty($_ENV['TMP'])) - return realpath( $_ENV['TMP'] ); - if (!empty($_ENV['TMPDIR'])) - return realpath( $_ENV['TMPDIR'] ); - if (!empty($_ENV['TEMP'])) - return realpath( $_ENV['TEMP'] ); - - $temp_file = tempnam(md5(uniqid(rand(), TRUE)), ''); - if ($temp_file) { - $temp_dir = realpath(dirname($temp_file)); - unlink($temp_file); - return $temp_dir; - } - return FALSE; - } -} - -if (!function_exists('my_mysql_connect')) { - /* wrapper to simplify test porting */ - function my_mysql_connect($host, $user, $passwd, $db, $port, $socket, $flags = NULL, $persistent = false) { - global $connect_flags; - - $flags = ($flags === NULL) ? $connect_flags : $flags; - - if ($socket) - $host = sprintf("%s:%s", $host, $socket); - else if ($port) - $host = sprintf("%s:%s", $host, $port); - - if ($persistent) { - $link = mysql_pconnect($host, $user, $passwd, $flags); - } else { - $link = mysql_connect($host, $user, $passwd, true, $flags); - } - - if (!$link) { - printf("[000-a] Cannot connect using host '%s', user '%s', password '****', persistent = %d, [%d] %s\n", - $host, $user, ($persistent) ? 1 : 0, - mysql_errno(), mysql_error()); - return false; - } - - if (!mysql_select_db($db, $link)) { - printf("[000-b] [%d] %s\n", mysql_errno($link), mysql_error($link)); - return false; - } - - return $link; - } -} else { - printf("skip Eeeek/BUG/FIXME - connect.inc included twice! skipif bug?\n"); -} - -/* -Default values are "localhost", "root", database "test" and empty password. -Change the MYSQL_TEST_* environment values if you want to use another configuration. -*/ - -$host = getenv("MYSQL_TEST_HOST") ? getenv("MYSQL_TEST_HOST") : "localhost"; -$port = getenv("MYSQL_TEST_PORT") ? getenv("MYSQL_TEST_PORT") : 3306; -$user = getenv("MYSQL_TEST_USER") ? getenv("MYSQL_TEST_USER") : "root"; -$passwd = getenv("MYSQL_TEST_PASSWD") ? getenv("MYSQL_TEST_PASSWD") : ""; - -$db = getenv("MYSQL_TEST_DB") ? getenv("MYSQL_TEST_DB") : "test"; -$engine = getenv("MYSQL_TEST_ENGINE") ? getenv("MYSQL_TEST_ENGINE") : "MyISAM"; -$socket = getenv("MYSQL_TEST_SOCKET") ? getenv("MYSQL_TEST_SOCKET") : null; -$skip_on_connect_failure = getenv("MYSQL_TEST_SKIP_CONNECT_FAILURE") ? getenv("MYSQL_TEST_SKIP_CONNECT_FAILURE") : true; -$connect_flags = getenv("MYSQL_TEST_CONNECT_FLAGS") ? (int)getenv("MYSQL_TEST_CONNECT_FLAGS") : 0; -if ($socket) { - ini_set('mysql.default_socket', $socket); -} -/* Development setting: test experimal features and/or feature requests that never worked before? */ -$TEST_EXPERIMENTAL = (in_array(getenv("MYSQL_TEST_EXPERIMENTAL"), array(0, 1))) ? - ((1 == getenv("MYSQL_TEST_EXPERIMENTAL")) ? true : false) : - false; - -$IS_MYSQLND = stristr(mysql_get_client_info(), "mysqlnd"); -?> diff --git a/ext/mysql/tests/mysql_affected_rows.phpt b/ext/mysql/tests/mysql_affected_rows.phpt deleted file mode 100644 index 2449ac416e..0000000000 --- a/ext/mysql/tests/mysql_affected_rows.phpt +++ /dev/null @@ -1,126 +0,0 @@ ---TEST-- -mysql_affected_rows() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include_once("connect.inc"); -include_once('setupdefault.inc'); - -$tmp = NULL; -$link = NULL; - -if (0 !== ($tmp = @mysql_affected_rows())) - printf("[001] Expecting int/0, got %s/%s\n", gettype($tmp), $tmp); - -if (null !== ($tmp = @mysql_affected_rows($link))) - printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (!is_null($tmp = @mysql_affected_rows($link, $link))) - printf("[003] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) - printf("[004] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", - $host, $user, $db, $port, $socket); - -if (-1 !== ($tmp = mysql_affected_rows($link))) - printf("[005] Expecting int/-1, got %s/%s. [%d] %s\n", - gettype($tmp), $tmp, mysql_errno($link), mysql_error($link)); - -if (!mysql_query('DROP TABLE IF EXISTS test', $link)) - printf("[006] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (!mysql_query('CREATE TABLE test(id INT, label CHAR(1), PRIMARY KEY(id)) ENGINE = ' . $engine, $link)) - printf("[007] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (!mysql_query("INSERT INTO test(id, label) VALUES (1, 'a')", $link)) - printf("[008] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (1 !== ($tmp = mysql_affected_rows($link))) - printf("[010] Expecting int/1, got %s/%s\n", gettype($tmp), $tmp); - -// ignore INSERT error, NOTE: command line returns 0, affected_rows returns -1 as documented -@mysql_query("INSERT INTO test(id, label) VALUES (1, 'a')", $link); -if (-1 !== ($tmp = mysql_affected_rows($link))) - printf("[011] Expecting int/-1, got %s/%s\n", gettype($tmp), $tmp); - -if (!mysql_query("INSERT INTO test(id, label) VALUES (1, 'a') ON DUPLICATE KEY UPDATE id = 4", $link)) - printf("[012] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (2 !== ($tmp = mysql_affected_rows($link))) - printf("[013] Expecting int/2, got %s/%s\n", gettype($tmp), $tmp); - -if (!mysql_query("INSERT INTO test(id, label) VALUES (2, 'b'), (3, 'c')", $link)) - printf("[014] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (2 !== ($tmp = mysql_affected_rows($link))) - printf("[015] Expecting int/2, got %s/%s\n", gettype($tmp), $tmp); - -if (!mysql_query("INSERT IGNORE INTO test(id, label) VALUES (1, 'a')", $link)) { - printf("[016] [%d] %s\n", mysql_errno($link), mysql_error($link)); -} - -if (1 !== ($tmp = mysql_affected_rows($link))) - printf("[017] Expecting int/1, got %s/%s\n", gettype($tmp), $tmp); - -if (!mysql_query("INSERT INTO test(id, label) SELECT id + 10, label FROM test", $link)) - printf("[018] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (4 !== ($tmp = mysql_affected_rows($link))) - printf("[019] Expecting int/4, got %s/%s\n", gettype($tmp), $tmp); - -if (!mysql_query("REPLACE INTO test(id, label) values (4, 'd')", $link)) - printf("[020] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (2 !== ($tmp = mysql_affected_rows($link))) - printf("[021] Expecting int/2, got %s/%s\n", gettype($tmp), $tmp); - -if (!mysql_query("REPLACE INTO test(id, label) values (5, 'e')", $link)) - printf("[022] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (1 !== ($tmp = mysql_affected_rows($link))) - printf("[023] Expecting int/1, got %s/%s\n", gettype($tmp), $tmp); - -if (!mysql_query("UPDATE test SET label = 'a' WHERE id = 2", $link)) - printf("[024] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (1 !== ($tmp = mysql_affected_rows($link))) - printf("[025] Expecting int/1, got %s/%s\n", gettype($tmp), $tmp); - -if (!mysql_query("UPDATE test SET label = 'a' WHERE id = 2", $link)) { - printf("[025] [%d] %s\n", mysql_errno($link), mysql_error($link)); -} - -if (0 !== ($tmp = mysql_affected_rows($link))) - printf("[026] Expecting int/0, got %s/%s\n", gettype($tmp), $tmp); - -if (!mysql_query("UPDATE test SET label = 'a' WHERE id = 100", $link)) { - printf("[025] [%d] %s\n", mysql_errno($link), mysql_error($link)); -} - -if (0 !== ($tmp = mysql_affected_rows($link))) - printf("[026] Expecting int/0, got %s/%s\n", gettype($tmp), $tmp); - -if (0 !== ($tmp = mysql_affected_rows())) - printf("[027] Expecting int/0, got %s/%s\n", gettype($tmp), $tmp); - -if (!mysql_query('DROP TABLE IF EXISTS test', $link)) - printf("[028] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -mysql_close($link); - -if (false !== ($tmp = @mysql_affected_rows($link))) - printf("[029] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -print "done!"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_client_encoding.phpt b/ext/mysql/tests/mysql_client_encoding.phpt deleted file mode 100644 index c10303b55a..0000000000 --- a/ext/mysql/tests/mysql_client_encoding.phpt +++ /dev/null @@ -1,73 +0,0 @@ ---TEST-- -mysql_client_encoding() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include_once "connect.inc"; - -$tmp = NULL; -$link = NULL; - -if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) - printf("[002] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", - $host, $user, $db, $port, $socket); - -$default_link_enc = mysql_client_encoding(); -$link_enc = mysql_client_encoding($link); - -if ($default_link_enc !== $link_enc) - printf("[003] %s != %s, [%d] %s\n", $default_link_enc, $link_enc, mysql_errno($link), mysql_error($link)); - -if (!$res = mysql_query('SELECT version() AS server_version', $link)) - printf("[004] [%d] %s\n", mysql_errno($link), mysql_error($link)); -$tmp = mysql_fetch_assoc($res); -mysql_free_result($res); -$version = explode('.', $tmp['server_version']); -if (empty($version)) - printf("[005] Cannot determine server version, need MySQL Server 4.1+ for the test!\n"); - -if ($version[0] <= 4 && $version[1] < 1) - printf("[006] Need MySQL Server 4.1+ for the test!\n"); - -if (!$res = mysql_query('SELECT @@character_set_connection AS charset, @@collation_connection AS collation', $link)) - printf("[007] [%d] %s\n", mysql_errno($link), mysql_error($link)); -$tmp = mysql_fetch_assoc($res); -mysql_free_result($res); -if (!$tmp['charset']) - printf("[008] Cannot determine current character set and collation\n"); - -if ($link_enc !== $tmp['charset']) { - if ($link_enc === $tmp['collation']) { - printf("[009] Known bug, collation instead of chatset returned, http://bugs.mysql.com/bug.php?id=7923\n"); - } else { - printf("[009] Check manually, watch out for unicode and others\n"); - var_dump($link_enc); - var_dump($tmp); - } -} - -if ((version_compare(PHP_VERSION, '5.9.9', '>') == 1) && - (version_compare(PHP_VERSION, '6.9.9', '<=') == 1) && - function_exists('is_unicode')) { -// unicode mode - if (!is_unicode($default_link_enc) || !is_unicode($link_enc)) { - printf("[010] No unicode returned!\n"); - var_dump($default_link_enc); - var_dump($link_enc); - } -} - -mysql_close($link); - -if (false !== ($tmp = @mysql_client_encoding($link))) - printf("[012] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -print "done!"; -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_close.phpt b/ext/mysql/tests/mysql_close.phpt deleted file mode 100644 index e676511961..0000000000 --- a/ext/mysql/tests/mysql_close.phpt +++ /dev/null @@ -1,40 +0,0 @@ ---TEST-- -mysql_close() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include "connect.inc"; - -$tmp = NULL; -$link = NULL; - -if (false !== ($tmp = @mysql_close())) - printf("[001] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -if (NULL !== ($tmp = @mysql_close($link, $link))) - printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) - printf("[003] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", - $host, $user, $db, $port, $socket); - -$tmp = @mysql_close(NULL); -if (null !== $tmp) - printf("[004] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -$tmp = mysql_close($link); -if (true !== $tmp) - printf("[005] Expecting boolean/true, got %s/%s\n", gettype($tmp), $tmp); - -if (false !== ($tmp = @mysql_query("SELECT 1", $link))) - printf("[006] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -print "done!\n"; -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_connect.phpt b/ext/mysql/tests/mysql_connect.phpt deleted file mode 100644 index 2b73092375..0000000000 --- a/ext/mysql/tests/mysql_connect.phpt +++ /dev/null @@ -1,128 +0,0 @@ ---TEST-- -mysql_connect() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include_once "connect.inc"; - -$tmp = NULL; -$link = NULL; - -// mysql_connect ( [string server [, string username [, string password [, bool new_link [, int client_flags]]]]] ) -if (NULL !== ($tmp = @mysql_connect($link, $link, $link, $link, $link, $link))) - printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -$myhost = (is_null($socket)) ? ((is_null($port)) ? $host : $host . ':' . $port) : $host . ':' . $socket; -if (!$link = mysql_connect($myhost, $user, $passwd, true)) - printf("[002] Cannot connect to the server using host=%s/%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", - $host, $myhost, $user, $db, $port, $socket); - -mysql_close($link); - -if (!$link = mysql_connect($myhost, $user, $passwd, true)) - printf("[003] Cannot connect to the server using host=%s/%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", - $host, $myhost, $user, $db, $port, $socket); - -mysql_close(); - -if ($link = mysql_connect($myhost, $user . 'unknown_really', $passwd . 'non_empty', true)) - printf("[004] Can connect to the server using host=%s/%s, user=%s, passwd=***non_empty, dbname=%s, port=%s, socket=%s\n", - $host, $myhost, $user . 'unknown_really', $db, $port, $socket); - -if (false !== $link) -printf("[005] Expecting boolean/false, got %s/%s\n", gettype($link), $link); - -// Run the following tests without an anoynmous MySQL user and use a password for the test user! -ini_set('mysql.default_socket', $socket); -if (!is_null($socket)) { - if (!is_resource($link = mysql_connect($host, $user, $passwd, true))) { - printf("[006] Usage of mysql.default_socket failed\n"); - } else { - mysql_close($link); - } -} - -if (!ini_get('sql.safe_mode')) { - - ini_set('mysql.default_port', $port); - if (!is_null($port)) { - if (!is_resource($link = mysql_connect($host, $user, $passwd, true))) { - printf("[007] Usage of mysql.default_port failed\n"); - } else { - mysql_close($link); - } - } - - ini_set('mysql.default_password', $passwd); - if (!is_resource($link = mysql_connect($myhost, $user))) { - printf("[008] Usage of mysql.default_password failed\n"); - } else { - mysql_close($link); - } - ini_set('mysql.default_user', $user); - if (!is_resource($link = mysql_connect($myhost))) { - printf("[009] Usage of mysql.default_user failed\n"); - } else { - mysql_close($link); - } - - ini_set('mysql.default_host', $myhost); - if (!is_resource($link = mysql_connect())) { - printf("[010] Usage of mysql.default_host failed\n") ; - } else { - mysql_close($link); - } - - if (!is_resource($link = mysql_connect()) || !is_resource($link2 = mysql_connect())) { - printf("[011] Usage of mysql.default_host failed\n") ; - } else { - mysql_close(); - mysql_close($link2); - } - - if (!stristr(PHP_OS, 'win') && !stristr(PHP_OS, 'netware')) { - ini_set('mysql.default_port', -1); - if (putenv(sprintf('MYSQL_TCP_PORT=%d', $port))) { - if (!is_resource($link = mysql_connect())) { - printf("[012] Usage of env MYSQL_TCP_PORT failed\n") ; - } else { - mysql_close($link); - } - } else if (putenv(sprintf('MYSQL_TCP_PORT=%d', $port + 1))) { - if (!is_resource($link = mysql_connect())) { - printf("[013] Usage of env MYSQL_TCP_PORT=%d should have failed\n", $port + 1) ; - mysql_close($link); - } - } - } -} - -print "done!"; -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Warning: mysql_connect(): Access denied for user '%s'@'%s' (using password: YES) in %s on line %d - -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_constants.phpt b/ext/mysql/tests/mysql_constants.phpt deleted file mode 100644 index e68774503c..0000000000 --- a/ext/mysql/tests/mysql_constants.phpt +++ /dev/null @@ -1,66 +0,0 @@ ---TEST-- -Constants exported by ext/mysql ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -require("connect.inc"); -require("table.inc"); - -$constants = get_defined_constants(true); -sort($constants); - -$expected_constants = array( - 'MYSQL_ASSOC' => true, - 'MYSQL_NUM' => true, - 'MYSQL_BOTH' => true, - 'MYSQL_CLIENT_COMPRESS' => true, - 'MYSQL_CLIENT_INTERACTIVE' => true, - 'MYSQL_CLIENT_IGNORE_SPACE' => true, -); - -$version = mysql_get_server_info($link); -if (!preg_match('@(\d+)\.(\d+)\.(\d+)@ism', $version, $matches)) - printf("[001] Cannot get server version\n"); -$version = ($matches[1] * 100) + ($matches[2] * 10) + $matches[3]; - -if ($version > 400) { - $expected_constants = array_merge($expected_constants, array( - "MYSQL_CLIENT_SSL" => true, - )); -} - - -$unexpected_constants = array(); - -foreach ($constants as $group => $consts) { - foreach ($consts as $name => $value) { - if (stristr($name, 'mysql') && !preg_match("/^mysql([^_]+)_/iu", $name)) { - $name = strtoupper($name); - if (isset($expected_constants[$name])) { - unset($expected_constants[$name]); - } else { - $unexpected_constants[$name] = $name; - } - } - } -} - -if (!empty($unexpected_constants)) { - printf("Dumping list of unexpected constants\n"); - var_dump($unexpected_constants); -} - -if (!empty($expected_constants)) { - printf("Dumping list of missing constants\n"); - var_dump($expected_constants); -} - -print "done!"; -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_create_db.phpt b/ext/mysql/tests/mysql_create_db.phpt deleted file mode 100644 index 0b6d58a09e..0000000000 --- a/ext/mysql/tests/mysql_create_db.phpt +++ /dev/null @@ -1,59 +0,0 @@ ---TEST-- -mysql_create_db() ---SKIPIF-- -<?php -require_once('skipif.inc'); -if (!function_exists('mysql_create_db')) - die("Skip mysql_create_db() exists only in old versions of the libmysql."); -?> ---FILE-- -<?php -include "connect.inc"; - -$link = NULL; -$tmp = null; - -if (false !== ($tmp = mysql_create_db())) - printf("[001] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -if (false !== ($tmp = mysql_create_db($link, $link, $link))) - printf("[002] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -if ($link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) - printf("[003] Can connect to the server using host=%s, user=%s, passwd=***non_empty, dbname=%s, port=%s, socket=%s\n", - $host, $user . 'unknown_really', $db, $port, $socket); - -if (!mysql_query("CREATE DATABASE mysqlcreatedb", $link)) - die(sprintf("[004] Cannot create database, aborting test, [%d] %s\n", mysql_errno($link), mysql_error($link))); - -if (!mysql_query("DROP DATABASE mysqlcreatedb", $link)) - printf("[005] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (true !== ($tmp = mysql_create_db("mysqlcreatedb", $link))) - printf("[006] Expecting boolean/true, got %s/%s, [%d] %s\n", gettype($tmp), $tmp, mysql_errno($link), mysql_error($link)); - -if (false !== ($tmp = mysql_create_db("mysqlcreatedb", $link))) - printf("[007] Expecting boolean/false, got %s/%s, [%d] %s\n", gettype($tmp), $tmp, mysql_errno($link), mysql_error($link)); - -if (!mysql_query("DROP DATABASE mysqlcreatedb", $link)) - printf("[008] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -print "done!"; -?> ---CLEAN-- -<?php -require_once('connect.inc'); -if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) - printf("[c001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", - $host, $user, $db, $port, $socket); - -if (!mysql_query("DROP DATABASE IF EXISTS mysqlcreatedb", $link)) - printf("[c002] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); - -mysql_close($link); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_data_seek.phpt b/ext/mysql/tests/mysql_data_seek.phpt deleted file mode 100644 index 268e145842..0000000000 --- a/ext/mysql/tests/mysql_data_seek.phpt +++ /dev/null @@ -1,79 +0,0 @@ ---TEST-- -mysql_data_seek() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include "connect.inc"; - -$tmp = NULL; -$link = NULL; - -if (NULL !== ($tmp = @mysql_data_seek())) - printf("[001] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -if (NULL !== ($tmp = @mysql_data_seek($link))) - printf("[002] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -if (NULL !== ($tmp = @mysql_data_seek($link, $link))) - printf("[003] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -require('table.inc'); -if (!$res = mysql_query('SELECT * FROM test ORDER BY id LIMIT 4', $link)) - printf("[004] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (true !== ($tmp = mysql_data_seek($res, 3))) - printf("[005] Expecting boolean/true, got %s/%s\n", gettype($tmp), $tmp); - -$row = mysql_fetch_assoc($res); -if (4 != $row['id']) - printf("[006] Expecting record 4/d, got record %s/%s\n", $row['id'], $row['label']); - -if (true !== ($tmp = mysql_data_seek($res, 0))) - printf("[007] Expecting boolean/true, got %s/%s\n", gettype($tmp), $tmp); - -$row = mysql_fetch_assoc($res); -if (1 != $row['id']) - printf("[008] Expecting record 1/a, got record %s/%s\n", $row['id'], $row['label']); - -if (false !== ($tmp = mysql_data_seek($res, 4))) - printf("[009] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -if (false !== ($tmp = mysql_data_seek($res, -1))) - printf("[010] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -mysql_free_result($res); - -if (!$res = mysql_unbuffered_query('SELECT * FROM test ORDER BY id', $link)) - printf("[011] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (false !== ($tmp = mysql_data_seek($res, 3))) - printf("[012] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -mysql_free_result($res); - -if (false !== ($tmp = mysql_data_seek($res, 1))) - printf("[013] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -mysql_close($link); - -print "done!\n"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Warning: mysql_data_seek(): Offset 4 is invalid for MySQL result index %d (or the query data is unbuffered) in %s on line %d - -Warning: mysql_data_seek(): Offset -1 is invalid for MySQL result index %d (or the query data is unbuffered) in %s on line %d - -Warning: mysql_data_seek(): Offset 3 is invalid for MySQL result index %d (or the query data is unbuffered) in %s on line %d - -Warning: mysql_data_seek(): supplied resource is not a valid MySQL result resource in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_db_name.phpt b/ext/mysql/tests/mysql_db_name.phpt deleted file mode 100644 index ba8334aaff..0000000000 --- a/ext/mysql/tests/mysql_db_name.phpt +++ /dev/null @@ -1,69 +0,0 @@ ---TEST-- -mysql_db_name() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include "connect.inc"; - -$tmp = NULL; -$link = NULL; - -if (NULL !== ($tmp = @mysql_db_name())) - printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (NULL !== ($tmp = @mysql_db_name($link, $link))) - printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -require('table.inc'); - -if (!$res = @mysql_list_dbs($link)) - printf("[003] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (!$num = mysql_num_rows($res)) - printf("[004] Empty database list? [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (false !== ($tmp = mysql_db_name($res, -1))) - printf("[005] Expecting boolean/false, got %s/%s. [%d] %s\n", - gettype($tmp), $tmp, mysql_errno($link), mysql_error($link)); - -if (false !== ($tmp = mysql_db_name($res, $num + 1))) - printf("[006] Expecting boolean/false, got %s/%s. [%d] %s\n", - gettype($tmp), $tmp, mysql_errno($link), mysql_error($link)); - -$unicode = (boolean)(version_compare(PHP_VERSION, '5.9.9', '>') == 1 && - version_compare(PHP_VERSION, '6.9.9', '<=') == 1); -for ($i = 0; $i < $num; $i++) { - if ('' === ($dbname = mysql_db_name($res, $i))) - printf("[%03d] Got empty database name! [%d] %s\n", - (($i * 2) + 1) + 6, mysql_errno($link), mysql_error($link)); - - if ($unicode && !is_unicode($dbname)) { - printf("[%03d] Expecting unicode string! [%d] %s\n", - (($i * 2) + 2) + 6, mysql_errno($link), mysql_error($link)); - var_inspect($dbname); - } -} - -mysql_free_result($res); - -if (false !== ($tmp = mysql_db_name($res, $num))) - printf("[999] Expecting boolean/false, got %s/%s. [%d] %s\n", - gettype($tmp), $tmp, mysql_errno($link), mysql_error($link)); - -mysql_close($link); - -print "done!\n"; -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Warning: mysql_db_name(): Unable to jump to row -1 on MySQL result index %d in %s on line %d - -Warning: mysql_db_name(): Unable to jump to row %d on MySQL result index %d in %s on line %d - -Warning: mysql_db_name(): supplied resource is not a valid MySQL result resource in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_db_query.phpt b/ext/mysql/tests/mysql_db_query.phpt deleted file mode 100644 index dc556f449e..0000000000 --- a/ext/mysql/tests/mysql_db_query.phpt +++ /dev/null @@ -1,70 +0,0 @@ ---TEST-- -mysql_db_query() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include "connect.inc"; - -// NOTE: this function is deprecated. We do only the most necessary -// to test it. We don't test all aspects of the documented behaviour. - -$tmp = NULL; -$link = NULL; - -if (NULL !== ($tmp = @mysql_db_query())) - printf("[001] Expecting NULL/NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (NULL !== ($tmp = @mysql_db_query($link))) - printf("[002] Expecting NULL/NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (NULL !== ($tmp = @mysql_db_query($link))) - printf("[003] Expecting NULL/NULL, got %s/%s\n", gettype($tmp), $tmp); - -require('table.inc'); -if (!$res = @mysql_db_query($db, 'SELECT id, label FROM test ORDER BY id LIMIT 1', $link)) - printf("[004] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -$row = mysql_fetch_assoc($res); -if (1 != $row['id']) - printf("[005] Expecting record 1/a, got record %s/%s\n", $row['id'], $row['label']); - -if ((version_compare(PHP_VERSION, '5.9.9', '>') == 1) && - (version_compare(PHP_VERSION, '6.9.9', '<=') == 1) && - !is_unicode($row['label'])) { - printf("[006] No unicode returned! [%d] %s\n", mysql_errno($link), mysql_error($link)); - var_inspect($row); -} - -mysql_free_result($res); - - -if (!$res = @mysql_db_query($db, 'SELECT id, label FROM test ORDER BY id LIMIT 1')) - printf("[007] [%d] %s\n", mysql_errno(), mysql_error()); - -$row = mysql_fetch_assoc($res); -if (1 != $row['id']) - printf("[008] Expecting record 1/a, got record %s/%s\n", $row['id'], $row['label']); - -if ((version_compare(PHP_VERSION, '5.9.9', '>') == 1) && - (version_compare(PHP_VERSION, '6.9.9', '<=') == 1) && - !is_unicode($row['label'])) { - printf("[009] No unicode returned! [%d] %s\n", mysql_errno(), mysql_error()); - var_inspect($row); -} - -mysql_free_result($res); -mysql_close($link); - -print "done!\n"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_deprecated_api.phpt b/ext/mysql/tests/mysql_deprecated_api.phpt deleted file mode 100644 index 8844617c66..0000000000 --- a/ext/mysql/tests/mysql_deprecated_api.phpt +++ /dev/null @@ -1,79 +0,0 @@ ---TEST-- -Check if deprecated API calls bail out ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---INI-- -mysql.trace_mode=1 -error_reporting=E_ALL | E_NOTICE | E_STRICT ---FILE-- -<?php -/* - We use an extra test to cover deprecation warning. - Due to this extra test we can silence deprecation warnings - in have other test using @ operator without losing the information - which function is deprecated and, without reducing test portability. -*/ -include "table.inc"; - -if (version_compare(PHP_VERSION, '5.3.0') >= 0) { - $error = NULL; - ob_start(); - if (!$res = mysql_db_query($db, "SELECT * FROM test", $link)) - $error .= sprintf("[001] [%d] %s\n", mysql_errno($link), mysql_error($link)); - else - mysql_free_result($res); - $output = ob_get_contents(); - ob_end_clean(); - - if (!stristr($output, 'deprecated')) { - printf("[002] mysql_db_query has been deprecated in 5.3.0\n"); - } - - /* - Deprecated since 2002 or the like but documented to be deprecated since 5.3. - In 5.3 and before the deprecation message was bound to mysql.trace_mode=1. - In 5.3.99 the warning will always be thrown, independent of the mysql.trace_mode - setting. - */ - $error = NULL; - ob_start(); - if (!$query = mysql_escape_string("charsets will be ignored")) - $error .= sprintf("[005] [%d] %s\n", mysql_errno($link), mysql_error($link)); - $output = ob_get_contents(); - ob_end_clean(); - - if (!stristr($output, 'deprecated')) { - printf("[006] mysql_escape_string has been deprecated in 5.3.0\n"); - } - -} - -if (version_compare(PHP_VERSION, '5.3.99') >= 0) { - $error = NULL; - ob_start(); - if (!$res = mysql_list_dbs($link)) - $error .= sprintf("[003] [%d] %s\n", mysql_errno($link), mysql_error($link)); - else - mysql_free_result($res); - $output = ob_get_contents(); - ob_end_clean(); - - if (!stristr($output, 'deprecated')) { - printf("[004] mysql_db_query has been deprecated in 5.3.0\n"); - } -} - - - -print "done!"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_drop_db.phpt b/ext/mysql/tests/mysql_drop_db.phpt deleted file mode 100644 index 3281b8a333..0000000000 --- a/ext/mysql/tests/mysql_drop_db.phpt +++ /dev/null @@ -1,56 +0,0 @@ ---TEST-- -mysql_drop_db() ---SKIPIF-- -<?php -require_once('skipif.inc'); -if (!function_exists('mysql_drop_db')) - die("Skip function is deprecated and not available"); -?> ---FILE-- -<?php -include_once "connect.inc"; - -$tmp = NULL; -$link = NULL; - -// NOTE: again this test does not test all of the behaviour of the function - -if (NULL !== ($tmp = mysql_drop_db())) - printf("[001] Expecting NULL/NULL, got %s/%s\n", gettype($tmp), $tmp); - -require('table.inc'); -if (!mysql_query('DROP DATABASE IF EXISTS mysqldropdb')) - printf("[004] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (!mysql_query('CREATE DATABASE mysqldropdb')) - die(sprintf("[005] Skipping, can't create test database. [%d] %s\n", mysql_errno($link), mysql_error($link))); - -if (true !== ($tmp = mysql_drop_db('mysqldropdb', $link))) - printf("[006] Can't drop, got %s/%s. [%d] %s\n", - gettype($tmp), $tmp, - mysql_errno($link), mysql_error($link)); - -if (false !== ($tmp = mysql_drop_db('mysqldropdb', $link))) - printf("[007] Expecting boolean/false, got %s/%s. [%d] %s\n", - gettype($tmp), $tmp, - mysql_errno($link), mysql_error($link)); - -mysql_close($link); - -print "done!\n"; -?> ---CLEAN-- -<?php -require_once('connect.inc'); -if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) - printf("[c001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", - $host, $user, $db, $port, $socket); - -if (!mysql_query("DROP DATABASE IF EXISTS mysqldropdb", $link)) - printf("[c002] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); - -mysql_close($link); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_errno.phpt b/ext/mysql/tests/mysql_errno.phpt deleted file mode 100644 index 83aa7327bd..0000000000 --- a/ext/mysql/tests/mysql_errno.phpt +++ /dev/null @@ -1,64 +0,0 @@ ---TEST-- -mysql_errno() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include "connect.inc"; - -$tmp = NULL; -$link = NULL; - -if (false !== ($tmp = @mysql_errno())) - printf("[001] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -if (null !== ($tmp = @mysql_errno($link))) - printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (!is_null($tmp = @mysql_errno($link, 'too many args'))) - printf("[002b] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) { - printf("[003] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", - $host, $user, $db, $port, $socket); -} -var_dump(mysql_errno($link)); - -if (!mysql_query('DROP TABLE IF EXISTS test', $link)) { - printf("[004] Failed to drop old test table: [%d] %s\n", mysql_errno($link), mysql_errno($link)); -} - -mysql_query('SELECT * FROM test', $link); -var_dump(mysql_errno($link)); - -mysql_close($link); - -var_dump(mysql_errno($link)); - -if ($link = @mysql_connect($host . '_unknown', $user . '_unknown', $passwd, true)) { - printf("[005] Can connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", - $host . '_unknown', $user . '_unknown', $db, $port, $socket); -} else { - $errno = mysql_errno(); - if (!is_int($errno)) - printf("[006] Expecting int/any (e.g 1046, 2005) got %s/%s\n", gettype($errno), $errno); - -} - -print "done!"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -int(0) -int(%d) - -Warning: mysql_errno(): supplied resource is not a valid MySQL-Link resource in %s on line %d -bool(false) -done! diff --git a/ext/mysql/tests/mysql_error.phpt b/ext/mysql/tests/mysql_error.phpt deleted file mode 100644 index 9b0729d0c0..0000000000 --- a/ext/mysql/tests/mysql_error.phpt +++ /dev/null @@ -1,71 +0,0 @@ ---TEST-- -mysql_error() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include "connect.inc"; - -$tmp = NULL; -$link = NULL; - -if (false !== ($tmp = @mysql_error())) - printf("[001] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -if (NULL !== ($tmp = @mysql_error($link))) - printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (!is_null($tmp = @mysql_error($link, 'too many args'))) - printf("[002b] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) { - printf("[003] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", - $host, $user, $db, $port, $socket); -} - -$tmp = mysql_error($link); -if (!is_string($tmp) || ('' !== $tmp)) - printf("[004] Expecting string/empty, got %s/%s. [%d] %s\n", gettype($tmp), $tmp, mysql_errno($link), mysql_error($link)); - -if (!mysql_query('DROP TABLE IF EXISTS test', $link)) { - printf("[005] Failed to drop old test table: [%d] %s\n", mysql_errno($link), mysql_error($link)); -} - -mysql_query('SELECT * FROM test', $link); -$tmp = mysql_error($link); -if (!is_string($tmp) || !preg_match("/Table '\w*\.test' doesn't exist/su", $tmp)) - printf("[006] Expecting string/[Table... doesn't exit], got %s/%s. [%d] %s\n", gettype($tmp), $tmp, mysql_errno($link), mysql_error($link)); - -if ((version_compare(PHP_VERSION, '5.9.9', '>') == 1) && - (version_compare(PHP_VERSION, '6.9.9', '<=') == 1) && - !is_unicode($tmp)) { - printf("[007] Expecting Unicode error message!\n"); - var_inspect($tmp); -} - -mysql_close($link); - -var_dump(mysql_error($link)); - -if ($link = @mysql_connect($host . '_unknown', $user . '_unknown', $passwd, true)) { - printf("[008] Can connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", - $host . '_unknown', $user . '_unknown', $db, $port, $socket); -} -if ('' == mysql_error()) - printf("[009] Connect error should have been set\n"); - -print "done!"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Warning: mysql_error(): supplied resource is not a valid MySQL-Link resource in %s on line %d -bool(false) -done! diff --git a/ext/mysql/tests/mysql_escape_string.phpt b/ext/mysql/tests/mysql_escape_string.phpt deleted file mode 100644 index 8e70da69c9..0000000000 --- a/ext/mysql/tests/mysql_escape_string.phpt +++ /dev/null @@ -1,33 +0,0 @@ ---TEST-- -mysql_escape_string() ---SKIPIF-- -<?php require_once('skipif.inc'); ?> ---FILE-- -<?php -include "connect.inc"; - -$tmp = NULL; -$link = NULL; - -if (NULL !== ($tmp = @mysql_escape_string())) - printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -var_dump(@mysql_escape_string("Am I a unicode string in PHP 6?")); -var_dump(@mysql_escape_string('\\')); -var_dump(@mysql_escape_string('"')); -var_dump(@mysql_escape_string("'")); -var_dump(@mysql_escape_string("\n")); -var_dump(@mysql_escape_string("\r")); -var_dump(@mysql_escape_string("foo" . chr(0) . "bar")); - -print "done!"; -?> ---EXPECTF-- -%unicode|string%(31) "Am I a unicode string in PHP 6?" -%unicode|string%(2) "\\" -%unicode|string%(2) "\"" -%unicode|string%(2) "\'" -%unicode|string%(2) "\n" -%unicode|string%(2) "\r" -%unicode|string%(8) "foo\0bar" -done! diff --git a/ext/mysql/tests/mysql_fetch_array.phpt b/ext/mysql/tests/mysql_fetch_array.phpt deleted file mode 100644 index 1b1852d932..0000000000 --- a/ext/mysql/tests/mysql_fetch_array.phpt +++ /dev/null @@ -1,361 +0,0 @@ ---TEST-- -mysql_fetch_array() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include_once "connect.inc"; - -$tmp = NULL; -$link = NULL; - -if (NULL !== ($tmp = @mysql_fetch_array())) - printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (NULL != ($tmp = @mysql_fetch_array($link))) - printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -require('table.inc'); -if (!$res = mysql_query("SELECT * FROM test ORDER BY id LIMIT 5", $link)) { - printf("[004] [%d] %s\n", mysql_errno($link), mysql_error($link)); -} - -print "[005]\n"; -var_dump(mysql_fetch_array($res)); - -print "[006]\n"; -var_dump(mysql_fetch_array($res, MYSQL_NUM)); - -print "[007]\n"; -var_dump(mysql_fetch_array($res, MYSQL_BOTH)); - -print "[008]\n"; -var_dump(mysql_fetch_array($res, MYSQL_ASSOC)); - -print "[009]\n"; -var_dump(mysql_fetch_array($res)); - -mysql_free_result($res); - -if (!$res = mysql_query("SELECT 1 AS a, 2 AS a, 3 AS c, 4 AS C, NULL AS d, true AS e", $link)) { - printf("[010] Cannot run query, [%d] %s\n", mysql_errno($link), mysql_error($link)); -} -print "[011]\n"; -var_dump(mysql_fetch_array($res, MYSQL_BOTH)); - -mysql_free_result($res); -if (!$res = mysql_query("SELECT 1 AS a, 2 AS b, 3 AS c, 4 AS C", $link)) { - printf("[012] Cannot run query, [%d] %s\n", - mysql_errno($link), $mysql_error($link)); - exit(1); -} - -do { - $illegal_mode = mt_rand(0, 10000); -} while (in_array($illegal_mode, array(MYSQL_ASSOC, MYSQL_NUM, MYSQL_BOTH))); -$tmp = mysql_fetch_array($res, $illegal_mode); -if (!is_array($tmp)) - printf("[013] Expecting array, got %s/%s. [%d] %s\n", - gettype($tmp), $tmp, mysql_errno($link), mysql_error($link)); - -$tmp = @mysql_fetch_array($res, $illegal_mode); -if (false !== $tmp) - printf("[014] Expecting boolean/false, got %s/%s. [%d] %s\n", - gettype($tmp), $tmp, mysql_errno($link), mysql_error($link)); - -mysql_free_result($res); - -function func_mysql_fetch_array($link, $engine, $sql_type, $sql_value, $php_value, $offset, $regexp_comparison = NULL, $binary_type = false) { - - if (!mysql_query("DROP TABLE IF EXISTS test", $link)) { - printf("[%04d] [%d] %s\n", $offset, mysql_errno($link), mysql_error($link)); - return false; - } - - if (!mysql_query($sql = sprintf("CREATE TABLE test(id INT NOT NULL, label %s, PRIMARY KEY(id)) ENGINE = %s", $sql_type, $engine), $link)) { - // don't bail, engine might not support the datatype - return false; - } - - if (is_null($php_value) && !mysql_query($sql = sprintf("INSERT INTO test(id, label) VALUES (1, NULL)"), $link)) { - printf("[%04d] [%d] %s\n", $offset + 1, mysql_errno($link), mysql_error($link)); - return false; - } - - if (!is_null($php_value)) { - if (is_int($sql_value) && !mysql_query(sprintf("INSERT INTO test(id, label) VALUES (1, '%d')", $sql_value), $link)) { - printf("[%04d] [%d] %s\n", $offset + 1, mysql_errno($link), mysql_error($link)); - return false; - } else if (!is_int($sql_value) && !mysql_query(sprintf("INSERT INTO test(id, label) VALUES (1, '%s')", $sql_value), $link)) { - printf("[%04d] [%d] %s\n", $offset + 1, mysql_errno($link), mysql_error($link)); - return false; - } - } - - if (!$res = mysql_query("SELECT id, label FROM test", $link)) { - printf("[%04d] [%d] %s\n", $offset + 2, mysql_errno($link), mysql_error($link)); - return false; - } - - if (!$row = mysql_fetch_array($res, MYSQL_BOTH)) { - printf("[%04d] [%d] %s\n", $offset + 3, mysql_errno($link), mysql_error($link)); - return false; - } - - if ($regexp_comparison) { - if (!preg_match($regexp_comparison, (string)$row['label']) || !preg_match($regexp_comparison, (string)$row[1])) { - printf("[%04d] Expecting %s/%s [reg exp = %s], got %s/%s resp. %s/%s. [%d] %s\n", $offset + 4, - gettype($php_value), $php_value, $regexp_comparison, - gettype($row[1]), $row[1], - gettype($row['label']), $row['label'], mysql_errno($link), mysql_error($link)); - return false; - } - } else if ((gettype($php_value) == 'unicode') && $binary_type) { - // Unicode is on and we are told that the MySQL column type is a binary type. - // Don't expect a unicode value from the database, you'll get binary string - if (($row['label'] != $php_value) || ($row[1] != $php_value)) { - printf("[%04d] Expecting %s/%s, got %s/%s resp. %s/%s. [%d] %s\n", $offset + 5, - gettype($php_value), $php_value, - gettype($row[1]), $row[1], - gettype($row['label']), $row['label'], mysql_errno($link), mysql_error($link)); - return false; - } - if (gettype($row['label']) == 'unicode') { - printf("[%04d] SQL Type: '%s', binary columns are supposed to return binary string and not unicode\n", - $offset + 6, $sql_type); - return false; - } - } else { - if (($row['label'] !== $php_value) || ($row[1] != $php_value)) { - printf("[%04d] Expecting %s/%s, got %s/%s resp. %s/%s. [%d] %s\n", $offset + 7, - gettype($php_value), $php_value, - gettype($row[1]), $row[1], - gettype($row['label']), $row['label'], mysql_errno($link), mysql_error($link)); - return false; - } - } - - return true; -} - -function func_mysql_fetch_array_make_string($len) { - - $ret = ''; - for ($i = 0; $i < $len; $i++) - $ret .= chr(mt_rand(65, 90)); - - return $ret; -} - -func_mysql_fetch_array($link, $engine, "TINYINT", -11, "-11", 20); -func_mysql_fetch_array($link, $engine, "TINYINT", NULL, NULL, 30); -func_mysql_fetch_array($link, $engine, "TINYINT UNSIGNED", 1, "1", 40); -func_mysql_fetch_array($link, $engine, "TINYINT UNSIGNED", NULL, NULL, 50); - -func_mysql_fetch_array($link, $engine, "BOOL", 1, "1", 60); -func_mysql_fetch_array($link, $engine, "BOOL", NULL, NULL, 70); -func_mysql_fetch_array($link, $engine, "BOOLEAN", 0, "0", 80); -func_mysql_fetch_array($link, $engine, "BOOLEAN", NULL, NULL, 90); - -func_mysql_fetch_array($link, $engine, "SMALLINT", -32768, "-32768", 100); -func_mysql_fetch_array($link, $engine, "SMALLINT", 32767, "32767", 110); -func_mysql_fetch_array($link, $engine, "SMALLINT", NULL, NULL, 120); -func_mysql_fetch_array($link, $engine, "SMALLINT UNSIGNED", 65535, "65535", 130); -func_mysql_fetch_array($link, $engine, "SMALLINT UNSIGNED", NULL, NULL, 140); - -func_mysql_fetch_array($link, $engine, "MEDIUMINT", -8388608, "-8388608", 150); -func_mysql_fetch_array($link, $engine, "MEDIUMINT", 8388607, "8388607", 160); -func_mysql_fetch_array($link, $engine, "MEDIUMINT", NULL, NULL, 170); -func_mysql_fetch_array($link, $engine, "MEDIUMINT UNSIGNED", 16777215, "16777215", 180); -func_mysql_fetch_array($link, $engine, "MEDIUMINT UNSIGNED", NULL, NULL, 190); - -func_mysql_fetch_array($link, $engine, "INTEGER", -2147483648, "-2147483648", 200); -func_mysql_fetch_array($link, $engine, "INTEGER", 2147483647, "2147483647", 210); -func_mysql_fetch_array($link, $engine, "INTEGER", NULL, NULL, 220); -func_mysql_fetch_array($link, $engine, "INTEGER UNSIGNED", 4294967295, "4294967295", 230); -func_mysql_fetch_array($link, $engine, "INTEGER UNSIGNED", NULL, NULL, 240); - -// func_mysql_fetch_array($link, $engine, "BIGINT", -9223372036854775808, "-9.22337e+018", 250, "/-9\.22337e\+[0]?18/iu"); -func_mysql_fetch_array($link, $engine, "BIGINT", NULL, NULL, 260); -// func_mysql_fetch_array($link, $engine, "BIGINT UNSIGNED", 18446744073709551615, "1.84467e+019", 270, "/1\.84467e\+[0]?19/iu"); -func_mysql_fetch_array($link, $engine, "BIGINT UNSIGNED", NULL, NULL, 280); - -func_mysql_fetch_array($link, $engine, "FLOAT", -9223372036854775808 - 1.1, "-9.22337e+18", 290, "/-9\.22337e\+?[0]?18/iu"); -func_mysql_fetch_array($link, $engine, "FLOAT", NULL, NULL, 300); -func_mysql_fetch_array($link, $engine, "FLOAT UNSIGNED", 18446744073709551615 + 1.1, "1.84467e+19", 310, "/1\.84467e\+?[0]?19/iu"); -func_mysql_fetch_array($link, $engine, "FLOAT UNSIGNED ", NULL, NULL, 320); - -func_mysql_fetch_array($link, $engine, "DOUBLE(10,2)", -99999999.99, "-99999999.99", 330); -func_mysql_fetch_array($link, $engine, "DOUBLE(10,2)", NULL, NULL, 340); -func_mysql_fetch_array($link, $engine, "DOUBLE(10,2) UNSIGNED", 99999999.99, "99999999.99", 350); -func_mysql_fetch_array($link, $engine, "DOUBLE(10,2) UNSIGNED", NULL, NULL, 360); - -func_mysql_fetch_array($link, $engine, "DECIMAL(10,2)", -99999999.99, "-99999999.99", 370); -func_mysql_fetch_array($link, $engine, "DECIMAL(10,2)", NULL, NULL, 380); -func_mysql_fetch_array($link, $engine, "DECIMAL(10,2)", 99999999.99, "99999999.99", 390); -func_mysql_fetch_array($link, $engine, "DECIMAL(10,2)", NULL, NULL, 400); - -// don't care about date() strict TZ warnings... -func_mysql_fetch_array($link, $engine, "DATE", @date('Y-m-d'), @date('Y-m-d'), 410); -func_mysql_fetch_array($link, $engine, "DATE NOT NULL", @date('Y-m-d'), @date('Y-m-d'), 420); -func_mysql_fetch_array($link, $engine, "DATE", NULL, NULL, 430); - -func_mysql_fetch_array($link, $engine, "DATETIME", @date('Y-m-d H:i:s'), @date('Y-m-d H:i:s'), 440); -func_mysql_fetch_array($link, $engine, "DATETIME NOT NULL", @date('Y-m-d H:i:s'), @date('Y-m-d H:i:s'), 450); -func_mysql_fetch_array($link, $engine, "DATETIME", NULL, NULL, 460); - -func_mysql_fetch_array($link, $engine, "TIMESTAMP", @date('Y-m-d H:i:s'), @date('Y-m-d H:i:s'), 470); - -func_mysql_fetch_array($link, $engine, "TIME", @date('H:i:s'), @date('H:i:s'), 480); -func_mysql_fetch_array($link, $engine, "TIME NOT NULL", @date('H:i:s'), @date('H:i:s'), 490); -func_mysql_fetch_array($link, $engine, "TIME", NULL, NULL, 500); - -func_mysql_fetch_array($link, $engine, "YEAR", @date('Y'), @date('Y'), 510); -func_mysql_fetch_array($link, $engine, "YEAR NOT NULL", @date('Y'), @date('Y'), 520); -func_mysql_fetch_array($link, $engine, "YEAR", NULL, NULL, 530); - -$string255 = func_mysql_fetch_array_make_string(255); - -func_mysql_fetch_array($link, $engine, "CHAR(1)", "a", "a", 540); -func_mysql_fetch_array($link, $engine, "CHAR(255)", $string255, $string255, 550); -func_mysql_fetch_array($link, $engine, "CHAR(1) NOT NULL", "a", "a", 560); -func_mysql_fetch_array($link, $engine, "CHAR(1)", NULL, NULL, 570); - -$string65k = func_mysql_fetch_array_make_string(65400); - -func_mysql_fetch_array($link, $engine, "VARCHAR(1)", "a", "a", 580); -func_mysql_fetch_array($link, $engine, "VARCHAR(255)", $string255, $string255, 590); -func_mysql_fetch_array($link, $engine, "VARCHAR(65400)", $string65k, $string65k, 600); -func_mysql_fetch_array($link, $engine, "VARCHAR(1) NOT NULL", "a", "a", 610); -func_mysql_fetch_array($link, $engine, "VARCHAR(1)", NULL, NULL, 620); - -func_mysql_fetch_array($link, $engine, "BINARY(1)", "a", "a", 630, null , true); -func_mysql_fetch_array($link, $engine, "BINARY(1) NOT NULL", "b", "b", 650, null , true); -func_mysql_fetch_array($link, $engine, "BINARY(1)", NULL, NULL, 660, null , true); - -func_mysql_fetch_array($link, $engine, "VARBINARY(1)", "a", "a", 670, null , true); -func_mysql_fetch_array($link, $engine, "VARBINARY(1) NOT NULL", "b", "b", 690, null , true); -func_mysql_fetch_array($link, $engine, "VARBINARY(1)", NULL, NULL, 700, null , true); - -func_mysql_fetch_array($link, $engine, "TINYBLOB", "a", "a", 710, null , true); -func_mysql_fetch_array($link, $engine, "TINYBLOB NOT NULL", "b", "b", 730, null , true); -func_mysql_fetch_array($link, $engine, "TINYBLOB", NULL, NULL, 740, null , true); - -func_mysql_fetch_array($link, $engine, "TINYTEXT", "a", "a", 750); -func_mysql_fetch_array($link, $engine, "TINYTEXT NOT NULL", "a", "a", 760); -func_mysql_fetch_array($link, $engine, "TINYTEXT", NULL, NULL, 770); - -func_mysql_fetch_array($link, $engine, "BLOB", "a", "a", 780, null , true); -func_mysql_fetch_array($link, $engine, "BLOB", NULL, NULL, 790, null , true); - -func_mysql_fetch_array($link, $engine, "TEXT", "a", "a", 800); -func_mysql_fetch_array($link, $engine, "TEXT", NULL, NULL, 820); - -func_mysql_fetch_array($link, $engine, "MEDIUMBLOB", "a", "a", 830, null , true); -func_mysql_fetch_array($link, $engine, "MEDIUMBLOB", NULL, NULL, 850, null , true); - -func_mysql_fetch_array($link, $engine, "MEDIUMTEXT", "a", "a", 860); -func_mysql_fetch_array($link, $engine, "MEDIUMTEXT", NULL, NULL, 880); - -func_mysql_fetch_array($link, $engine, "LONGBLOB", "a", "a", 890, null , true); -func_mysql_fetch_array($link, $engine, "LONGBLOB", NULL, NULL, 910, null , true); - -func_mysql_fetch_array($link, $engine, "ENUM('a', 'b')", "a", "a", 920); -func_mysql_fetch_array($link, $engine, "ENUM('a', 'b')", NULL, NULL, 930); - -func_mysql_fetch_array($link, $engine, "SET('a', 'b')", "a", "a", 940); -func_mysql_fetch_array($link, $engine, "SET('a', 'b')", NULL, NULL, 950); - -mysql_close($link); - -if (false !== ($tmp = mysql_fetch_array($res, MYSQL_ASSOC))) -printf("[015] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -print "done!"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -[005] -array(4) { - [0]=> - %unicode|string%(1) "1" - [%u|b%"id"]=> - %unicode|string%(1) "1" - [1]=> - %unicode|string%(1) "a" - [%u|b%"label"]=> - %unicode|string%(1) "a" -} -[006] -array(2) { - [0]=> - %unicode|string%(1) "2" - [1]=> - %unicode|string%(1) "b" -} -[007] -array(4) { - [0]=> - %unicode|string%(1) "3" - [%u|b%"id"]=> - %unicode|string%(1) "3" - [1]=> - %unicode|string%(1) "c" - [%u|b%"label"]=> - %unicode|string%(1) "c" -} -[008] -array(2) { - [%u|b%"id"]=> - %unicode|string%(1) "4" - [%u|b%"label"]=> - %unicode|string%(1) "d" -} -[009] -array(4) { - [0]=> - %unicode|string%(1) "5" - [%u|b%"id"]=> - %unicode|string%(1) "5" - [1]=> - %unicode|string%(1) "e" - [%u|b%"label"]=> - %unicode|string%(1) "e" -} -[011] -array(11) { - [0]=> - %unicode|string%(1) "1" - [%u|b%"a"]=> - %unicode|string%(1) "2" - [1]=> - %unicode|string%(1) "2" - [2]=> - %unicode|string%(1) "3" - [%u|b%"c"]=> - %unicode|string%(1) "3" - [3]=> - %unicode|string%(1) "4" - [%u|b%"C"]=> - %unicode|string%(1) "4" - [4]=> - NULL - [%u|b%"d"]=> - NULL - [5]=> - %unicode|string%(1) "1" - [%u|b%"e"]=> - %unicode|string%(1) "1" -} - -Warning: mysql_fetch_array(): The result type should be either MYSQL_NUM, MYSQL_ASSOC or MYSQL_BOTH in %s on line %d - -Warning: mysql_fetch_array(): supplied resource is not a valid MySQL result resource in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_fetch_assoc.phpt b/ext/mysql/tests/mysql_fetch_assoc.phpt deleted file mode 100644 index 936c7c6f23..0000000000 --- a/ext/mysql/tests/mysql_fetch_assoc.phpt +++ /dev/null @@ -1,106 +0,0 @@ ---TEST-- -mysql_fetch_assoc() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include "connect.inc"; - -$tmp = NULL; -$link = NULL; - -// Note: no SQL type tests, internally the same function gets used as for mysql_fetch_array() which does a lot of SQL type test - -if (!is_null($tmp = @mysql_fetch_assoc())) - printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (NULL !== ($tmp = @mysql_fetch_assoc($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("[004] [%d] %s\n", mysql_errno($link), mysql_error($link)); -} - -print "[005]\n"; -var_dump(mysql_fetch_assoc($res)); - -print "[006]\n"; -var_dump(mysql_fetch_assoc($res)); - -mysql_free_result($res); - -if (!$res = mysql_query("SELECT 1 AS a, 2 AS a, 3 AS c, 4 AS C, NULL AS d, true AS e", $link)) { - printf("[007] Cannot run query, [%d] %s\n", mysql_errno($link), $mysql_error($link)); -} -print "[008]\n"; -var_dump(mysql_fetch_assoc($res)); - -mysql_free_result($res); - -if (false !== ($tmp = mysql_fetch_assoc($res))) - printf("[008] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -mysql_close($link); - -include('table.inc'); -if (!$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)) { - printf("[009] [%d] %s\n", mysql_errno($link), $mysql_error($link)); -} -print "[010]\n"; -var_dump(mysql_fetch_assoc($res)); -mysql_free_result($res); - -mysql_close($link); - -print "done!"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -[005] -array(2) { - [%u|b%"id"]=> - %unicode|string%(1) "1" - [%u|b%"label"]=> - %unicode|string%(1) "a" -} -[006] -bool(false) -[008] -array(5) { - [%u|b%"a"]=> - %unicode|string%(1) "2" - [%u|b%"c"]=> - %unicode|string%(1) "3" - [%u|b%"C"]=> - %unicode|string%(1) "4" - [%u|b%"d"]=> - NULL - [%u|b%"e"]=> - %unicode|string%(1) "1" -} - -Warning: mysql_fetch_assoc(): supplied resource is not a valid MySQL result resource in %s on line %d - -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -[010] -array(5) { - [%u|b%"id"]=> - %unicode|string%(1) "1" - [%u|b%"label"]=> - %unicode|string%(1) "a" - [%u|b%"_id"]=> - %unicode|string%(1) "1" - [%u|b%"_label"]=> - %unicode|string%(2) "aa" - [%u|b%"_foo"]=> - NULL -} -done! diff --git a/ext/mysql/tests/mysql_fetch_field.phpt b/ext/mysql/tests/mysql_fetch_field.phpt deleted file mode 100644 index 6855fc52dc..0000000000 --- a/ext/mysql/tests/mysql_fetch_field.phpt +++ /dev/null @@ -1,278 +0,0 @@ ---TEST-- -mysql_fetch_field() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php - include "connect.inc"; - - $tmp = NULL; - $link = NULL; - - // Note: no SQL type tests, internally the same function gets used as for mysql_fetch_array() which does a lot of SQL type test - if (!is_null($tmp = @mysql_fetch_field())) - printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - - if (NULL !== ($tmp = @mysql_fetch_field($link))) - printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - - require('table.inc'); - - $version = mysql_get_server_info($link); - if (!preg_match('@(\d+)\.(\d+)\.(\d+)@ism', $version, $matches)) - printf("[003] Cannot get server version\n"); - $version = ($matches[1] * 100) + ($matches[2] * 10) + $matches[3]; - - if (!$res = mysql_query("SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 1", $link)) { - printf("[004] [%d] %s\n", mysql_errno($link), mysql_error($link)); - } - - while ($tmp = mysql_fetch_field($res)) - var_dump($tmp); - var_dump($tmp); - - mysql_free_result($res); - - 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 - 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), var_export($tmp, true)); - - $types = array( - 'BIT' => array(1, 'int'), - 'TINYINT' => array(1, 'int'), - 'BOOL' => array('true', 'int'), - 'BOOL' => array(1, 'int'), - 'SMALLINT' => array(32767, 'int'), - 'MEDIUMINT' => array(8388607, 'int'), - 'INT' => array(100, 'int'), - 'BIGINT' => array(100, 'int'), - 'FLOAT' => array(100, 'real'), - 'DOUBLE' => array(100, 'real'), - 'DECIMAL' => array(100, 'real'), - 'DATE' => array(@date('Y-m-d'), 'date'), - 'DATETIME' => array(@date('Y-m-d H:i:s'), 'datetime'), - 'TIMESTAMP' => array(@date('Y-m-d H:i:s'), 'timestamp'), - 'TIME' => array(@date('H:i:s'), 'time'), - 'YEAR' => array(@date('Y'), 'year'), - 'CHAR(1)' => array('a', 'string'), - 'VARCHAR(1)' => array('a', 'string'), - 'BINARY(1)' => array('a', 'string'), - 'VARBINARY(1)' => array('a', 'string'), - 'TINYBLOB' => array('a', 'blob'), - 'TINYTEXT' => array('a', 'blob'), - 'BLOB' => array('a', 'blob'), - 'TEXT' => array('a', 'blob'), - 'MEDIUMBLOB' => array('a', 'blob'), - 'MEDIUMTEXT' => array('a', 'blob'), - 'LONGBLOB' => array('a', 'blob'), - 'LONGTEXT' => array('a', 'blob'), - 'ENUM("a", "b")' => array('a', 'string'), /* !!! */ - 'SET("a", "b")' => array('a', 'string'), /* !!! */ - ); - - foreach ($types as $type_name => $type_desc) { - if (!mysql_query("DROP TABLE IF EXISTS test", $link)) - printf("[008/%s] [%d] %s\n", $type_name, mysql_errno($link), mysql_error($link)); - if (!mysql_query(sprintf("CREATE TABLE test(id INT, label %s) ENGINE = %s", $type_name, $engine), $link)) { - // server and/or engine might not support the data type - continue; - } - - if (is_string($type_desc[0])) - $insert = sprintf("INSERT INTO test(id, label) VALUES (1, '%s')", $type_desc[0]); - else - $insert = sprintf("INSERT INTO test(id, label) VALUES (1, %s)", $type_desc[0]); - - if (!mysql_query($insert, $link)) { - if (1366 == mysql_errno($link)) { - /* Strict SQL mode - 1366, Incorrect integer value: 'true' for column 'label' at row 1 */ - continue; - } - printf("[009/%s] [%d] %s\n", $type_name, mysql_errno($link), mysql_error($link)); - continue; - } - if (!$res = mysql_query("SELECT id, label FROM test", $link)) { - printf("[010/%s] [%d] %s\n", $type_name, mysql_errno($link), mysql_error($link)); - continue; - } - if (!$tmp = mysql_fetch_field($res, 1)) { - printf("[011/%s] [%d] %s\n", $type_name, mysql_errno($link), mysql_error($link)); - } - - if ($type_desc[1] != $tmp->type) { - printf("[012/%s] Expecting type '%s' got '%s'\n", $type_name, $type_desc[1], $tmp->type); - } - mysql_free_result($res); - } - - if (!mysql_query("DROP TABLE IF EXISTS test", $link)) - printf("[013] [%d] %s\n", mysql_errno($link), mysql_error($link)); - - if (!mysql_query("CREATE TABLE test(id INT DEFAULT 1)")) - printf("[014] [%d] %s\n", mysql_errno($link), mysql_error($link)); - - if (!mysql_query("INSERT INTO test(id) VALUES (2)")) - printf("[015] [%d] %s\n", mysql_errno($link), mysql_error($link)); - - if (!$res = mysql_query("SELECT id FROM test", $link)) { - printf("[016] [%d] %s\n", mysql_errno($link), mysql_error($link)); - } - - var_dump(mysql_fetch_field($res)); - mysql_free_result($res); - - if (!$res = mysql_query("SELECT id FROM test", $link)) { - printf("[017] [%d] %s\n", mysql_errno($link), mysql_error($link)); - } - $res = mysql_list_fields($db, 'test'); - $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-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -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) -} -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) -} -bool(false) - -Warning: mysql_fetch_field(): Bad field offset in %s on line %d - -Warning: mysql_fetch_field(): supplied resource is not a valid MySQL result resource in %s on line %d -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(0) - [%u|b%"primary_key"]=> - int(0) - [%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) -} -Fetch field from mysql_list_fields result set. -object(stdClass)#%d (13) { - [%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|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(1) - [%u|b%"blob"]=> - int(0) - [%u|b%"type"]=> - %unicode|string%(3) "int" - [%u|b%"unsigned"]=> - int(0) - [%u|b%"zerofill"]=> - int(0) -} -done! diff --git a/ext/mysql/tests/mysql_fetch_lengths.phpt b/ext/mysql/tests/mysql_fetch_lengths.phpt deleted file mode 100644 index f59833e918..0000000000 --- a/ext/mysql/tests/mysql_fetch_lengths.phpt +++ /dev/null @@ -1,53 +0,0 @@ ---TEST-- -mysql_fetch_lengths() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include "connect.inc"; - -$tmp = NULL; -$link = NULL; - -if (!is_null($tmp = @mysql_fetch_lengths())) - printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (NULL !== ($tmp = @mysql_fetch_lengths($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)); -} - -while ($row = mysql_fetch_assoc($res)) - var_dump(mysql_fetch_lengths($res)); -var_dump(mysql_fetch_lengths($res)); - -mysql_free_result($res); - -var_dump(mysql_fetch_lengths($res)); - -mysql_close($link); -print "done!"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -array(2) { - [0]=> - int(1) - [1]=> - int(1) -} -bool(false) - -Warning: mysql_fetch_lengths(): supplied resource is not a valid MySQL result resource in %s on line %d -bool(false) -done! diff --git a/ext/mysql/tests/mysql_fetch_object.phpt b/ext/mysql/tests/mysql_fetch_object.phpt deleted file mode 100644 index 5038863458..0000000000 --- a/ext/mysql/tests/mysql_fetch_object.phpt +++ /dev/null @@ -1,153 +0,0 @@ ---TEST-- -mysql_fetch_object() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include "connect.inc"; - -$tmp = NULL; -$link = NULL; - -if (!is_null($tmp = @mysql_fetch_object())) - printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (false !== ($tmp = @mysql_fetch_object($link))) - printf("[002] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -require('table.inc'); -if (!$res = mysql_query("SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 5", $link)) { - printf("[003] [%d] %s\n", mysql_errno($link), mysql_error($link)); -} - -var_dump(mysql_fetch_object($res)); - -class mysql_fetch_object_test { - - public $a = null; - public $b = null; - - public function toString() { - var_dump($this); - } -} - -var_dump(mysql_fetch_object($res, 'mysql_fetch_object_test')); - -class mysql_fetch_object_construct extends mysql_fetch_object_test { - - public function __construct($a, $b) { - $this->a = $a; - $this->b = $b; - } - -} - -var_dump(mysql_fetch_object($res, 'mysql_fetch_object_construct', null)); -var_dump(mysql_fetch_object($res, 'mysql_fetch_object_construct', array('a'))); -var_dump(mysql_fetch_object($res, 'mysql_fetch_object_construct', array('a', 'b'))); -var_dump(mysql_fetch_object($res, 'mysql_fetch_object_construct', array('a', 'b', 'c'))); -var_dump(mysql_fetch_object($res, 'mysql_fetch_object_construct', "no array and not null")); -var_dump(mysql_fetch_object($res)); -var_dump(mysql_fetch_object($res, 'mysql_fetch_object_construct', array('a', 'b'))); - -class mysql_fetch_object_private_construct { - private function __construct($a, $b) { - var_dump($a); - } -} -var_dump(mysql_fetch_object($res, 'mysql_fetch_object_private_construct', array('a', 'b'))); - -mysql_free_result($res); - -if (!$res = mysql_query("SELECT id AS ID, label FROM test AS TEST", $link)) { - printf("[009] [%d] %s\n", mysql_errno($link), mysql_error($link)); -} - -mysql_free_result($res); - -var_dump(mysql_fetch_object($res)); - -// Fatal error, script execution will end -var_dump(mysql_fetch_object($res, 'this_class_does_not_exist')); - -mysql_close($link); -print "done!"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -object(stdClass)#%d (2) { - [%u|b%"ID"]=> - %unicode|string%(1) "1" - [%u|b%"label"]=> - %unicode|string%(1) "a" -} -object(mysql_fetch_object_test)#%d (4) { - [%u|b%"a"]=> - NULL - [%u|b%"b"]=> - NULL - [%u|b%"ID"]=> - %unicode|string%(1) "2" - [%u|b%"label"]=> - %unicode|string%(1) "b" -} - -Warning: Missing argument 1 for mysql_fetch_object_construct::__construct() in %s on line %d - -Warning: Missing argument 2 for mysql_fetch_object_construct::__construct() in %s on line %d - -Notice: Undefined variable: a in %s on line %d - -Notice: Undefined variable: b in %s on line %d -object(mysql_fetch_object_construct)#%d (4) { - [%u|b%"a"]=> - NULL - [%u|b%"b"]=> - NULL - [%u|b%"ID"]=> - %unicode|string%(1) "3" - [%u|b%"label"]=> - %unicode|string%(1) "c" -} - -Warning: Missing argument 2 for mysql_fetch_object_construct::__construct() in %s on line %d - -Notice: Undefined variable: b in %s on line %d -object(mysql_fetch_object_construct)#%d (4) { - [%u|b%"a"]=> - %unicode|string%(1) "a" - [%u|b%"b"]=> - NULL - [%u|b%"ID"]=> - %unicode|string%(1) "4" - [%u|b%"label"]=> - %unicode|string%(1) "d" -} -object(mysql_fetch_object_construct)#%d (4) { - [%u|b%"a"]=> - %unicode|string%(1) "a" - [%u|b%"b"]=> - %unicode|string%(1) "b" - [%u|b%"ID"]=> - %unicode|string%(1) "5" - [%u|b%"label"]=> - %unicode|string%(1) "e" -} -bool(false) -bool(false) -bool(false) -bool(false) -bool(false) - -Warning: mysql_fetch_object(): supplied resource is not a valid MySQL result resource in %s on line %d -bool(false) - -Fatal error: Class 'this_class_does_not_exist' not found in %s on line %d diff --git a/ext/mysql/tests/mysql_fetch_row.phpt b/ext/mysql/tests/mysql_fetch_row.phpt deleted file mode 100644 index d26f7a4d82..0000000000 --- a/ext/mysql/tests/mysql_fetch_row.phpt +++ /dev/null @@ -1,57 +0,0 @@ ---TEST-- -mysql_fetch_row() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include "connect.inc"; - -$tmp = NULL; -$link = NULL; - -if (!is_null($tmp = @mysql_fetch_row())) - printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (NULL !== ($tmp = @mysql_fetch_row($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)); -} - -print "[004]\n"; -var_dump(mysql_fetch_row($res)); - -print "[005]\n"; -var_dump(mysql_fetch_row($res)); - -mysql_free_result($res); - -var_dump(mysql_fetch_row($res)); - -mysql_close($link); -print "done!"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -[004] -array(2) { - [0]=> - %unicode|string%(1) "1" - [1]=> - %unicode|string%(1) "a" -} -[005] -bool(false) - -Warning: mysql_fetch_row(): supplied resource is not a valid MySQL result resource in %s on line %d -bool(false) -done! diff --git a/ext/mysql/tests/mysql_field_flags.phpt b/ext/mysql/tests/mysql_field_flags.phpt deleted file mode 100644 index bf2a193f57..0000000000 --- a/ext/mysql/tests/mysql_field_flags.phpt +++ /dev/null @@ -1,159 +0,0 @@ ---TEST-- -mysql_field_flags() ---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_flags())) - printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (null !== ($tmp = @mysql_field_flags($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 2", $link)) { - printf("[003] [%d] %s\n", mysql_errno($link), mysql_error($link)); -} - -if (NULL !== ($tmp = mysql_field_flags($res))) - printf("[004] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (false !== ($tmp = mysql_field_flags($res, -1))) - printf("[005] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -if (!is_string($tmp = mysql_field_flags($res, 0)) || empty($tmp)) - printf("[006] Expecting non empty string, got %s/%s\n", gettype($tmp), $tmp); - -if ((version_compare(PHP_VERSION, '5.9.9', '>') == 1) && - (version_compare(PHP_VERSION, '6.9.9', '<=') == 1) && - !is_unicode($tmp)) { - printf("[007] Check the unicode support!\n"); - var_inspect($tmp); -} - -if (false !== ($tmp = mysql_field_flags($res, 2))) - printf("[008] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -mysql_free_result($res); - -$version = mysql_get_server_info($link); -if (!preg_match('@(\d+)\.(\d+)\.(\d+)@ism', $version, $matches)) - printf("[009] Cannot get server version\n"); -$version = ($matches[1] * 1000) + ($matches[2] * 100) + $matches[3]; - -$tables = array( - 'label INT, UNIQUE KEY (label)' => array( - array('label', '1'), - 'label' => array(($version < 5000) ? 'multiple_key' : 'unique_key') - ), - 'labela INT, label2 CHAR(1), KEY keyname (labela, label2)' => array( - array('labela, label2', "1, 'a'"), - 'labela' => array('multiple_key'), - ), - 'label1 BLOB' => array( - array('label1', "'blob'"), - 'label1' => array('blob', 'binary'), - ), - 'label1 INT UNSIGNED' => array( - array('label1', '100'), - 'label1' => array('unsigned'), - ), - 'label1 INT UNSIGNED NOT NULL AUTO INCREMENT' => array( - array('label1', '100'), - 'label1' => array('auto_increment', - 'unsigned'), - ), - 'label1 ENUM("a", "b")' => array( - array('label1', "'a'"), - 'label1' => array('enum'), - ), - 'label1 SET("a", "b")' => array( - array('label1', "'a'"), - 'label1' => array('set'), - ), - 'label1 TIMESTAMP' => array( - array('label1', sprintf("'%s'", @date("Y-m-d H:i:s"))), - 'label1' => array( - 'timestamp', - 'binary', - 'not_null'), - ), -); - -if ($version < 5600) { - $tables['label1 TIMESTAMP']['label1'][] = 'zerofill'; - $tables['label1 TIMESTAMP']['label1'][] = 'unsigned'; -} - - -foreach ($tables as $columns => $expected) { - if (!mysql_query("DROP TABLE IF EXISTS test", $link)) { - printf("[010/%s] [%d] %s\n", $columns, mysql_errno($link), mysql_error($link)); - continue; - } - $sql = sprintf("CREATE TABLE test(id INT, %s) ENGINE = %s", $columns, $engine); - if (!@mysql_query($sql, $link)) { - // server or engine might not support this - continue; - } - - reset($expected); - list($k, $values) = each($expected); - $sql = sprintf("INSERT INTO test(id, %s) VALUES (1, %s)", $values[0], $values[1]); - if (!mysql_query($sql, $link)) { - printf("[011/%s] '%s', [%d] %s\n", $columns, $sql, mysql_errno($link), mysql_error($link)); - continue; - } - - if (!$res = mysql_query(sprintf("SELECT id, %s FROM test", $values[0]), $link)) { - printf("[012/%s] [%d] %s\n", $columns, mysql_errno($link), mysql_error($link)); - continue; - } - - $i = 1; - while (list($field, $flags) = each($expected)) { - $tmp = mysql_field_flags($res, $i++); - - foreach ($flags as $k => $flag) { - if (!preg_match(sprintf('@\s*%s\s*@ismU', $flag), $tmp)) { - printf("[013/%s] Field '%s', flag '%s' not found, [%d] %s\n", $columns, $field, $flag, mysql_errno($link), mysql_error($link)); - } - } - foreach ($flags as $k => $flag) { - $tmp = preg_replace(sprintf('@\s*%s\s*@ismU', $flag), '', $tmp); - } - if ('' != $tmp) - printf("[014/%s] Field '%s', unexpected flags '%s' found, [%d] %s\n", $columns, $field, $tmp, mysql_errno($link), mysql_error($link)); - } - mysql_free_result($res); -} - -var_dump(mysql_field_flags($res, 0)); - -mysql_close($link); -print "done!"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Warning: mysql_field_flags() expects exactly 2 parameters, 1 given in %s on line %d - -Warning: mysql_field_flags(): Field -1 is invalid for MySQL result index %d in %s on line %d - -Warning: mysql_field_flags(): Field 2 is invalid for MySQL result index %d in %s on line %d - -Warning: mysql_field_flags(): supplied resource is not a valid MySQL result resource in %s on line %d -bool(false) -done! diff --git a/ext/mysql/tests/mysql_field_len.phpt b/ext/mysql/tests/mysql_field_len.phpt deleted file mode 100644 index a7b4cabee3..0000000000 --- a/ext/mysql/tests/mysql_field_len.phpt +++ /dev/null @@ -1,60 +0,0 @@ ---TEST-- -mysql_field_len() ---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_len())) - printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (null !== ($tmp = @mysql_field_len($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 2", $link)) { - printf("[003] [%d] %s\n", mysql_errno($link), mysql_error($link)); -} - -if (NULL !== ($tmp = mysql_field_len($res))) -printf("[004] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (false !== ($tmp = mysql_field_len($res, -1))) - printf("[005] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -if (!is_int($tmp = mysql_field_len($res, 0)) || empty($tmp)) - printf("[006] Expecting non empty integer, got %s/%s\n", gettype($tmp), $tmp); - -if (false !== ($tmp = mysql_field_len($res, 2))) - printf("[008] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -mysql_free_result($res); - -var_dump(mysql_field_len($res, 0)); - -mysql_close($link); -print "done!"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Warning: mysql_field_len() expects exactly 2 parameters, 1 given in %s on line %d - -Warning: mysql_field_len(): Field -1 is invalid for MySQL result index %d in %s on line %d - -Warning: mysql_field_len(): Field 2 is invalid for MySQL result index %d in %s on line %d - -Warning: mysql_field_len(): supplied resource is not a valid MySQL result resource in %s on line %d -bool(false) -done! diff --git a/ext/mysql/tests/mysql_field_name.phpt b/ext/mysql/tests/mysql_field_name.phpt deleted file mode 100644 index 1ef613babe..0000000000 --- a/ext/mysql/tests/mysql_field_name.phpt +++ /dev/null @@ -1,60 +0,0 @@ ---TEST-- -mysql_field_name() ---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_name())) - printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (null !== ($tmp = @mysql_field_name($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 2", $link)) { - printf("[003] [%d] %s\n", mysql_errno($link), mysql_error($link)); -} - -if (NULL !== ($tmp = mysql_field_name($res))) - printf("[004] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (false !== ($tmp = mysql_field_name($res, -1))) - printf("[005] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -var_dump(mysql_field_name($res, 0)); - -if (false !== ($tmp = mysql_field_name($res, 2))) - printf("[008] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -mysql_free_result($res); - -var_dump(mysql_field_name($res, 0)); - -mysql_close($link); -print "done!"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Warning: mysql_field_name() expects exactly 2 parameters, 1 given in %s on line %d - -Warning: mysql_field_name(): Field -1 is invalid for MySQL result index %d in %s on line %d -%unicode|string%(2) "id" - -Warning: mysql_field_name(): Field 2 is invalid for MySQL result index %d in %s on line %d - -Warning: mysql_field_name(): supplied resource is not a valid MySQL result resource in %s on line %d -bool(false) -done! diff --git a/ext/mysql/tests/mysql_field_seek.phpt b/ext/mysql/tests/mysql_field_seek.phpt deleted file mode 100644 index a9eab70bca..0000000000 --- a/ext/mysql/tests/mysql_field_seek.phpt +++ /dev/null @@ -1,144 +0,0 @@ ---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-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -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(): supplied resource is not a valid MySQL result resource in %s on line %d -bool(false) -done! diff --git a/ext/mysql/tests/mysql_field_table.phpt b/ext/mysql/tests/mysql_field_table.phpt deleted file mode 100644 index d95be96ee5..0000000000 --- a/ext/mysql/tests/mysql_field_table.phpt +++ /dev/null @@ -1,60 +0,0 @@ ---TEST-- -mysql_field_table() ---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_table())) - printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (null !== ($tmp = @mysql_field_table($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 2", $link)) { - printf("[003] [%d] %s\n", mysql_errno($link), mysql_error($link)); -} - -if (NULL !== ($tmp = mysql_field_table($res))) - printf("[004] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (false !== ($tmp = mysql_field_table($res, -1))) - printf("[005] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -var_dump(mysql_field_table($res, 0)); - -if (false !== ($tmp = mysql_field_table($res, 2))) - printf("[008] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -mysql_free_result($res); - -var_dump(mysql_field_table($res, 0)); - -mysql_close($link); -print "done!"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Warning: mysql_field_table() expects exactly 2 parameters, 1 given in %s on line %d - -Warning: mysql_field_table(): Field -1 is invalid for MySQL result index %d in %s on line %d -%unicode|string%(4) "test" - -Warning: mysql_field_table(): Field 2 is invalid for MySQL result index %d in %s on line %d - -Warning: mysql_field_table(): supplied resource is not a valid MySQL result resource in %s on line %d -bool(false) -done! diff --git a/ext/mysql/tests/mysql_field_type.phpt b/ext/mysql/tests/mysql_field_type.phpt deleted file mode 100644 index e4b774a691..0000000000 --- a/ext/mysql/tests/mysql_field_type.phpt +++ /dev/null @@ -1,60 +0,0 @@ ---TEST-- -mysql_field_type() ---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_type())) - printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (null !== ($tmp = @mysql_field_type($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 2", $link)) { - printf("[003] [%d] %s\n", mysql_errno($link), mysql_error($link)); -} - -if (NULL !== ($tmp = mysql_field_type($res))) - printf("[004] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (false !== ($tmp = mysql_field_type($res, -1))) - printf("[005] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -var_dump(mysql_field_type($res, 0)); - -if (false !== ($tmp = mysql_field_type($res, 2))) - printf("[008] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -mysql_free_result($res); - -var_dump(mysql_field_type($res, 0)); - -mysql_close($link); -print "done!"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Warning: mysql_field_type() expects exactly 2 parameters, 1 given in %s on line %d - -Warning: mysql_field_type(): Field -1 is invalid for MySQL result index %d in %s on line %d -%unicode|string%(3) "int" - -Warning: mysql_field_type(): Field 2 is invalid for MySQL result index %d in %s on line %d - -Warning: mysql_field_type(): supplied resource is not a valid MySQL result resource in %s on line %d -bool(false) -done! diff --git a/ext/mysql/tests/mysql_free_result.phpt b/ext/mysql/tests/mysql_free_result.phpt deleted file mode 100644 index 582297c80f..0000000000 --- a/ext/mysql/tests/mysql_free_result.phpt +++ /dev/null @@ -1,52 +0,0 @@ ---TEST-- -mysql_free_result() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include "connect.inc"; - -$tmp = NULL; -$link = NULL; - -if (!is_null($tmp = @mysql_free_result())) - printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (null !== ($tmp = @mysql_free_result($link))) - printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -require('table.inc'); -if (!$res = mysql_query("SELECT id FROM test ORDER BY id LIMIT 1", $link)) { - printf("[003] [%d] %s\n", mysql_errno($link), mysql_error($link)); -} - -var_dump(mysql_free_result($res)); -var_dump(mysql_free_result($res)); - -if ($tmp = sys_get_temp_dir()) { - $tmpname = tempnam($tmp, 'free_result'); - if ($fp = fopen($tmpname, 'w')) { - if (false !== ($tmp = @mysql_free_result($fp))) - printf("[004] Expecting boolean/false got %s/%s\n", gettype($tmp), $tmp); - fclose($fp); - @unlink($tmpname); - } -} - -mysql_close($link); -print "done!"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -bool(true) - -Warning: mysql_free_result(): supplied resource is not a valid MySQL result resource in %s on line %d -bool(false) -done! diff --git a/ext/mysql/tests/mysql_get_client_info.phpt b/ext/mysql/tests/mysql_get_client_info.phpt deleted file mode 100644 index 6e84628476..0000000000 --- a/ext/mysql/tests/mysql_get_client_info.phpt +++ /dev/null @@ -1,25 +0,0 @@ ---TEST-- -mysql_get_client_info() ---SKIPIF-- -<?php require_once('skipif.inc'); ?> ---FILE-- -<?php -include "connect.inc"; -if (!is_string($info = mysql_get_client_info()) || ('' === $info)) - printf("[001] Expecting string/any_non_empty, got %s/%s\n", gettype($info), $info); - -if ((version_compare(PHP_VERSION, '5.9.9', '>') == 1) && - (version_compare(PHP_VERSION, '6.9.9', '<=') == 1) && - !is_unicode($info)) { - printf("[002] Expecting Unicode!\n"); - var_inspect($info); -} - -if (!is_null($tmp = @mysql_get_client_info("too many arguments"))) { - printf("[003] Expecting NULL/NULL got %s/%s\n", $tmp, gettype($tmp)); -} - -print "done!"; -?> ---EXPECTF-- -done!
\ No newline at end of file diff --git a/ext/mysql/tests/mysql_get_host_info.phpt b/ext/mysql/tests/mysql_get_host_info.phpt deleted file mode 100644 index a98ab5be35..0000000000 --- a/ext/mysql/tests/mysql_get_host_info.phpt +++ /dev/null @@ -1,47 +0,0 @@ ---TEST-- -mysql_get_host_info() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include_once "connect.inc"; - -if (NULL !== ($tmp = @mysql_get_host_info(NULL))) - printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -require "table.inc"; -if (!is_string($info = mysql_get_host_info($link)) || ('' === $info)) - printf("[003] Expecting string/any_non_empty, got %s/%s\n", gettype($info), $info); - -$def_info = mysql_get_host_info(); -if ($def_info !== $info) { - printf("[004] Host info for the default link and the specified link differ, [%d] %s\n", - mysql_errno(), mysql_error()); - - var_dump($def_info); - var_dump($info); -} - -if ((version_compare(PHP_VERSION, '5.9.9', '>') == 1) && - (version_compare(PHP_VERSION, '6.9.9', '<=') == 1) && - !is_unicode($info)) { - printf("[005] Expecting Unicode error message!\n"); - var_inspect($info); -} - -if (!is_null($tmp = @mysql_get_host_info($link, "too many arguments"))) { - printf("[006] Expecting NULL/NULL got %s/%s\n", $tmp, gettype($tmp)); -} - -print "done!"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_get_proto_info.phpt b/ext/mysql/tests/mysql_get_proto_info.phpt deleted file mode 100644 index 3e1481121e..0000000000 --- a/ext/mysql/tests/mysql_get_proto_info.phpt +++ /dev/null @@ -1,35 +0,0 @@ ---TEST-- -mysql_get_proto_info() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include_once "connect.inc"; - -if (NULL !== ($tmp = @mysql_get_proto_info(NULL))) - printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -require "table.inc"; -if (!is_int($info = mysql_get_proto_info($link)) || (0 === $info)) - printf("[003] Expecting int/any_non_empty, got %s/%s\n", gettype($info), $info); - -if (!is_int($info2 = mysql_get_proto_info()) || (0 === $info2)) - printf("[004] Expecting int/any_non_empty, got %s/%s\n", gettype($info2), $info2); - -assert($info === $info2); - -if (NULL !== ($tmp = @mysql_get_proto_info('too many', 'arguments'))) - printf("[005] Expecting NULL got %s/%s\n", gettype($tmp), $tmp); - -print "done!"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_get_server_info.phpt b/ext/mysql/tests/mysql_get_server_info.phpt deleted file mode 100644 index e29222b966..0000000000 --- a/ext/mysql/tests/mysql_get_server_info.phpt +++ /dev/null @@ -1,42 +0,0 @@ ---TEST-- -mysql_get_server_info() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include "connect.inc"; - -if (null !== ($tmp = @mysql_get_server_info(NULL))) - printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -require "table.inc"; -if (!is_string($info = mysql_get_server_info($link)) || ('' === $info)) - printf("[003] Expecting string/any_non_empty, got %s/%s\n", gettype($info), $info); - -$def_info = mysql_get_server_info(); -if ($def_info !== $info) { - printf("[004] Server info for the default link and the specified link differ, [%d] %s\n", - mysql_errno(), mysql_error()); - - var_dump($def_info); - var_dump($info); -} - -if ((version_compare(PHP_VERSION, '5.9.9', '>') == 1) && - (version_compare(PHP_VERSION, '6.9.9', '<=') == 1) && - !is_unicode($info)) { - printf("[005] Expecting Unicode error message!\n"); - var_inspect($info); -} - -if (NULL !== ($tmp = @mysql_get_server_info('too many', 'just too many'))) - printf("[006] Expecting NULL got %s/%s\n", gettype($tmp), $tmp); - -print "done!"; -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_info.phpt b/ext/mysql/tests/mysql_info.phpt deleted file mode 100644 index 82c680768b..0000000000 --- a/ext/mysql/tests/mysql_info.phpt +++ /dev/null @@ -1,76 +0,0 @@ ---TEST-- -mysql_info() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include "connect.inc"; - -if (false !== ($tmp = @mysql_info())) - printf("[001] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -if (NULL !== ($tmp = @mysql_info(NULL))) - printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -require "table.inc"; -if (!$res = mysql_query("INSERT INTO test(id, label) VALUES (100, 'a')", $link)) - printf("[003] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (false !== ($tmp = mysql_info($link))) - printf("[004] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -if (!$res = mysql_query("INSERT INTO test(id, label) VALUES (101, 'a'), (102, 'b')", $link)) - printf("[005] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (!is_string($tmp = mysql_info($link)) || ('' == $tmp)) - printf("[006] Expecting string/any_non_empty, got %s/%s\n", gettype($tmp), $tmp); - -if (!$res = mysql_query('INSERT INTO test(id, label) SELECT id + 200, label FROM test', $link)) - printf("[007] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (!is_string($tmp = mysql_info($link)) || ('' == $tmp)) - printf("[008] Expecting string/any_non_empty, got %s/%s\n", gettype($tmp), $tmp); - -if (!$res = mysql_query('ALTER TABLE test MODIFY label CHAR(2)', $link)) - printf("[009] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (!is_string($tmp = mysql_info($link)) || ('' == $tmp)) - printf("[010] Expecting string/any_non_empty, got %s/%s\n", gettype($tmp), $tmp); - -if (!$res = mysql_query("UPDATE test SET label = 'b' WHERE id >= 100", $link)) - printf("[011] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (!is_string($tmp = mysql_info($link)) || ('' == $tmp)) - printf("[012] Expecting string/any_non_empty, got %s/%s\n", gettype($tmp), $tmp); - -if ((version_compare(PHP_VERSION, '5.9.9', '>') == 1) && - (version_compare(PHP_VERSION, '6.9.9', '<=') == 1) && - !is_unicode($tmp)) { - printf("[013] Expecting Unicode!\n"); - var_inspect($info); -} - -if (!is_string($def_tmp = mysql_info()) || ('' == $def_tmp)) - printf("[014] Expecting string/any_non_empty, got %s/%s\n", gettype($def_tmp), $def_tmp); - -if ($def_tmp !== $tmp) { - printf("[015] Results differ for default link and specified link, [%d] %s\n", - mysql_errno(), mysql_error()); - var_inspect($tmp); - var_inspect($def_tmp); -} - -// NOTE: no LOAD DATA INFILE test - -print "done!"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_insert_id.phpt b/ext/mysql/tests/mysql_insert_id.phpt deleted file mode 100644 index 93319dad23..0000000000 --- a/ext/mysql/tests/mysql_insert_id.phpt +++ /dev/null @@ -1,73 +0,0 @@ ---TEST-- -mysql_insert_id() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include "connect.inc"; -include 'setupdefault.inc'; - -$tmp = NULL; -$link = NULL; - -if (0 !== ($tmp = @mysql_insert_id())) - printf("[001] Expecting int/0, got %s/%s\n", gettype($tmp), $tmp); - -if (NULL !== ($tmp = @mysql_insert_id($link))) - printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (!is_null($tmp = @mysql_insert_id($link, 'too many args'))) - printf("[002a] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -require('table.inc'); - -if (0 !== ($tmp = mysql_insert_id($link))) - printf("[003] Expecting int/0, got %s/%s\n", gettype($tmp), $tmp); - -if (!$res = mysql_query("SELECT id, label FROM test ORDER BY id LIMIT 1", $link)) { - printf("[004] [%d] %s\n", mysql_errno($link), mysql_error($link)); -} -if (0 !== ($tmp = mysql_insert_id($link))) - printf("[005] Expecting int/0, got %s/%s\n", gettype($tmp), $tmp); -mysql_free_result($res); - -// no auto_increment column -if (!$res = mysql_query("INSERT INTO test(id, label) VALUES (100, 'a')", $link)) { - printf("[006] [%d] %s\n", mysql_errno($link), mysql_error($link)); -} -if (0 !== ($tmp = mysql_insert_id($link))) - printf("[007] Expecting int/0, got %s/%s\n", gettype($tmp), $tmp); - -if (!$res = mysql_query("ALTER TABLE test MODIFY id INT NOT NULL AUTO_INCREMENT", $link)) { - printf("[008] [%d] %s\n", mysql_errno($link), mysql_error($link)); -} -if (!$res = mysql_query("INSERT INTO test(label) VALUES ('a')", $link)) { - printf("[009] [%d] %s\n", mysql_errno($link), mysql_error($link)); -} -if (0 === ($tmp = mysql_insert_id($link))) - printf("[010] Expecting int/not zero, got %s/%s\n", gettype($tmp), $tmp); - -if ($tmp !== ($tmp2 = mysql_insert_id())) - printf("[011] Expecting %s/%s, got %s/%s\n", - gettype($tmp), $tmp, - gettype($tmp2), $tmp2); - -mysql_close($link); - -var_dump(mysql_insert_id($link)); - -print "done!"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Warning: mysql_insert_id(): supplied resource is not a valid MySQL-Link resource in %s on line %d -bool(false) -done! diff --git a/ext/mysql/tests/mysql_list_dbs.phpt b/ext/mysql/tests/mysql_list_dbs.phpt deleted file mode 100644 index 559b5a05d9..0000000000 --- a/ext/mysql/tests/mysql_list_dbs.phpt +++ /dev/null @@ -1,57 +0,0 @@ ---TEST-- -mysql_list_dbs() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include_once "connect.inc"; - -$tmp = NULL; -$link = NULL; - -if (NULL !== ($tmp = @mysql_list_dbs(NULL))) - printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (NULL !== ($tmp = @mysql_list_dbs($link, $link))) - printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -require('table.inc'); - -if (!$res = @mysql_list_dbs($link)) - printf("[003] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (!$num = mysql_num_rows($res)) - printf("[004] Empty database list? [%d] %s\n", mysql_errno($link), mysql_error($link)); - -$row = mysql_fetch_array($res, MYSQL_NUM); -if ((version_compare(PHP_VERSION, '5.9.9', '>') == 1) && - (version_compare(PHP_VERSION, '6.9.9', '<=') == 1) && - !is_unicode($row[0])) { - printf("[005] Check for unicode support\n"); - var_inspect($row); -} - -mysql_free_result($res); - -if (!$res2 = @mysql_list_dbs()) - printf("[006] [%d] %s\n", mysql_errno(), mysql_error()); - -$row2 = mysql_fetch_array($res2, MYSQL_NUM); -mysql_free_result($res2); - -assert($row === $row2); - -mysql_close($link); - -print "done!\n"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_list_fields.phpt b/ext/mysql/tests/mysql_list_fields.phpt deleted file mode 100644 index 6b6ae9b319..0000000000 --- a/ext/mysql/tests/mysql_list_fields.phpt +++ /dev/null @@ -1,80 +0,0 @@ ---TEST-- -mysql_list_fields() ---SKIPIF-- -<?php -require_once 'skipif.inc'; -require_once 'skipifconnectfailure.inc'; -?> ---FILE-- -<?php -require_once 'connect.inc'; - -$tmp = NULL; -$link = NULL; - -require 'table.inc'; - -if (!$res = mysql_list_fields($db, 'test', $link)) - printf("[003] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (2 !== ($num = mysql_num_fields($res))) - printf("[004] Expecting two fields from 'test', got %d. [%d] %s\n", $num, mysql_errno($link), mysql_error($link)); - -mysql_free_result($res); - -if (!mysql_query("DROP TABLE IF EXISTS test2", $link)) - printf("[005] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (!$res = @mysql_list_fields($db, 'test2', $link)) - printf("[006] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (!$res = mysql_list_fields($db, 'test', $link)) - printf("[007] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (2 !== ($num = mysql_num_fields($res))) - printf("[008] Expecting 2 fields from 'test', got %d. [%d] %s\n", $num, mysql_errno($link), mysql_error($link)); - -var_dump(mysql_fetch_assoc($res)); -for ($field_offset = 0; $field_offset < mysql_num_fields($res); $field_offset++) { - printf("Field Offset %d\n", $field_offset); - printf("mysql_field_flags(): %s\n", mysql_field_flags($res, $field_offset)); - printf("mysql_field_len(): %s\n", mysql_field_len($res, $field_offset)); - printf("mysql_field_name(): %s\n", mysql_field_name($res, $field_offset)); - printf("mysql_field_type(): %s\n", mysql_field_type($res, $field_offset)); -} - -mysql_free_result($res); -mysql_close($link); - -print "done!"; -?> ---CLEAN-- -<?php -require_once 'connect.inc'; -if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) - printf("[c001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", - $host, $user, $db, $port, $socket); - -if (!mysql_query("DROP TABLE IF EXISTS test", $link)) - printf("[c002] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); - -if (!mysql_query("DROP TABLE IF EXISTS test2", $link)) - printf("[c002] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); - -mysql_close($link); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -[006] [%d] %s -bool(false) -Field Offset 0 -mysql_field_flags()%s -mysql_field_len(): 11 -mysql_field_name(): id -mysql_field_type(): int -Field Offset 1 -mysql_field_flags()%s -mysql_field_len(): %s -mysql_field_name(): label -mysql_field_type(): string -done! diff --git a/ext/mysql/tests/mysql_list_processes.phpt b/ext/mysql/tests/mysql_list_processes.phpt deleted file mode 100644 index 402a10d995..0000000000 --- a/ext/mysql/tests/mysql_list_processes.phpt +++ /dev/null @@ -1,57 +0,0 @@ ---TEST-- -mysql_list_processes() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include "connect.inc"; - -$tmp = NULL; -$link = NULL; - -if (NULL !== ($tmp = @mysql_list_processes($link, $link))) - printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -require('table.inc'); - -if (!$res = mysql_list_processes($link)) - printf("[002] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (!$num = mysql_num_rows($res)) - printf("[003] Empty process list? [%d] %s\n", mysql_errno($link), mysql_error($link)); - -$row = mysql_fetch_array($res, MYSQL_NUM); -if ((version_compare(PHP_VERSION, '5.9.9', '>') == 1) && - (version_compare(PHP_VERSION, '6.9.9', '<=') == 1) && - !is_unicode($row[0])) { - printf("[004] Check for unicode support\n"); - var_inspect($row); -} - -mysql_free_result($res); - -if (!$res = mysql_list_processes()) - printf("[005] [%d] %s\n", mysql_errno(), mysql_error()); - -if (!$num = mysql_num_rows($res)) - printf("[006] Empty process list? [%d] %s\n", mysql_errno(), mysql_error()); - -$row = mysql_fetch_array($res, MYSQL_NUM); -if ((version_compare(PHP_VERSION, '5.9.9', '>') == 1) && - (version_compare(PHP_VERSION, '6.9.9', '<=') == 1) && - !is_unicode($row[0])) { - printf("[007] Check for unicode support\n"); - var_inspect($row); -} - -mysql_free_result($res); -mysql_close($link); - -print "done!\n"; -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_list_tables.phpt b/ext/mysql/tests/mysql_list_tables.phpt deleted file mode 100644 index 3b753ae37a..0000000000 --- a/ext/mysql/tests/mysql_list_tables.phpt +++ /dev/null @@ -1,86 +0,0 @@ ---TEST-- -mysql_list_tables() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include_once "connect.inc"; - -$tmp = NULL; -$link = NULL; - -if (NULL !== ($tmp = @mysql_list_tables())) - printf("[001] Expecting NULL got %s/%s\n", gettype($tmp), $tmp); - -if (NULL !== ($tmp = @mysql_list_tables('too', 'many', 'arguments'))) - printf("[002] Expecting NULL got %s/%s\n", gettype($tmp), $tmp); - -if (false !== ($tmp = @mysql_list_tables(NULL))) - printf("[003] Expecting boolean/false got %s/%s\n", gettype($tmp), $tmp); - -if (NULL !== ($tmp = @mysql_list_tables($db, NULL))) - printf("[004] Expecting NULL got %s/%s\n", gettype($tmp), $tmp); - -require_once('table.inc'); - -if (!$res_def = @mysql_list_tables($db)) - printf("[005] [%d] %s\n", mysql_errno(), mysql_error()); - -if (!$res = @mysql_list_tables($db, $link)) - printf("[006] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (!$res_query = mysql_query("SHOW TABLES", $link)) - printf("[007] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -$tables_def = $tables = $tables_query = array(); - -while ($row = mysql_fetch_assoc($res_def)) - $tables_def[] = $row; -mysql_free_result($res_def); - -while ($row = mysql_fetch_assoc($res)) - $tables[] = $row; -mysql_free_result($res); - -while ($row = mysql_fetch_assoc($res_query)) - $tables_query[] = $row; -mysql_free_result($res_query); - -if ($tables_def !== $tables) { - printf("[008] Got different table lists for default link and specified link\n"); - var_dump($tables_def); - var_dump($tables); -} - -$list1 = $list2 = array(); -foreach ($tables as $k => $tlist) - foreach ($tlist as $k => $table) - $list1[] = $table; - -foreach ($tables_query as $k => $tlist) - foreach ($tlist as $k => $table) - $list2[] = $table; - -if ($list1 !== $list2) { - printf("[009] Got different results for mysql_list_tables() and SHOW TABLES\n"); - var_dump($list1); - var_dump($list2); -} - -if (!in_array('test', $list1)) - printf("[010] Table lists seem to be wrong. Check manually.\n"); - -mysql_close($link); - -print "done!\n"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_max_links.phpt b/ext/mysql/tests/mysql_max_links.phpt deleted file mode 100644 index 32096c426e..0000000000 --- a/ext/mysql/tests/mysql_max_links.phpt +++ /dev/null @@ -1,80 +0,0 @@ ---TEST-- -mysql_[p]connect() - max_links/max_persistent ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---INI-- -mysql.max_links=2 ---FILE-- -<?php -require_once('connect.inc'); - -function my_connect($offset, $host, $user, $passwd, $db, $port, $socket) { - if ($socket) - $host = sprintf("%s:%s", $host, $socket); - else if ($port) - $host = sprintf("%s:%s", $host, $port); - - $link = mysql_connect($host, $user, $passwd, true); - - if (!$link) { - printf("[%03d] Cannot connect using host '%s', user '%s', password '****', [%d] %s\n", - $offset, $host, $user, $passwd, - mysql_errno(), mysql_error()); - return false; - } - - return $link; -} - -$links = array(); - -// try to open 3 links -$links[0] = my_connect(10, $host, $user, $passwd, $db, $port, $socket); -$links[1] = my_connect(20, $host, $user, $passwd, $db, $port, $socket); -$links[2] = my_connect(30, $host, $user, $passwd, $db, $port, $socket); -if (false !== $links[2]) - printf("[040] Last connection should not have been allowed!\n"); - -// free some links but let index 1 remain -unset($links[2]); -mysql_close($links[0]); -unset($links[0]); - -// should be allowed -> second open connection -$links[0] = my_connect(50, $host, $user, $passwd, $db, $port, $socket); -$links[2] = my_connect(60, $host, $user, $passwd, $db, $port, $socket); -ksort($links); -var_dump($links); - -mysql_close($links[0]); -mysql_close($links[1]); -print "done!\n"; -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Warning: mysql_connect(): Too many open links (2) in %s on line %s -[030] Cannot connect using host '%s', user '%s', password '****', [0] 0 - -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Warning: mysql_connect(): Too many open links (2) in %s on line %s -[060] Cannot connect using host '%s', user '%s', password '****', [0] 0 -array(3) { - [0]=> - resource(%d) of type (mysql link) - [1]=> - resource(%d) of type (mysql link) - [2]=> - bool(false) -} -done! diff --git a/ext/mysql/tests/mysql_max_persistent.phpt b/ext/mysql/tests/mysql_max_persistent.phpt deleted file mode 100644 index 36f2266665..0000000000 --- a/ext/mysql/tests/mysql_max_persistent.phpt +++ /dev/null @@ -1,105 +0,0 @@ ---TEST-- -mysql_[p]connect() - max_links/max_persistent ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -require_once('table.inc'); - -mysql_query('DROP USER pcontest', $link); -if (!mysql_query('CREATE USER pcontest IDENTIFIED BY "pcontest"', $link)) { - printf("skip Cannot create second DB user [%d] %s", mysql_errno($link), mysql_error($link)); - mysql_close($link); - die(); -} - -// we might be able to specify the host using CURRENT_USER(), but... -if (!mysql_query(sprintf("GRANT SELECT ON TABLE %s.test TO pcontest@'%%'", $db), $link)) { - printf("skip Cannot GRANT SELECT to second DB user [%d] %s", mysql_errno($link), mysql_error($link)); - mysql_query('REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest', $link); - mysql_query('DROP USER pcontest', $link); - mysql_close($link); - die(); -} -mysql_close($link); -?> ---INI-- -mysql.max_links=2 -mysql.allow_persistent=1 -mysql.max_persistent=1 ---FILE-- -<?php -require_once('connect.inc'); - -function my_connect($offset, $host, $user, $passwd, $db, $port, $socket) { - if ($socket) - $host = sprintf("%s:%s", $host, $socket); - else if ($port) - $host = sprintf("%s:%s", $host, $port); - - - $link = mysql_pconnect($host, $user, $passwd); - if (!$link) { - printf("[%03d] Cannot connect using host '%s', user '%s', password '****', [%d] %s\n", - $offset, $host, $user, $passwd, - mysql_errno(), mysql_error()); - return false; - } - - if (!mysql_select_db($db, $link)) - return false; - - return $link; -} - -$links = array(); - -// try to open 2 links -$links[0] = my_connect(10, $host, $user, $passwd, $db, $port, $socket); -$links[1] = my_connect(20, $host, 'pcontest', 'pcontest', $db, $port, $socket); -if (false !== $links[1]) - printf("[030] Last connection should not have been allowed!\n"); - -// free some links but let index 1 remain -unset($links[1]); -mysql_close($links[0]); -unset($links[0]); - -// should be allowed -> only open connection -$links[0] = my_connect(40, $host, $user, $passwd, $db, $port, $socket); -var_dump($links); - -mysql_query('REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest', $links[0]); -mysql_query('DROP USER pcontest', $links[0]); - -mysql_close($links[0]); -print "done!\n"; -?> ---CLEAN-- -<?php -// connect + select_db -require_once("connect.inc"); -if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) { - printf("[c001] Cannot connect to the server using host=%s/%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", - $host, $myhost, $user, $db, $port, $socket); -} - -@mysql_query('REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest', $link); -@mysql_query('DROP USER pcontest', $link); - -mysql_close($link); -?> ---EXPECTF-- -Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Warning: mysql_pconnect(): Too many open persistent links (1) in %s on line %d -[020] Cannot connect using host '%s', user '%s', password '****', [0] 0 - -Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -array(1) { - [0]=> - resource(%d) of type (mysql link persistent) -} -done! diff --git a/ext/mysql/tests/mysql_mysqlnd_read_timeout_long.phpt b/ext/mysql/tests/mysql_mysqlnd_read_timeout_long.phpt deleted file mode 100644 index 2c67e64878..0000000000 --- a/ext/mysql/tests/mysql_mysqlnd_read_timeout_long.phpt +++ /dev/null @@ -1,38 +0,0 @@ ---TEST-- -mysqlnd.net_read_timeout > default_socket_timeout ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -require_once('connect.inc'); -?> ---INI-- -default_socket_timeout=1 -mysqlnd.net_read_timeout=12 -max_execution_time=12 ---FILE-- -<?php - set_time_limit(12); - include ("connect.inc"); - - if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) { - printf("[001] Connect failed, [%d] %s\n", mysql_errno(), mysqlerror()); - } - - if (!$res = mysql_query("SELECT SLEEP(6)", $link)) - printf("[002] [%d] %s\n", mysql_errno($link), mysql_error($link)); - - var_dump(mysql_fetch_assoc($res)); - - mysql_free_result($res); - mysql_close($link); - - print "done!"; -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -array(1) { - [%u|b%"SLEEP(6)"]=> - %unicode|string%(1) "0" -} -done! diff --git a/ext/mysql/tests/mysql_num_fields.phpt b/ext/mysql/tests/mysql_num_fields.phpt deleted file mode 100644 index f65f8ec165..0000000000 --- a/ext/mysql/tests/mysql_num_fields.phpt +++ /dev/null @@ -1,58 +0,0 @@ ---TEST-- -mysql_num_fields() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include "connect.inc"; - -$tmp = NULL; -$link = NULL; - -if (!is_null($tmp = @mysql_num_fields())) - printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (NULL !== ($tmp = @mysql_num_fields($link))) - printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -require('table.inc'); - -function func_test_mysql_num_fields($link, $query, $expected, $offset, $test_free = false) { - -if (!($res = mysql_query($query, $link))) { - printf("[%03d] [%d] %s\n", $offset, mysql_errno($link), mysql_error($link)); - return; -} - -if ($expected !== ($tmp = mysql_num_fields($res))) - printf("[%03d] Expecting %s/%d, got %s/%d\n", $offset + 1, - gettype($expected), $expected, - gettype($tmp), $tmp); - -mysql_free_result($res); - -if ($test_free && (false !== ($tmp = mysql_num_fields($res)))) - printf("[%03d] Expecting boolean/false, got %s/%s\n", $offset + 2, gettype($tmp), $tmp); -} - -func_test_mysql_num_fields($link, "SELECT 1 AS a", 1, 5); -func_test_mysql_num_fields($link, "SELECT id, label FROM test", 2, 10); -func_test_mysql_num_fields($link, "SELECT 1 AS a, NULL AS b, 'foo' AS c", 3, 15); -func_test_mysql_num_fields($link, "SELECT id FROM test", 1, 20, true); - -mysql_close($link); - -print "done!"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Warning: mysql_num_fields(): supplied resource is not a valid MySQL result resource in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_num_rows.phpt b/ext/mysql/tests/mysql_num_rows.phpt deleted file mode 100644 index 2b69e939be..0000000000 --- a/ext/mysql/tests/mysql_num_rows.phpt +++ /dev/null @@ -1,89 +0,0 @@ ---TEST-- -mysql_num_rows() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include "connect.inc"; - -$tmp = NULL; -$link = NULL; - -if (!is_null($tmp = @mysql_num_rows())) -printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (NULL !== ($tmp = @mysql_num_rows($link))) -printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -require('table.inc'); - -function func_test_mysql_num_rows($link, $query, $expected, $offset, $test_free = false) { - - if (!$res = mysql_query($query, $link)) { - printf("[%03d] [%d] %s\n", $offset, mysql_errno($link), mysql_error($link)); - return; - } - - if ($expected !== ($tmp = mysql_num_rows($res))) - printf("[%03d] Expecting %s/%d, got %s/%d\n", $offset + 1, - gettype($expected), $expected, - gettype($tmp), $tmp); - - mysql_free_result($res); - - if ($test_free && (false !== ($tmp = mysql_num_rows($res)))) - printf("[%03d] Expecting boolean/false, got %s/%s\n", $offset + 2, gettype($tmp), $tmp); -} - -func_test_mysql_num_rows($link, "SELECT 1 AS a", 1, 5); -func_test_mysql_num_rows($link, "SHOW VARIABLES LIKE '%nixnutz%'", 0, 10); -func_test_mysql_num_rows($link, "INSERT INTO test(id, label) VALUES (100, 'z')", NULL, 15); -func_test_mysql_num_rows($link, "SELECT id FROM test LIMIT 2", 2, 20, true); - -if ($res = mysql_query('SELECT COUNT(id) AS num FROM test', $link)) { - - $row = mysql_fetch_assoc($res); - mysql_free_result($res); - - func_test_mysql_num_rows($link, "SELECT id, label FROM test", (int)$row['num'], 25); - -} else { - printf("[030] [%d] %s\n", mysql_errno($link), mysql_error($link)); -} - -if ($res = mysql_unbuffered_query('SELECT id, label FROM test')) { - - if (0 != mysql_num_rows($res)) - printf("[032] Expecting 0 rows got %d\n", mysql_num_rows($res)); - - $rows = 0; - while ($row = mysql_fetch_assoc($res)) - $rows++; - - if ($rows != mysql_num_rows($res)) - printf("[033] Expecting %d rows got %d\n", $rows, mysql_num_rows($res)); - - mysql_free_result($res); -} else { - printf("[034] [%d] %s\n", mysql_errno($link), mysql_error($link)); -} - -mysql_close($link); -print "done!"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in %s on line %d - -Warning: mysql_free_result() expects parameter 1 to be resource, boolean given in %s on line %d - -Warning: mysql_num_rows(): supplied resource is not a valid MySQL result resource in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_pconn_disable.phpt b/ext/mysql/tests/mysql_pconn_disable.phpt deleted file mode 100644 index 6997e5970f..0000000000 --- a/ext/mysql/tests/mysql_pconn_disable.phpt +++ /dev/null @@ -1,61 +0,0 @@ ---TEST-- -mysql_pconnect() - disabling feature ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---INI-- -mysql.allow_persistent=0 -mysql.max_persistent=1 -mysql.max_links=2 ---FILE-- -<?php - require_once("connect.inc"); - require_once("table.inc"); - - if (($plink = my_mysql_connect($host, $user, $passwd, $db, $port, $socket, NULL, true))) - printf("[001] Can connect to the server.\n"); - - if (($res = mysql_query('SELECT id FROM test ORDER BY id ASC', $plink)) && - ($row = mysql_fetch_assoc($res)) && - (mysql_free_result($res))) { - printf("[002] Can fetch data using persistent connection! Data = '%s'\n", - $row['id']); - } - - $thread_id = mysql_thread_id($plink); - mysql_close($plink); - - if (!($plink = my_mysql_connect($host, $user, $passwd, $db, $port, $socket, NULL, true))) - printf("[003] Cannot connect, [%d] %s\n", mysql_errno(), mysql_error()); - - if (mysql_thread_id($plink) != $thread_id) - printf("[004] Looks like the second call to pconnect() did not give us the same connection.\n"); - - $thread_id = mysql_thread_id($plink); - mysql_close($plink); - - if (!($plink = my_mysql_connect($host, $user, $passwd, $db, $port, $socket))) - printf("[005] Cannot connect, [%d] %s\n", mysql_errno(), mysql_error()); - - if (mysql_thread_id($plink) == $thread_id) - printf("[006] Looks like connect() did not return a new connection.\n"); - - print "done!"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -[001] Can connect to the server. -[002] Can fetch data using persistent connection! Data = '1' - -Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_pconn_kill.phpt b/ext/mysql/tests/mysql_pconn_kill.phpt deleted file mode 100644 index eb1feb7b85..0000000000 --- a/ext/mysql/tests/mysql_pconn_kill.phpt +++ /dev/null @@ -1,117 +0,0 @@ ---TEST-- -mysql_pconnect() - killing persitent connection ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---INI-- -mysql.allow_persistent=1 -mysql.max_persistent=2 ---FILE-- -<?php - include "connect.inc"; - include "table.inc"; - - if ($socket) - $myhost = sprintf("%s:%s", $host, $socket); - else if ($port) - $myhost = sprintf("%s:%s", $host, $port); - else - $myhost = $host; - - if (!($plink = mysql_pconnect($myhost, $user, $passwd))) - printf("[001] Cannot connect to the server using host=%s/%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", - $host, $myhost, $user, $db, $port, $socket); - mysql_select_db($db, $plink); - - $pthread_id = mysql_thread_id($plink); - $thread_id = mysql_thread_id($link); - - if (!($res = mysql_query("SHOW FULL PROCESSLIST", $link))) - printf("[002] Cannot get processlist, [%d] %s\n", mysql_errno($link), mysql_error($link)); - - $processlist = array(); - while ($row = mysql_fetch_assoc($res)) - $processlist[$row['Id']] = $row; - mysql_free_result($res); - - if (!isset($processlist[$thread_id])) - printf("[003] Cannot find regular connection thread in process list, [%d] %s\n", mysql_errno($link), mysql_error($link)); - if (!isset($processlist[$pthread_id])) - printf("[004] Cannot find persistent connection thread in process list, [%d] %s\n", mysql_errno($link), mysql_error($link)); - - if (!mysql_query(sprintf("KILL %d", $pthread_id), $link)) - printf("[005] Cannot kill persistent connection thread, [%d] %s\n", mysql_errno($link), mysql_error($link)); - - while (1) { - if (!($res = mysql_query("SHOW FULL PROCESSLIST", $link))) - printf("[006] Cannot get processlist, [%d] %s\n", mysql_errno($link), mysql_error($link)); - - $processlist2 = array(); - while ($row = mysql_fetch_assoc($res)) - $processlist2[$row['Id']] = $row; - mysql_free_result($res); - if (isset($processlist2[$pthread_id])) { - sleep(1); - } else { - break; - } - } - - if (!isset($processlist2[$thread_id])) - printf("[007] Cannot find regular connection thread in process list, [%d] %s\n", mysql_errno($link), mysql_error($link)); - - mysql_close($plink); - - if (!($plink = @mysql_pconnect($myhost, $user, $passwd))) - printf("[009] Cannot create new persistent connection, [%d] %s\n", mysql_errno(), mysql_error()); - mysql_select_db($db, $plink); - - if (!($res = mysql_query("SELECT 1", $plink))) - printf("[010] Cannot run query on new persistent connection, [%d] %s\n", @mysql_errno($plink), @mysql_error($plink)); - mysql_free_result($res); - - var_dump(mysql_ping($plink)); - - if (!($res = mysql_query("SELECT 1", $plink))) - printf("[011] Cannot run query on new persistent connection, [%d] %s\n", @mysql_errno($plink), @mysql_error($plink)); - mysql_free_result($res); - - if (!($link2 = mysql_connect($myhost, $user, $passwd, true))) - printf("[012] Cannot connect to the server using host=%s/%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", - $host, $myhost, $user, $db, $port, $socket); - mysql_select_db($db, $link2); - if (!mysql_query(sprintf("KILL %d", $thread_id), $link2)) - printf("[013] Cannot kill regular connection thread, [%d] %s\n", mysql_errno($link2), mysql_error($link2)); - - if (!($link = mysql_connect($myhost, $user, $passwd, true))) - printf("[014] Cannot connect to the server using host=%s/%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", - $host, $myhost, $user, $db, $port, $socket); - mysql_select_db($db, $link); - if (!($res = mysql_query("SELECT * FROM test", $link))) - printf("[015] Cannot run query on new regular connection, [%d] %s\n", @mysql_errno($link), @mysql_error($link)); - - if (!($res = mysql_query("SELECT * FROM test", $link2))) - printf("[016] Cannot run query on other regular connection, [%d] %s\n", @mysql_errno($link2), @mysql_error($link2)); - - mysql_free_result($res); - mysql_close($plink); - mysql_close($link); - mysql_close($link2); - print "done!"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -bool(true) - -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_pconn_max_links.phpt b/ext/mysql/tests/mysql_pconn_max_links.phpt deleted file mode 100644 index ced94b3dbf..0000000000 --- a/ext/mysql/tests/mysql_pconn_max_links.phpt +++ /dev/null @@ -1,211 +0,0 @@ ---TEST-- -Persistent connections and mysql.max_persistent ---SKIPIF-- -<?php - require_once('skipif.inc'); - require_once('skipifconnectfailure.inc'); - require_once('table.inc'); - - if ($socket) - $host = sprintf("%s:%s", $host, $socket); - else if ($port) - $host = sprintf("%s:%s", $host, $port); - - // we need a second DB user to test for a possible flaw in the ext/mysql[i] code - if (!$link = mysql_connect($host, $user, $passwd, true)) - die(sprintf("skip Cannot connect [%d] %s", mysql_errno(), mysql_error())); - - if (!mysql_select_db($db, $link)) - die(sprintf("skip [%d] %s", mysql_errno($link), mysql_error($link))); - - if (!$res = mysql_query('SHOW VARIABLES LIKE "old_passwords"', $link)) { - die(sprintf("skip [%d] %s", mysql_errno($link), mysql_error($link))); - } - - if (mysql_num_rows($res) != 1) { - die(sprintf("skip Can't check if old_passwords = ON")); - } - - $row = mysql_fetch_assoc($res); - mysql_free_result($res); - if ($row['Value'] == "ON") - die(sprintf("skip Test will fail because old_passwords = ON. Hint: old passwords are insecure!")); - - if (!$res = mysql_query("SELECT CURRENT_USER() AS _user", $link)) - die(sprintf("skip [%d] %s", mysql_errno($link), mysql_error($link))); - - $row = mysql_fetch_assoc($res); - mysql_free_result($res); - $host = substr($row['_user'], strrpos($row['_user'], "@") + 1, strlen($row['_user'])); - - mysql_query('DROP USER pcontest', $link); - mysql_query(sprintf('DROP USER pcontest@"%s"', mysql_real_escape_string($host, $link)), $link); - if (!mysql_query(sprintf('CREATE USER pcontest@"%s" IDENTIFIED BY "pcontest"', mysql_real_escape_string($host, $link)), $link)) { - printf("skip Cannot create second DB user [%d] %s", mysql_errno($link), mysql_error($link)); - mysql_close($link); - die(); - } - - // we might be able to specify the host using CURRENT_USER(), but... - if (!mysql_query(sprintf('GRANT SELECT ON TABLE %s.test TO pcontest@"%s"', $db, mysql_real_escape_string($host, $link)), $link)) { - printf("skip Cannot GRANT SELECT to second DB user [%d] %s", mysql_errno($link), mysql_error($link)); - mysql_query(sprintf('REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest@"%s"', mysql_real_escape_string($host, $link)), $link); - mysql_query(sprintf('DROP USER pcontest@"%s"', mysql_real_escape_string($host, $link)), $link); - mysql_close($link); - die(); - } - - mysql_close($link); -?> ---INI-- -mysql.max_links=3 -mysql.max_persistent=2 -mysql.allow_persistent=1 ---FILE-- -<?php - require_once("connect.inc"); - require_once('table.inc'); - - if ($socket) - $host = sprintf("%s:%s", $host, $socket); - else if ($port) - $host = sprintf("%s:%s", $host, $port); - - if (!$plink = mysql_pconnect($host, $user, $passwd)) - printf("[001] Cannot connect using the second DB user created during SKIPIF, [%d] %s\n", - mysql_errno(), mysql_error()); - - if (!mysql_select_db($db, $plink)) - printf("[002] [%d] %s\n", mysql_errno($plink), mysql_error($plink)); - - ob_start(); - phpinfo(); - $phpinfo = strip_tags(ob_get_contents()); - ob_end_clean(); - $phpinfo = substr($phpinfo, strpos($phpinfo, 'MySQL Support => enabled'), 500); - if (!preg_match('@Active Persistent Links\s+=>\s+(\d+)@ismU', $phpinfo, $matches)) - printf("[003] Cannot get # active persistent links from phpinfo()"); - $num_plinks = $matches[1]; - - if (!$res = mysql_query('SELECT id, label FROM test WHERE id = 1', $plink)) - printf("[004] Cannot run query on persistent connection of second DB user, [%d] %s\n", - mysql_errno($plink), mysql_error($plink)); - - if (!$row = mysql_fetch_assoc($res)) - printf("[005] Cannot run fetch result, [%d] %s\n", - mysql_errno($plink), mysql_error($plink)); - mysql_free_result($res); - var_dump($row); - - // change the password for the second DB user and kill the persistent connection - if (!$res = mysql_query("SELECT CURRENT_USER() AS _user", $link)) - printf("[006] [%d] %s", mysql_errno($link), mysql_error($link)); - - $row = mysql_fetch_assoc($res); - mysql_free_result($res); - $host = substr($row['_user'], strrpos($row['_user'], "@") + 1, strlen($row['_user'])); - - $sql = sprintf('SET PASSWORD FOR pcontest@"%s" = PASSWORD("newpass")', mysql_real_escape_string($host, $link)); - if (!mysql_query($sql, $link)) - printf("[007] Cannot change PW of second DB user, [%d] %s\n", mysql_errno($link), mysql_error($link)); - - // persistent connections cannot be closed but only be killed - $pthread_id = mysql_thread_id($plink); - if (!mysql_query(sprintf('KILL %d', $pthread_id), $link)) - printf("[008] Cannot KILL persistent connection of second DB user, [%d] %s\n", mysql_errno($link), mysql_error($link)); - // give the server a second to really kill the thread - sleep(1); - - if (!$res = mysql_query("SHOW FULL PROCESSLIST", $link)) - printf("[009] [%d] %s\n", mysql_errno($link), mysql_error($link)); - - $running_threads = array(); - while ($row = mysql_fetch_assoc($res)) - $running_threads[$row['Id']] = $row; - mysql_free_result($res); - - if (isset($running_threads[$pthread_id])) - printf("[010] Persistent connection has not been killed\n"); - - // we might get the old handle - if ($plink = @mysql_pconnect($host, 'pcontest', 'pcontest')) - printf("[011] Can connect using the old password, [%d] %s\n", - mysql_errno(), mysql_error()); - - ob_start(); - phpinfo(); - $phpinfo = strip_tags(ob_get_contents()); - ob_end_clean(); - $phpinfo = substr($phpinfo, strpos($phpinfo, 'MySQL Support => enabled'), 500); - if (!preg_match('@Active Persistent Links\s+=>\s+(\d+)@ismU', $phpinfo, $matches)) - printf("[012] Cannot get # active persistent links from phpinfo()\n"); - - $num_plinks_kill = $matches[1]; - if ($num_plinks_kill > $num_plinks) - printf("[013] Statistics seems to be wrong, got %d active persistent links, expecting < %d links\n", - $num_plinks_kill, $num_plinks); - - // The first connection has been closed, the last pconnect() was unable to connect -> no connection open - // We must be able to connect because max_persistent limit has not been reached - if (!$plink = mysql_pconnect($host, 'pcontest', 'newpass')) - die(sprintf("[014] Cannot connect using the second DB, [%d] %s\n", - mysql_errno(), mysql_error())); - - if (!mysql_select_db($db, $plink)) - printf("[015] [%d] %s\n", mysql_errno($plink), mysql_error($plink)); - - if (!$res = mysql_query('SELECT id, label FROM test WHERE id = 1', $plink)) - printf("[016] Cannot run query on persistent connection of second DB user, [%d] %s\n", - mysql_errno($plink), mysql_error($plink)); - - if (!$row = mysql_fetch_assoc($res)) - printf("[017] Cannot run fetch result, [%d] %s\n", - mysql_errno($plink), mysql_error($plink)); - mysql_free_result($res); - var_dump($row); - - mysql_query(sprintf('REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest@"%s"', mysql_real_escape_string($host, $link)), $link); - mysql_query(sprintf('DROP USER pcontest@"%s"', mysql_real_escape_string($host, $link)), $link); - mysql_close($link); - print "done!"; -?> ---CLEAN-- -<?php -// connect + select_db -require_once("connect.inc"); -if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) { - printf("[c001] Cannot connect to the server using host=%s/%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", - $host, $myhost, $user, $db, $port, $socket); -} - -if (!$res = mysql_query("SELECT CURRENT_USER() AS _user", $link)) - printf("[c002] [%d] %s", mysql_errno($link), mysql_error($link)); - -$row = mysql_fetch_assoc($res); -mysql_free_result($res); -$host = substr($row['_user'], strrpos($row['_user'], "@") + 1, strlen($row['_user'])); - -@mysql_query(sprintf('REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest@"%s"', mysql_real_escape_string($host, $link)), $link); -@mysql_query(sprintf('DROP USER pcontest@"%s"', mysql_real_escape_string($host, $link)), $link); - -mysql_close($link); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -array(2) { - [%u|b%"id"]=> - %unicode|string%(1) "1" - [%u|b%"label"]=> - %unicode|string%(1) "a" -} - -Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -array(2) { - [%u|b%"id"]=> - %unicode|string%(1) "1" - [%u|b%"label"]=> - %unicode|string%(1) "a" -} -done! diff --git a/ext/mysql/tests/mysql_pconn_reuse.phpt b/ext/mysql/tests/mysql_pconn_reuse.phpt deleted file mode 100644 index 26b4ca5f49..0000000000 --- a/ext/mysql/tests/mysql_pconn_reuse.phpt +++ /dev/null @@ -1,75 +0,0 @@ ---TEST-- -mysql_pconnect() - disabling feature ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---INI-- -mysql.allow_persistent=1 -mysql.max_persistent=1 -mysql.max_links=2 ---FILE-- -<?php - require_once("connect.inc"); - require_once("table.inc"); - mysql_close($link); - - if ($socket) - $myhost = sprintf("%s:%s", $host, $socket); - else if ($port) - $myhost = sprintf("%s:%s", $host, $port); - else - $myhost = $host; - - if (($plink = mysql_pconnect($myhost, $user, $passwd))) - printf("[001] Can connect to the server.\n"); - - if ((mysql_select_db($db, $plink)) && - ($res = mysql_query('SELECT id FROM test', $plink)) && - ($row = mysql_fetch_assoc($res)) && - (mysql_free_result($res))) { - printf("[002] Can fetch data using persistent connection! Data = '%s'\n", - $row['id']); - } else { - printf("[002] [%d] %s\n", mysql_errno($plink), mysql_error($plink)); - } - - $thread_id = mysql_thread_id($plink); - mysql_close($plink); - - if (!($plink = mysql_pconnect($myhost, $user, $passwd))) - printf("[003] Cannot connect, [%d] %s\n", mysql_errno(), mysql_error()); - - if (mysql_thread_id($plink) != $thread_id) - printf("[004] Looks like the second call to pconnect() did not give us the same connection.\n"); - - $thread_id = mysql_thread_id($plink); - mysql_close($plink); - - if (!($plink = mysql_connect($myhost, $user, $passwd, true))) - printf("[005] Cannot connect, [%d] %s\n", mysql_errno(), mysql_error()); - - if (mysql_thread_id($plink) == $thread_id) - printf("[006] Looks like connect() did not return a new connection.\n"); - - if (($link = mysql_connect($myhost, $user, $passwd, true))) - printf("[007] Can connect although limit has been reached, [%d] %s\n", mysql_errno(), mysql_error()); - - print "done!"; -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -[001] Can connect to the server. -[002] Can fetch data using persistent connection! Data = '1' - -Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Warning: mysql_connect(): Too many open links (2) in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_pconnect.phpt b/ext/mysql/tests/mysql_pconnect.phpt deleted file mode 100644 index ec28d2ea8a..0000000000 --- a/ext/mysql/tests/mysql_pconnect.phpt +++ /dev/null @@ -1,97 +0,0 @@ ---TEST-- -mysql_pconnect() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---INI-- -mysql.max_persistent=10 -mysql.allow_persistent=1 ---FILE-- -<?php - include "connect.inc"; - - $tmp = NULL; - $link = NULL; - - // mysql_pconnect ( [string server [, string username [, string password [, bool new_link [, int client_flags]]]]] ) - if (NULL !== ($tmp = @mysql_pconnect($link, $link, $link, $link, $link, $link))) - printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - - $myhost = (is_null($socket)) ? ((is_null($port)) ? $host : $host . ':' . $port) : $host . ':' . $socket; - if (!$link = mysql_pconnect($myhost, $user, $passwd, true)) - printf("[002] Cannot connect to the server using host=%s/%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", - $host, $myhost, $user, $db, $port, $socket); - - mysql_close($link); - - if ($link = mysql_pconnect($myhost, $user . 'unknown_really', $passwd . 'non_empty', true)) - printf("[003] Can connect to the server using host=%s/%s, user=%s, passwd=***non_empty, dbname=%s, port=%s, socket=%s\n", - $host, $myhost, $user . 'unknown_really', $db, $port, $socket); - - if (false !== $link) - printf("[004] Expecting boolean/false, got %s/%s\n", gettype($link), $link); - - // Run the following tests without an anoynmous MySQL user and use a password for the test user! - - - if (!ini_get('sql.safe_mode')) { - - if ($socket) { - ini_set('mysql.default_socket', $socket); - if (!is_resource($link = mysql_pconnect($host, $user, $passwd, true))) { - printf("[005] Usage of mysql.default_socket failed\n") ; - } else { - mysql_close($link); - } - } else { - ini_set('mysql.default_socket', null); - } - - ini_set('mysql.default_port', $port); - if (!is_resource($link = mysql_pconnect($host, $user, $passwd, true))) { - printf("[006] Usage of mysql.default_port failed\n") ; - } else { - mysql_close($link); - } - - ini_set('mysql.default_password', $passwd); - if (!is_resource($link = mysql_pconnect($myhost, $user))) { - printf("[007] Usage of mysql.default_password failed\n") ; - } else { - mysql_close($link); - } - - ini_set('mysql.default_user', $user); - if (!is_resource($link = mysql_pconnect($myhost))) { - printf("[008] Usage of mysql.default_user failed\n"); - } else { - mysql_close($link); - } - - ini_set('mysql.default_host', $myhost); - if (!is_resource($link = mysql_pconnect())) { - printf("[009] Usage of mysql.default_host failed\n") ; - } else { - mysql_close($link); - } - } - - print "done!"; -?> ---EXPECTF-- -Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Warning: mysql_pconnect(): Access denied for user '%s'@'%s' (using password: YES) in %s on line %d - -Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_phpinfo.phpt b/ext/mysql/tests/mysql_phpinfo.phpt deleted file mode 100644 index 79de939167..0000000000 --- a/ext/mysql/tests/mysql_phpinfo.phpt +++ /dev/null @@ -1,75 +0,0 @@ ---TEST-- -phpinfo() mysql section ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include_once("connect.inc"); - -@ob_clean(); -ob_start(); -phpinfo(); -$phpinfo = ob_get_contents(); -ob_end_clean(); - -/* all versions should at least dump this minimum information */ -if (!stristr($phpinfo, "mysql support")) - printf("[001] ext/mysql should have exposed itself.\n"); - -if (!stristr($phpinfo, "client api version")) - printf("[002] ext/mysql should have exposed the library version.\n"); - -if (!stristr($phpinfo, "mysql.default_host")) - printf("[003] php.ini setting mysql.default_host not shown.\n"); - -if (!stristr($phpinfo, "mysql.default_port")) - printf("[004] php.ini setting mysql.default_port not shown.\n"); - -if (!stristr($phpinfo, "mysql.default_password")) - printf("[005] php.ini setting mysql.default_password not shown.\n"); - -if (!stristr($phpinfo, "mysql.default_socket")) - printf("[006] php.ini setting mysql.default_socket not shown.\n"); - -if (!stristr($phpinfo, "mysql.default_user")) - printf("[007] php.ini setting mysql.default_user not shown.\n"); - -if (!stristr($phpinfo, "mysql.max_links")) - printf("[008] php.ini setting mysql.max_links not shown.\n"); - -if (!stristr($phpinfo, "mysql.max_persistent")) - printf("[009] php.ini setting mysql.max_persistent not shown.\n"); - -if (!stristr($phpinfo, "mysql.connect_timeout")) - printf("[010] php.ini setting mysql.connect_timeout not shown.\n"); - -if (!stristr($phpinfo, "mysql.allow_persistent")) - printf("[011] php.ini setting mysql.allow_persistent not shown.\n"); - -if ($IS_MYSQLND) { - $expected = array( - 'mysqlnd statistics', - 'bytes_sent', 'bytes_received', 'packets_sent', 'packets_received', - 'protocol_overhead_in', 'protocol_overhead_out', 'result_set_queries', - 'non_result_set_queries', 'no_index_used', 'bad_index_used', - 'buffered_sets', 'unbuffered_sets', 'ps_buffered_sets', 'ps_unbuffered_sets', - 'flushed_normal_sets', 'flushed_ps_sets', 'rows_fetched_from_server', - 'rows_fetched_from_client', 'rows_skipped', 'copy_on_write_saved', - 'copy_on_write_performed', 'command_buffer_too_small', 'connect_success', - 'connect_failure', 'connection_reused', 'explicit_close', 'implicit_close', - 'disconnect_close', 'in_middle_of_command_close', 'explicit_free_result', - 'implicit_free_result', 'explicit_stmt_close', 'implicit_stmt_close', - 'size', - ); - foreach ($expected as $k => $entry) - if (!stristr($phpinfo, $entry)) - printf("[012] Could not find entry for '%s'\n", $entry); -} - -print "done!"; -?> ---EXPECTF-- -done! diff --git a/ext/mysql/tests/mysql_ping.phpt b/ext/mysql/tests/mysql_ping.phpt deleted file mode 100644 index 2f2c38cd90..0000000000 --- a/ext/mysql/tests/mysql_ping.phpt +++ /dev/null @@ -1,51 +0,0 @@ ---TEST-- -mysql_ping() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include_once "connect.inc"; - -$tmp = NULL; -$link = NULL; - -require('table.inc'); - -if (!is_null($tmp = @mysql_ping($link, $link))) - printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -var_dump(mysql_ping($link)); - -// provoke an error to check if mysql_ping resets it -$res = mysql_query('SELECT * FROM unknown_table', $link); -if (!($errno = mysql_errno($link))) - printf("[002] Statement should have caused an error\n"); - -var_dump(mysql_ping($link)); - -if ($errno === mysql_errno($link)) - printf("[003] Error codes should have been reset\n"); - -var_dump(mysql_ping()); -mysql_close($link); - -if (false !== ($tmp = mysql_ping($link))) - printf("[004] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -print "done!"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -bool(true) -bool(true) -bool(true) - -Warning: mysql_ping(): supplied resource is not a valid MySQL-Link resource in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_query.phpt b/ext/mysql/tests/mysql_query.phpt deleted file mode 100644 index abe7adb88c..0000000000 --- a/ext/mysql/tests/mysql_query.phpt +++ /dev/null @@ -1,132 +0,0 @@ ---TEST-- -mysql_query() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include_once("connect.inc"); - -$tmp = NULL; -$link = NULL; - -if (!is_null($tmp = @mysql_query())) - printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (false !== ($tmp = @mysql_query($link))) - printf("[002] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -require('table.inc'); - -if (NULL !== ($tmp = @mysql_query("SELECT 1 AS a", $link, "foo"))) - printf("[003] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (false !== ($tmp = mysql_query('THIS IS NOT SQL', $link))) - printf("[004] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -if (false !== ($tmp = mysql_query("SELECT 'this is sql but with backslash g'\g", $link))) - printf("[005] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -if ((0 === mysql_errno($link)) || ('' == mysql_error($link))) - printf("[006] mysql_errno()/mysql_error should return some error\n"); - -if (!$res = mysql_query("SELECT 'this is sql but with semicolon' AS valid ; ", $link)) - printf("[007] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -var_dump(mysql_fetch_assoc($res)); -mysql_free_result($res); - -if (!$res = mysql_query("SELECT 'a' AS ''", $link)) - printf("[007a] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -var_dump($tmp = mysql_fetch_assoc($res)); -var_dump($tmp[""]); -mysql_free_result($res); - -if (false !== ($res = mysql_query("SELECT 'this is sql but with semicolon' AS valid ; SHOW VARIABLES", $link))) - printf("[008] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (mysql_query('DROP PROCEDURE IF EXISTS p', $link)) { - // let's try to play with stored procedures - if (mysql_query('CREATE PROCEDURE p(OUT ver_param VARCHAR(25)) BEGIN SELECT VERSION() INTO ver_param; END;', $link)) { - $res = mysql_query('CALL p(@version)', $link); - $res = mysql_query('SELECT @version AS p_version', $link); - $tmp = mysql_fetch_assoc($res); - if (!isset($tmp['p_version']) || ('' == $tmp['p_version'])) { - printf("[009] Result seems wrong, dumping\n"); - var_dump($tmp); - } - if ((version_compare(PHP_VERSION, '5.9.9', '>') == 1) && - (version_compare(PHP_VERSION, '6.9.9', '<=') == 1) && - !is_unicode($tmp['p_version'])) { - printf("[010] Expecting unicode string, dumping\n"); - var_dump($tmp); - } - mysql_free_result($res); - } else { - printf("[011] [%d] %s\n", mysql_errno($link), mysql_error($link)); - } - - mysql_query('DROP FUNCTION IF EXISTS f', $link); - if (mysql_query('CREATE FUNCTION f( ver_param VARCHAR(25)) RETURNS VARCHAR(25) DETERMINISTIC RETURN ver_param;', $link)) { - $res = mysql_query('SELECT f(VERSION()) AS f_version', $link); - $tmp = mysql_fetch_assoc($res); - if (!isset($tmp['f_version']) || ('' == $tmp['f_version'])) { - printf("[012] Result seems wrong, dumping\n"); - var_dump($tmp); - } - if ((version_compare(PHP_VERSION, '5.9.9', '>') == 1) && - (version_compare(PHP_VERSION, '6.9.9', '<=') == 1) && - !is_unicode($tmp['f_version'])) { - printf("[013] Expecting unicode string, dumping\n"); - var_dump($tmp); - } - mysql_free_result($res); - } else { - printf("[014] [%d] %s\n", mysql_errno($link), mysql_error($link)); - } -} - -mysql_close($link); - -if (false !== ($tmp = mysql_query("SELECT id FROM test", $link))) - printf("[011] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -print "done!"; -?> ---CLEAN-- -<?php -require_once('connect.inc'); - -// connect + select_db -if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) { - printf("[clean] Cannot connect to the server using host=%s/%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", - $host, $myhost, $user, $db, $port, $socket); -} - -if (!mysql_query('DROP TABLE IF EXISTS test', $link)) { - printf("[clean] Failed to drop test table: [%d] %s\n", mysql_errno($link), mysql_error($link)); -} - -/* MySQL server may not support this - ignore errors */ -@mysql_query('DROP PROCEDURE IF EXISTS p', $link); -@mysql_query('DROP FUNCTION IF EXISTS f', $link); - -mysql_close($link); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -array(1) { - [%u|b%"valid"]=> - %unicode|string%(30) "this is sql but with semicolon" -} -array(1) { - [%u|b%""]=> - %unicode|string%(1) "a" -} -%unicode|string%(1) "a" - -Warning: mysql_query(): supplied resource is not a valid MySQL-Link resource in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_query_load_data_openbasedir.phpt b/ext/mysql/tests/mysql_query_load_data_openbasedir.phpt deleted file mode 100644 index c2cb41e026..0000000000 --- a/ext/mysql/tests/mysql_query_load_data_openbasedir.phpt +++ /dev/null @@ -1,121 +0,0 @@ ---TEST-- -LOAD DATA INFILE - open_basedir ---SKIPIF-- -<?php -include_once('skipif.inc'); -include_once('skipifconnectfailure.inc'); - - -if (!$IS_MYSQLND) - die("skip mysqlnd only, libmysql does not know about open_basedir restrictions"); - -if (file_exists('./simple.csv') && !unlink('./simple.csv')) - die("skip Cannot remove previous CSV file"); - -if (!$fp = fopen('./simple.csv', 'w')) - die("skip Cannot create test CSV file"); - -fclose($fp); -@unlink('./simple.csv'); - -if ($socket == "" && $host != NULL && $host != 'localhost' && $host != '.') { - /* could be a remote TCP/IP connection. LOCAL INFILE may not work */ - if (gethostbyaddr($host) != gethostname()) { - die("skip LOAD DATA LOCAL INFILE will fail if connecting to remote MySQL"); - } -} -?> ---FILE-- -<?php -@include_once("connect.inc"); -ini_set("open_basedir", __DIR__); -chdir(__DIR__); -if (!isset($db)) { - // run-tests, I love you for not allowing me to set ini settings dynamically - print "[006] [1148] The used command is not allowed with this MySQL version -[007] [0] -[008] LOAD DATA not run? -[010] [1148] The used command is not allowed with this MySQL version -done!"; - die(); -} -require('table.inc'); -mysql_close($link); -if ($socket) - $host = sprintf("%s:%s", $host, $socket); -else if ($port) - $host = sprintf("%s:%s", $host, $port); - -if (!$link = mysql_connect($host, $user, $passwd, true, 128)) { - printf("[001] Cannot connect using host '%s', user '%s', password '****', [%d] %s\n", - $host, $user, $passwd, - mysql_errno(), mysql_error()); -} - -if (!mysql_select_db($db, $link)) { - printf("[002] [%d] %s\n", mysql_errno($link), mysql_error($link)); -} - -if (file_exists('./simple.csv')) - unlink('./simple.csv'); - -if (!$fp = fopen('./simple.csv', 'w')) - printf("[003] Cannot open CSV file\n"); - -if (version_compare(PHP_VERSION, '5.9.9', '>') >= 0) { - if (!fwrite($fp, (binary)"'97';'x';\n") || - !fwrite($fp, (binary)"'98';'y';\n") || - !fwrite($fp, (binary)"99;'z';\n")) { - printf("[004] Cannot write CVS file '%s'\n", $file); - } -} else { - if (!fwrite($fp, "97;'x';\n") || - !fwrite($fp, "98;'y';\n") || - !fwrite($fp, "99;'z';\n")) { - printf("[005] Cannot write CVS file '%s'\n", $file); - } -} -fclose($fp); - -$sql = sprintf("LOAD DATA LOCAL INFILE '%s' - INTO TABLE test - FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '\'' - LINES TERMINATED BY '\n'", - mysql_real_escape_string(realpath('./simple.csv'), $link)); - -if (!mysql_query($sql, $link)) - printf("[006] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (!($res = mysql_query('SELECT label FROM test WHERE id = 97', $link)) || - !($row = mysql_fetch_assoc($res)) || - !mysql_free_result($res)) - printf("[007] [%d] '%s'\n", mysql_errno($link), mysql_error($link)); - -if ($row['label'] != "x") - printf("[008] LOAD DATA not run?\n"); - -if (!mysql_query('DELETE FROM test', $link)) - printf("[009] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -$sql = "LOAD DATA LOCAL INFILE '/tmp/idonotexist' - INTO TABLE test - FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '\'' - LINES TERMINATED BY '\n'"; - -if (!mysql_query($sql, $link)) - printf("[010] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -mysql_close($link); -unlink("./simple.csv"); - -print "done!"; -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -[006] [1148] %s -[007] [0] '' -[008] LOAD DATA not run? -[010] [1148] %s -done! diff --git a/ext/mysql/tests/mysql_real_escape_string.phpt b/ext/mysql/tests/mysql_real_escape_string.phpt deleted file mode 100644 index 4fdedf7b37..0000000000 --- a/ext/mysql/tests/mysql_real_escape_string.phpt +++ /dev/null @@ -1,44 +0,0 @@ ---TEST-- -mysql_real_escape_string() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include "connect.inc"; - -$tmp = NULL; -$link = NULL; - -if (NULL !== ($tmp = @mysql_real_escape_string())) - printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -require('table.inc'); - -if (NULL !== ($tmp = @mysql_real_escape_string('foo', $link, $link))) - printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -var_dump(mysql_real_escape_string("Am I a unicode string in PHP 6?", $link)); -var_dump(mysql_real_escape_string('\\', $link)); -var_dump(mysql_real_escape_string('"', $link)); -var_dump(mysql_real_escape_string("'", $link)); -var_dump(mysql_real_escape_string("\n", $link)); -var_dump(mysql_real_escape_string("\r", $link)); -var_dump($tmp = mysql_real_escape_string("foo" . chr(0) . "bar", $link)); - -assert($tmp === mysql_real_escape_string("foo" . chr(0) . "bar")); - -print "done!"; -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -%unicode|string%(31) "Am I a unicode string in PHP 6?" -%unicode|string%(2) "\\" -%unicode|string%(2) "\"" -%unicode|string%(2) "\'" -%unicode|string%(2) "\n" -%unicode|string%(2) "\r" -%unicode|string%(8) "foo\0bar" -done! diff --git a/ext/mysql/tests/mysql_reflection_extension.phpt b/ext/mysql/tests/mysql_reflection_extension.phpt deleted file mode 100644 index 169036cd54..0000000000 --- a/ext/mysql/tests/mysql_reflection_extension.phpt +++ /dev/null @@ -1,105 +0,0 @@ ---TEST-- -ReflectionExtension basics to check API ---SKIPIF-- -<?php -require_once('skipif.inc'); -?> ---FILE-- -<?php - $r = new ReflectionExtension("mysql"); - - printf("Name: %s\n", $r->name); - printf("Version: %s\n", $r->getVersion()); - $classes = $r->getClasses(); - if (!empty($classes)) { - printf("[002] Expecting no class\n"); - asort($classes); - var_dump($classes); - } - - $ignore = array(); - - $functions = $r->getFunctions(); - asort($functions); - printf("Functions:\n"); - foreach ($functions as $func) { - if (isset($ignore[$func->name])) { - unset($ignore[$func->name]); - } else { - printf(" %s\n", $func->name); - } - } - if (!empty($ignore)) { - printf("Dumping version dependent and missing functions\n"); - var_dump($ignore); - } - - - print "done!"; -?> ---EXPECTF-- -Name: mysql -Version: 1.0 -Functions: - mysql - mysql_affected_rows - mysql_client_encoding - mysql_close - mysql_connect - mysql_data_seek - mysql_db_name - mysql_db_query - mysql_dbname - mysql_errno - mysql_error - mysql_escape_string - mysql_fetch_array - mysql_fetch_assoc - mysql_fetch_field - mysql_fetch_lengths - mysql_fetch_object - mysql_fetch_row - mysql_field_flags - mysql_field_len - mysql_field_name - mysql_field_seek - mysql_field_table - mysql_field_type - mysql_fieldflags - mysql_fieldlen - mysql_fieldname - mysql_fieldtable - mysql_fieldtype - mysql_free_result - mysql_freeresult - mysql_get_client_info - mysql_get_host_info - mysql_get_proto_info - mysql_get_server_info - mysql_info - mysql_insert_id - mysql_list_dbs - mysql_list_fields - mysql_list_processes - mysql_list_tables - mysql_listdbs - mysql_listfields - mysql_listtables - mysql_num_fields - mysql_num_rows - mysql_numfields - mysql_numrows - mysql_pconnect - mysql_ping - mysql_query - mysql_real_escape_string - mysql_result - mysql_select_db - mysql_selectdb - mysql_set_charset - mysql_stat - mysql_table_name - mysql_tablename - mysql_thread_id - mysql_unbuffered_query -done!
\ No newline at end of file diff --git a/ext/mysql/tests/mysql_reflection_functions.phpt b/ext/mysql/tests/mysql_reflection_functions.phpt deleted file mode 100644 index 4f2710d806..0000000000 --- a/ext/mysql/tests/mysql_reflection_functions.phpt +++ /dev/null @@ -1,387 +0,0 @@ ---TEST-- -ReflectionFunction to check API ---SKIPIF-- -<?php -require_once('skipif.inc'); -?> ---FILE-- -<?php - $r = new ReflectionExtension("mysql"); - - $ignore = array(); - - $functions = $r->getFunctions(); - asort($functions); - printf("Functions:\n"); - foreach ($functions as $func) { - if (isset($ignore[$func->name])) - continue; - - printf(" %s\n", $func->name); - $rf = new ReflectionFunction($func->name); - printf(" Deprecated: %s\n", $rf->isDeprecated() ? "yes" : "no"); - printf(" Accepted parameters: %d\n", $rf->getNumberOfParameters()); - printf(" Required parameters: %d\n", $rf->getNumberOfRequiredParameters()); - foreach( $rf->getParameters() as $param ) { - printf(" %s\n", $param); - } - } - - print "done!"; -?> ---EXPECTF-- -Functions: - mysql - Deprecated: yes - Accepted parameters: 3 - Required parameters: 2 - Parameter #0 [ <required> $database_name ] - Parameter #1 [ <required> $query ] - Parameter #2 [ <optional> $link_identifier ] - mysql_affected_rows - Deprecated: no - Accepted parameters: 1 - Required parameters: 0 - Parameter #0 [ <optional> $link_identifier ] - mysql_client_encoding - Deprecated: no - Accepted parameters: 1 - Required parameters: 0 - Parameter #0 [ <optional> $link_identifier ] - mysql_close - Deprecated: no - Accepted parameters: 1 - Required parameters: 0 - Parameter #0 [ <optional> $link_identifier ] - mysql_connect - Deprecated: no - Accepted parameters: 5 - Required parameters: 0 - Parameter #0 [ <optional> $hostname ] - Parameter #1 [ <optional> $username ] - Parameter #2 [ <optional> $password ] - Parameter #3 [ <optional> $new ] - Parameter #4 [ <optional> $flags ] - mysql_data_seek - Deprecated: no - Accepted parameters: 2 - Required parameters: 2 - Parameter #0 [ <required> $result ] - Parameter #1 [ <required> $row_number ] - mysql_db_name - Deprecated: no - Accepted parameters: 3 - Required parameters: 2 - Parameter #0 [ <required> $result ] - Parameter #1 [ <required> $row ] - Parameter #2 [ <optional> $field ] - mysql_db_query - Deprecated: yes - Accepted parameters: 3 - Required parameters: 2 - Parameter #0 [ <required> $database_name ] - Parameter #1 [ <required> $query ] - Parameter #2 [ <optional> $link_identifier ] - mysql_dbname - Deprecated: yes - Accepted parameters: 3 - Required parameters: 2 - Parameter #0 [ <required> $result ] - Parameter #1 [ <required> $row ] - Parameter #2 [ <optional> $field ] - mysql_errno - Deprecated: no - Accepted parameters: 1 - Required parameters: 0 - Parameter #0 [ <optional> $link_identifier ] - mysql_error - Deprecated: no - Accepted parameters: 1 - Required parameters: 0 - Parameter #0 [ <optional> $link_identifier ] - mysql_escape_string - Deprecated: no - Accepted parameters: 1 - Required parameters: 1 - Parameter #0 [ <required> $string ] - mysql_fetch_array - Deprecated: no - Accepted parameters: 2 - Required parameters: 1 - Parameter #0 [ <required> $result ] - Parameter #1 [ <optional> $result_type ] - mysql_fetch_assoc - Deprecated: no - Accepted parameters: 1 - Required parameters: 1 - Parameter #0 [ <required> $result ] - mysql_fetch_field - Deprecated: no - Accepted parameters: 2 - Required parameters: 1 - Parameter #0 [ <required> $result ] - Parameter #1 [ <optional> $field_offset ] - mysql_fetch_lengths - Deprecated: no - Accepted parameters: 1 - Required parameters: 1 - Parameter #0 [ <required> $result ] - mysql_fetch_object - Deprecated: no - Accepted parameters: 3 - Required parameters: 1 - Parameter #0 [ <required> $result ] - Parameter #1 [ <optional> $class_name ] - Parameter #2 [ <optional> $ctor_params ] - mysql_fetch_row - Deprecated: no - Accepted parameters: 1 - Required parameters: 1 - Parameter #0 [ <required> $result ] - mysql_field_flags - Deprecated: no - Accepted parameters: 2 - Required parameters: 2 - Parameter #0 [ <required> $result ] - Parameter #1 [ <required> $field_offset ] - mysql_field_len - Deprecated: no - Accepted parameters: 2 - Required parameters: 2 - Parameter #0 [ <required> $result ] - Parameter #1 [ <required> $field_offset ] - mysql_field_name - Deprecated: no - Accepted parameters: 2 - Required parameters: 2 - Parameter #0 [ <required> $result ] - Parameter #1 [ <required> $field_index ] - mysql_field_seek - Deprecated: no - Accepted parameters: 2 - Required parameters: 2 - Parameter #0 [ <required> $result ] - Parameter #1 [ <required> $field_offset ] - mysql_field_table - Deprecated: no - Accepted parameters: 2 - Required parameters: 2 - Parameter #0 [ <required> $result ] - Parameter #1 [ <required> $field_offset ] - mysql_field_type - Deprecated: no - Accepted parameters: 2 - Required parameters: 2 - Parameter #0 [ <required> $result ] - Parameter #1 [ <required> $field_offset ] - mysql_fieldflags - Deprecated: yes - Accepted parameters: 2 - Required parameters: 2 - Parameter #0 [ <required> $result ] - Parameter #1 [ <required> $field_offset ] - mysql_fieldlen - Deprecated: yes - Accepted parameters: 2 - Required parameters: 2 - Parameter #0 [ <required> $result ] - Parameter #1 [ <required> $field_offset ] - mysql_fieldname - Deprecated: yes - Accepted parameters: 2 - Required parameters: 2 - Parameter #0 [ <required> $result ] - Parameter #1 [ <required> $field_index ] - mysql_fieldtable - Deprecated: yes - Accepted parameters: 2 - Required parameters: 2 - Parameter #0 [ <required> $result ] - Parameter #1 [ <required> $field_offset ] - mysql_fieldtype - Deprecated: yes - Accepted parameters: 2 - Required parameters: 2 - Parameter #0 [ <required> $result ] - Parameter #1 [ <required> $field_offset ] - mysql_free_result - Deprecated: no - Accepted parameters: 1 - Required parameters: 1 - Parameter #0 [ <required> $result ] - mysql_freeresult - Deprecated: yes - Accepted parameters: 1 - Required parameters: 1 - Parameter #0 [ <required> $result ] - mysql_get_client_info - Deprecated: no - Accepted parameters: 0 - Required parameters: 0 - mysql_get_host_info - Deprecated: no - Accepted parameters: 1 - Required parameters: 0 - Parameter #0 [ <optional> $link_identifier ] - mysql_get_proto_info - Deprecated: no - Accepted parameters: 1 - Required parameters: 0 - Parameter #0 [ <optional> $link_identifier ] - mysql_get_server_info - Deprecated: no - Accepted parameters: 1 - Required parameters: 0 - Parameter #0 [ <optional> $link_identifier ] - mysql_info - Deprecated: no - Accepted parameters: 1 - Required parameters: 0 - Parameter #0 [ <optional> $link_identifier ] - mysql_insert_id - Deprecated: no - Accepted parameters: 1 - Required parameters: 0 - Parameter #0 [ <optional> $link_identifier ] - mysql_list_dbs - Deprecated: yes - Accepted parameters: 1 - Required parameters: 0 - Parameter #0 [ <optional> $link_identifier ] - mysql_list_fields - Deprecated: no - Accepted parameters: 3 - Required parameters: 2 - Parameter #0 [ <required> $database_name ] - Parameter #1 [ <required> $table_name ] - Parameter #2 [ <optional> $link_identifier ] - mysql_list_processes - Deprecated: no - Accepted parameters: 1 - Required parameters: 0 - Parameter #0 [ <optional> $link_identifier ] - mysql_list_tables - Deprecated: yes - Accepted parameters: 2 - Required parameters: 1 - Parameter #0 [ <required> $database_name ] - Parameter #1 [ <optional> $link_identifier ] - mysql_listdbs - Deprecated: yes - Accepted parameters: 1 - Required parameters: 0 - Parameter #0 [ <optional> $link_identifier ] - mysql_listfields - Deprecated: yes - Accepted parameters: 3 - Required parameters: 2 - Parameter #0 [ <required> $database_name ] - Parameter #1 [ <required> $table_name ] - Parameter #2 [ <optional> $link_identifier ] - mysql_listtables - Deprecated: yes - Accepted parameters: 2 - Required parameters: 1 - Parameter #0 [ <required> $database_name ] - Parameter #1 [ <optional> $link_identifier ] - mysql_num_fields - Deprecated: no - Accepted parameters: 1 - Required parameters: 1 - Parameter #0 [ <required> $result ] - mysql_num_rows - Deprecated: no - Accepted parameters: 1 - Required parameters: 1 - Parameter #0 [ <required> $result ] - mysql_numfields - Deprecated: yes - Accepted parameters: 1 - Required parameters: 1 - Parameter #0 [ <required> $result ] - mysql_numrows - Deprecated: yes - Accepted parameters: 1 - Required parameters: 1 - Parameter #0 [ <required> $result ] - mysql_pconnect - Deprecated: no - Accepted parameters: 4 - Required parameters: 0 - Parameter #0 [ <optional> $hostname ] - Parameter #1 [ <optional> $username ] - Parameter #2 [ <optional> $password ] - Parameter #3 [ <optional> $flags ] - mysql_ping - Deprecated: no - Accepted parameters: 1 - Required parameters: 0 - Parameter #0 [ <optional> $link_identifier ] - mysql_query - Deprecated: no - Accepted parameters: 2 - Required parameters: 1 - Parameter #0 [ <required> $query ] - Parameter #1 [ <optional> $link_identifier ] - mysql_real_escape_string - Deprecated: no - Accepted parameters: 2 - Required parameters: 1 - Parameter #0 [ <required> $string ] - Parameter #1 [ <optional> $link_identifier ] - mysql_result - Deprecated: no - Accepted parameters: 3 - Required parameters: 2 - Parameter #0 [ <required> $result ] - Parameter #1 [ <required> $row ] - Parameter #2 [ <optional> $field ] - mysql_select_db - Deprecated: no - Accepted parameters: 2 - Required parameters: 1 - Parameter #0 [ <required> $database_name ] - Parameter #1 [ <optional> $link_identifier ] - mysql_selectdb - Deprecated: yes - Accepted parameters: 2 - Required parameters: 1 - Parameter #0 [ <required> $database_name ] - Parameter #1 [ <optional> $link_identifier ] - mysql_set_charset - Deprecated: no - Accepted parameters: 2 - Required parameters: 1 - Parameter #0 [ <required> $charset_name ] - Parameter #1 [ <optional> $link_identifier ] - mysql_stat - Deprecated: no - Accepted parameters: 1 - Required parameters: 0 - Parameter #0 [ <optional> $link_identifier ] - mysql_table_name - Deprecated: no - Accepted parameters: 3 - Required parameters: 2 - Parameter #0 [ <required> $result ] - Parameter #1 [ <required> $row ] - Parameter #2 [ <optional> $field ] - mysql_tablename - Deprecated: no - Accepted parameters: 3 - Required parameters: 2 - Parameter #0 [ <required> $result ] - Parameter #1 [ <required> $row ] - Parameter #2 [ <optional> $field ] - mysql_thread_id - Deprecated: no - Accepted parameters: 1 - Required parameters: 0 - Parameter #0 [ <optional> $link_identifier ] - mysql_unbuffered_query - Deprecated: no - Accepted parameters: 2 - Required parameters: 1 - Parameter #0 [ <required> $query ] - Parameter #1 [ <optional> $link_identifier ] -done!
\ No newline at end of file diff --git a/ext/mysql/tests/mysql_result.phpt b/ext/mysql/tests/mysql_result.phpt deleted file mode 100644 index ae1983fe04..0000000000 --- a/ext/mysql/tests/mysql_result.phpt +++ /dev/null @@ -1,116 +0,0 @@ ---TEST-- -mysql_result() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -require_once("connect.inc"); - -$tmp = NULL; -$link = NULL; - -// string mysql_result ( resource result, int row [, mixed field] ) - -if (!is_null($tmp = @mysql_result())) - printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (!is_null($tmp = @mysql_result($link))) - printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -require_once('table.inc'); -if (!$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)) { - printf("[003] [%d] %s\n", mysql_errno($link), mysql_error($link)); -} - -var_dump(mysql_result($res, -1)); -var_dump(mysql_result($res, 2)); - -var_dump(mysql_result($res, 0, -1)); -var_dump(mysql_result($res, 0, 500)); - -print "valid fields\n"; -var_dump(mysql_result($res, 0)); -var_dump(mysql_result($res, 0, 1)); - -var_dump(mysql_result($res, 0, 'id')); -var_dump(mysql_result($res, 0, '_test.id')); -var_dump(mysql_result($res, 0, 'label')); -var_dump(mysql_result($res, 0, '_test.label')); -print "some invalid fields\n"; -var_dump(mysql_result($res, 0, 'unknown')); -var_dump(mysql_result($res, 0, '_test.')); -var_dump(mysql_result($res, 0, chr(0))); -var_dump(mysql_result($res, 0, '_test.' . chr(0))); -print "_id\n"; -var_dump(mysql_result($res, 0, '_id')); -print "_label\n"; -var_dump(mysql_result($res, 0, '_label')); -print "_foo\n"; -var_dump(mysql_result($res, 0, '_foo')); -var_dump(mysql_result($res, 0, 'test.id')); -var_dump(mysql_result($res, 0, 'test.label')); - -mysql_free_result($res); - -var_dump(mysql_result($res, 0)); - -mysql_close($link); -print "done!"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Warning: mysql_result(): Unable to jump to row -1 on MySQL result index %d in %s on line %d -bool(false) - -Warning: mysql_result(): Unable to jump to row 2 on MySQL result index %d in %s on line %d -bool(false) - -Warning: mysql_result(): Bad column offset specified in %s on line %d -bool(false) - -Warning: mysql_result(): Bad column offset specified in %s on line %d -bool(false) -valid fields -%unicode|string%(1) "1" -%unicode|string%(1) "a" -%unicode|string%(1) "1" -%unicode|string%(1) "1" -%unicode|string%(1) "a" -%unicode|string%(1) "a" -some invalid fields - -Warning: mysql_result(): unknown not found in MySQL result index %d in %s on line %d -bool(false) - -Warning: mysql_result(): _test. not found in MySQL result index %d in %s on line %d -bool(false) - -Warning: mysql_result(): not found in MySQL result index %d in %s on line %d -bool(false) - -Warning: mysql_result(): _test. not found in MySQL result index %d in %s on line %d -bool(false) -_id -%unicode|string%(1) "1" -_label -string(2) "aa" -_foo -NULL - -Warning: mysql_result(): test.id not found in MySQL result index %d in %s on line %d -bool(false) - -Warning: mysql_result(): test.label not found in MySQL result index %d in %s on line %d -bool(false) - -Warning: mysql_result(): supplied resource is not a valid MySQL result resource in %s on line %d -bool(false) -done! diff --git a/ext/mysql/tests/mysql_select_db.phpt b/ext/mysql/tests/mysql_select_db.phpt deleted file mode 100644 index 6e0bf9e505..0000000000 --- a/ext/mysql/tests/mysql_select_db.phpt +++ /dev/null @@ -1,74 +0,0 @@ ---TEST-- -mysql_select_db() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include_once "connect.inc"; - -$tmp = NULL; -$link = NULL; - -if (false !== ($tmp = @mysql_select_db($link))) - printf("[001] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) - printf("[002] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", - $host, $user, $db, $port, $socket); - -if (!is_null($tmp = @mysql_select_db($db, $link, "foo"))) - printf("[003] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -/* does not make too much sense, unless we have access to at least one more database than $db */ -if (!mysql_select_db($db, $link)) - printf("[004] Cannot select DB %s, [%d] %s\n", $db, mysql_errno($link), mysql_error($link)); - -if (!$res = mysql_query("SELECT DATABASE() AS dbname", $link)) - printf("[005] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (!$row = mysql_fetch_assoc($res)) - printf("[006] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if ($row['dbname'] !== (string)$db) - printf("[007] Expecting database '%s', found '%s'\n", $db, $row['dbname']); - -var_dump($row['dbname']); - -mysql_free_result($res); - -if (mysql_select_db('mysql', $link)) { - // Yippie, a second database to play with - that's great because mysql_select_db - // ($db) was done by mysql__connect() already and the previous test - // was quite useless - if (!$res = mysql_query("SELECT DATABASE() AS dbname", $link)) - printf("[008] [%d] %s\n", mysql_errno($link), mysql_error($link)); - - if (!$row = mysql_fetch_assoc($res)) - printf("[009] [%d] %s\n", mysql_errno($link), mysql_error($link)); - - if (strtolower($row['dbname']) !== 'mysql') - printf("[010] Expecting database 'mysql', found '%s'\n", $row['dbname']); - - mysql_free_result($res); -} - - -var_dump(mysql_select_db('I can not imagine that this database exists', $link)); - -mysql_close($link); - -if (false !== ($tmp = mysql_select_db($db, $link))) - printf("[012] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -print "done!\n"; -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -%unicode|string%(%d) "%s" -bool(false) - -Warning: mysql_select_db(): supplied resource is not a valid MySQL-Link resource in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_set_charset.phpt b/ext/mysql/tests/mysql_set_charset.phpt deleted file mode 100644 index a0bccd8c31..0000000000 --- a/ext/mysql/tests/mysql_set_charset.phpt +++ /dev/null @@ -1,62 +0,0 @@ ---TEST-- -mysql_set_charset() - STUB, function usage not recommended ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); - -if (version_compare(PHP_VERSION, '5.9.9', '>') == 1) { - die('skip set character set not functional with PHP 6 (fomerly PHP 6 && unicode.semantics=On)'); -} - -if (!function_exists('mysql_set_charset')) - die("skip Function not available"); -?> ---FILE-- -<?php -include_once "connect.inc"; - -$tmp = NULL; -$link = NULL; - -if (!is_null($tmp = @mysql_set_charset())) - printf("[001] Expecting NULL got %s/%s\n", $tmp, gettype($tmp)); - -if (false !== ($tmp = @mysql_set_charset($link))) - printf("[002] Expecting boolean/false got %s/%s\n", $tmp, gettype($tmp)); - -if (false !== ($tmp = @mysql_set_charset(-1))) - printf("[003] Expecting boolean/false got %s/%s\n", $tmp, gettype($tmp)); - -if (!is_null($tmp = @mysql_set_charset('somecharset', $link))) - printf("[004] Expecting NULL got %s/%s\n", $tmp, gettype($tmp)); - -if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) - printf("[005] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", - $host, $user, $db, $port, $socket); - -/* unicode mode should throw a warning */ -$tmp = mysql_set_charset('uFt8', $link); - -if ((version_compare(PHP_VERSION, '5.9.9', '>') == 1)) - $expect = false; -else - $expect = true; - -$charsets = array('latin1', 'latin2'); -foreach ($charsets as $k => $charset) { - if (!($res = mysql_query(sprintf('SHOW CHARACTER SET LIKE "%s"', $charset), $link))) - continue; - mysql_free_result($res); - if ($expect !== ($tmp = @mysql_set_charset($charset, $link))) - printf("[006] Expecting %s/%s got %s/%s\n", - gettype($expect), $expect, - gettype($tmp), $tmp); -} - -mysql_close($link); -print "done!"; -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_sql_safe_mode.phpt b/ext/mysql/tests/mysql_sql_safe_mode.phpt deleted file mode 100644 index 4d8ca92e47..0000000000 --- a/ext/mysql/tests/mysql_sql_safe_mode.phpt +++ /dev/null @@ -1,40 +0,0 @@ ---TEST-- -mysql_[p]connect() - safe_mode ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -$link = @mysql_connect("", "", "", true); -if ($link) - die("skip Test cannot be run if annonymous connections are allowed"); -?> ---INI-- -sql.safe_mode=1 ---FILE-- -<?php -require_once('connect.inc'); -if ($socket) - $host = sprintf("%s:%s", $host, $socket); -else if ($port) - $host = sprintf("%s:%s", $host, $port); - -if ($link = mysql_connect($host, $user, $passwd, true)) { - printf("[001] Safe mode not working properly?\n"); - mysql_close($link); -} - -if ($link = mysql_pconnect($host, $user, $passwd)) { - printf("[002] Safe mode not working properly?\n"); - mysql_close($link); -} -print "done!\n"; -?> ---EXPECTF-- -Notice: mysql_connect(): SQL safe mode in effect - ignoring host/user/password information in %s on line %d - -Warning: mysql_connect(): Access denied for user '%s'@'%s' (using password: NO) in %s on line %d - -Notice: mysql_pconnect(): SQL safe mode in effect - ignoring host/user/password information in %s on line %d - -Warning: mysql_pconnect(): Access denied for user '%s'@'%s' (using password: NO) in %s on line %d -done!
\ No newline at end of file diff --git a/ext/mysql/tests/mysql_stat.phpt b/ext/mysql/tests/mysql_stat.phpt deleted file mode 100644 index 95868b7b90..0000000000 --- a/ext/mysql/tests/mysql_stat.phpt +++ /dev/null @@ -1,52 +0,0 @@ ---TEST-- -mysql_stat() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include_once "connect.inc"; - -$dbname = 'test'; -$tmp = NULL; -$link = NULL; - -if (!is_null($tmp = @mysql_stat($link))) - printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -require('table.inc'); - -if (!is_null($tmp = @mysql_stat($link, "foo"))) - printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if ((!is_string($stat = mysql_stat($link))) || ('' === $stat)) - printf("[003] Expecting non empty string, got %s/'%s', [%d] %s\n", - gettype($stat), $stat, mysql_errno($link), mysql_error($link)); - -if ((version_compare(PHP_VERSION, '5.9.9', '>') == 1) && - (version_compare(PHP_VERSION, '6.9.9', '<=') == 1) && - !is_unicode($stat)) { - printf("[004] Expecting Unicode error message!\n"); - var_inspect($stat); -} - -if ((!is_string($stat_def = mysql_stat())) || ('' === $stat_def)) - printf("[003] Expecting non empty string, got %s/'%s', [%d] %s\n", - gettype($stat_def), $stat_def, mysql_errno(), mysql_error()); - -assert(soundex($stat) === soundex($stat_def)); - -mysql_close($link); - -if (false !== ($tmp = mysql_stat($link))) - printf("[005] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -print "done!"; -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Warning: mysql_stat(): supplied resource is not a valid MySQL-Link resource in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_tablename.phpt b/ext/mysql/tests/mysql_tablename.phpt deleted file mode 100644 index 76007fde46..0000000000 --- a/ext/mysql/tests/mysql_tablename.phpt +++ /dev/null @@ -1,56 +0,0 @@ ---TEST-- -mysql_tablename() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include "connect.inc"; - -$tmp = NULL; -$link = NULL; - -if (!is_null($tmp = @mysql_tablename())) - printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (null !== ($tmp = @mysql_tablename($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 2", $link)) { - printf("[003] [%d] %s\n", mysql_errno($link), mysql_error($link)); -} - -if (NULL !== ($tmp = mysql_tablename($res))) - printf("[004] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (false !== ($tmp = mysql_tablename($res, -1))) - printf("[005] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -var_dump(mysql_tablename($res, 0)); - -if (false !== ($tmp = mysql_tablename($res, 2))) - printf("[00%d] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -mysql_free_result($res); - -var_dump(mysql_tablename($res, 0)); - -mysql_close($link); -print "done!"; -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Warning: mysql_tablename() expects at least 2 parameters, 1 given in %s on line %d - -Warning: mysql_tablename(): Unable to jump to row -1 on MySQL result index %d in %s on line %d -%unicode|string%(1) "1" - -Warning: mysql_tablename(): Unable to jump to row 2 on MySQL result index %d in %s on line %d - -Warning: mysql_tablename(): supplied resource is not a valid MySQL result resource in %s on line %d -bool(false) -done! diff --git a/ext/mysql/tests/mysql_thread_id.phpt b/ext/mysql/tests/mysql_thread_id.phpt deleted file mode 100644 index a2e0f934c2..0000000000 --- a/ext/mysql/tests/mysql_thread_id.phpt +++ /dev/null @@ -1,41 +0,0 @@ ---TEST-- -mysql_thread_id() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include_once "connect.inc"; - -$tmp = NULL; -$link = NULL; - -if (!is_null($tmp = @mysql_thread_id($link))) - printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -require('table.inc'); - -if (!is_int($id = mysql_thread_id($link)) || (0 === $id)) - printf("[002] Expecting int/any but zero, got %s/%s. [%d] %s\n", - gettype($id), $id, mysql_errno($link), mysql_error($link)); - -if (!is_int($id_def = mysql_thread_id()) || (0 === $id_def)) - printf("[003] Expecting int/any but zero, got %s/%s. [%d] %s\n", - gettype($id_def), $id_def, mysql_errno(), mysql_error()); - -assert($id === $id_def); - -mysql_close($link); - -if (false !== ($tmp = mysql_thread_id($link))) - printf("[003] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -print "done!"; -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d - -Warning: mysql_thread_id(): supplied resource is not a valid MySQL-Link resource in %s on line %d -done! diff --git a/ext/mysql/tests/mysql_trace_mode.phpt b/ext/mysql/tests/mysql_trace_mode.phpt deleted file mode 100644 index 73872de1db..0000000000 --- a/ext/mysql/tests/mysql_trace_mode.phpt +++ /dev/null @@ -1,37 +0,0 @@ ---TEST-- -mysql.trace_mode=1 ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---INI-- -mysql.trace_mode=1 -error_reporting=E_ALL | E_NOTICE | E_STRICT ---FILE-- -<?php -require_once('table.inc'); - -$res1 = mysql_query('SELECT id FROM test', $link); - -if (!$res2 = @mysql_db_query($db, 'SELECT id FROM test', $link)) - printf("[001] [%d] %s\n", mysql_errno($link), mysql_error($link)); -mysql_free_result($res2); -print @mysql_escape_string("I don't mind character sets, do I?\n"); - -$res3 = mysql_query('BOGUS_SQL', $link); -mysql_close($link); - -print "done!\n"; -?> ---CLEAN-- -<?php -require_once("clean_table.inc"); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -I don\'t mind character sets, do I?\n -Warning: mysql_query(): You have an error in your SQL syntax; check the manual that corresponds to your %s server version for the right syntax to use near 'BOGUS_SQL' at line 1 in %s on line %d -done! - -Warning: Unknown: 1 result set(s) not freed. Use mysql_free_result to free result sets which were requested using mysql_query() in %s on line %d diff --git a/ext/mysql/tests/mysql_unbuffered_query.phpt b/ext/mysql/tests/mysql_unbuffered_query.phpt deleted file mode 100644 index 8c3c2d6e10..0000000000 --- a/ext/mysql/tests/mysql_unbuffered_query.phpt +++ /dev/null @@ -1,126 +0,0 @@ ---TEST-- -mysql_unbuffered_query() ---SKIPIF-- -<?php -require_once('skipif.inc'); -require_once('skipifconnectfailure.inc'); -?> ---FILE-- -<?php -include_once("connect.inc"); - -$tmp = NULL; -$link = NULL; - -if (false !== ($tmp = @mysql_unbuffered_query($link))) - printf("[001] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -require('table.inc'); - -if (NULL !== ($tmp = @mysql_unbuffered_query("SELECT 1 AS a", $link, "foo"))) - printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - -if (false !== ($tmp = mysql_unbuffered_query('THIS IS NOT SQL', $link))) - printf("[003] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -if (false !== ($tmp = mysql_unbuffered_query("SELECT 'this is sql but with backslash g'\g", $link))) - printf("[004] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -if ((0 === mysql_errno($link)) || ('' == mysql_error($link))) - printf("[005] mysql_errno()/mysql_error should return some error\n"); - -if (!$res = mysql_unbuffered_query("SELECT 'this is sql but with semicolon' AS valid ; ", $link)) - printf("[006] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -var_dump(mysql_fetch_assoc($res)); -mysql_free_result($res); - -if (false !== ($res = mysql_unbuffered_query("SELECT 'this is sql but with semicolon' AS valid ; SHOW VARIABLES", $link))) - printf("[007] [%d] %s\n", mysql_errno($link), mysql_error($link)); - -if (mysql_unbuffered_query('DROP PROCEDURE IF EXISTS p', $link)) { - // let's try to play with stored procedures - if (mysql_unbuffered_query('CREATE PROCEDURE p(OUT ver_param VARCHAR(25)) BEGIN SELECT VERSION() INTO ver_param; END;', $link)) { - $res = mysql_unbuffered_query('CALL p(@version)', $link); - $res = mysql_unbuffered_query('SELECT @version AS p_version', $link); - $tmp = mysql_fetch_assoc($res); - if (!isset($tmp['p_version']) || ('' == $tmp['p_version'])) { - printf("[008] Result seems wrong, dumping\n"); - var_dump($tmp); - } - if ((version_compare(PHP_VERSION, '5.9.9', '>') == 1) && - (version_compare(PHP_VERSION, '6.9.9', '<=') == 1) && - !is_unicode($tmp['p_version'])) { - printf("[009] Expecting unicode string, dumping\n"); - var_dump($tmp); - } - mysql_free_result($res); - } else { - printf("[010] [%d] %s\n", mysql_errno($link), mysql_error($link)); - } - - mysql_unbuffered_query('DROP FUNCTION IF EXISTS f', $link); - if (mysql_unbuffered_query('CREATE FUNCTION f( ver_param VARCHAR(25)) RETURNS VARCHAR(25) DETERMINISTIC RETURN ver_param;', $link)) { - $res = mysql_unbuffered_query('SELECT f(VERSION()) AS f_version', $link); - $tmp = mysql_fetch_assoc($res); - if (!isset($tmp['f_version']) || ('' == $tmp['f_version'])) { - printf("[011] Result seems wrong, dumping\n"); - var_dump($tmp); - } - if ((version_compare(PHP_VERSION, '5.9.9', '>') == 1) && - (version_compare(PHP_VERSION, '6.9.9', '<=') == 1) && - !is_unicode($tmp['f_version'])) { - printf("[012] Expecting unicode string, dumping\n"); - var_dump($tmp); - } - mysql_free_result($res); - } else { - printf("[012] [%d] %s\n", mysql_errno($link), mysql_error($link)); - } -} - -var_dump(mysql_unbuffered_query('INSERT INTO test(id) VALUES (100)', $link)); -var_dump($res = mysql_unbuffered_query('SELECT id FROM test', $link)); -var_dump(mysql_num_rows($res)); - -mysql_close($link); - -if (false !== ($tmp = mysql_unbuffered_query("SELECT id FROM test", $link))) - printf("[010] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - -print "done!"; -?> ---CLEAN-- -<?php -require_once('connect.inc'); - -// connect + select_db -if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) { - printf("[clean] Cannot connect to the server using host=%s/%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", - $host, $myhost, $user, $db, $port, $socket); -} - -if (!mysql_query('DROP TABLE IF EXISTS test', $link)) { - printf("[clean] Failed to drop test table: [%d] %s\n", mysql_errno($link), mysql_error($link)); -} - -/* MySQL server may not support this - ignore errors */ -@mysql_query('DROP PROCEDURE IF EXISTS p', $link); -@mysql_query('DROP FUNCTION IF EXISTS f', $link); - -mysql_close($link); -?> ---EXPECTF-- -Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d -array(1) { - [%u|b%"valid"]=> - %unicode|string%(30) "this is sql but with semicolon" -} -bool(true) -resource(%d) of type (mysql result) -int(0) - -Notice: mysql_close(): Function called without first fetching all rows from a previous unbuffered query in %s on line %d - -Warning: mysql_unbuffered_query(): supplied resource is not a valid MySQL-Link resource in %s on line %d -done! diff --git a/ext/mysql/tests/setupdefault.inc b/ext/mysql/tests/setupdefault.inc deleted file mode 100644 index b13402ec14..0000000000 --- a/ext/mysql/tests/setupdefault.inc +++ /dev/null @@ -1,10 +0,0 @@ -<?php - -// copy variables from connect.inc into mysql default connection ini settings, so that implicit mysql_connect() behaviour can be tested where needed -// must be loaded AFTER connect.inc - -ini_set('mysql.default_host', $host . ":" . $port); -ini_set('mysql.default_user', $user); -ini_set('mysql.default_password', $passwd); - -?> diff --git a/ext/mysql/tests/skipif.inc b/ext/mysql/tests/skipif.inc deleted file mode 100644 index 0f932892ca..0000000000 --- a/ext/mysql/tests/skipif.inc +++ /dev/null @@ -1,6 +0,0 @@ -<?php -if (!extension_loaded("mysql")) { - die('skip mysql extension not available'); -} -require_once('connect.inc'); -?> diff --git a/ext/mysql/tests/skipifconnectfailure.inc b/ext/mysql/tests/skipifconnectfailure.inc deleted file mode 100644 index a57c7dbd58..0000000000 --- a/ext/mysql/tests/skipifconnectfailure.inc +++ /dev/null @@ -1,17 +0,0 @@ -<?php -require_once('connect.inc'); -if ($skip_on_connect_failure) { - if ($socket) - $myhost = sprintf("%s:%s", $host, $socket); - else if ($port) - $myhost = sprintf("%s:%s", $host, $port); - - if (!$link = @mysql_connect($myhost, $user, $passwd, true, $connect_flags)) - die(sprintf("skip Can't connect to MySQL Server - [%d] %s", mysql_errno(), mysql_error())); - - if (!@mysql_select_db($db, $link)) - die(sprintf("skip Can't connect to MySQL Server - [%d] %s", mysql_errno(), mysql_error())); - - mysql_close($link); -} -?>
\ No newline at end of file diff --git a/ext/mysql/tests/skipifnotmysqlnd.inc b/ext/mysql/tests/skipifnotmysqlnd.inc deleted file mode 100644 index 9cccdc7bf1..0000000000 --- a/ext/mysql/tests/skipifnotmysqlnd.inc +++ /dev/null @@ -1,5 +0,0 @@ -<?php -if (strpos(mysql_get_client_info(), 'mysqlnd') === false) { - die('skip mysqlnd extension not available'); -} -?> diff --git a/ext/mysql/tests/table.inc b/ext/mysql/tests/table.inc deleted file mode 100644 index 18c858d913..0000000000 --- a/ext/mysql/tests/table.inc +++ /dev/null @@ -1,24 +0,0 @@ -<?PHP -require_once 'connect.inc'; - -// connect + select_db -if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) { - printf("Cannot connect to the server using host=%s/%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", - $host, $myhost, $user, $db, $port, $socket); - exit(1); -} - -if (!mysql_query('DROP TABLE IF EXISTS test', $link)) { - printf("Failed to drop old test table: [%d] %s\n", mysql_errno($link), mysql_error($link)); - exit(1); -} - -if (!mysql_query('CREATE TABLE test(id INT, label CHAR(1), PRIMARY KEY(id)) ENGINE=' . $engine, $link)) { - printf("Failed to create test table: [%d] %s\n", mysql_errno($link), mysql_error($link)); - exit(1); -} - -if (!mysql_query("INSERT INTO test(id, label) VALUES (1, 'a'), (2, 'b'), (3, 'c'), (4, 'd'), (5, 'e'), (6, 'f')", $link)) { - printf("[%d] %s\n", mysql_errno($link), mysql_error($link)); -} -?> |