utf8_conversion_without_entity_decode.php File Reference

Variables
	$start = microtime(true)
	$pdo
	$result = $pdo->query("SHOW VARIABLES LIKE 'innodb_file_format'")
	$var = $result->fetch(PDO::FETCH_KEY_PAIR)
	$collation = $result->fetchColumn()
	$db = DBManager::get()
foreach($db->query("SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA ='{$GLOBALS	$end [ 'DB_STUDIP_DATABASE']}' AND TABLE_TYPE='BASE TABLE'/*AND TABLE_COLLATION<> 'utf8mb4_unicode_ci' */") ->fetchAll() as $data) = microtime(true)
	$duration = $end - $start
	$human_duration

Variable Documentation

$collation

$collation = $result->fetchColumn()

$db

$db = DBManager::get()

$duration

$duration = $end - $start

$end

foreach ( $db->query("SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA ='{$GLOBALS $end['DB_STUDIP_DATABASE']}' AND TABLE_TYPE='BASE TABLE' /* AND TABLE_COLLATION <> 'utf8mb4_unicode_ci' */") ->fetchAll() as $data) = microtime(true)

$human_duration

$human_duration

Initial value:

= sprintf("%02d:%02d:%02d",
    ($duration / 60 / 60) % 24, ($duration / 60) % 60, $duration % 60)

$pdo

if ( $collation !='utf8mb4_unicode_ci') $pdo

Initial value:

= new PDO('mysql:host=' . $GLOBALS['DB_STUDIP_HOST'] .
    ';dbname=' . $GLOBALS['DB_STUDIP_DATABASE'] .
    ';charset=utf8',
    $GLOBALS['DB_STUDIP_USER'],
    $GLOBALS['DB_STUDIP_PASSWORD']
)

$result

if (mb_strtolower( $var[ 'innodb_large_prefix']) !='on') $result = $pdo->query("SHOW VARIABLES LIKE 'innodb_file_format'")

$start

$start = microtime(true)

$var

$var = $result->fetch(PDO::FETCH_KEY_PAIR)