mysql_connect.phpt   [plain text]

--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!