| Server IP : 217.18.85.50 / Your IP : 52.15.92.58 Web Server : LiteSpeed System : Linux server50.tr85.dhs.com.tr 3.10.0-962.3.2.lve1.5.85.el7.x86_64 #1 SMP Thu Apr 18 15:18:36 UTC 2024 x86_64 User : ferhatgenc ( ) PHP Version : 7.2.34 Disable Function : restore_ini,mail,openbasedir,f_open,system,dl,array_compare,array_user_key_compare,passthru,cat,exec,popen,proc_close,proc_get_status,proc_nice,proc_open,escapeshellcmd,escapeshellarg,show_source,posix_mkfifo,ini_restore,mysql_list_dbs,getmyuid,pconnect,link,symlink,fin,passthruexec,fileread,shell_exec,pcntl_exec,ini_alter,leak,apache_child_terminate,chown,posix_kill,posix_setpgid,posix_setsid,posix_setuid,proc_terminate,syslog,allow_url_fopen,fpassthru,execute,shell,chgrp,passthru,socket_select,socket_create,socket_create_listen,socket_create_pair,socket_listen,socket_accept,socket_bind,foreach,socket_strerror,pcntl_fork,pcntl_signal,pcntl_waitpid,pcntl_wexitstatus,pcntl_wifexited,pcntl_wifsignaled,pcntl_wifstopped,pcntl_wstopsig,pcntl_wtermsig,openlog,apache_get_version,apache_getenv,apache_note,apache_setenv,virtualal MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /var/softaculous/zen/ |
Upload File : |
<?php
function getCollationSetClause() {
if (hasUtf8mb4Support('utf8mb4_520')) { // MySQL 5.6+
return ' CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci';
} else if (hasUtf8mb4Support('utf8mb4')) { // MySQL 5.5.3+
return ' CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci';
} else {
return ' CHARACTER SET utf8 COLLATE utf8_unicode_ci';
}
}
function hasUtf8mb4Support($which = 'utf8mb4_520') {
$db_version = getVersion();
if ($db_version) { // if not set no db functions available
switch ($which) {
case 'utf8mb4':
if (isMariaDB() && version_compare($db_version, '5.5.0', '<')) {
return false;
} else if (version_compare($db_version, '5.5.3', '<')) {
return false;
}
$client_version = mysqli_get_client_info();
/*
* libmysql has supported utf8mb4 since 5.5.3, same as the MySQL server.
* mysqlnd has supported utf8mb4 since 5.0.9.
*/
if (strpos($client_version, 'mysqlnd') !== false) {
$client_version = preg_replace('/^\D+([\d.]+).*/', '$1', $client_version);
return version_compare($client_version, '5.0.9', '>=');
} else {
return version_compare($client_version, '5.5.3', '>=');
}
case 'utf8mb4_520':
return version_compare($db_version, '5.6', '>=');
case 'general':
return (hasUtf8mb4Support('utf8mb4') || hasUtf8mb4Support('utf8mb4_520'));
}
}
return false;
}
function getVersion() {
$software = getVersionComplete();
if ($software) {
if (isMariaDB()) {
preg_match("/\d+(\.\d+){2,}-MariaDB/", $software, $matches);
if ($matches) {
return str_replace('-MariaDB', '', $matches[0]);
}
return $software; // just in case…
} else {
return $software;
}
}
return '0.0.0';
}
function getVersionComplete() {
global $connection;
$connection = mysqli_connect("[[softdbhost]]","[[softdbuser]]","[[softdbpass]]","[[softdb]]");
if ($connection) {
$query = mysqli_fetch_array(mysqli_query($connection, "SELECT version()"));
if ($query) {
return $query['version()'];
}
}
return null;
}
function isMariaDB() {
$db_version = getVersionComplete();
if ($db_version && stristr($db_version, 'mariadb')) { // version includes note if mariadb
return true;
}
return false;
}
$charset_value = getCollationSetClause();
if(!empty($charset_value)){
echo '<charset_value>'.$charset_value.'</charset_value>';
}
?>