| Server IP : 79.136.114.73 / Your IP : 3.21.126.72 Web Server : Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.29 OpenSSL/1.0.1f System : Linux b8009 3.13.0-170-generic #220-Ubuntu SMP Thu May 9 12:40:49 UTC 2019 x86_64 User : www-data ( 33) PHP Version : 5.5.9-1ubuntu4.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /proc/self/root/home/b8009/php-5.6.22/ext/mysqli/tests/ |
Upload File : |
--TEST--
mysqli_change_user() - SET NAMES
--SKIPIF--
<?php
require_once('skipif.inc');
require_once('skipifemb.inc');
require_once('skipifconnectfailure.inc');
if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
die(sprintf("skip [%d] %s", mysqli_connect_errno(), mysqli_connect_error()));
if (!$res = mysqli_query($link, 'SELECT version() AS server_version'))
die(sprintf("skip [%d] %s\n", mysqli_errno($link), mysqli_error($link)));
$tmp = mysqli_fetch_assoc($res);
mysqli_free_result($res);
$version = explode('.', $tmp['server_version']);
if (empty($version))
die(sprintf("skip Cannot determine server version, we need MySQL Server 4.1+ for the test!"));
if ($version[0] <= 4 && $version[1] < 1)
die(sprintf("skip We need MySQL Server 4.1+ for the test!"));
?>
--FILE--
<?php
require_once('connect.inc');
if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
printf("[001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
if (!$res = mysqli_query($link, "SHOW CHARACTER SET LIKE 'latin%'"))
printf("[002] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
$charsets = array();
while ($row = mysqli_fetch_assoc($res))
$charsets[$row['Charset']] = $row['Default collation'];
mysqli_free_result($res);
if (!mysqli_query($link, 'SET NAMES DEFAULT'))
printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
if (!$res = mysqli_query($link, 'SELECT
@@character_set_client AS charset_client,
@@character_set_connection AS charset_connection,
@@character_set_results AS charset_results,
@@collation_connection AS collation_connection,
@@collation_database AS collation_database,
@@collation_server AS collation_server'))
printf("[004] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
if (!$defaults = mysqli_fetch_assoc($res))
printf("[005] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
mysqli_free_result($res);
$not_changed = $defaults;
foreach ($charsets as $charset => $collation) {
if (isset($not_changed['charset_client']) &&
$charset != $not_changed['charset_client'] &&
mysqli_query($link, sprintf("SET @@character_set_client = '%s'", $charset)))
unset($not_changed['charset_client']);
if (isset($not_changed['charset_connection']) &&
$charset != $not_changed['charset_connection'] &&
mysqli_query($link, sprintf("SET @@character_connection = '%s'", $charset)))
unset($not_changed['charset_connection']);
if (isset($not_changed['charset_results']) &&
$charset != $not_changed['charset_results'] &&
mysqli_query($link, sprintf("SET @@character_set_results = '%s'", $charset)))
unset($not_changed['charset_results']);
if (isset($not_changed['collation_connection']) &&
$collation != $not_changed['collation_connection'] &&
mysqli_query($link, sprintf("SET @@collation_connection = '%s'", $collation)))
unset($not_changed['collation_connection']);
if (isset($not_changed['collation_database']) &&
$collation != $not_changed['collation_database'] &&
mysqli_query($link, sprintf("SET @@collation_database = '%s'", $collation)))
unset($not_changed['collation_database']);
if (isset($not_changed['collation_server']) &&
$collation != $not_changed['collation_server'] &&
mysqli_query($link, sprintf("SET @@collation_server = '%s'", $collation)))
unset($not_changed['collation_server']);
if (empty($not_changed))
break;
}
if (!$res = mysqli_query($link, 'SELECT
@@character_set_client AS charset_client,
@@character_set_connection AS charset_connection,
@@character_set_results AS charset_results,
@@collation_connection AS collation_connection,
@@collation_database AS collation_database,
@@collation_server AS collation_server'))
printf("[006] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
if (!$modified = mysqli_fetch_assoc($res))
printf("[007] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
mysqli_free_result($res);
if ($modified == $defaults)
printf("[008] Not all settings have been changed\n");
// LAST_INSERT_ID should be reset
mysqli_change_user($link, $user, $passwd, $db);
if (!$res = mysqli_query($link, 'SELECT
@@character_set_client AS charset_client,
@@character_set_connection AS charset_connection,
@@character_set_results AS charset_results,
@@collation_connection AS collation_connection,
@@collation_database AS collation_database,
@@collation_server AS collation_server'))
printf("[009] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
if (!$new = mysqli_fetch_assoc($res))
printf("[010] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
mysqli_free_result($res);
if ($new == $modified) {
printf("[011] Charsets/collations have not been reset.\n");
printf("Got:\n");
var_dump($new);
printf("Expected:\n");
var_dump($defaults);
}
if ((version_compare(PHP_VERSION, '5.9.9', '>') == 1)) {
// charsets cannot take any other value but utf8 in unicode mode
$defaults['charset_client'] = 'utf8';
$defaults['charset_connection'] = 'utf8';
$defaults['charset_results'] = 'utf8';
$defaults['collation_connection'] = 'utf8_general_ci';
}
if ($new != $defaults) {
printf("[012] Charsets/collations have not been reset to their defaults.\n");
printf("Got:\n");
var_dump($new);
printf("Expected:\n");
var_dump($defaults);
}
if (!is_object($charset = mysqli_get_charset($link)))
printf("[013] Expecting object/std_class, got %s/%s\n", gettype($charset), $charset);
if ($charset->charset != $defaults['charset_connection'])
printf("[014] Expecting connection charset to be %s got %s\n",
$defaults['charset_connection'],
$charset->charset);
if ($charset->collation != $defaults['collation_connection'])
printf("[015] Expecting collation to be %s got %s\n",
$defaults['collation_connection'],
$charset->collation);
mysqli_close($link);
print "done!";
?>
--EXPECTF--
done!