Bu sayt kukilərdən istifadə edir. Onların istifadəsinə razılıq verirsinizmi?
Bəli, icazə verirəm.
Şərhlər 3
Salam Auto Chatlarda Cox Yerde SSmaylikler falan simvol seklinde dusur buda problem yaradir de buda hell yolu qisayoldan
[code=php]<?php
$prohack = [
'host' => 'localhost',
'user' => 'demo_user',
'pass' => 'demo_pass',
'db' => 'demo_db'
];
$conn = new mysqli($prohack['host'], $prohack['user'], $prohack['pass'], $prohack['db']);
$conn->set_charset('utf8mb4');
if ($conn->connect_error) die($conn->connect_error);
$tables = $conn->query("SHOW TABLES");
while ($tableRow = $tables->fetch_array()) {
$table = $tableRow[0];
$columns = $conn->query("SHOW FULL COLUMNS FROM `$table`");
while ($col = $columns->fetch_assoc()) {
$field = $col['Field'];
$type = $col['Type'];
$collation = $col['Collation'];
if ($collation && (stripos($type, 'char') !== false || stripos($type, 'text') !== false)) {
$alter = "ALTER TABLE `$table` MODIFY `$field` $type CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci";
$conn->query($alter);
}
}
$conn->query("ALTER TABLE `$table` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci");
}
$conn->close();
?>
[/code]
27 İyl 2025, 15:27
[code=php]<?php
$prohack = [
'host' => 'localhost',
'user' => 'demo_user',
'pass' => 'demo_pass',
'db' => 'demo_db'
];
$conn = new mysqli($prohack['host'], $prohack['user'], $prohack['pass'], $prohack['db']);
$conn->set_charset('utf8mb4');
if ($conn->connect_error) die($conn->connect_error);
$tables = $conn->query("SHOW TABLES");
while ($tableRow = $tables->fetch_array()) {
$table = $tableRow[0];
$columns = $conn->query("SHOW FULL COLUMNS FROM `$table`");
while ($col = $columns->fetch_assoc()) {
$field = $col['Field'];
$type = $col['Type'];
$collation = $col['Collation'];
if ($collation && (stripos($type, 'char') !== false || stripos($type, 'text') !== false)) {
$alter = "ALTER TABLE `$table` MODIFY `$field` $type CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci";
$conn->query($alter);
}
}
$conn->query("ALTER TABLE `$table` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci");
}
$conn->close();
?>
[/code]
0
Bağışlayın, sizin üçün şərh yazmaq əlçatan deyil
Geriyə
