xref: /PHP-5.3/ext/mysql/tests/mysql_connect.phpt (revision e1357bdb) 
1--TEST--
2mysql_connect()
3--SKIPIF--
4<?php
5require_once('skipif.inc');
6require_once('skipifconnectfailure.inc');
7?>
8--FILE--
9<?php
10include_once "connect.inc";
11
12$tmp    = NULL;
13$link   = NULL;
14
15// mysql_connect ( [string server [, string username [, string password [, bool new_link [, int client_flags]]]]] )
16if (NULL !== ($tmp = @mysql_connect($link, $link, $link, $link, $link, $link)))
17	printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
18
19$myhost = (is_null($socket)) ? ((is_null($port)) ? $host : $host . ':' . $port) : $host . ':' . $socket;
20if (!$link = mysql_connect($myhost, $user, $passwd, true))
21	printf("[002] Cannot connect to the server using host=%s/%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
22		$host, $myhost, $user, $db, $port, $socket);
23
24mysql_close($link);
25
26if (!$link = mysql_connect($myhost, $user, $passwd, true))
27	printf("[003] Cannot connect to the server using host=%s/%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
28		$host, $myhost, $user, $db, $port, $socket);
29
30mysql_close();
31
32if ($link = mysql_connect($myhost, $user . 'unknown_really', $passwd . 'non_empty', true))
33	printf("[004] Can connect to the server using host=%s/%s, user=%s, passwd=***non_empty, dbname=%s, port=%s, socket=%s\n",
34		$host, $myhost, $user . 'unknown_really', $db, $port, $socket);
35
36if (false !== $link)
37printf("[005] Expecting boolean/false, got %s/%s\n", gettype($link), $link);
38
39// Run the following tests without an anoynmous MySQL user and use a password for the test user!
40ini_set('mysql.default_socket', $socket);
41if (!is_null($socket)) {
42	if (!is_resource($link = mysql_connect($host, $user, $passwd, true))) {
43		printf("[006] Usage of mysql.default_socket failed\n");
44	} else {
45		mysql_close($link);
46	}
47}
48
49if (!ini_get('sql.safe_mode')) {
50
51	ini_set('mysql.default_port', $port);
52	if (!is_null($port)) {
53		if (!is_resource($link = mysql_connect($host, $user, $passwd, true))) {
54			printf("[007] Usage of mysql.default_port failed\n");
55		} else {
56			mysql_close($link);
57		}
58	}
59
60	ini_set('mysql.default_password', $passwd);
61	if (!is_resource($link = mysql_connect($myhost, $user))) {
62		printf("[008] Usage of mysql.default_password failed\n");
63	} else {
64		mysql_close($link);
65	}
66	ini_set('mysql.default_user', $user);
67	if (!is_resource($link = mysql_connect($myhost))) {
68		printf("[009] Usage of mysql.default_user failed\n");
69	} else {
70		mysql_close($link);
71	}
72
73	ini_set('mysql.default_host', $myhost);
74	if (!is_resource($link = mysql_connect())) {
75		printf("[010] Usage of mysql.default_host failed\n") ;
76	} else {
77		mysql_close($link);
78	}
79
80	if (!is_resource($link = mysql_connect()) || !is_resource($link2 = mysql_connect())) {
81		printf("[011] Usage of mysql.default_host failed\n") ;
82	} else {
83		mysql_close();
84		mysql_close($link2);
85	}
86
87	if (!stristr(PHP_OS, 'win') && !stristr(PHP_OS, 'netware')) {
88		ini_set('mysql.default_port', -1);
89		if (putenv(sprintf('MYSQL_TCP_PORT=%d', $port))) {
90			if (!is_resource($link = mysql_connect())) {
91				printf("[012] Usage of env MYSQL_TCP_PORT failed\n") ;
92			} else {
93			mysql_close($link);
94		}
95		} else if (putenv(sprintf('MYSQL_TCP_PORT=%d', $port + 1))) {
96			if (!is_resource($link = mysql_connect())) {
97				printf("[013] Usage of env MYSQL_TCP_PORT=%d should have failed\n", $port + 1) ;
98				mysql_close($link);
99		}
100		}
101	}
102}
103
104print "done!";
105?>
106--EXPECTF--
107Warning: mysql_connect(): Access denied for user '%s'@'%s' (using password: YES) in %s on line %d
108done!
109